Services Support - FAQ - How do I read Excel CSV files in the SCADA system VTScada?

How do I read Excel CSV files in the SCADA system VTScada?

Please use VTSCADA version 12.0.43 or above (Image 1), and prepare a CSV file (Image 2). Then follow the instructions below.

(Image 1)

(Image 2)

1. Select Tag Browser and right click > New Child

2. Select All Tag Types > CSV Data Driver

3. ID Settings: Enter name and notes in Name and Description

4. File Settings:

- Fill in an absolute path in Directory to Scan (e.g., D:\).
- Enter the CSV file name in File Spec.
- Leave empty CMEP MEPMD01 Standard.
- Select Header Row in File as the template file has a header.
- Select File Use Unique Keys as the MachineID in the template file lists equipment IDs. As this is row A, which stands for row zero counting from zero, enter “0” in Key Column (0-based).
- Leave empty Parameters in One Column.
- Keep the default setting in File Time Zone.
- Directory Scan Rate (secs) stands for the rate of scanning for the CSV file.
- File Process Rate (secs) stands for the rate of processing for the CSV file.
- Trigger stands for the conditions triggering the function.

5. Date / Time Mappings

- As the template CSV file includes a timestamp row, leave Time&Data Separate Columns empty to indicate the log and time in the same row. As Row B is the first row counting from zero, fill in “1” in Date Column (0-based).

- The “%d” in Data Column Format stands for a reserved space. The value “3” in Year Position means that the third reserved space indicates “Year.” The “1” in Month Position maps the first reserved space with “Month,” and the “2” in Day Position maps the second reserved space for “Date.”

B. Create I/O Tag

1. Right click on CSV Data Driver > Select New Child.
2. Select All Tag Types > I/O and Calculations.
3. Enter “M001::2” in Read Address to indicate this tag corresponds to the second row of the M001’s column (aka. Row C).

4. Continue to add new tags.

C. Check reading results

1. Copy and paste the CSV file to the previously designated path. If the reading is successful, the tag browser will display values.

Back