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.

BorderConnect File Import Wizard

Bulk upload data for manifests, drivers, and shipments to save time and ensure accuracy.

Type: Data Tool System: General Data

Overview

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 (ACE and ACI)
• Drivers and Passengers
• Trucks, Trailers, and Vehicles

This significantly reduces setup time and improves data consistency across manifests.

File Import Wizard Home Page

Support: For assistance with file uploads or troubleshooting, contact BorderConnect’s 24/7 technical support.

Access & Supported Formats

How to Access

The File Import Wizard is available to all BorderConnect users. Note that importing directly from shipment pages requires Allow ACE/ACI Imports to be enabled in Company Settings.

Location	How to Access
Manage Data Menu	Select Import Wizard.
Search Pages (ACE/ACI Shipments)	Click the Import button dropdown → Import Wizard.
Data Searches (Drivers, Trucks, etc.)	Click the Import button dropdown → Import Wizard.

Supported File Types

The wizard accepts common spreadsheet and data formats:

• .csv (Comma Separated Values)
• .xlsx / .xls (Excel)
• .xml (XML Data)
• .numbers (Apple Numbers)

Step 1: Uploading Your File

First, choose the type of data you are importing (e.g., ACE Shipments, Drivers, Trailers).

Selecting the data category

Then, either click Upload a File or drag and drop your file into the designated area.

Uploading the source file

Once uploaded, click Next to proceed to mapping.

Step 2: Mapping Your Data

Mapping columns to fields

The mapping screen connects your file’s column headers with BorderConnect’s required data fields. The page is divided into three sections:

• Completed Mappings: Fields that are properly matched. You can duplicate, ignore, or split this data if needed.
• Incomplete Mappings: Fields that require 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 & Finishing

Validating data before import

The validation page allows for a full review before final submission. Here you can:

• Correct formatting errors and review flagged issues.
• Add or remove rows/columns.
• Edit individual values directly in the grid.

After confirming accuracy, click Finish Import. A confirmation message will appear with a unique Import Reference ID.

Reviewing Imported Files

Imported Files Search Page

All completed imports are stored for review.

To Access: Go to Manage Data → Search Imported Files.

From here you can search by Import Reference ID, Schema Type, or Date Range. Clicking View opens the details where individual records can be edited, deactivated, or deleted.

Best Practices

• Headers: Use clear, descriptive column headers in your spreadsheet.
• Cleanup: Remove duplicate or outdated data from your file before uploading.
• Validation: Resolve incomplete mappings and validate carefully to avoid data conflicts.

📱

eManifesting in your pocket. Process ACE & ACI eManifests, track shipments in real-time, and upload documents instantly—anytime, anywhere.

Download on theApp Store GET IT ONGoogle Play