Search the Community

I have an issue with an external database, which all in all I'm relatively new to. I have successfully gotten lighting devices to automatically update and sync the changes, and mapped the fields well. I have a UUID field that pulls the IDs and places them in a field I can extract, so a unique key field to use as well. My issue right now is that there are 13 lighting devices pulled into the database that are not in the VW file (screenshot attached). If I add a fixture it adds it, if I remove a fixture it removes it, so it's syncing correctly, and I have my options set correctly just going off that. What would cause this, if anyone knows? 🔴 EDIT: Just adding some additional info that probably points to why I'm seeing these additional fixtures without them being in the file. How I have no idea, but maybe someone will see this and their light bulb will brighten up 🙂 First Screenshot: The list of fixtures in the database, after adding in 4x 36 degree S4s and 1x Moving light Second Screenshot: The UUIDs pulled for the fixtures. Notice the ACTUAL UUID strings, and the single character map that somehow got applied to these ghost fixtures as a UUID. I don't know enough about how exactly Vectorworks carries it's data out to external sources, or what process it goes though to create a SQLite file to point towards and map the chosen records to, but something is fishy here. If this looks familiar to anyone, let me know!

Creating a database of materials and specifications unfortunately is quite a tedious task and not always can be done inside of VW. Currently, when editing properties for materials, all physical / other properties need to be filled in manually. Given the number of permutations for material properties, the task almost seems unreachable when doing this manually (also especially when needing to update the information! ) What if we could populate it from a database (say that has a list of information regarding Building product information in HEAT, AIR, and Moisture Control in Building Assemblies - material properties from ASHRAE Handbook of Fundamentals,etc..)