Integrations & Setup
...
CSV
Configuring a CSV Collector
the csv collector in factry historian allows you to parse and collect data from csv files once measurements are configured and a valid csv file is available in the collector’s incoming path , the data is automatically processed into data points according to the measurement configuration, making it available for historization, reporting, and analysis in factry historian prerequisites permissions in factry historian to manage collectors see privileges docid\ k2nnyecuxqqsiuclmpfkh an installed csv collector if you have not done so already, first installing a collector docid\ iv4 sd56tdxcqkrkcj4kv a configured creating a time series database connection docid\ sq5uvlchyg7umi930nyml to write the collected data to collector access to a shared folder/disk with readable csv files configure the collector after installation, the collector should appear in an initial state initial state and be actively running this indicates that it has successfully connected to factry historian and is ready for configuration to configure the collector, select it from the collectors overview in factry historian and click the edit button configure the following fields delimiter specifies the delimiter used in the csv file to separate values for example , csvheader indicates whether the csv files contain a header or not if a header is present, the header record will be skipped when parsing the csv file timestampcolumn indicates the column index of where the timestamp can be found in the csv file index starts from 0 basepath the default directory containing the incoming , processed , and error subdirectories default subdirectory names incoming processed error paths are absolute add a trailing forward slash ( / ) for linux or a trailing backslash ( \ ) for windows for example c \plantdata\\ filemask defines the file mask pattern used to identify which csv files should be used for example csv example then, click save expected outcome after you have configured the collector, a green start button will appear in the top right corner of the collector page click start to launch the collector if the connection is successful, you should observe the collector status change to collecting collecting troubleshooting error occured while parsing file make sure you set the correct delimiter in collector settings according to the delimiter used in your csv file adding measurements follow the guide on read data from csv docid\ qjcpc1w8j8zngta38mpqu