Custom Import File Specifications

Overview | Tips

This information is applicable to the custom file page of the Data Import Wizard. From the File menu, select Utilities Import.

Use this page to specify the custom import file location and name, the worksheet the data is on, and to select or create a custom mapping file.

The available options are:

Identify the information to be imported:

• Choose which file to import

Select Browse to locate the file containing the data you wish to import into Point of Sale.

To import a text file, be sure the file has a csv extension (rename the file if necessary) and change the selection to csv in the Files of Type drop-down list in the Open a File dialog. Selecting the correct file you will use for this map will affect the options available when assigning data fields to the map.

• Data is on sheet

If you have selected an Excel file as the data source for the import, identify which worksheet contains the data you wish to import.

• Data starts on row

Identify the first row or line containing the actual data to be imported. Do not include any heading rows when specifying the starting row.

• Choose file mapping

Select an existing mapping template or Manage Mappings to create a new template. Tell me more about managing mapping templates.