Import Excel file and show in infotable

[SaranKarthick]

Hi Team,

ThingWorx Manufacturing and Service Apps 8.3.0 & Operator Advisor Beta are Available for Download!

In the above article you had mentioned under Asset Advisor category there is "Equipment Export/Import via Excel" feature available.

Currently i'm working on a functionality where the user will upload an excel file (not csv) which i have to then parse and show it in an infotable.

I have checked through the community and i came to know about the "Data Export Extension" which can export the infotable as excel file but this is opposite to my use case. 

Since import via Excel feature is available in Asset Advisor can you explain how i can leverage this feature i.e. Thing name and service description, etc.

Thanks and Regards,

Saran   

[SebB · Accepted solution]

Hey @SaranKarthick 

there are multiple things in the MFG apps that have services for the import and export process:

• PTC.SCA.SCO.Common.ImportExportEquipmentUtils
• PTC.SCA.SCO.Common.ParseExcelProcessor
• PTC.SCA.SCO.Common.ImportValidator
• PTC.SCA.SCO.Common.ImportProcessor

The Parse Excel Processor has a "ParseImportFile" service that is used to parse the Excel format for the import services. You can customize this services to fit to your specific requirements and Excel structure.

Here in the customization guide on page 43 you can find more information: 

https://www.ptc.com/support/-/media/B4ECC4B78EBB4DAEAEF1C4D0308587BA.pdf?sc_lang=en

Seb