How to create batch import templates |
A built-in program helps you create a template to generate the actual import data file. A single import file may only include transactions for one screen and one transaction type (insert, modify, or delete).
Import file records are of variable length; a single new line character (hex 0d0a) follows each record. Commas separate fields within a record. Text values should not include trailing spaces.
To create a batch import template:
Step 1. Access the screen for which you want to create an import template.
Step 2. The procedure that you use to create an import file template varies by transaction type. Click the applicable hyperlink:
After you have created an import file template, continue with step 3 of this procedure.
Step 3. To save the import file template you created in step 2, from the File menu, select Batch process -> Create.
The Open dialog box appears.
Step 4. In the File name field, type a name and the file extension .imp (for import).
Tip: You are encouraged to specify a file name that reflects the data in the file (such as the screen ID) and the transaction you are performing.
Step 5. Navigate to the directory in which you want to store the file and click Open.
The system saves your file in the specified directory.
Tip: Make sure to note where the file was saved. You may want to create a special directory structure specifically for batch processing files.
Once the template file has been created, it can be populated with data. There are two methods:
Open template file in Microsoft Excel
Open template file in a text editor, such as WordPad (advanced users only)
Next topic:
Open import template in text editor (advanced users only)
Previous topics:
_______________
See Also