Download View PDF Documentation

Import Wizard
Importing Delimited Files
Introduction
Upon creating a new model for a delimited file, Import Wizard tries to find the best Delimiter Settings for the import and builds a model for these
settings. If these settings are incorrect, you can change the Delimiter Settings and press the 'Build Model' button to rebuild the model. For an
introduction in more advanced features such as Markers please read the Tutorial.
Window Layout
The screen is split in three subwindows:
Model Definition Window gives an overview of the markers and fields defined in the model. When you select a marker or field in this window the
File window highlights the part of the file that matches the selected item and the Properties window will show the properties for the selected item.
Properties Window gives the property details for the selected marker or field in the Model window.
Source File Window shows the file content split into fields according to the Delimiter Setup. Lines in the source file which match the selected
marker are highlighted in yellow. If a field is selected then the field data is also highlighted in red. Discarded (ignored) lines are gray and any other
lines are blue.
When you click anywhere in the Source File Window the first field for the selected marker and clicked column will be selected. If the field does not
exist, a messagebox will ask you if you want to create a new field.
The Copy and Delete buttons operate on the currently selected item in the Model window. For example: if the Copy button is pressed while a Field is
selected then that field is copied into a new field.
Delimiter Setup
Build Model button
Pressing this button will create a new model with fields according to the selected settings. Changing Delimiter or Text Qualifier updates the File
Window immediately, the fields and markers stay unchanged unless you press the Build Model button.
Delimiter
Sets the delimiter character(s) that separates fields in the import file, see Delimiter Characters Definitions.
Text Qualifier
Field starting with this character are expected to end at the next occurrence of this character. I.e. embedded delimiter characters are ignored until
the closing text qualifier character is processed. Two consecutive Text Qualifier characters are treated as a single character upon import. See
Delimiter Characters Definitions.
Get field names from line
This is the line number where the field names are taken from after you press the Build Model button. Line number 1 is the first line of the file. Set the
line number to 0 if the file does not contain field names. The two dropdowns control the casing and filtering of non-alphanumeric characters of the
fieldnames, changes are applied after the Build Model button is pressed.
Fields
To create a field: First select the marker for which you want to create a field, then click any cell in the column for which you want to create a field. If
the field already exists, it will be selected and you can use the Copy button to create a duplicate. Alternatively, you can press the Add Field button
and change the Field Properties manually. The data which will be imported for the Field appears with red background color in the Source File
The following table only describes the Field Properties specific for Fixed imports, see Field Properties for a description of common Field Properties.