Skip to main content
P
pbaierl1-Visitor
1-Visitor
September 27, 2016
Question

Exporting Data Question

  • September 27, 2016
  • 1 reply
  • 1883 views

Is there a way to export my historic/logged data to an external server?

I will need to export a number of data items.  I will have to export a combination of data sets (individual parameter data, thing parameter data, data from a group of things)

Any guidance on where to start looking on how to do this would be greatly appreciated.

Thanks,

Paul

1 reply

C
CarlesColl1-Visitor
1-Visitor
September 27, 2016

You can use this library https://marketplace.thingworx.com/Items/csv-parser  in order to generate CSV files with the data you want to export.

Also you can generate easily JSON files and or XML

Don't use this extension https://marketplace.thingworx.com/Items/Data%20Export%20Extension as the Excel generated will be a pain to process ( almost all the data it's not generated on the correct Excel data format )

It will depend on how you want to ingest the exported data.

To query the data, if it are on ValueStreams, you will need to use Query"baseType"PropertyHistory to get the data, if it are Streams the corresponding QueryStream services.

On previous versions ( before 6.5 ) with exporter services you where able to generate XML/JSON files for Data, but not (at least from composer) it's not possible, it exports the data on propietary binary format that you will need to reverse-engineer.

Best Regards,

Carles.

P
pbaierl1-VisitorAuthor
1-Visitor
September 27, 2016

Thanks Carles!

I will take a look into your suggestion.

Could you provide a bit more information on exporting the values as json?

C
CarlesColl1-Visitor
1-Visitor
September 27, 2016

"InfotableVariable".ToJSON();

If your destination server can Query a REST API, you may create services directly which returns the desired data, you will have the answers on JSON.

Best Regards,

Carles.

Terms & ConditionsAccessibility statement