Download View PDF Documentation

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 Data
The following table only describes the Field Properties specific for Fixed imports, see Field Properties for a description of common Field Properties.
Field Property
Description
Column Number
The column number which is imported into this field. The first column is number 1.
Marker Number
The marker number that will trigger the import of this field.
Line
The line offset of the import field relative to the line that matched the marker pattern. I.e. line 0 means the
field is on the same line, -2 means the field is two lines above the matched line.
Strip Tags
When set to True all HTML tags are removed from the field.
Markers
You can create new markers by pressing the Add Marker button, this will create a new blank (match all) marker. See Markers for a detailed
description of all Marker properties.
The Column Number property defines which column number is used for matching. The first column is number 1. NOTE: Column Number 0 will
match against the first field as well, not the whole record.
The marker pattern can be edited directly above File contents. NOTE: the marker always matches against the data with HTML tags included, even if
'Strip Tags' has been checked. This allows for matching information inside HTML tags, such as the href="" attribute.
Import Properties
Selecting Import Properties in the Import Definition window allows you to set the following properties:
Property
Description
HTML Table(s)
The HTML table number(s) to import. Tables are numbered sequentially as they occur in the HTML file. You can
use commas to separate table numbers, and dashes to indicate ranges of tables. For example '1,4-6' will import
tables 1, 4, 5, and 6.
Skip Number of Lines
Skips this many lines from the start of the file.
Year 2000 Cutoff
This is the first year for two digit year imports that will be treated as in the 20th century. This is set to 30 by
default, i.e. 30-99 converts to 1930-1999, 00-29 to 2000-2029.
Code Page
Select the desired character set Code Page to read the source file. Import Wizard works internally with unicode
(16bit) characters. If the required Code Page is not in the list the enter the Code Page number by hand. If the
Code Page is invalid you will get a import warning upon importing.
© Beside Software - All rights reserved.