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 sources

Thanks
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 wrote: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 ?