PDM to Excel Export

Hi all

I would like to perform an extraction from PDM to Excel.

Let me explain: We have a database with all our standard products, I would only like to retrieve the reference which is the name of the part or assembly + the mass of the part, to note that these two "data" are present in my data card. All in an Excel table

Thank you for your feedback :slight_smile:

Hello
By searching if you know the file names, just display the variables you are interested in in the columns of the result (it is set up in the administration) and export the result to Excel for processing.
There are still possibilities via Excel directly by macro if you know the file names and their locations.

1 Like

Hello

Thank you for your feedback. I can't create a column view that shows up in the full search

Hello

You need to add or change the display view here:
image
Don't forget to give rights to users

1 Like

Thank you for your answer. Indeed that's what I did but it doesn't offer it to me in the explorer

image

Hello;

You will normally find some answers here:

Kind regards.

Hello
It's not in quick search but search result

Hello

Yes sorry it's my screen that's wrong because I tested in both before answering you

image

But it doesn't work

Oh yes sorry, I think it's a bug of the 2022 at least (version I'm on) because you can no longer assign permissions on search results.
So as it stands, there are still macros or use the quick search from the explorer:
image

Edit: I'm correcting myself, not a bug but a SW will, who knows why...

Hello

So in the state via PDM I can't do anything because my goal is to display filtered products via the data card.

Hello
Via the data card, yes. Personally, I think I'm going to create a request for SW because it's a regression compared to the old versions.
As we have had PDM for years, we have been able to keep some of the settings and as a result we have different displays for admins and users for search results.
So we can still edit them and add missing columns, but we can't create anything anymore.
The only way I see if it's for a database management need only accessible to you, a macro in Excel will be just as effective.
Edit: As for another topic on PDM, I honestly wonder how they manage the evolutions on this software. They give us changes that make no sense from a usage point of view (no more configurable columns for the different groups, loading of parent and child files of all the files contained in an ASM when they are obtained, parameter in the groups that does not replicate on the users of the group...). With 3DExperience anyway I doubt that SW will make evolutions on PDM in the years to come (already that evolutions have been rare for at least 3 years).