‘Export to Excel’ functionality for Standard Profiles

[JenniferKnieper]

Could you please advise if there is a way to enable ‘Export to Excel’ functionality for Standard Profiles? I can export License Profiles to Excel but don’t see the same option available for Standard Profiles. Is this feature restricted, or can it be enabled through permissions or configuration?

[Marco_Tosin]

Have you already looked at this article?

How to export the "Standard Profiles" and "License Profiles" in Windchill PDMLink

You can read also the Help Guide

https://support.ptc.com/help/windchill/r13.1.0.0/en/index.html#page/Windchill_Help_Center/profilemgmt/ProfileMgmtProfileExport.html#

[JenniferKnieper]

I'm try to export the Standard profile to Excel.  I can export the Standard profile to import to another system, I don't have the Export to Excel option for the Standard profile

[avillanueva]

To clarify, you just asking why the standard profile table does not have an export to excel action list the license profile does, correct? Some tables lack this feature as it was likely neglected in development.  If its no present, there is no good way to enable it without customization. Are you looking to export these for some specific reason? 

[BenLoosli]

It looks like that is not an option.

Standard profiles can only be exported as XML files.

What is the use case for needing the profiles exported?

[JenniferKnieper]

I would like an easy way to view the Standard profiles.  The XML file doesn't give a clean view of the profiles as you have to manipulate the data to get the results.

[BryanK · Accepted solution]

Hi,

If you import the XML file into Excel you can get something that looks like this. 

get data from file xml. 

Transform> Pivot Column

[JenniferKnieper]

Thank you for providing this solution.