Import a Project

Use the Project Import (PSI) program to import project data from an ASCII file. See Background and Road Map for more information.

  1. Enter data in these fields:

Field Name

Type / Max Length

Action / Description

Name of file to import

Required
45 alphanumeric

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, clear the field and press Enter or Tab.

Name of batch file

Required
5 alphanumeric

Enter a batch name for this file. This name is associated with this file until import is complete.

D=Delimited or F=Fixed length

Required
1 alphanumeric

Enter D if this file uses a delimiter or enter 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 entered D for D=Delimited or F=Fixed length, enter the field delimiter used in this file; for example, enter T for tab, a ; ( semicolon), or a , (comma).

Qantel Technologies recommends the semicolon delimiter because address and comment fields can include commas.

If the PSI Import Log reports the Invalid record type message for every line, you selected the wrong delimiter.

Erase import file when done?

Optional

Select to erase the file after import or leave blank to retain it.

  1. When you complete all fields click OK.

The program displays the message Checking import file for structural integrity . . .. When finished, the program exits.

  1. Check your default output device for the Project Import Log. The log contains the project number assigned and any error messages.