AnsweredAssumed Answered

Compiling Data from PDM

Question asked by Andrew Holowack on Nov 29, 2017
Latest reply on Jun 1, 2018 by Michael Dekoning

Like • Show 0 Likes0
Comment • 5

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.

No one else has this question

Outcomes

Jeff Sweeney Nov 30, 2017 7:36 PM

Yeah, I'm pretty sure I see you writing a SQL query in your future.

Actions

Steven Richmond Dec 1, 2017 3:30 AM

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

Attachments

Variables Per File Per Configuration.crp.zip1.0 KB

Actions

David Nicholls @ Steven Richmond on May 30, 2018 7:21 AM

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

Actions

Ulf Stockburger Feb 8, 2019 7:53 AM

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

Actions

Michael Dekoning Jun 1, 2018 8:37 AM

Another option is to write a program using the PDM Professional API.

Actions

5 Replies

Jeff Sweeney Nov 30, 2017 7:36 PM
Mark Correct
Correct Answer
Yeah, I'm pretty sure I see you writing a SQL query in your future.
Like • Show 0 Likes0
Actions
Steven Richmond Dec 1, 2017 3:30 AM
Mark Correct
Correct Answer
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
Attachments
- Variables Per File Per Configuration.crp.zip1.0 KB
Like • Show 1 Like1
Actions
- David Nicholls @ Steven Richmond on May 30, 2018 7:21 AM
  Mark Correct
  Correct Answer
  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 Likes0
  Actions
Ulf Stockburger Feb 8, 2019 7:53 AM
Mark Correct
Correct Answer
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 Likes0
Actions
Michael Dekoning Jun 1, 2018 8:37 AM
Mark Correct
Correct Answer
Another option is to write a program using the PDM Professional API.
Like • Show 0 Likes0
Actions

Compiling Data from PDM

Outcomes

Attachments

Related Content

Recommended Content