BorderConnect Wiki

ACE Shipment CSV Upload Feature (ACE Manifest): Difference between revisions

← Older edit
No edit summary
No edit summary
 
Line 3: Line 3:
{{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest}}
{{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest}}


[[File:Company-pref.jpg|thumb|360px|right|Selecting '''Company Settings''' from the Account menu]]
[[File:Company-pref.jpg|thumb|360px|right|Selecting Company Settings from the Account menu]]


This guide explains how to import a large number of shipments into an [[ACE_Manifest_Software_User_Guide_(CBP)|ACE eManifest]] using BorderConnect’s CSV upload feature.
This guide explains how to import a large number of shipments into an [[ACE_Manifest_Software_User_Guide_(CBP)|ACE eManifest]] using BorderConnect’s CSV upload feature.


This feature is ideal when you have many shipments on one trip and want to avoid entering each shipment manually.
BorderConnect also offers a newer, more user-friendly option called the '''[[Import_Wizard_(ACE_and_ACI_eManifest)|File Import Wizard]]''', which provides a guided import experience in one place. The Import Wizard supports multiple file types (including CSV and Excel formats) and can import many types of data used throughout ACE and ACI eManifests, such as shippers, consignees, vehicles, trailers, drivers, passengers, and shipments.


== Overview ==
{| class="wikitable"
! Option
! Best For
! File Types
|-
| [[Import_Wizard_(ACE_and_ACI_eManifest)|File Import Wizard]]
| Most imports and ongoing data maintenance (profiles and shipments)
| CSV, XLSX, XLS, XML, Numbers
|-
| CSV Upload on ACE eManifest
| Quick, trip-specific bulk shipment upload directly into one ACE manifest
| CSV
|}


Using a BorderConnect CSV template, you can:
== Step 1: Enable Import Buttons ==


* Upload shipments in bulk into a new or existing ACE eManifest
By default, some companies have import buttons disabled.
* Automatically validate shipment data before it is saved
* Resolve common formatting issues using clear import error messages


== Step 1: Enable ACE Import Buttons ==
To enable imports:


[[File:Display-ace-import.png|thumb|360px|right|Enabling ACE import buttons in Company Settings]]
# Go to '''Account'''
 
By default, shipment import buttons are disabled for many companies.
 
To enable them:
 
# Go to '''Account''' on the top menu
# Click '''Company Settings'''
# Click '''Company Settings'''
# Scroll to '''eManifest Preferences'''
# Under '''eManifest Preferences''', set '''Display ACE Import Buttons''' to '''Yes'''
# Set '''Display ACE Import Buttons''' to '''Yes'''
# Click '''Save'''
# Click '''Save'''


Once enabled, import controls will appear when creating or editing an ACE eManifest.
Once enabled, the import controls will appear when creating or editing an ACE eManifest.


== Step 2: Download the CSV Template ==
== Step 2: Download the CSV Template ==


Before uploading, download the official BorderConnect template file:
Before uploading, download the official template:


* [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template]
* [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template]
Line 56: Line 59:
== Field Specifications ==
== Field Specifications ==


Use the sections below to confirm data formatting before uploading.
Use the sections below to confirm formatting before uploading.


=== SCN (Shipment Control Number) ===
=== SCN (Shipment Control Number) ===
Line 95: Line 98:
=== Shipment Type ===
=== Shipment Type ===


Only the values below are valid and are case sensitive.
Only the values below are valid and case sensitive.


{| class="wikitable"
{| class="wikitable"
|-
! Shipment Type
! Shipment Type
! Value
! Value
Line 129: Line 133:


=== Shipper and Consignee ===
=== Shipper and Consignee ===
Use the following limits and formatting.


{| class="wikitable"
{| class="wikitable"
Line 327: Line 329:


# Start a new ACE eManifest or open an existing one for editing
# Start a new ACE eManifest or open an existing one for editing
# Use the import control near the top of the manifest page
# Click '''Choose File''' and select your CSV
# Click '''Choose File''' and select your CSV
# Click '''Save'''
# Click '''Save'''
Line 355: Line 356:
|-
|-
| 1
| 1
| Create the original manifest, import the first batch, save and view trip details
| Create the original manifest, import the first batch, then Save and View Trip Details
|-
|-
| 2
| 2
| Create a second manifest with a modified trip number (example: add B)
| Create a second manifest using a modified trip number (example: add B)
|-
|-
| 3
| 3
Line 373: Line 374:
|-
|-
| 7
| 7
| Send each linked manifest to CBP using '''Link Shipments to Trip''' transmission
| Send each linked manifest to CBP using the '''Link Shipments to Trip''' transmission
|}
|}


Line 428: Line 429:


Fix:
Fix:
* Use the valid value exactly, such as '''SECTION_321''' if applicable for your template version, or match the official list shown above
* Use the valid value exactly as specified in the Shipment Type table


=== Shipper Errors ===
=== Shipper Errors ===
Line 453: Line 454:


Fix:
Fix:
* Ensure valid Canadian postal code format, example: V5S 1A1
* Ensure valid Canadian postal code format


=== Consignee Errors ===
=== Consignee Errors ===
Line 484: Line 485:


Fix:
Fix:
* Package codes must match exactly, example: '''BOX'''
* Package codes must match exactly, example: BOX


<pre style="white-space: pre-wrap; word-wrap: break-word;">
<pre style="white-space: pre-wrap; word-wrap: break-word;">
Retrieved from "https://wiki.borderconnect.com/index.php?title=ACE_Shipment_CSV_Upload_Feature_(ACE_Manifest)"