To begin setting up your text file connection to BarTender, you must specify the text file to read from and its character set.
-
Enter the name of the text file to read from. Specifies the path and file name of the desired text file. Alternatively, to navigate to the file on your computer or network, click Select File.
-
Select File. Opens the Specify Text File dialog, which allows you to navigate to the directory location of the desired text file.
-
View File. Opens the specified text file in the default text editor.
-
Encoding. Specifies the character set of the text file.
Once you have selected your text file and its character set, click Next for the next step in the wizard.
After selecting your text file and its character set, you need to specify the field delimitation type so that BarTender can read data from your file correctly. Using this dialog, you can set the delimitation type and view your file.
-
Delimitation Type. Specifies the type of delimitation. Select from the following options:
-
View File. Opens the text file in the default text editor.
-
Field Delimiter. Specifies the character that will separate the fields of data. Available when Delimitation Type is set to User Defined Delimiter.
Once you have selected your text file delimitation type, click Next for the next step in the wizard.
After selecting your text file delimitation type, you need to specify whether the first record of the text file is a header that contains the names of the fields. If you are not certain, you can view the text by selecting the View File button.
For example, the first record of the following text file is a header that contains the names of the fields:
"ID","TITLE","(Rating)","TYPE"
"V124","RAMBO","(R — Restricted)","DVD"
"V037","FROZEN","(G — General Audiences)","BLU-RAY"
"V061","APOLLO 13","(PG13 — No One Under 13)","DVD"
Once you have answered Yes or No, click Finish to complete the Add Database Connection Wizard.
Select the text file to read from
