Working with the NBS specification data
With NBS Chorus and NBS Source, our vision is to (a) first and foremost to produce best-in-class platforms with great user experience and then (b) to open up the data for partners and those with basic programming skills to use. With both, we have loads of exciting functionality planned for the main platforms, this means that opening up the data access will take a little longer. However, we do allow users to export specifications to the well-structured DOCX format. Primarily this is for manipulation in Microsoft Word. But as a secondary point of interest, this means that hobbyist programmers can play with the data. Last Saturday morning @mgjspidey on Twitter let me know that he'd written some code to generate a Revit Keynote file from the DOCX output. As I used to enjoy a bit of programming a while back, I took this as a challenge to dust off the old coding fingers and write some sample code that I'd share with the community. Having some spare holiday days mixed with Covid lockdown boredom also helped ;) As the most accessible coding language for Microsoft Office is probably VBA, I wrote some code and popped it up on GitHub. Summaries of the four use cases are below. Feel free to download and amend the code to create your own use cases. 1. Microsoft Word Macro - Generate Keynote file from Chorus specification Use case: Revit LT users cannot use the NBS Plug-in for Revit. So a keynote file is required for making annotations. Coding solution: Open the DOCX file - run the macro - generate the keynote file. NBS plan: Intend to implement in this within Chorus in 2021, in particular for small works customers.
2. Microsoft Word Macro - Prepare NBS legacy word-processing for importing into Chorus Use case: NBS customers may have old word processing versions of NBS they want to import into Chorus as record/historic specifications. Unfortunately, the historic word processing format used does not have structure to it. Coding solution: Open the DOCX file - run the macro - convert to a file that imports cleanly. NBS plan: Incremental enhancements to the MS Word import feature will continue to be made.
3. Microsoft Word Macro - Prepare stylesheet for uploading to Chorus Use case: It can be quite time consuming to change the colour and font-style for all styles in an NBS print template document. Coding solution: Open the DOCX file - run the macro - change all of the fonts and colours instantly. NBS plan: No plan at this stage to develop this into the main software
4. Microsoft Excel Macro - Generate a pricing document Use case: On small jobs that don't of bills of quantities, a priceable spreadsheet with specification references may be useful. Coding solution: Open the XSLM file, specify which DOCX file to look at - run the macro - generate the pricing spreadsheet. NBS plan: Intend to implement in this within Chorus in 2021, in particular for small works customers.
I do realise that programming and working with data like this is not for everyone. But hopefully this will spark of other ideas of what the data inside specifications can be used for - ideas worked on can turn into well-worked functionality that makes it into the main product one day too. Via Home http://www.rssmix.com/ via Blogger http://jonasjjackson.blogspot.com/2020/12/working-with-nbs-specification-data.html December 05, 2020 at 04:26AM
0 Comments
Leave a Reply. |