Data Report - Windchill

[Amirtharaj_K]

Hi Guys,

Can we obtain the total data from Windchill using export to spreadsheet, but the problem is I have more than 5 lakh data.

Regards,

Aj

[PS_10220246 · Accepted solution]

Hi @Amirtharaj_K 

I think below can help you:

• Depending on the memory allocated to Windchill you may decide to lower or raise this value
• Increase the value of com.ptc.jca.exportRowLimit

1. Launch Windchill Shell and execute the command xconfmanager -s com.ptc.jca.exportRowLimit=*** -t codebase\wt.properties -p 
   where *** is replaced by a number e.g. 80000
2. Restart Windchill

Notes:

• Be aware that a high value may cause memory shortage and MethodServer instability
• The new limit does not work for "XLS" and "XLS Report", because older Excel versions are limited to 65531 rows
  • Use the XLSX export instead

PTC support Article for same: https://www.ptc.com/en/support/article/CS52471

Thank you,

Pravin S.