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