Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Read external file CSV
-
Hi guys,
I should read a file in CSV format. I noticed that among the various datasources there are two that I could exploit: "ASCII file Reader" and "DATA FILE". there is some guide or reference to understand how it works. Because I searched inside the forum and in the documentation and I did not understand how it works. Could you give me some examples? Thanks in advance -
Hi pierjsap,
The ASCII file reader uses regex to parse values by line of the input.
There is good information in context help for the data file data source as to how to use it. That's the blue question mark by the data source name while you are editing it.
In brief, you have to implement a Java class that extends the abstract importer you wish to use. These threads have examples:
https://forum.infiniteautomation.com/topic/1636/problem-with-defining-class-for-csv-datafile-import
https://forum.infiniteautomation.com/topic/3126/file-datasource-breaks-on-file-uploadWe can work through the CSV you need to import in this thread, if you'd like.
Another option that has come up in the past is reading the CSV from a scripting data source, as in this thread: https://forum.infiniteautomation.com/topic/2970/is-it-possible-to-read-several-csv-documents-by-scripting