Importing and Mapping a Delimited File

The first set of steps below shows you how to import a delimited file. (You may also import data in a fixed-position format.) The first time you import a file format you will need to create a map for it. If you use this format frequently, you will want to save the mapping information. The second set of steps shows you how to import a delimited file with a map you have already created and saved.

Note:  Any mapped fields will overwrite the existing transaction information.

To import a delimited file and add/edit a map

1. Choose File Transfer | Import Data | Import.

2. Select the category/subcategory from the drop-down list.

3. Type the full path and file name. Or, click Browse, locate the file, and click Open.

4. To create a new import map, choose (New Map).
   To edit an existing map, choose the map from the drop-down list and mark the Modify Map option.

5. If you are creating a new map, make sure the Type marked is Delimited. Enter the field delimiter.

6. Choose Next.

7. Enter or edit the descriptive name for the map, for example, Billing Amounts.

8. Indicate whether the first line in the file contains heading titles. The application will skip this first line if it contains only headings.

9. Each Column entry on the left shows the data that the application found in your file. For each entry, choose the appropriate transaction field from the drop-down list. If you would like to default the Effective Date, Account Type, Debit/Credit Type, and/or Amount, do not import those fields.

10. Choose Next.

11. If you would like to default certain fields, enter default information as necessary. The information you enter here will be applied to every imported transaction. (If you import all fields, you will not see the Define Defaults page; go to the next step.)

12. Check the confirmation totals.

13. Choose Confirm.

14. Click Home to return to the home page.

To import a delimited file with an existing map

Note:  If you are using a shortcut from the Home page, begin with step 3.

1. Choose File Transfer | Import Data | Import.

2. Select the category/subcategory from the drop-down list.

3. Type the full path and file name. Or, click Browse, locate the file, and click Open.

4. Select the map from the drop-down list.

5. Choose Next.

6. If necessary, complete the default fields and click Next.

7. Check the confirmation totals.

8. Choose Confirm.

9. Click Home to return to the home page.