Configuration Tab - Document Import Type

<< Click to Display Table of Contents >>

You are here:  Capture > Importer > CSV Import > Configuration Tab >

Configuration Tab - Document Import Type

 

1.Click the Configuration tab.
 
The window similar to the following displays:
 
ImportCSVConfigurationtab-mh
 

2.In the Import Type field, use the dropdown to select Document.

3.In the Header Document Type field, use the dropdown to select the appropriate document type.

4.The Detail Document Type field selection is based on the selected line type (in the Line Type field). For document import types, <None> as the default.

5.In the Column Delimiter field, use the dropdown to select one of the following, based on the CSV file being imported:
 
- Comma
- Tab
- Space
- Pipe
 

6.In the Text Delimiter field, use the dropdown to select one of the following, based on the CSV file being imported:
 
- None
- Single Quote
- Double Quote
 

7.In the Skip first field, use the arrows to indicate the number of lines considered to be the header lines, based on the CSV file being imported.

8.Click the Generate Image check box, if appropriate.
 
Note:  If you do not have an actual image for the document, clicking this option generates an image that is basically a report with some of the document information in it. This is optional.
 

9.For the Line Type field, click Add.
 
The following Add Line Types dialog box displays:
 
CSVImportConfigurationAddLineTypes-mh

 

10.If the CSV file resembles the following with no distinct header lines and distinct detail lines:
 
Vendor #, Packing Ticket #, Total, Description
100, 2497,  368.11, "Bolts"
100, 2498, 55.00, "Nuts"
 
Select:
 
Each line of the file is formatted the same and describes a single document / invoice in the system.
 
If the CSV file resembles the following with a distinct header line (HL in the example) and distinct detail lines (DL in the example):
 
HL, 100, 1, 100.00, "Tires"
DL, 10-000, 25.00, "Front Tire"
DL, 10-000, 75, "Back Tires"
HL, 100, 2, 55.00, "Gas"
DL, 10-000, 55.00, "Exxon"
 
Select:
 
The first line of the file is formatted one way and describes a header line followed by a sequence of detail lines formatted another way.
 

11.Click OK.
 
General will display in the Line Type field.
 
Note: The Detail Document Type is not applicable and the field will not be active.

 

12.Click Add Column to bring up the Add Column Mappings dialog box similar to the following:
 
CSVImportConfigurationAddColumnMappings-mh
 

13.To add a new column at the bottom of the existing column entries in the grid, click: Add # new column(s) at the end to map to a new value.
To insert a new column at a specific position within the grid, click: Insert a new column at the selected grid position to map to a new value.
To add a new entry (identified as the same column but subordinate or child) to a specific column entry, click: Add a new entry for the currently selected column to map to an additional value.

 

14.Click OK.
 
Based on the CSV file, this will generate column mapping similar to the following:
 
CSVImportConfigurationAddColumnMappingsAddOneNewColumn-mh
 

15.Once all the job configuration tabs are filled out, click Save to save the CSV Import job template.

 

Additional Fields and Functionality

 

Field

Description

Generate Images

Click the Generate Images check box only if document image(s); real image, exist in the CSV file.
If no document image(s) exist in the CSV file, leave unchecked.
 
Note:  This is an optional field.

Set Defaults

Refer to details below this table concerning Set Defaults functionality.

Special Fields

This is a Data Type associated with Field Types based on the selected Line Type.

Origination Date

In the file, document(s) with specific origination dates.

Document Class

Invoice only.

Page Number

In the file, single document housing all images on specific page numbers.

Processor ID

Invoice only.

Initialize

Click Initialize if the columns should be based on a template--either on an import type or an import file.

Click OK to close the dialog box.
 
If columns are present when Initialize is clicked, the following warning prompt displays:
 
CSVImportConfigurationInitializawarningprompt-mh
 
Note:  Usually for invoices only.

Queue

In the Queue field, use the dropdown to select the appropriate queue.
Do this if the document should be reviewed before being indexed.
 
Note: This is optional.

 

 

Set Defaults

 

If job specific values should be used, click Set Defaults.

The Set Index Defaults dialog box similar to the following displays:

 

CSVImportConfigurationSetIndexDefaultsdialog-mh

 

The value defaults are listed. An F4 lookup is associated with these default field type values listed in the grid.

1.Highlight a row.

2.Click the cursor in the Value column.

3.Press F4.
 
The lookup dialog for that specific field type (in this instance AP Invoice Number) similar to the following displays:
 
CSVImportConfigurationSetIndexDefaultsdialogLookupDocumentImport-mh
 

4.Scroll through the list to highlight an entry or use the Filter functionality.

5.Click OK.
 
The Set Index Defaults dialog box redisplays with the default value similar to the following:
 
CSVImportConfigurationSetIndexDefaultsdialogpostlookupDocumentImport-mh