1.5

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.
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 CSV files (.csv)
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).
CSV file options
o
Encoding: the Designer can not infer from a CSV file what encoding it is in. The default is
right in the large majority of cases, but when it isn't, it can be very difficult to figure out the
correct encoding. Ask your source what the encoding of the file is.
o
Field separator: choose the character that separates the fields in the file.
o
Comment delimiter: if there are comment lines in the file, type the character that starts a
comment line.
o
Text Delimiter: type the character that surrounds text fields in the file. Other delimiters will
not be interpreted within these text delimiters.
o
Ignore unparsable lines: when checked, any line that does not correspond to the above
settings will be ignored.
Page 200