Chad Hamilton HAarchs

Thanks - I will explore this approach - here's what I worked out yesterday - crude, but works - I blocked out a marionette sequence that grabs text on any sheet (intended to grab notes from non-keynoted sheets), writes them to records, then use a worksheet to gather and report the results. You can see from the worksheet that the intent is QA on notes written by multiple people, plus helping to coordinate spec writing. I added a detail sheet from a set as well - 20050_A7.6 Roof Details.vwx 210216 Get All Text from Sheet.vwx

FWW - I try to draw everything in a design layer while viewing the title block and detail module - even if the drawing will eventually be viewed on a Sheet Layer - this lets me format the drawing to the paper space it will be formatted on. I've always thought the ability to draw this way was a strength of vectorworks.

Took a little while, but I was able to work it out - still need to clean up the script, but it scrapes all the text on a sheet and writes it to a worksheet, which was my goal!

This script is not longer in the post - do you still have it? I'd like to look at it for a project -

Thanks Pat and Wes for the worksheet - this looks great.

Perfect - that's exactly what I was looking for. thanks!

You are right, you don't understand my question. This is not a question about two way editing. But the "Finishes Schedule" above is listing data from the Finish Key field, I think, and that's what I'm after. Look in the finishes field in your schedule - the wall finish reads "[W-1] TBA". You don't show the W-1 finish on your finish legend, but if you did, you would see in the key field "W-1" - no brackets. The finishes field in your "Finishes Schedule" does not have the brackets. The sample Finish schedule VW provides in the resource browser fakes this - if you expand their finishes column, you'll see that the data is a concatenation of data from the finishes editor - it adds the key and the description of the finish into the finish record field in the space database, and reports it in the finish schedule. They hide the finish description by narrowing the column width, but the brackets still show up. If you would upload the second worksheet called "Finishes Schedule", I would like to look at the header definitions.

Does anyone know how to access the Key field from the Finishes database? For example, [CT-1] would be the key with the description Ceramic Tile, 4" x 4", etc. In VW we enter finishes by editing a database and entering these values, but in a finish schedule report, we only have access to a concatenation of Key and Description (which would be Floor Finishes Edit, or Space.Finish Floor and read as "[CT-1] Ceramic Tile, 4" x 4", etc." in the finish schedule), or alternatively the finish description only (which would be Static Floor Finishes, or Space.Floor Finish and read as "Ceramic Tile, 4" x 4", etc." in the finish schedule). Ideally, we would want to use the Key field in a finish schedule, not a length description.

If there is much repetition in unit types, you might try creating unit types as symbols - this should save crunching geometry. Another different strategy would be to separate core and shell into one model, and residential units into another. I'm not a fan of separating models by floor, because then coordination between floors becomes more difficult.

Nice!

Yes, you are right - here is the formula pasted from the file - "I3" would be "A" from the written example. =IF(I3-INT(I3)>=0.01, (INT(I3)+1), INT(I3))

From the date of the post, I'm pretty sure this is a VW 2017 file - we tend to stay up to date. Here is a copy of the file exported to VW 2013. But you should upgrade, the enhancements are worth it. Space_Label_v2013.vwx

Is there a reference file available that provides definitions for ifc data fields? I've looked on the BuildingSmart web page, but can't seem to find it. The page http://www.buildingsmart-tech.org/ifc/review/IFC4Add2/ifc4-add2-rv/html/ has definitions from ifc to english - it would be very useful to have an index from english to ifc, to give a sense of where to look for something.

Note that the worksheets that appear on each sheet layer are set to report only keynote records on that sheet. If you edit a keynote from the worksheet on the sheet layer, you won't be editing all the keynotes if any show up on a different sheet layer. We find having a keynotes worksheet on a separate layer, set to report all keynote records throughout the file, is a good way to implement this. You could do it other ways - you could put the keynotes editor worksheet on every sheet layer, or you could just open it from the resource brower.

Here is an actual file that has the worksheet, plus the symbol elements - this later version works bi-directionally. A couple of caveats - when placing the worksheet on a drawing to act as keynotes, edit the database criteria to return keynote records from that drawing only (edit the criteria for the sheet or viewport name). When editing keynotes - we set up a design layer in our files called "Notes Management", with a version of the keynotes worksheet set to report all values for keynote symbols. Values in all keynote fields must be exactly the same - this is relatively easy to monitor and correct in the Notes Management layer. To change the text of a particular keynote globally - edit the keynote in Notes Management. 17070_RES_Model_171029_Stand_Alone.vwx