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

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Read csv files into thingworx

VR_10133499
13-Aquamarine

Read csv files into thingworx

We have scenario where we have data stored in csv files stored in local computer and we need to read the data into thingworx which is present in cloud. we then have to visualize the data loaded into thingworx from csv in a mashups.

 

Any leads on how we can achieve it. we also have kepware where we can use simulators to read csv files to a tag and then read the data from the tag. But is it possible to read files directly into thingworx without interacting with kepware.

1 ACCEPTED SOLUTION

Accepted Solutions
nmutter
14-Alexandrite
(To:VR_10133499)

You could create

- a TWX agent which will upload the files to ThingWorx e.g. with the Java SDK c_javasdk_sdk_file_transfers.html . But this is some work.

- a script which calls REST-API of thingworx which uploads a file

Can the machine/local computer:

- connect to the TWX instance directly? Or only via Kepware 'proxy'?

- execute custom executables?

 

I'm not sure how to do it nicely via Kepware.

View solution in original post

5 REPLIES 5

If thingworx server able to reach local computer then you can try following,

  1. FTP
  2. SMB/NFS - Windows or Linux Fileshare over the network

No, our thingworx is on cloud and file is on local network secured using firewall. and we are not able to reach local computer from thingworx.

nmutter
14-Alexandrite
(To:VR_10133499)

If doing it manually is fine:

  1. Create mashup with FileUpload widget
  2. Let user upload the csv file to a FileRepository via the mashup
  3. On upload complete call a service in TWX using CSV Parser to read the csv
  4. somehow transform the data for your mashup to visualize it (not clear what visualization u need)
VR_10133499
13-Aquamarine
(To:nmutter)

The files are generated automatically using a software frequently and periodically so it is not feasible for the user to upload the files manually to FileRepository.

Also the thingworx server is on cloud and csv files are generated in a machine located in the organisation network..

nmutter
14-Alexandrite
(To:VR_10133499)

You could create

- a TWX agent which will upload the files to ThingWorx e.g. with the Java SDK c_javasdk_sdk_file_transfers.html . But this is some work.

- a script which calls REST-API of thingworx which uploads a file

Can the machine/local computer:

- connect to the TWX instance directly? Or only via Kepware 'proxy'?

- execute custom executables?

 

I'm not sure how to do it nicely via Kepware.

Top Tags