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

CSV Parser Help

SOLVED
Highlighted

Re: CSV Parser Help

I have used both way undefined and all column names too! is there any tutorials on this plz?

Highlighted

Re: CSV Parser Help

Have you imported CSV Parser?

Highlighted

Re: CSV Parser Help

No, I am still researching, Can you help me on this plz?

Highlighted

Re: CSV Parser Help

Yes, Thank Satish. Finally i have done it and imported successfully!

 

Regards

Vikas

Highlighted

Re: CSV Parser Help

Cool.

Highlighted

Re: CSV Parser Help

 Hi,

 

I have csv file imported, In csv file i have 5 columns like (timestamp, tagName, condition, timestamp_value, value) so

 

1524046971797.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046975530.00 0
1524046972789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046976535.00 0
1524046973789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046977529.00 0
1524046974789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046978333.00 0
1524046974804.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046979350.00 0
1524046975789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046980517.00 3
1524046976790.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046981469.00 3
1524046976804.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046982449.00 3
1524046977789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046983569.00 3
1524046978788.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046984556.00 3
1524046979790.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046985722.00 3
1524046980789.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524046986655.00

3

 

1524047070162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047093717.00 0
1524047071162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047094549.00 0
1524047072162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047095863.00 0
1524047073162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047096665.00 0
1524047074162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047097686.00 0
1524047075162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047098625.00 0
1524047091163.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047116512.00 3
1524047092162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047117518.00 3
1524047093163.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047118781.00 3
1524047094162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047119747.00 3
1524047095162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047120609.00 3
1524047096162.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047121857.00 3
1524047097163.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047122868.00 3
1524047098163.00 Channel2.ARK CNC Machine.General Status Information.Auto Operate TRUE 1524047123886.00 3

 

few rows are coming with value 0 and then 3 and again 0 respectively....

 

I want to calculate summasation of timestamp with intervals which has value 3

 

is there any way to calculate such values or can you give me any idea so that i can try?

 

Regards

Vikas

Highlighted

Re: CSV Parser Help

Filter with value 3. and iterate the infotable or do aggregation based on requirements.

Highlighted

Re: CSV Parser Help

Hi Satish,

 

Can you help to do "Filter with value 3. and iterate the infotable or do aggregation"?

 

I am really new to Thingworx, can you plz?

 

Regards

Vikas

Highlighted

Re: CSV Parser Help

Hi Jeff,

Here is an example per the test data you provided and it works on my Thingworx 7.0.0-b479:

var params = {

    columnMappings: "Tagname;Description" /* STRING */,

    hasHeader: "false" /* BOOLEAN */,

    longitudeField: undefined /* NUMBER */,

    dateFormat: undefined /* STRING */,

    latitudeField: undefined /* NUMBER */,

    fieldDelimiter: "," /* STRING */,

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

    content: "XV101,Valve Input\n" /* STRING */,

    dataShape: "PES_Tags" /* DATASHAPENAME */

};

// result: INFOTABLE

var result = Resources["CSVParserFunctions"].ParseCSVFile(params);

Hope this helps,

Thanks,

Br,

Anna

Highlighted

Re: CSV Parser Help

Thanks both of you!!!! My issue was the space between the columnMappings... I appreciate it.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________