Sepasoft - MES Modules
Cirrus Link - MQTT Modules
Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support
Ignition 8.1. Offline Version (04/2021)
Ignition 8 Online Version
Ignition 7.9 Online Version
Ignition 7.8 Online Version
Converts a dataset stored in a CSV formatted string to a dataset that can be immediately assignable to a dataset property in your project. Usually this is used in conjunction with system.file.readFileAsString when reading in a CSV file that was exported using system.dataset.toCSV . The CSV string must be formatted in a specific way:
#NAMES Col 1,Col 2,Col 3 #TYPES I,str,D #ROWS,6 44,Test Row 2,1.8713151369491254 86,Test Row 3,97.4913421614675 0,Test Row 8,20.39722542161364 78,Test Row 9,34.57127071614745 20,Test Row 10,76.41114659745085 21,Test Row 13,13.880548366871926
The first line must be #NAMES
The second line must list the names of the columns of the dataset separated by commas
The third line must be #TYPES
The fourth line must list the type of each column of the dataset in order, separated by commas
Integer = I
String = str
Double = D
Date = date
Long = L
Short = S
Float = F
Boolean = B
The fifth line must be #ROWS followed by a comma and then the number of rows of data (i.e. #ROWS, 6)
The following lines will be your data, each column value separated by a comma; each row on a separate line. The number of rows must match what was specified on line 5
This scripting function has no Client Permission restrictions.
system.dataset.fromCSV( csv )
String csv - A string holding a CSV dataset in the format outlined above.
Dataset - A new dataset.
Gateway, Vision Client, Perspective Session
# In this example it is assumed that the CSV file being read was a dataset
#that was previously exported using system.dataset.toCSV with the forExport flag set to True:
# Specify file path.
file_path = "C:\\my_dataset.csv"
# Read in the file as a string.
data_string = system.file.readFileAsString(file_path)
# Convert the string to a dataset and store in a variable.
data = system.dataset.fromCSV(data_string)
# Assign the dataset to a table.
event.source.parent.getComponent('Table').data = data
system dataset fromCSV, dataset.fromCSV