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.

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

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

Error creating thumbnail: /bin/bash: line 1: /usr/bin/convert: No such file or directory Error code: 127

Imported Files Search Page

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.