2020.2

l
Sort on: Select a field on which to sort the data, in ascending (A-Z) or
descending (Z-A) order. Note that sorting is always textual. Even if the
selected column has numbers, it will be sorted as a text.
3.
Click Finish to open the database.
After adding data from a database, the Data Model pane at the right hand bottom shows the
data fields that occur in the data.
The Value column displays data from the first record in the data file. Use the First, Previous,
Next and Last buttons to browse through the records.
Adding JSON data from a JSON file
JSON data can either be added to, or replace the Data Model in a template.
To add data from a JSON file:
1.
Select File > Add Data > JSON sample data, from the menu. Alternatively, click the
JSON Sample Data toolbar button on the Data Model pane.
2. Either browse to the location of the file and select it, or paste or write the JSON directly in
the box below the file name.
3. Review the JSON; you may edit it if you like.
4.
Select the Replace Data Model option if you want the JSON to replace the existing Data
Model. Otherwise, the JSON data will be mapped to corresponding fields in the existing
Data Model, and data that cannot be mapped to any field will be discarded.
5.
Click Finish.
Note
Values are converted to text strings. If a value in a record object is another JSON
object, it is ignored.
Add a counter using the Generate Counter Wizard
Generating a counter is useful for numbered tickets or any other template requiring sequential
numbers but no variable data.
Page 339