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 at least one column, and it can include but does not require a header row.
To complete a batch import:
On the Import-Export tab, select Batch Import and then Batch Import. The Batch Import Data window appears.
Select an import map name in the Select a Map to Import Data From grid.
Tip: Do not select a map in which reserved words (such as Currency) have been used in column names.
If present, select the following as needed:
Click the down arrow in the Shipper Number box and select a shipper.
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 (FPO), 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 Number When Invalid check box if you want to clear the record if the 1Z Tracking Number is not valid.
Select the Clear 1Z Tracking Number When Duplicate if you want to clear the record if the 1Z Tracking Number is a duplicate.
Select the Clear Postal Service Tracking ID When Invalid check box if you want to clear the record if the Postal Service Tracking ID is not valid.
Select the Clear Postal Service Tracking ID When Duplicate check box if you want to clear the record if the Postal Service 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 Process Shipments when Upload My Forms is not Successful check box to indicate if you want UPS WorldShip to process imported shipments whose user-created forms cannot be uploaded for any reason.
Tip: This check box appears only if you have a contract to upload forms.
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.