Notes:
This task requires previous experience working with databases. Ask your technical staff for help if necessary.
Use only a Western character set to create records for an import file. If you use any other character set to create the field names and data in a record, the import fails for that record.
The file should be a text file with only one column, and it can include but does not require a header row.
To complete a batch import:
On the Import/Export Data menu, click Batch Import. The Batch Import Data window appears.
Select an import map name
from the Select a Map to Import Data From box.
Tip: Do not select a map in which reserved words (such as Currency)
have been used in column names.
Select the following as needed:
Select a method for handling duplicate records:
Manually Process Duplicate Records to review each set of duplicate records found during the import and decide which record to keep.
Discard Duplicate Records to keep the original records when duplicate records are found during the import process.
Overwrite Existing Records to keep the latest record when duplicate records are found during the import process.
Select the Do
Not Use Postal Code Validation check box if you do not want to use the
City-State-Zip Validator with the import process.
Tip: The City-State-Zip Validator checks that you enter a valid
combination in the City or Town, State/Province/County, and Postal Code
boxes for all US 50
addresses. In addition, it validates the city and state information for
UPS Mail Innovations shipments with Army Post Office (APO), Fleet Post
Office (APO), and Diplomatic Post Office (DPO) Ship To addresses. For
these shipments, the City or Town box must show APO, FPO, or DPO, and
the State/Province/County box must show AA, AE, or AP.
Select the Process Shipments Automatically After Import check box to process all records automatically after the import process. Do not select this check box if you want to mark selected imported shipments on the Shipment History window for manual or automatic processing later.
Select the Delete Existing Records check box to delete all records from a previous import before you continue with the import process.
Select the Clear 1Z Tracking ID When Invalid check box if you want to clear the record if the 1Z Tracking ID is not valid.
Select the Clear 1Z Tracking ID When Duplicate if you want to clear the record if the 1Z Tracking ID is a duplicate.
Select the Fail Shipments when Duties and Taxes are not Available check box to indicate that shipments should not be processed when duties and taxes are not available.
Select the appropriate address book check boxes on the Address Books tab.
Select the appropriate distribution list check boxes on the Distribution Lists tab.
Click the Next button. The Import/Export Preview window appears.
Click the Next button. When the import is complete, the Import/Export Summary window appears.
Do one of the following:
Click the Save button to save the changes you made.
Click the Discard button to close this window without saving any changes.
Click the Keep Log button to define the path and directory where the summary information will be saved.
Select the Auto Save Log check box to save the summary information automatically to a log.