5 Replies Latest reply on Jun 1, 2018 8:37 AM by Michael Dekoning

Compiling Data from PDM

Andrew Holowack Nov 29, 2017 10:47 AM

Hi All,

We have PDM Professional and I have recently been asked to provide some information about our library (List of all parts with their associated part numbers) as well as other information. We have a lot of files which have configurations with different part number for each configuration. I can use the search function in PDM but this doesn't provide the information for each configuration. Is the only way I can get this information for all configurations by using the report generator and creating a SQL query or is there another options?

Thanks for your help.

Re: Compiling Data from PDM

Jeff Sweeney Nov 30, 2017 7:36 PM (in response to Andrew Holowack)

Yeah, I'm pretty sure I see you writing a SQL query in your future.
Like Show 0 Likes(0)

Actions
Re: Compiling Data from PDM

Steven Richmond Dec 1, 2017 3:30 AM (in response to Andrew Holowack)
Hi Andrew,

If you have access to the customer portal there are a bunch of SQL queries that can be found on there which can then be used with the report generator. I've attached one which searches the database for a specific variable for each file and for every config within that file. You can even search for multiple variables at once.

Regards
Stevie

Variables Per File Per Configuration.crp.zip 1.0 KB
Like Show 1 Likes(1)

Actions
- Re: Compiling Data from PDM
  
  David Nicholls May 30, 2018 7:21 AM (in response to Steven Richmond)
  
  Hi Steven, I have been searching the customer portal and can not find these queries. Is there a link or are they scattered in the forums?
  
  Dave
  
  Like Show 0 Likes(0)
  
  Actions
Re: Compiling Data from PDM

Ulf Stockburger Dec 11, 2017 9:52 AM (in response to Andrew Holowack)

Hi Andrew

I have a report similar to SolidWorks. In this you can also limit the variables to a specific file version and you can see in which version the variables have been changed. It is also possible to work with wild cards when selecting configurations and variables. ShowAllAssignedVariables.7z In my opinion, it is a bit more comfortable. Maybe it will help you, but you won't get by in the long run without SQL.

BiI SAP-PDM
Like Show 0 Likes(0)

Actions
Re: Compiling Data from PDM

Michael Dekoning Jun 1, 2018 8:37 AM (in response to Andrew Holowack)

Another option is to write a program using the PDM Professional API.
Like Show 0 Likes(0)

Actions

Go to original post