AnsweredAssumed Answered

Update file properties via SQL?

Question asked by Damir Galic on Jul 3, 2019
Latest reply on Jul 5, 2019 by Jerome De San Nicolás

Hello.

Are custom properties of solidworks files stored in SQL database or are they also in solidworks files?

Is it possible to update custom properties of files just by changing stuff in SQL tables?

 

Also does anyone have an example of SQL statement that would update one or more custom properties in specific file and specific configuration and in the last version of solidworks file that's either in pre-state or any other state?

 

How are files identified? Some internal ID? Can that ID be shown in BOM?

 

My objective is to automate this a bit via excel and vba and so people here can compare data with data on our secondary database (which has different purpose).

Outcomes