Import Data

Field Name

Type / Max Length

Action / Description

Name of file to import

Required
128 alphanumeric

Click the icon to launch a browser to which you can drop a file from your PC or network.

OR

Enter the name of the file (up to 8-characters) if it resides on a native disc or enter the full path name including the file extension (e.g., C:\My documents\CMX.XML or U:\IMPORT\VMX.XML where U: is a mapped network drive) if the file is on your PC or network.

If the PC file is not found or if the file resides on a native disc, the program prompts to check for a sequential file. Click Yes if you entered the file name correctly or click No to re-enter the name of the file to import.

By default, the last file imported is displayed. To exit to the menu, click Cancel.

Name of batch file

Optional
5 alphanumeric

Enter the name of the batch file for this import.

XMAP Format

Required
10 alphanumeric

Select the appropriate format. Formats are defined in the Format Mapping Maintenance (XMAP) program.

D=Delimited or F=Fixed length

Required
1 alphanumeric

Select D if the file uses a delimiter or select F if fields are a fixed length.

If you import data from an ASCII file generated from Microsoft Excel, fields are a fixed length.

Field delimiter

Conditional
1 alphanumeric

If you selected D for the D=Delimited or F=Fixed length option, enter the field delimiter used in the import file; for example T for tab, a ; (semicolon), or a , (comma).

Erase import file when complete

Optional

Select if you want to delete the import file when importing is completed or leave blank if you do not. It is usually a good practice to delete the import file as a part of the process. The bill of material drop file process allows you to create an archive copy if desired.