This graphic component lets you export an entire datalogue in CSV (or PDF) format.The component lets you customize the format of the generated file by means of a few properties. In any case, the only properties required for use of the component are “groups” and “groupsDescription.”If required, you can check the component from PLC with two variables that let you command export.The following properties are available:groups: list of datalogue groups to be exported. Every group lets you generate a report with the datalogues listed in the columns and order them by sampling date and time. Each list is composed by the name of the datalogues chosen, separated by a comma. Example of groups:
LOG1,LOG2,LOG3
LOG2,LOG4
LOG1,LOG4,LOG5,LOG6groupsDescription: description of groups listed in groups property. Lets you assign descriptions (linked to active language) to each of the listed groups. Example of descriptions:
Temperature samplings
Head temperatures
Global working temperaturescsvCommaChar: choice of character to be used as decimal separator in REAL numerical values. Default value: COMMA.
Possible values are:
COMMA: “,”
PERIOD: “.”csvSeparatorChar: choice of character to be used as field separator in CSV file. Default value: SEMICOLON.
Possible values are:
TAB: separator with “TAB”
COMMA: separator with “,”
SEMICOLON: separator with “;”csvUseQuotes: lets you specify if it is necessary to define fields with a control character (ex.: quotation marks). Default value: NONE
Possible values are:
NONE: no defining character
SINGLE: single quotation mark ‘
DOUBLE: double quotation mark “alwaysOverwrite: allows to activate the CSV export overwriting an already existing file with the same nameformatDate: lets you customize the sampling date format with a formatting string.
Customizing is done by means of a string with dynamic parameters. Default value (used with “[none]” value): %14/%15/%8 (example: 15/07/2010)
The following parameters are available:
%6 : replaced with indication of the day [1..31]
%7 : replaced with indication of the month [1..12]
%8 : replaced with indication of the year in 4 figures
%9 : replaced with indication of the year in 2 figures
%14: as %6, but with zero at left if necessary
%15: as %7, but with zero at left if necessary
%16: as %9, but with zero at left if necessaryformatTime: lets you customize the sampling time format with a formatting string.
Customizing is done by means of a string with dynamic parameters. Default value (used with “[none]” value): %10:%12:%13 (example: 22:51:48)
The following parameters are available:
%1 : replaced with the hour [0..23]
%2 : replaced with the hour [0.12]
%3 : replaced with AM or PM
%4 : replaced with indication of minutes [0..59]
%5 : replaced with indication of seconds [0..59]
%10 : as %1, but with zero at left if necessary
%11: as %2 but with zero at left if necessary
%12: as %4 but with zero at left if necessary
%13: as %5 but with zero at left if necessarystartMarker: string to be used when you have to indicate the sampling START time in the report. Default value (used with “[none]” value): “START”stopMarker: string to be used when you have to indicate the sampling STOP time in the report. Default value (used with “[none]” value): “STOP”invalidMarker: string to be used when you have to indicate in the report that sampling was not done (for example, if 2 datalogs with samplings at different intervals are specified in a group). Default value (used with “[none]” value): string emptystringID: strings that let you customize descriptions in the component. Individual strings must be separated by a semicolon “;”. They are (in order): the string that describes the label (“File name:”) and the start export button (“Export”). Default value (used with “[none]” value): “File name:;Export”.path: selects the destination folder where CSV files will be created.
Value
Destination
ATA0A
/ata0a/export/
USBKEY
/usbkey/export/
USBKEY1
/usbkey/1/export/
SDCARD
/sdcard/export/
ctrlStart: control variable that lets you command export by code. To run export, you have to change the value of the variable (up or down). The group to be exported is contained in the variable specified in the ctrlGroup property. The filename is contained in the variable @@EXPORTFILENAME.ctrlGroup: variable that contains the number of the group to be exported via code (the first corresponds to value 0). The control variable that commands start is specified it the ctrlStart property.index: allows to use the widget more than one time inside the program (e.g.: on two different pages). In this case the widgets must have a different, unique index (e.g.: “1” for the first widget, “2” for the second and so on).remote: remote system name to connect with. To connect to a local system leave this field empty.remoteUser: FTP username of the remote system, if not specified the datalog is not transferred to the specified remote. In case of Full HMI system if not specified the datalog will not be saved.remotePassword: FTP password of the remote system, if not specified the datalog is not transferred to the specified remote. In case of Full HMI system if not specified the datalog will not be saved.