Text file data point
-
Hi,
is it possible somehow to create a texte file (csv for example) as
data source? Can someone give me ideas? Thanks... -
Currently, no. But it is something that is being considered. You'd just want to be able to do a browse/upload of a file?
-
Hi,
I need this functinality too. I like to setup a schedule for example every five minutes read the file (CSV format) from ftp server and link each value to a data point. Your help is appreciated.
Similar to SQL data sourcesThanks
Mo -
Maybe the way exists.
You can use Javascript with imported FileInputStream and FileOutputStream. Or, you can create JAVA library for CSV file controlling and import to Javascript in datapoint.
I am using this for serial communication with unsuported protocols etc. Siemens Elan protocol.Please, describe your requirements for CSV access.
Oja
-
Hi,
I can use the event handler and choose the type as Process and run the script (e.g. JavaScript) to read the CSV file and write it into a database (Derby, MySQL, etc).
The rest is easy to setup a SQL data source and map the table columns into data points. I appreciate if you can suggest an effective way to write the script to read the file and write it into DB.
Thanks
Mo -
The most effective way would be to create a data source that can read CSV text files, similar to how the point data upload module works in M2M2.
-
Thx Matthew,
Is there any plan to integrate it in M2M2?
Mo
-
You mean in M2M? No, there are no plans to port it over.
-
@oja said:
Maybe the way exists.
You can use Javascript with imported FileInputStream and FileOutputStream. Or, you can create JAVA library for CSV file controlling and import to Javascript in datapoint.
I am using this for serial communication with unsuported protocols etc. Siemens Elan protocol.Please, describe your requirements for CSV access.
Oja
Hi, that's exactly what I need
I wish to read some datapoints BOTH via Modbus/TCP when my device is online, and to read same datapoints stored locally in devices filesystem and uploaded to my server via some backup connection, in roder not to lose recordings on unreliable networks. Could you please explain better how to implement such a Javascript task and to integrate into Mango, or address me to a working example ?