Jump to content

Search the Community

Showing results for tags 'database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Announcements
    • Announcements
    • News You Need
    • Job Board
  • Feedback
    • Wishlist - Feature and Content Requests
    • Known Issues
    • Wishes Granted / Issues Resolved
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • Rendering
    • Workflows
    • Buying and Selling Vectorworks Licenses
    • Hardware
  • Customization
    • Marionette
    • Vectorscript
    • Python Scripting
    • SDK
    • 3rd Party Services, Products and Events
  • Solids Modeling and 3D Printing
    • Subdivision
    • Solids Modeling
    • 3D Printing
  • Vectorworks in Action
  • Archive
    • Resource Sharing
    • Machine Design

Categories

  • Knowledgebase
    • Tech Bulletins
    • Troubleshooting
    • Workflows
    • How To
    • FAQs

Categories

  • Marionette - Objects
  • Marionette - Networks
  • Marionette - Nodes
  • Marionette - Menu Commands

Product Groups

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Occupation


Homepage


Hobbies


Location


Skype

Found 13 results

  1. Hi, I want to multiply two database values but I can't manage to do it. I attach a screenshot of the results I get.
  2. Hey All I want to ask, if it impossible to read or write to/from the Title Block - Database? I have try it like this: But it didn't work... Did i do something wrong or it is impossible? Greetings KroVex
  3. I've been struggling with finding a way to use keynotes effectively in Vectorworks - and for us, one of the most essential aspects is the ability to revise keynotes as a project proceeds through the design process. Our office uses keynotes with a numbered prefix keyed to the CSI division format, and all keynotes have the same number throughout a project. We only place keynotes in a sheet legend if the keynote actually appears on a sheet, and keynotes may frequently appear on many different drawings - plans, elevations, sections. Attached is a sample file showing an alternate system for placing and reporting keynotes, based on a keynote record format attached to a custom symbol. The system uses worksheets on each sheet layer to report the keynotes on that sheet, and a separate 'master' worksheet to handle global editing of keynotes. Global editing is limited - text or reference fields may be edited, but editing the actual keynote number will break the link - the keynote number is providing the key link to the worksheet. I'd love to get feedback or suggestions that would improve this system. 170527 VW 2017 test.vwx
  4. You can create a database of "Data Tags" but it can't seem to filter by style, or display the style being used. Any Ideas? Optimally I want to create a database of all data tags used in a file with a certain name and call up the parameters to check their values.
  5. Grethe Connerth

    Reports Records Database Worksheet Schedule

    Dear VW aficionados, could anyone please explain to me the difference between the below. Most likely I would understand a 'sketch or visualisation' to it better in comparison to reading the Help menu where I can't digest the content. --> Reports, Records, Databases, Worksheets & Schedules <-- Am getting utterly confused about these ;0)) Any input is appreciated. Cheers, Grethe
  6. Marissa Farrell

    Open Database Connection (ODBC)

    Version 1.0.0

    46 downloads

    ODBC connection is useful for those that have an external database and want to use values from it within Vectorworks. It is also helpful going the other way, allowing users to edit their external database from within Vectorworks. These are more advanced nodes that will require an understanding of setting up and working with external databases.
  7. So we just recently started having problems with our plant database after having it work fine. I'm wondering if a change occurred in one of the recent Service Packs? Without informing users? Before the .exe file and folder used to be called 'VW Plants' and now it seems to be 'Vectorworks Plants'? This seemingly simple shift has me boggled because we track our favorite plants by checking the box for favorites...and they all disappeared. I am able to retrieve my old data, in tact, and find my favorites, but when I try to import the .usr file with just the favorites, I can't seem to select an option that just updates existing records with the "favorites" box checked. Instead, the only way I can seem to get those records in is by adding entirely new and often duplicate records into the database. When I do this I end up with two 'Plant name A's...one checked as a favorite and another unchecked. I want to be able to delete duplicate entries in the database. I have even found ones that come in it stock. Is there a way to quickly purge the database of duplicates based on a specific field (i.e. VW Latin Name)? Or Is there a way to import records from another database and have them simply update the records within the database without adding duplicates...mainly the check box for VW Favorites?
  8. So we just recently started having problems with our plant database after having it work fine. I'm wondering if a change occurred in one of the recent Service Packs? Without informing users? Before the .exe file and folder used to be called 'VW Plants' and now it seems to be 'Vectorworks Plants'? This seemingly simple shift has me boggled because we track our favorite plants by checking the box for favorites...and they all disappeared. I am able to retrieve my old data, in tact, and find my favorites, but when I try to import the .usr file with just the favorites, I can't seem to select an option that just updates existing records with the "favorites" box checked. Instead, the only way I can seem to get those records in is by adding entirely new and often duplicate records into the database. When I do this I end up with two 'Plant name A's...one checked as a favorite and another unchecked. I want to be able to delete duplicate entries in the database. I have even found ones that come in it stock. Is there a way to quickly purge the database of duplicates based on a specific field (i.e. VW Latin Name)? Or Is there a way to import records from another database and have them simply update the records within the database without adding duplicates...mainly the check box for VW Favorites?
  9. Chad Hamilton HAarchs

    Better Keynotes

    I can’t stress enough the importance of annotations to a BIM program, especially the ability to use keynotes in a drawing. Drawing objects are only one-half of the architect’s design documents – notes and annotations are the other half. A drawn object is meaningless in any set of design documents without an annotation that identifies what the drawn object represents, in the form of a legend, note, keynote, or some other written description. Keynotes need to be – easy to access easy to extract information from for use downstream, to develop specifications easy to edit, especially global revisions to identical keynotes throughout the document set. Currently, Vectorworks fails in each of these key areas. The current notes database scheme is arcane and difficult to use. There is not an easy way for users to extract information from the notes database – while it is possible report the database to a worksheet, inexplicably, data for the actual note is not accessible in a report. But the most significant failure in my view is the inability to globally edit identical notes within the program. Through the life a design project, notes must be revised numerous times, including – refining notes as the design becomes more specific correcting errors coordinating the entire set of notes to a standard Under the current Vectorworks keynotes design, a task as simple as correcting a spelling error requires finding and changing every instance of that keynote in the documents, a process that is painful, does not take advantage of automation, and is likely to introduce errors. Revit is not any better at keynotes documentation – in my view this creates both an opportunity and a threat for Vectorworks. We can spend more resources to implement a functional keynotes system and move ahead of other programs in this regard, or wait for Autodesk to develop a better keynotes scheme and fall behind.
  10. Hey all, Quick worksheet question for the veterans. Is it possible to get a SUM of areas generated from space objects. The SUM function adds together the number of database objects rather than of the information they are providing. I've attached a dropbox link to a jpeg that will explain it better than I can. https://www.dropbox.com/s/z62v30i61i5965i/Worksheet Screenshot.png?dl=0
  11. Hi there, I wish, there was a way to stamp an object's database information to it. I know that some local versions like the German (called 'Multistempel' or multistamp) already have this feature, but it doesn't always work properly. So I was hoping that there will be a generic version of this tool. On top it would be nice to gain access to the internal databases also. For example: I stamp the x and y coordinates value of an rectangle right onto that rectangle with the ability to change the coordinates by clicking right into the text in the drawing and editing it. What do you think? Kind regards VvierA
  12. Dear All, I came across an issue of changed behavior in VW. Since VW 8.5 I use external .txt files to alter database records in VW. Task is, to easily replace specific values in VW database by another. Lets say: update all items in 'database-name' with price record 'Field_1'='30,00' to 'Field_1'='40,00'. Or update all records with item no. '3.1.01' to 'C.1.01' . So far I used the database sync commad somewhat like a SQL statment would do UPDATE 'database-name' SET 'database-name.Field_1'='new value' WHERE 'database-name.Field_1'='old value'; The external .txt. file contains two values: The 'old value' and the 'new value', seperated by tab. In VW I assign a database sync matching set to find all items with 'old value' (key) and assign the 'new value' (sync from .txt to VW in the same field than the key field). Done, all old values in all database records of the specific database are updated - well, at least up to VW 2015 this is working like charm. VW2016 and VW2017 will not update the key field with the new data :-( I enclosed a zip file with two simple VW files (2015 an 2017) with database and some simple objects with database records and a txt file to sync with. Is anyone able to verify this change in behavioir also? Thanks for your help! Edward DB_Test_files.zip
  13. Hi all, I can't find a proper subforum for my question, so I'm posting it here. As seen in the screenshot I'm doing the following: - Marionette Object will change its size and look according to user input via OIP (see 9 objects on shape pane) - The objects are "Rack Panel" used for 19" Rack assembly and have two parameters: "Rack Unit Height" (integer 1-4) & "Panel Type" (blank, vented, etc.) - The parameters are written into a database ("RackPanelRecord" (see exported .txt bottom right) However, when trying to generate a spreadsheet for that data, my approach doesn't seem to work (see bottom left). As seen on the drawing, there's three different versions of Panels with 1RU: "Blank", "Security" and "Vented" Instead of giving me three individual lines for each version, the spreadsheet will just "sum up" all 1 RU Panels and show "---" for the type field. What am I doing wrong? P.S.: I hope someone can make sense of what I wrote

 

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.

×