1.8

Table Of Contents
l a data file, see "Adding data from a data file" below
l a database, see "Adding data from a database" on page242.
After opening a data file or 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, or use the Page Up, Page Down, Home
and End keys.
Tip
If you have no data at hand, download a demo from http://demo.objectiflune.com and
open a dummy data file to test with.
Adding data from a data file
1.
Click File, select Add Data and then click From file data source. Browse to the location
of the file and select it.
The Designer can open the following types of data files:
l Tabular files: CSV files (.csv) and Excel files (.xls, .xlsx)
Note
Excel files saved in "Strict Open XML" format are not supported yet.
l Microsoft Access Database (.mdb, .accddb)
l XML files (.XML).
l AFP files (optional).
2. Review the options presented, to ensure that the data will be interpreted correctly. The
options available depend on the type of data file (see below).
Excel (XLS/XLSX) file options
l
First row contains field names: Check this option to use the first line of the CSV as
headers. This option automatically names all extracted fields.
Page 240