Data Export Widget
The Data Export widget provides functionality to export data to a CSV file.
When using the Data Export widget, if you are exporting data that contains password data (for instance a password property and its values) via a ThingWorx service such as GetStringPropertyValue, do not bind that service directly to the Data Export widget. The best practice is to create a wrapper service that finds any Password Primitive data types and gets their plain text password value and encrypts that value and adds it to a new infotable (or replaces the existing infotable's old password value and primitive type appropriately) to a encrypted value using the EncryptionServices.EncryptPropertyValue service. A partial example of this is below:
var params = {
propertyName: "Property1" /* STRING */
};
// result: STRING
var plaintText = me.GetStringPropertyValue(params);
var params = {
data: plaintText /* STRING */
};
// result: STRING
var result = Resources["EncryptionServices"].EncryptPropertyValue(params);
propertyName: "Property1" /* STRING */
};
// result: STRING
var plaintText = me.GetStringPropertyValue(params);
var params = {
data: plaintText /* STRING */
};
// result: STRING
var result = Resources["EncryptionServices"].EncryptPropertyValue(params);
For more information, see Passwords.
If you are using a service that returns PASSWORD primitive properties as PASSWORDS such as GetPropertyValues, the value will be encrypted and is safe to bind directly to the Data Export widget for export. The Data Export widget will produce a CSV output, PASSWORD types values will remain encrypted in the resulted CSV and do not require a wrapping service.
 |
Styles and common widget properties are not included in the table below.
|
|
Property Name
|
Description
|
Base Type
|
Default Value
|
Bindable? (Y/N)
|
Localizable? (Y/N)
|
||
|---|---|---|---|---|---|---|---|
|
CustomClass
|
User defined CSS class to apply to the top div of the widget. Multiple classes can be entered, separated by a space.
|
STRING
|
n/a
|
Y
|
N
|
||
|
Export
|
A service that exports the CSV data.
|
Service
|
n/a
|
Y
|
N
|
||
|
ExportFileName
|
Sets the filename for the exported CSV file.
|
STRING
|
n/a
|
Y
|
N
|
||
|
Label
|
The text to display on the button.
|
STRING
|
Export
|
N
|
Y
|
||
|
TabSequence
|
The index of the Data Export widget in the tab sequence.
|
NUMBER
|
0
|
N
|
N
|
||
|
RoundedCorners
|
Determines if the button has rounded corners.
|
BOOLEAN
|
True
|
N
|
N
|
||
|
Data
|
Data service return. Select an infotable from a service return as the data source for this property.
|
INFOTABLE
|
n/a
|
N
|
N
|
||
|
IconAlignment
|
Aligns the icon for the button to the left or right of the text.
|
STRING
|
True
|
N
|
N
|
||
|
IncludeBOM
|
Adds a UTF-8 byte order mark at the start of the exported CSV file.
|
BOOLEAN
|
False
|
N
|
N
|
||
|
ShowDataLoading
|
Displays a spinning icon when data is loading.
|
BOOLEAN
|
True
|
N
|
N
|
||
|
ShowAdvancedExportOptions
|
Displays a drop-down list that enables users to export data using one of two options: CSV (Standard) and CSV (Excel Formatted)
|
BOOLEAN
|
False
|
N
|
N
|
||
|
Visibility
|
Sets the visibility of the widget in run time.
|
BOOLEAN
|
True
|
Y
|
N
|
