Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by DaviesTheChair

  1. I’m trying to set a Space Number from a text item but not sure how to pick up the Space object. All I know is the handle is 86 and that I can set the record values for Space field names. Is there such a thing as a Space node? I thought I could assign via a Space symbol, but not sure how. Anyone with any experience or examples?
  2. Ah, this is just the function I have been looking for. I would even go so far as to suggest something similar, matching user defined record formats, might be made available in a general utility menu/tool from Vectorworks for those of us who have to manage large object libraries (with all the necessary overwrite warnings etc). Multiple Symbol DEFINITION access is essential with the volume of data required for BIM today.
  3. I agree Pat. I was merely suggesting an optional method that if you want to see more than only Symbols in your criteria you can choose “Record is Present” to show all items. Some built-in Vectorworks reports use this approach including a Boolean “on schedule” checkbox for fine control of what you want to show on worksheets, which is most useful. Copying and pasting data for records is certainly a much easier way to manipulate data across many record fields (for items in the drawing). Being able to similarly manipulate Symbol Definitions would be very useful e.g. for BIM Master Libraries. I am sooo looking forward to this being available in V2021 ...?? 🤔
  4. You may already know this but probably worth mentioning to access and amend record data in worksheets is to use the criteria “record is present” instead of “Type is Symbol”. That way you can change records for all items including (Blue) Symbol to Group type or any other non-symbol objects which have records attached.
  5. Just a thought - are you certain your plug-in object sits within the Space object top/bottom bounds. Spaces sometimes clip top and bottom to storey elevations or can have their bounds set manually. I have missed picking up items previously when my Space bounds are not defined as I expected.
  6. Based on past experience I agree with Pat entirely, ODBC is definitely the way to work for a large number of objects. However ODBC only works on symbol instances placed in a drawing. There has not been a regular method (yet) to update multiple Resource Manager symbol definitions except via the Tools>Records>Change one field/Change all fields options. Also unfortunately ODBC (on a Mac at least) seems currently to be in a pretty shaky state. So I am rather excited by Pat's inferred hint that some of this may be resolved in the upcoming Excel data connection to Vectorworks 2021c.f. Teaser Tuesday. (Or am I reading way too much into this).
  7. Hi @Pat Stanford . I added your script and it works a treat. As long as the text is fairly central to the Space object, and the worksheet is sorted appropriately, I can now copy the number text into the Space Number field in the worksheet in one shot. Great stuff. [There is still scope for a master puppeteer to knit together some marionette strings if you know of anyone]. Many thanks, Marc
  8. @Pat Stanford hi Pat. Thanks for your reply. My query seems to have led you along a different path. It is not the positional value I am looking for, but rather the actual text of the text object reported in the worksheet. E.g I have an unnamed polygon which has a text object typed near its centre which reads “abc”. I can set up a worksheet which finds the x and y centres of the polygon and the x and y centres of the text object. (So I can match them). I can show the Name value of the polygon (empty) so I want the “abc” text Value of the text object which I can then paste into the empty polygon name. My next step is to repeat to extract the polygon name and paste into the Space Number field of a Space object with same 2D centre. I'm sure there are scripts which would do this better, but I’m no script writer. I have looked at marionette, but can’t find a Space object node. So I’m after the actual text of a text object to view in the worksheet if this is possible? [Full kudos and thanks to anyone who can write a marionette script to get the text room numbers which lie within the bounds of a polygon room then create spaces with that number added to The SpaceNumber field, that would solve all my issues. This has to be a regular requirement of anyone working with imported 2D dwg’s who needs to add wonderful data-rich Space objects. Perhaps less so for domestic projects but definitely for multi-storey buildings of say 80 spaces per floor].
  9. Is it possible to get the text value from a text object within a worksheet? I am (still) looking for a way to take a text item from an imported DWG i.e. Room Number, and assign it to the Space Number of the closest Space object. I figure I could do this with a worksheet using the nearest x and y centres, but I still need the text value of my text object.
  10. Hi, I have tried many things but with limited success. My local VWksUK tech support helped to refresh my VWks installation to a clean install which in a simple test of just 4 objects seemed to have worked, but after a short time Vectorworks began crashing due background polling of the ODBC Driver which was reporting to have lost connection. This is what seems to trigger the VWks crash on object connection. Sorry no resolution for me yet. It seems to be a driver connection issue, Because I can get a connection and import data without a crash, but only within a narrow time frame until the next background polling. As to whether the problem lies within Vectorworks or in the Mac system I cannot tell. Needs more VWks tech support.
  11. ODBC has worked really well for me with Filemaker previously, but the connection quality varies over time depending on compatibility of updates for a) operating system ODBC driver, b) ODBC drivers for Filemaker, c) Vectorworks implementation between Service Packs. However when it works, it is truly indistinguishable from magic! When it is up again I plan to set up a how to video for colleagues and I'm happy to share. My plan B is to learn how to query and connect to MySQL, but I suspect the ODBC connection issues are not at the database end on this occasion as I think we are currently in version c) of the above options. I have tried various drivers and the Database connection works, the record format links from Vectorworks are all OK and I can even get small packets of data into the Vectorworks objects on first run (sometimes), but it constantly crashes on object connection. I have a five storey building with 1500 objects on each floor to connect up to an external catalogue of coded items so doing this by hand is (gulp) not really an option I want to pursue. I'm awaiting a VWks tech support call, so will see how that goes. Thanks for your valuable advice.
  12. Thanks Pat, really helpful to know. You have confirmed my searching and prevented me looking further in vain. I'm trying to figure out a workaround for the short-term - I really hope it is short term, until there is a fix for external ODBC object connections for a large catalogue of furniture information I need to get into a VWks BIM drawing.
  13. While ODBC has stopped working in VWks 2020 and Catalina (at least with Filemaker Pro), I am searching for alternative options for a live project. One of these is to find a way to import an excel spreadsheet into VWks - doable as tabbed text import, then to link record fields to the worksheet containing the imported data. This would by-pass ODBC which is great (when it works) but takes more set up for inexperienced users> Also an internal look-ups within a drawing file should be more efficient within the programme. However I cannot find any reference to lookup commands within the Vectorworks ecosystem, no equivalent Lookup and Match or Find routines from Excel for example. I know there are specific search criteria for object data and attributes, but no spreadsheet cell lookups based on Find criteria. Have I missed anything obvious here? Essentially I need to get ID key data from database cells, find matching data from spreadsheet cells and return other values from a row and return them to record fields in the database cells so that I can add Symbol data automatically. Can this be done internally within a Vectorworks file or across referenced VWks files?
  14. Same issues here working on VWks 2020, Filemaker 17, but with FMP19 ODBC connector (having tried 17, 18 and now 19) with latest ODBC Manager for Mac Catalina. Vwks SP4 says this is fixed, but not apparently. Also crashes on Object connection even for 1 row. Mission critical for me. UPDATE: It does seem to be fixed in SP4 - I was on SP3, my error. UPDATE 2: No, it still crashes with SP4, - constantly.
  15. Many thanks @sbarrett I will pursue further. I loved your tutorials btw. They were what piqued my interest in marionette to start with.
  16. Hi, I regularly receive architects base files with polygons and separate text elements for room numbers and names. I want to extract these and create Vectoroworks Space objects with the same number and name fields. It looks like it should be easy for Marionette to do this, it just isn't easy for me to configure Marionette! Has anyone else had a similar requirement (and solved it) I wonder?
  17. Thanks Marissa. File attached (via separate private message) with two test Marionette versions. The bottom one is the problem with the Mirror node. The top one is my attempt to do the same with Duplicate and Move and Flip nodes - which I am also having some issues with, but that is probably just my lack of Mrionette experience getting in the way.
  18. Hi, I have been trying to mirror (and Duplicate) 3D items e.g. a left door and handle mirrored around the centre of a carcase to create the right door and mirrored handle. Everything works fine in 2D pla, but mirrored duplicates of the 3D extruded versions drop 50mm or so below the original. When I use the debug tool to select the input strings, everything jumps into place as expected. Is this a bug, bug or simply my implementation is wrong? I'm providing Point3 x, y, z inputs with same x and different y (to create a top-plan vertical axis) and same Z=0. Using Point2 input makes no difference.
  19. Hi @PatStanfordOk I understand the difference between A) “default” values for Record Fields -as defined during Field creation and B) the data added to fields when editing a Symbol definition which has a record attached in an unselected state. These are very esoteric differences but I see that they are different although for new users they are very confusing and I’m still not certain about hierarchy of precedence when reading the data in a worksheet, I will have to experiment further. If your script writes data from Symbol instances back to Symbol definitions, then I can either look up external data, attach it to instances or add the data in a Worksheet of my symbol instances and then use the script to post the new data back to the Symbol Definition. That would help enormously. Any progress with the script?
  20. Hi Both, missed your recent replies sorry. I have followed your advice @markdd and used the change all fields for those items where I could which has helped get me a long way forward. So many thanks as I had missed that option. For the questions you posed @Pat Stanford, it is something of a combination. Do each of the symbol definitions have the same record(s) attached? - Yes. Do you want the data for a specific record to be the same for all symbol definitions? - Some fields yes, for Category/Group fields others need to be individual, e.g. cat refs and dimensions. Do you want to change the data for all symbol definitions with that record attached? To the same value? - No. Do you want to change the data attached to the symbol definition? Or do you want to change the default values for the record? They are different. - Probably the latter (b. below) if I understand the difference correctly. a) = changing the record format attached to the symbol. b) = changing default field values within the record format. Is that what you mean? The script sounds interesting. It is not something I do each week, probably every other month, but can apply to many, say 50 or so, symbols. It would be really useful to add these via copy and pasteable data into worksheets to attache to unique cat referenced objects of similar types. i.e. All repeating data for say "Chairs" plus individual dimensional details and finishes references which will differ by Chair "Range". I have tried to extract dimensional data from the symbol images as x and y width and height parameters, but I have not got these to stick in the data fields yet.
  21. Thanks markdd. I have attached Records already, but I need to attach data to specific fields for a number of symbol definitions at once. I still haven't found a method for this yet.
  22. Is there a quick method of adding default (sticky) data to symbols en masse, without having to edit each Resource Browser item one by one? I don't mean editing per file after the symbol is imported, (I can achieve this via ODBC to Filemaker), I mean at root definition level so that on import the data is already attached.
  23. Many thanks for this Pat. 26th December! I hope your Christmas holidays were not interrupted by my query. All the best for the New Year. I will work through your example and see where this gets me. Regards Marc Davies
  24. @Pat Stanford Is there an easy way to do a "fill down" entry to assign incrementing numbers to a database field and thereby add ID numbers to the records?


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

  • Create New...