Can i import data and edit at mashup

[DR_10558933]

First i get data from excel like this

and then import to Thingworx and create datashape like this

and show data in grid at mashup

but data not show the same as raw data

Can i setting to show as the raw data in grid table and edit data in table?

[Arun_C]

Hi @DR_10558933 ,

 I have tried to replicate the same case in my local Thingworx 9.4.0, its working fine. Can you please post your code/snippet which you have utilized in your service along with your Thingworx version.

Sample CSV File: 

Sample Code to import CSV file to Thingworx  using ReadCSVFile Snippet:

Datashape fields:

Expected Output as Infotable:

Final Mashup Update in Grid:

Thanks & Regards,

Arun C

[DR_10558933]

This is my code

[Arun_C]

Hi @DR_10558933 ,

As per the Parsley Extension - 2.2.8 they mentioned in the note that "ParseXLSX is rudimentary and expects a simple grid of data. It also requires the Apache POI libraries, which conflict with some other extensions". I think the complete XLSX parsing may not be work in this case. 

ParseJSON & PasreCSV are working fine in Parsley Extension. If it is single sheet data better go with CSVParseFunctions by importing & parsing the CSV files which is recommended by PTC Team.

As per this post you can also check with this person for the parsley extension related queries @jamesm1 /jmccuen@ptc.com.

Thanks & Regards,

Arun C

[VladimirRosu]

The key aspect here is that in case you have issues with a non-PTC supported extension you should:

1. always reach out to the extension owner.
2. be prepared to debug and fix the extension's source code in case it's no longer maintained or the owner is non-responsive.

All extensions out there that are not downloadable from support.ptc.com follow this model, and they are always provided as a starter-kit (and not as a supported content).

Note that James no longer works at PTC since quite some time and the email address mentioned above is not valid.

In this situation you should create an issue in that extension's Github repository page (if that really is your issue).