Hello
We would like to do a data extraction from PDM, do you have an example of a query to extract the product line?
Here's an example of how to pull you want:
PDM No. | Reference | Designation | Created by | Created on |
123456 | TA1000 | Table 1000 | draughtsman | 20/02/2018 |
|
|
|
|
|
|
|
|
|
|
Hello
In the Solidworks PDM software folder, you have the Report.exe utility that allows you to extract the SQL database. The Report Examples 1.crp file is viewable with Notepad++ and should help generate the query.
Another solution is to use a macro in Excel.
Hello
the most complicated thing for SQL queries (from my point of view) is to know in which table you will have to type the info and how to make its joins.
What's also a real hassle is that all the versions of files are returned in response and you have to add a filter on it.
(I need to have a list of SQL tables for PDM as well as a query that lists the fields in a table)
I find it easier to make a specific lookup map/columns with the amin tool and export it to Excel for processing.