Data Files

If a user is provided a number of image files with an accompanying text file that contains index information about those files, the user can import them into the program with data file indexing. To configure this option, select the Index from data files of a specific type check box.

Users can import text file data through the default list of text file type extensions below.

Merge image files into same Document if the index values match: If this option is selected, when importing files using data file indexing, any files containing the exact same index values are merged.

In the Text file settings tab, you can configure the following settings:

• Format: Select either Delimited or Fixed Width.

• Delimiter: Select one of the following:

  • Comma {,}

  • Pipe {|}

  • Colon {:}

  • Semicolon {;}

  • Tilde {~}

  • <TAB>

  • <SPACE>

• Text Qualifier: Select the character that denotes text values in the expected string. Common values are " and '.

• Header rows to skip: Select the number of rows in the data file that contain header rows. If there are none, leave the field blank.

• Treat entire file contents as one row: Depending on how the text file is formatted, this setting may be necessary.

  Only available when the Delimited format is selected.

• Create a new batch for each file (Auto Import Only): Creates a new batch for each indexing data file.

• Treat the entire file contents as a single value: Instead of looking for specific values, PSIcapture treats the whole file as a single value.

  Only available when the Fixed Length format is selected.

Under Column field mappings, Column Fields can be added, removed, or moved up/down in the list by using the buttons on the right side of the page. Below is an explanation of the column field information shown.

• Column: The column number in the data file as seen on the Preview tab discussed below.

• Index Field Name: Lists the available index fields for this capture profile.

• Truncate Whitespace: Selecting this option causes all spaces at the end of the bar code to be removed once the value is placed in an index field.

The selectable options for Document path position determine whether the document path is a column and in what position to put the path in.

• Match File Name: Import image files with the exact same file name as the data file (sans file extension) or just the same beginning.

• Last Column: Do not create a column for the document path position.

• Custom Column: Select the column that contains the path to the document.

In the Preview tab, you can preview the information of data files.

To preview the information of a data file, either enter the path to the text file or browse for the file within the file or folder of the station. Once you selected the format, delimiter, and text file, this tab displays the results. You should verify on the Text file settings tab that the expected column corresponds to the desired Index Field Name.