How do we extract data from Windchill to a CSV File ?

[aachanta]

Hi All,

Do we need to develop a utility to extract the Windchill related data say for WTDocument or WTPart or for any other object as well(including Soft Types) to a CSV file or is there any other way we can do that.

If customization is required can anyone share a sample code snippet for the same.

Thanks in advance.

Best Regards,

Aditya Achanta

[satre-2 · Accepted solution]

there are several different ways to extract metadata in CSV and primary and secondary content from windchill.

1. You can use Import/Export Manager to export meta data and primary/secondary content.

2. If you know the database relation ship then you can sql queries and run it on database

3. If you are performing Windchill to Other PLM data migration then you can write custom java class to query data in windchill and write CSV file and download content. in this approach you can control the how you want to write the CSV file

3. You can perform search in windchill and export the search result in CSV format

4. You can reports in report manger and extract the report output in CSV.

Hope it helps!!!!

Thanks

Shreyas