Jump to content

DaviesTheChair

Member
  • Content Count

    49
  • Joined

  • Last visited

Community Reputation

3 Neutral

About DaviesTheChair

  • Rank
    Greenhorn

Personal Information

  • Occupation
    Designer
  • Location
    United Kingdom

Recent Profile Visitors

844 profile views
  1. 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.
  2. 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 ...?? 🤔
  3. 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.
  4. 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.
  5. 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).
  6. 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
  7. @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].
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. 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?
  13. 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.
  14. Many thanks @sbarrett I will pursue further. I loved your tutorials btw. They were what piqued my interest in marionette to start with.

 

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...