Yoel Caja

Variables (with Configurations) report in Excel from PDM and SQL

Discussion created by Yoel Caja on Feb 26, 2020
Latest reply on Feb 27, 2020 by Ulf Stockburger

Hi, friends.

 

I know is possible to retrieve data from PDM vault from SQL tables and export it to Excel. But what I would like to do is this same thing including different configurations.

 

For instance, I can create a report for some parts existing in the PDM vault. This report is an Excel file with columns that include weight, price, revisión, status, part number, etc: But it happens this parts have some configurations inside them. So, I need the same variable columns report but also organized by Configuration. 

Example:

Maybe each configuration could be an Excel sheet. Only an idea.

 

My question is if this is possible to do without an API.

 

Thanks.

Outcomes