Skip to content

A console application to reformat Bluebeam CSV markup summaries into a more traditional comment sheet format where responses are recorded in a single column as opposed to a new row.

License

Notifications You must be signed in to change notification settings

einajade-forest/bluebeam-reformat-comments

Repository files navigation

Bluebeam CSV Summary Reformatter

A console application to reformat Bluebeam CSV markup summaries into a more traditional comment sheet format where responses are recorded in a single column as opposed to a new row.

Comment sheet reformat - Before and After

Purpose of this project

This is a personal project born from the desire to practise coding. The application is inspired by a previous experience with transitioning users from paper to digital PDF reviews and frequent requests for compromise during the early adoption phase. This was an experiement as to whether it is possible to efficiently reformat the Bluebeam CSV markup summaries, rather than a tool that aimed to advance the original PDF markup software.

How does it work?

  1. Console application analyses the Markups Summary CSV file and checks that all required fields have been included in the export from Bluebeam
  2. If one does not already exist, a custom "Response" column header is created
  3. Each of the remaining rows in the CSV file is read and categorised as a Comment or Reply
  4. Nested replies are identified through the ID and Parent columns and consolidated into a single response property in the parent Reply
  5. The remaining top level replies are then captured in their corresponding Comment's response property
  6. The finalised collection of Comment is written as a new CSV file in the application's Export folder

Included files

This repository contains:

Licence

MIT License

About

A console application to reformat Bluebeam CSV markup summaries into a more traditional comment sheet format where responses are recorded in a single column as opposed to a new row.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages