Jump to content

Database Issue With SQLite File


JanezicDesign

Recommended Posts

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?

 

 

 

 

Screenshot2024-09-22185015.thumb.png.0cf90a7fa95b2d415c0ba53c58fb4d83.png

 

 

🔴 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

 

Screenshot2024-09-22200348.png.3dce9986eb4ba2ef194c7406ade110f9.png

 

 

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!

 

Screenshot2024-09-22200357.png.84ae181f5e9a8f64de0714cf4a09bd18.png

 

 

 

 

Edited by JanezicDesign
New Information
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...