Download View PDF Documentation

Import Wizard
Other Import Examples
See Also: Import Example 1: Simple Import | Import Example 2: Header Imports | The Main Import Wizard Window
The examples are stored in the "Samples" subdirectory of the directory where you installed Import Wizard,
"C:\Program Files\Import Wizard 8\Samples" by default.
Example 3: Address Import
This example shows how to solve problems with optional fields, i.e. fields that are not present in each record. By
defining separate sections and markers for each field it is possible to correctly import such files.
Example 4: Delimited Text File
This example shows how to selectively import fields from a delimited text file. The file used in this example is
the log file of a web server.
Example 5: Footer Import
Sometimes the required information is found in footers below the actual record. This example shows how to use
footers in an inventory report.
Example 6: Use of Delimited Field No and Formula properties
This example uses the SAMPLE1.TXT file to create a table with the first/last name of the employee together with
the total number of hours.
Delimited Field No/Delimiter properties
The employee name is in the source file in the format Last, First (for example: “Doe, John”) From this data the
first and last name are extracted using the “Delim Field No” property. To extract the last name “Delim Field No”
is set to 1 and “Delimiter” to {COMMA}, this will extract the first field from the left. For the first name “Delim
Field No” is set to –1, thus extracting the first field from the right. Note that “Delim Field No” set to 2 would
have worked as well of course.
Formula properties
The first and last name obtained using the method described above is combined into a field named “FirstLast
Name” using the formula: First_Name & “ “ & Last_Name
Note the underscore (“_”) in the fieldnames in the formula. As spaces and other special characters are not
allowed in formula names these have been replaced with an underscore. The name of a field for use in formulas
is given by the Formula Field property.
The “Hours” field has this formula: Regular_Hours+Other_Hours+Overtime_Hours, thus adding up all the hours.
Note that the “Regular Hours”, “Other Hours”, and “Overtime Hours” fields are present in the model but not
output to the destination table. This is because the Skip property is checked for these fields.
Example 7: Multi Line Fields
This example demonstrates the use of the MultiLine Field Type property.
Example 8: Vertical Report
Sample report with records organized in columns instead of rows.
Example 9: Chinese Characters
Import of a file with Chinese characters. The Chinese characters are treated as double width characters in order