Column Data Import: Fields to Columns Dialog Box

This is the final step of the Column Data Import Wizard. Now that you have defined where the data columns are, you need to specify which column maps to which field of a Personal Knowbase article. You can specify a mapping by selecting the column from the appropriate drop-down menu or by clicking on the column in the File Preview pane while the cursor is in the corresponding field.

You can also specify the formats for the date and keyword columns in this step.

Select the Back button to return to the previous step of the wizard. Select the Finish button to complete the wizard and import the file. Select Cancel to stop the import process.

Delimited File

This is the full path and file name of the file you are importing.

Personal Knowbase attempts to automatically detect and assign the columns of your file to the appropriate fields, based on the text found in the Column Names line of your file which was specified in the previous Setup Dialog Box. If a column's header is missing, the column is referred to by its column number (for example, "Column 1").

Title / Date / Content

For each of the first three article fields, use their drop-down menus to select the column from your file which maps to that field. When a column is selected, the corresponding column in the File Preview pane is highlighted.

Alternatively, place the cursor in the field's menu and then click on the corresponding column in the File Preview pane. The drop-down menu changes to reflect the column you select.

If a field is not included in the data file, simply set that field to None. In that case, this field will be left blank or use the default value.

Attachment / Keywords

For the attachments and keywords fields, you can select one or more columns from your file. To set an attachment or keywords column, click on it in the scrollable list menu to highlight it. Clicking on it a second time removes the highlight. All columns are also highlighted in the File Preview pane as you select them.

Alternatively, with the cursor in the Attachment or Keywords menu, click on the corresponding columns in the File Preview pane to highlight them. The list menu changes to reflect the columns you select.

The data from all columns highlighted in the scrollable menu are mapped to the corresponding article field. If no columns are highlighted, that field is left empty.

Date Format

Select the code which specifies the order of the year, month, and day for the dates in your file. The Y represents the year in the date. The M represents the month. The D represents the day. All imported dates from a single file are interpreted in the same way.

For example, if one of your dates is 4/6/1997, and the month is April, the correct code is MDY. If the month is June, the correct code is DMY. For a date like 20020820, the correct code is YMD. For "Jan 1, 2001", the code is MDY.

Keyword/Attachment Text Delimiter

Select which character, if any, your file uses in its attachment and keyword column(s) to indicate that everything between these characters should be treated as a single unit of plain text.

Keyword/Attachment Delimiter Within Column

Select the character which your file uses to separate the attachments and keywords from each other within the attachment and keyword column(s). If your file uses a character other than Comma, Tab, or Space, select Other and type the delimiter character into the box to the right. Select None if there are no attachments or keywords in the file or if each attachment or keyword appears in its own column.

File Preview

Your import file is displayed. Data will not be imported from the grayed lines. Select the Back button twice to change which line the data starts on.

To map a data column to an article field, place the cursor in the drop-down menu for the appropriate field, then click on the corresponding field in the File Preview pane. The drop-down menu changes to reflect the column you selected. Use the horizontal scroll bar to reach any columns which are not originally visible in the pane.

Unprintable characters, such as tabs, may appear as small boxes:

A small Enter symbol indicates that this field contains multiple lines. Only the first line is previewed.