Jump to content

Marc Davies

  • Posts

  • Joined

  • Last visited

Everything posted by Marc Davies

  1. I know one can duplicate a DataVis, but how does one use the same attributes for a different data set? I have a series of carefully crafted attributes including line styles, fills, hatches etc against a number of fixed values (I typed the values manually as I need to use them for a template file). I want to use the same attributes when I attach looked up (SQLite) data to objects with matching values. This will format all my drawn objects correctly agains the external data. However, when I select a different Record set, I lose all the applied attributes which took many hours to set up in the first place. Is there any way to retain/copy the attributes for a different record set? The only way I can think of at the moment is to Data Map the records from an imported set into my template set, which is "faffy". [technical verb: "to faff"].
  2. [Another in my series of ODBC queries] I am using both Object Database connections with SQLite plus highlighting imported data with the excellent DataVisualisation. SQLite data connection works fine, but the DataVis doesn't update when object connections are amended. One way to force an update is to save and reopen the file, which is less than ideal. Is there another option to recalculate the DataVis e.g a button (similar to "Recalculate" in worksheets) which would be available to other users i.e. more built-in than a script (but a script might help in the short term).
  3. Is it only broken for me or is anyone successfully using ODBC connection from Vectorworks 2022 or 2022 to collect external data on a Mac? SQLite queries (non ODBC) work fine but I really need to link up to FileMaker Pro for wider database functions. Vwks has been crashing after 5 mins or so every time for the last three versions 2022, back through 2019.
  4. Thanks Silvano. I have a few hundred space objects to work through i.e. each room so I need to check if I can change them in one go as individually is not an option (for the time available to me).
  5. I'm not certain how many users are regular creators of adjacency diagrams, but I'm looking to create a multi-building, multi-floor bubble diagram listing University Faculty spaces as CIRCULAR area bubbles, and not as the area squares as VWks Spaces are drawn by default. Is there a simple checkbox for this [please] or will it require scripting/marionetting?
  6. SP4 notes say ODBC connection is fixed (as did SP3), but Vectorworks is still crashing within 5 minutes of updating the drawing with data drawn from an external FileMaker database. This long-standing issue (nearly two years since successful connection) is preventing good BIM data connections for Vectorworks, a real shame.
  7. Another thought which has given me problems in the past, which you may already know, but anything is worth a try... Make sure your primary key field definitely has only unique values as it trips up everything if there are two records with the same key value.
  8. ODBC is really difficult to useconsistently at the moment. Can you export to SQLite instead? This seems to work best on a Mac as it avoids ODBC connectors, however, I don't know about a PC I'm afraid.
  9. Your response is exactly why I love this forum. Really helpful and a complete solution. Many thanks Michael. I will try out in earnest tomorrow. I can use the UUID number to create a match key to an SQLite Database row to fetch additional data back into Vectorworks and populate additional record fields. I have 100 fields to populate for each symbol and over 8000 symbol instances so this is really the only option. Cheers, Marc
  10. I have seen previous posts for scripting the UUID into a record so that it can be viewed in a worksheet, but not examples of the actual scripts. Does anyone have such available to share? The issue I have relates to tagging individual furniture symbols with a unique code for linking to external SQLite database for extracting finishes specifications via ODBC - materials and colours need to be applied to similar symbols but may vary for individual objects (8000 of them in current project). I know UUID's exist for all items, but I have no quick means of identifying these in records (and worksheets). I also know how to use the Data Manager to pipe the codes through to my own record, just not how to access them in the first instance. The GetObjectUUID(h) function may work in a script but not in a worksheet as far as I can tell and I don't know how to script it.
  11. Follow up. It appears there is a geometry redraw bug around this otherwise very useful function along the following lines: IF (DataVis is turned ON in the DataVis coloured menu box) AND (matching “ImageByDataVis” function is in cell header) THEN geometry recalculates (Green redraw bar) and update the worksheet colours - which it does after a short while. However, IF(DataVis is turned OFF in the DataVis coloured menu box) AND (“ImageByDataVis” function is called in cell header) THEN it gets in a geometry redraw loop as it cannot refer to the deselected DataVis. Net result : constant redraw loop and non-functioning Vectorworks 2021.
  12. Hi, we are having problems with constant geometry refresh issues when using this function. It seems to work to begin with but the refresh update loops take longer and longer until the file is unusable. I wonder if we applying the function incorrectly? =ImageByDataVisualization(criteria,datavis name) I am confused by the "Criteria" requirement which is surely inherent in the dataVis set up? So I have been simply using the datavis name without any criteria. It seems to return the correct matching colours but is this throwing a curve to the calculations by not using criteria?
  13. Ah, but it can and does play nicely with SQLite, such that you can use a lookup-key field to fetch all your data back from an external SQLite database (either on same machine or on a server) and fill in otherwise empty fields. This can be done for Symbols within a drawing (instances) where it is truly indistinguishable from magic, or by linking Symbols via the Resource Manager (Definitions). It takes a little set up, but saves hours, nay, days of in-Vectorworks typing for larger libraries. All maintenance can be done in the SQLite database file thereafter and updated with a refreshed lookup.
  14. If your data Viz is working for other objects then commonly you may have a space or typo in your data which is throwing the viz.
  15. Yes it works as promised, and is a great solution for adding colour keyed items to worksheets. Thanks to @drelARCH for pointing it out and Vectorworkers for implementing it.
  16. @drelARCH brilliant - I hadn't spotted that function as my current project is in 2020, but it looks very much like that is the answer. Many thanks for pointing it out. I will open it in 2021 to try it. Cheers, Marc
  17. I know there is a built in index/key which will show in a viewport for all Data Viz matching colours, but I'm wondering if there is a way to illustrate data viewed in a worksheet with the DataViz colour overlay? Ideally I would like to view my furniture items in 2D within a cell - which is currently easily achieved, but with the Data Viz formatting applied, or if not, then at least a matching DataViz index colour block in a cell alongside the image. Anyone achieved anything similar?
  18. I believe SQLite does not use ODBC, at least it is not necessary via ODBC Manager (at least not on a Mac, but perhaps it does on Windows). So this may get around your issues. It does report an ODBC error on Mac, but it still maintains the SQLite connection. I have not yet tested this fully in SP3 however. UPDATE: SQLite does still work - and works very well, fast and reliable.
  19. I awaited SP3 eagerly (since July last year) of the promised fix for object database connection. While it waited 5 mins before crashing previously, now VWks crashes immediately on connection of any object. Will test SQLite later for direct connection, but for now ODBC is rendered inoperable.
  20. Hi Pat, It works like magic, really, totally indistinguishable from magic. A script which cleans up in 2 seconds that which took me 3 days (I could weep) in a project last week. It may take me a few years to get to your level of scripting, but now I know I really need to start learning this week. Many thanks @Pat Stanford.
  21. That’s excellent and I can follow the logic. Many thanks for all your input Pat you are a star. It is getting late this side of the pond so will have a look tomorrow morning. We are currently on Vw2021 but the symbols came from an older file so I will be testing in VWks 2021. I hope to return the favour someday. Cheers, Marc
  22. I think the most likely scenario is that symbols will be placed in the blank “cleaning file”, then cleaned with the script and the definitions tagged to indicate they are cleaned. Changing the symbol name will likely create other problems with database connections so tagging would be best for us. Given we will be using by a “cleaning” file, then only newly imported symbols will be in that file so any options are good for us. We may need to create a “furnishings” Uniclass class to propagate through the Symbol first, then adjust any text within the symbol to the Furniture Reference Class indicated above. (sorry for delayed reply, forgot to hit send last night).
  23. Ah, good question. In this case I am trying to clean up instances already added in the drawing, but definitions are imported into the file and so also available via Resource Manager for the same file. Plus some symbols are only imported to Resource Manager without being inserted in the drawing.
  24. Wow thanks Pat. The Uniclass 2015 code for Furniture text is,.... I-ZZ-20-10-T-FurnitureReference If you make it work for Furniture Text I may also need another for Equipment etc. so if I can get in and change the script "text" I can make those changes myself. [Incidentally I have solved my previous issues around assigning values to Symbol Definition data. I am using SQLite database connections via Resource Manager so I will video and post as promised. Still awaiting ODBC fix - updates in next Service Pack I understand.]
  • Create New...