Download Import Wizard

Transcript
Importing HTML Files
With this option you can import one or more HTML tables. The screen is split up in four
windows: top left is the “HTML File Structure” window, top right “Table Preview”, bottom left
“Model” and bottom right “Field Properties”.
The “HTML File Structure” window shows an overview of the tables in the HTML file, clicking
on a table will show that table in the “Table Preview” window. Pressing the “Apply” button will
build a default model for this table, the result can be seen in the “Model” and “Field
Properties” windows. Changing fields works in the same way as with a Defining a Fixed
Import.
The “Table(s) to import” property can contain one or more tables. 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.
The “Table Preview” window might contain the following entries ###Table:x###,
###Colspan###, ###Rowspan### to indicate that at that position a embedded table
exists, or that the cell is covered in a column or rowspan. These entries will not show up in
the actual imported table.
Field Properties
Select a field from the "Fields" list, then set the field properties as required:
Name
The name of the selected field from the Field Names list.
Field No
The delimited field number to import from each line. This property in not used for fields with
Convert To "Variable".
Convert To and Conversion Method
These properties determine the conversion rules to be used for the import of the field, see
Conversion Field Properties for details.
Repeat
If set to "Yes" then the previous field value will be repeated if the current field value is empty.
Formula
If a formula is entered, the result of the formula will be stored in the field. For detailed