Leveraging Vectorworks Object Data with SQLite Databases

This blog and video are from Marc Davies, a former furniture design advisor for the UK Department for Education. Davies recently worked for a UK interior and data visualization company for a diverse clientele across UK universities and government departments.

A long-standing Vectorworks customer and product designer, Davies searches for efficient and effective methods of information delivery for client organizations, combining Vectorworks with Claris Filemaker Pro and, more recently, SQLite databases.

. . .

This video covers the essentials of connecting parametric objects in Vectorworks to SQLite databases, enabling you to set up links to external data via a lookup ID code (a “Primary Key” in SQLite terms). It shows:

• How to set up the external database
• How to connect objects in a Vectorworks drawing by ID code to the external database
• How to bring the external data into the drawn objects within the Vectorworks drawing

For more on how to best leverage your use of data in Vectorworks, check out this blog:

3 WAYS TO MAXIMIZE YOUR DATA USE

In the blog post, you’ll learn about the Object Info Palette(OIP) with its one-click interface, as well as how to dynamically assign data. The right tools can help you develop your informational model with automated yet flexible initial data input, efficient data management, and accurate verification of your data.