cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

LOAD JSON/CSV FILE IN THINGWORX

mvolanti
8-Gravel

LOAD JSON/CSV FILE IN THINGWORX

Hello everyone!!

I'm trying to create a demo having data in csv(or json) format.

I would like to import data's file in the composer, parse it and see data in a mashup with a grid.

Also i would like to create a stream that show me (in the meshup) the parameter's trend.

I created a thing with a repository template (because the file is in C:/ThingworxStorage/repository) but when i try the service loadJSON anything appeare to me.

Can anyone help me??

Thank's!!

ACCEPTED SOLUTION

Accepted Solutions
keriw
12-Amethyst
(To:mvolanti)

you need to hit the save button for the service after creating it before you can hit the execute, that's the classic error you see, if you haven't done that.

View solution in original post

6 REPLIES 6
keriw
12-Amethyst
(To:mvolanti)

Maurizio,

Here is an example of pulling data from a csv file stored in a repository and then outputting it as an infotable in a service.

var params = {

  path: "RPTM.csv" /* STRING */,

  columnMappings: "Location;StartTime;EndTime;ProductCode;CasesProduced;PerHourCWS;CWS;Efficiency"/* STRING */,

  hasHeader: true /* BOOLEAN */,

  longitudeField: undefined /* NUMBER */,

  dateFormat: undefined /* STRING */,

  fileRepository: "RPTMFileRepository"/* THINGNAME */,

  latitudeField: undefined /* NUMBER */,

  fieldDelimiter: "," /* STRING */,

  stringDelimiter: "\"" /* STRING */,

  dataShape: "RPTMImport" /* DATASHAPENAME */

};

// result: INFOTABLE

var rptmData = Resources["CSVParserFunctions"].ReadCSVFile(params);

var params = {

  infoTableName : "InfoTable",

  dataShapeName : "RPTM"

};

// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(RPTM)

var modifiedData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

//translating the date fields in csv to date fields in ThingWorx

for each (var row in rptmData.rows) {

   var startTime = new Date(row.StartTime);

   var endTime = new Date(row.EndTime);

   row.StartTime = startTime;

   row.EndTime = endTime;

   

    modifiedData.AddRow({

        Location: row.Location,

        StartTime: startTime,

        EndTime: endTime,

        ProductCode: row.ProductCode,

        CasesProduced: row.CasesProduced,

        PerHourCWS: row.PerHourCWS,

        CWS: row.CWS,

        Efficiency: row.Efficiency,

        Baseline: 100.00

     

    });

}

result = modifiedData;

Thanks,

Keri

mvolanti
8-Gravel
(To:keriw)

Thank's Kery!

I create a service with your script modificate with my name's file and called it GetDataCSV but when i test the servite  appear:

Error executing service

Invalid service name: GetDataCSV

I try to change name service but the error it's the same.

Have you got any idea??

Thank's very much!!

keriw
12-Amethyst
(To:mvolanti)

you need to hit the save button for the service after creating it before you can hit the execute, that's the classic error you see, if you haven't done that.

mvolanti
8-Gravel
(To:keriw)

thank's very much!

now the problem is:

Error executing service

Wrapped java.lang.Exception: Unable To Convert From java.lang.String to NUMBER Cause: Unable To Convert From java.lang.String to NUMBER

keriw
12-Amethyst
(To:mvolanti)

what does your data look like, it sounds like it thinks that there is a value in your number field that is coming across as a string

nkhose
12-Amethyst
(To:mvolanti)

Announcements


Top Tags