Table of Contents
Import Wizard - Import From Text Help
On this page, you can define the relationship between fields in the data file and target table and tune import options.
Options of CSV Format
- Field Delimiter – Determines characters that will be used as a field delimiter. You can select one of the standard delimiters like SPACE, COMMA, SEMICOLON, COLON. Also, you can type in a custom delimiter.
- Line Delimiter – Determines characters that will be used as a line delimiter. You can select one of the standard delimiters – CR, LF, CRLF. Also, you can type in a custom delimiter.
- Encoding – Determines encoding of the exported file – UTF8, UTF16, etc.
- Has Column Header – Check if the first line of the source file is a header.
- Limit Records – Determines the number of records to load from the data file.
- Use Transaction – If supported by the database engine, determines whether to use a transaction to insert records or not. Usually, inserts in transactions are performed faster.
- Text Qualifier – Specify characters used to mark text values in the data file. It is necessary to use qualifiers if a value contains characters defined as delimiters. Note, not all database engines support this option.
Fields of Target Table
This area contains the list of fields in the target table. It is shown only if import to an existing table is performed.
Under the list, there is a set of buttons:
- Create Field… – Invokes the dialog to create a new field in the selected table.
- Smart Mapping – Maps table fields to the columns of the source file automatically.
- Clear Mapping – Cancel the mapping.
The following buttons are available in the Valentina Studio Pro:
- Save Mapping… – Saves the mapping in a file on disk for later use.
- Load Mapping… – Loads the mapping from the file.
The table contains a sample of data loaded from the source file.
It is necessary to drag and drop fields from the list to the columns of this table or use the Smart Mapping function.
After mapping, the column header contains the name of the mapped field.
If the data file contains a header, the first line is marked with a different color.
You can unmap a particular field using the context menu or click Clear Mapping to unmap them all.