Import Wizard (ACE and ACI eManifest)
|
🔖 This article is part of the BorderConnect Software User Guide |
| This article contains software features actively in development. Content is subject to change. |
The BorderConnect File Import Wizard allows users to quickly and accurately bring internal company data into BorderConnect for use across ACE and ACI eManifest workflows.
Instead of manually creating records one by one, the Import Wizard supports bulk uploads for:
- Shippers and consignees
- Shipments
- Drivers and passengers
- Trucks, trailers, and vehicles
This significantly reduces setup time and improves data consistency across manifests.
For assistance with file uploads or troubleshooting, contact BorderConnect’s 24/7 technical support.
Accessing the Import Wizard
The File Import Wizard is available to all BorderConnect users and can be opened from multiple locations:
| Location | How to Access |
|---|---|
| Manage Data Menu | Select Import Wizard |
| Search ACI Shipments | Import button dropdown → Import Wizard |
| Search ACE Shipments | Import button dropdown → Import Wizard |
| Search Drivers, Passengers, Trucks, Trailers | Import button dropdown → Import Wizard |
| Shipper and Consignee Searches | Import button dropdown → Import Wizard |
Note: Importing directly from ACI and ACE shipment pages requires Allow ACE Imports and Allow ACI Imports to be enabled on the Company Settings page.
Supported File Formats
The Import Wizard accepts commonly used spreadsheet and data formats:
| Supported File Types |
|---|
| .csv |
| .xlsx |
| .xls |
| .xml |
| .numbers |
Data Types You Can Import
| Data Category | Information Included |
|---|---|
| ACE Shippers | Name, contact details, address |
| ACE Consignees | Name, contact details, address |
| ACE Shipments | Shipment type, control number, trip sheet, shipper and consignee, commodities |
| ACI Shippers | Name, contact details, address |
| ACI Consignees | Name, contact details, address |
| ACI Shipments | Cargo control number, port, release office, sublocation, ETA, commodities |
| Drivers | Name, travel documents, notification settings |
| Passengers | Name, travel documents, FAST or ACE ID data |
| Trailers | Unit number, type, license plate details |
| Vehicles | Unit number, type, VIN, license plate details |
Import Process Overview
The Import Wizard guides users through three clear stages:
| Step | Purpose |
|---|---|
| Upload | Select data type and upload file |
| Mapping | Match spreadsheet columns to BorderConnect fields |
| Validate | Review, correct, and confirm imported data |
Step 1 Uploading Your File
Choose the type of data you are importing, then either:
- Click Upload a File
- Drag and drop your file into the upload area
Once uploaded, click Next to proceed to mapping.
Step 2 Mapping Your Data
The mapping screen connects your file’s column headers with BorderConnect’s required data fields.
The page is divided into:
Completed Mappings
Fields that are properly matched and ready to import. Options allow you to duplicate, ignore, or split incoming data as needed.
Incomplete Mappings
Fields requiring attention due to missing or incompatible formats.
Ignored Fields
Columns intentionally excluded from the import.
Once all required fields are properly mapped, click Next.
Step 3 Validating Imported Data
The validation page allows full review and editing before final submission.
You can:
- Correct formatting errors
- Add or remove rows and columns
- Edit individual values directly
- Review flagged issues
After confirming accuracy, click Finish Import.
A confirmation message appears with a unique Import Reference ID.
Reviewing Imported Files
All completed imports can be reviewed under:
Manage Data → Search Imported Files
Here you can search by:
- Import Reference ID
- Data schema type
- Date range
Clicking View opens the Imported File Details page where individual records can be:
- Viewed
- Edited
- Deactivated or deleted
Best Practices
- Use clear column headers in your spreadsheet
- Remove duplicate or outdated data before importing
- Resolve incomplete mappings before proceeding
- Validate carefully to avoid data conflicts
Summary
The BorderConnect File Import Wizard provides a fast, flexible, and user friendly way to bulk load critical manifest data. With built in mapping and validation tools, users can ensure clean, accurate records while saving significant time on data entry.