|
|
| (8 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{note|This article is part of the [[ACE_Manifest_Software_User_Guide_(CBP)|BorderConnect ACE Manifest Guide]] and the [[BorderConnect_Software_User_Guide|BorderConnect Software User Guide]]|info}} | | {{note|This article is part of the [[ACE_Manifest_Software_User_Guide_(CBP)|BorderConnect ACE Manifest Guide]] and the [[BorderConnect_Software_User_Guide|BorderConnect Software User Guide]]|info}} |
|
| |
|
| {{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest.}}
| | <div class="bc-wrap"> |
|
| |
|
| [[File:Company-pref.jpg|thumb|360px|right|Selecting Company Settings from the Account menu]]This guide provides '''instructions on how to upload a large volume of shipments into an ACE Manifest''', using BorderConnect's CSV upload feature in an [https://www.borderconnect.com/ace-e-manifest/index.htm ACE Manifest]. The CSV upload feature is designed for users who have a significant amount of shipments on a single trip and would like to avoid entering data separately for each shipment.
| | <div class="bc-article-hero"> |
| == Enabling Import Buttons == | | <h1>ACE Shipment CSV Upload Feature</h1> |
| | <p>A comprehensive guide to bulk importing shipments into ACE eManifests using CSV files.</p> |
| | <div class="bc-article-meta"> |
| | <span class="bc-article-pill"><i class="fas fa-file-csv"></i> Type: Data Import Tool</span> |
| | <span class="bc-article-pill"><i class="fas fa-cubes"></i> Feature: Bulk Shipment Creation</span> |
| | </div> |
| | </div> |
|
| |
|
| The first step is to enable the ability to upload shipments. By default, companies will have this option disabled. To enable this option, once logged into BorderConnect, navigate to the top right corner and hover over the menu option '''Account''', and select '''Company Settings'''.
| | <div class="bc-card"> |
|
| |
|
| Within the '''Company Settings''' page navigate down to '''Display ACE Import Buttons''' under the section '''eManifest Preferences'''. Once the option is selected to 'Yes', click 'Save' on the top left and your company has now enabled the ability to upload shipments.
| | <div class="bc-float-video" style="margin-top: 0;"> |
| | <div class="bc-video-trigger" data-video-id="bWwYYqaVZ0k"> |
| | <div class="bc-play-icon"><i class="fas fa-play-circle"></i></div> |
| | </div> |
| | </div> |
|
| |
|
| == CSV File Format == | | <h2 style="margin-top: 0;">Overview</h2> |
| | <p>The <strong>ACE Shipment CSV Upload Feature</strong> allows carriers to import large volumes of shipments directly into a specific ACE eManifest using a standardized CSV template. This is ideal for trips with hundreds of shipments, such as courier loads or consolidated freight.</p> |
|
| |
|
| [[File:Display-ace-import.png|360px|thumb|right|Enabling ACE import buttons from Company Settings]]Before uploading your .csv file, you will need to download the .csv template file that [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv BorderConnect provides here]. The headers in this file must remain intact and un-modified as they are required for the upload to be successful. | | <p>BorderConnect also offers the <strong>[[Import_Wizard_(ACE_and_ACI_eManifest)|File Import Wizard]]</strong>, a broader tool for importing permanent company data (drivers, trucks, profiles).</p> |
|
| |
|
| When saving your file, you will need to make sure that it is saved in CSV format, even if you are using a spreadsheet program to edit the file. Only CSV file format can be used for this feature.
| | <div class="bc-did-you-know" style="margin-top: 15px;"> |
| | <strong>Which Tool Should I Use?</strong><br> |
| | * <strong>CSV Upload (This Guide):</strong> Best for quick, trip-specific bulk shipment uploads directly into one manifest.<br> |
| | * <strong>Import Wizard:</strong> Best for importing standing data like driver profiles, truck lists, or maintaining customer databases. |
| | </div> |
|
| |
|
| == Field Specifications == | | <div style="clear: both;"></div> |
| | </div> |
|
| |
|
| === SCN (Shipment Control Number) === | | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 1: Enable Import Buttons</h2> |
|
| |
|
| *Unique identifier assigned to this shipment by the carrier.
| | <div class="bc-card"> |
| *Starts with carrier's 4 letter SCAC code followed by unique reference number.
| | <p>By default, the import controls may be hidden. To enable them:</p> |
| *Must be alpha-numeric with no spaces or special characters, '''letters must be upper case'''.
| | <div class="bc-cleanlist"> |
| *Minimum length: 8 characters.
| | 1. Go to <strong>Account</strong> > <strong>Company Settings</strong>. |
| *Maximum length: 16 characters.
| | 2. Scroll to the <strong>eManifest Preferences</strong> section. |
| | 3. Set <strong>Display ACE Import Buttons</strong> to <strong>Yes</strong>. |
| | 4. Click <strong>Save</strong>. |
| | </div> |
| | [[File:Company-pref.jpg|thumb|center|Enabling Import Buttons in Company Settings]] |
| | </div> |
|
| |
|
| When entering Shipments Control Numbers into the CSV document, you can enter them manually OR you have the option to use BorderConnect's system to automatically generate SCNs. To import shipments with automatically generated shipment control numbers in sequential order enter your SCAC + the word AUTOFILL (ex. ZZZZAUTOFILL). Using the autofill feature means that all SCNs must use the autofill feature. You cannot have a mix of autofill and non-autofill SCNs.
| | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 2: Download the Template</h2> |
|
| |
|
| === Shipment Type === | | <div class="bc-card"> |
| | <p>You must use the official template to ensure your data maps correctly.</p> |
| | <div class="bc-cleanlist"> |
| | * <strong>Download:</strong> [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template] |
| | * <strong>Format Rule:</strong> Do not rename, remove, or reorder the column headers. Always save as <strong>.csv</strong> (Comma Separated Values). |
| | </div> |
| | </div> |
|
| |
|
| *The type of U.S. Customs clearance for this shipment.
| | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Prepare Your Data</h2> |
| *Only the coded values listed in the table below can be used in this field.
| |
|
| |
|
| Below are the valid Shipment Type values.<br>
| | <div class="bc-card"> |
| (Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.) | | <h3>Shipment Control Number (SCN)</h3> |
| | <div class="bc-cleanlist"> |
| | * <strong>Format:</strong> Must be 8-16 alphanumeric characters. No spaces or special characters. |
| | * <strong>Autofill:</strong> To let BorderConnect generate numbers, use your SCAC followed immediately by "AUTOFILL" (e.g., <code>ABCDAUTOFILL</code>). |
| | * <strong>Rule:</strong> Do not mix manual SCNs and AUTOFILL in the same file. |
| | </div> |
|
| |
|
| {| class="wikitable"
| | <h3>Shipment Type</h3> |
| |-
| | <p>Values must match exactly (case-sensitive):</p> |
| ! Shipment Type
| | <table class="wikitable" style="width: 100%;"> |
| ! Value
| | <tr><th>Type</th><th>Value</th></tr> |
| |-
| | <tr><td>PAPS</td><td><code>PAPS</code></td></tr> |
| | PAPS
| | <tr><td>Section 321</td><td><code>SECTION 321</code></td></tr> |
| | PAPS
| | <tr><td>Intangibles</td><td><code>INTANGIBLES</code></td></tr> |
| |-
| | <tr><td>Free of Duty</td><td><code>ATTACHED_CF7523</code></td></tr> |
| | QP In-Bond
| | </table> |
| | QP_IN_BOND
| |
| |-
| |
| | Intangibles
| |
| | INTANGIBLES
| |
| |-
| |
| | Free of Duty (Customs Form 7523)
| |
| | ATTACHED_CF7523
| |
| |-
| |
| | Returned American Products (Customs Form 3311)
| |
| | ATTACHED_CF3311
| |
| |-
| |
| | Personal Shipment (Customs Form 3299)
| |
| | ATTACHED_CF3299
| |
| |}
| |
|
| |
|
| === Province Of Loading === | | <h3>Commodity Data</h3> |
| | <div class="bc-cleanlist"> |
| | * <strong>Description:</strong> Plain language description of goods (max 45 chars). |
| | * <strong>Value:</strong> Numeric only. No dollar signs (e.g., <code>1500.50</code>). |
| | * <strong>Weight:</strong> Whole numbers only (round up). |
| | </div> |
| | </div> |
|
| |
|
| *The Canadian Province or Mexican State in which the shipment was picked up by the carrier.
| | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 4: Importing into BorderConnect</h2> |
| *Must use the 2 letter code of the Canadian province or 3 letter code of the Mexican state.
| |
|
| |
|
| E.g. For a shipment loading in British Columbia, you must use BC. For a shipment loading in Guerrero, you must use GRO. State or province codes must be '''upper case'''.
| | <div class="bc-card"> |
| | <p>Once your file is ready, follow these specific steps to upload it into the system.</p> |
|
| |
|
| === Shipper === | | <h3>1. Create or Open the Manifest</h3> |
| | <div class="bc-cleanlist"> |
| | * Navigate to <strong>ACE eManifest</strong> > <strong>Start New ACE eManifest</strong>. |
| | * Enter the required Trip details (Trip Number, Port of Entry, Estimated Arrival). |
| | * Click <strong>Save</strong>. You must save the trip header before you can add shipments. |
| | </div> |
|
| |
|
| <u>Name</u>: | | <h3>2. Locate the Import Tool</h3> |
| *The name of the shipper for this shipment. | | <div class="bc-cleanlist"> |
| *Minimum length: 1 | | * On the <strong>ACE eManifest Details</strong> page, scroll down to the <strong>Shipments</strong> section. |
| *Maximum length: 60
| | * Look for the button labeled <strong>Import Shipments via CSV</strong> (sometimes labeled <strong>Upload Shipments</strong>). |
| | * <em>Note: If you do not see this button, ensure you completed Step 1 to enable import buttons in Company Settings.</em> |
| | </div> |
| | [[File:Ace-upload-shipments.png|thumb|center|800px|The Import Shipments interface in BorderConnect]] |
|
| |
|
| <u>Address</u>: | | <h3>3. Upload and Process</h3> |
| *The street number and street name of the shipper for this shipment. | | <div class="bc-cleanlist"> |
| *Minimum length: 1 | | * Click <strong>Choose File</strong> and select your prepared <code>.csv</code> file from your computer. |
| *Maximum length: 55 | | * Click <strong>Save</strong> or <strong>Import</strong>. |
| | * The system will process the file immediately. |
| | </div> |
|
| |
|
| <u>City</u>: | | <h3>4. Verify Results</h3> |
| *The city name of the shipper for this shipment. | | <div class="bc-cleanlist"> |
| *Minimum length: 1
| | * <strong>Success:</strong> You will see a green confirmation message, and your shipments will appear in the list below. |
| *Maximum length: 30
| | * <strong>Failure:</strong> A red error box will appear at the top of the page. It will list the specific row numbers and the exact error (e.g., "Row 4: Invalid SCAC"). Correct these errors in your CSV file and try uploading again. |
| | </div> |
| | </div> |
|
| |
|
| <u>State</u>: | | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Reference Codes</h2> |
| *The Canadian Province or Mexican State of the shipper for this shipment.
| |
| *Must use the 2 letter code of the Canadian province or 3 letter code of the Mexican state.
| |
| *State or province codes must be '''upper case'''.
| |
|
| |
|
| <u>Zip</u>: | | <div class="bc-card"> |
| *The postal code of the shipper for this shipment.
| | <h3><i class="fas fa-balance-scale"></i> Weight Unit Codes</h3> |
| *For Canadian postal codes, must be in the format "A1A1A1" or "A1A 1A1".
| | <p>Only the following codes are accepted for the <strong>Weight Unit</strong> column:</p> |
| *For Mexican postal codes, must be in the format "12345".
| | <table class="wikitable" style="width: 100%;"> |
| *Letters must be '''upper case'''.
| | <tr> |
| | <th style="width: 30%;">Unit</th> |
| | <th>Accepted Codes</th> |
| | </tr> |
| | <tr> |
| | <td><strong>Kilograms</strong></td> |
| | <td><code>K</code>, <code>KG</code>, <code>KGM</code></td> |
| | </tr> |
| | <tr> |
| | <td><strong>Pounds</strong></td> |
| | <td><code>L</code>, <code>LB</code>, <code>LBS</code>, <code>LBR</code></td> |
| | </tr> |
| | </table> |
| | </div> |
|
| |
|
| === Consignee === | | <div class="bc-card" style="margin-top: 20px;"> |
| | <h3><i class="fas fa-box"></i> Package Type Codes</h3> |
| | <p>The <strong>Quantity Unit</strong> column must use one of the specific 3-letter codes below. (Case-sensitive).</p> |
|
| |
|
| <u>Name</u>: | | <div class="bc-2col"> |
| *The name of the consignee for this shipment.
| | <div style="flex: 1; min-width: 250px;"> |
| *Minimum length: 1
| | <table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;"> |
| *Maximum length: 60
| | <tr><th>Description</th><th>Code</th></tr> |
| | <tr><td>Bag</td><td>BAG</td></tr> |
| | <tr><td>Bale</td><td>BLE</td></tr> |
| | <tr><td>Barrel</td><td>BBL</td></tr> |
| | <tr><td>Basket</td><td>BSK</td></tr> |
| | <tr><td>Bin</td><td>BIN</td></tr> |
| | <tr><td>Box</td><td>BOX</td></tr> |
| | <tr><td>Bucket</td><td>BKT</td></tr> |
| | <tr><td>Bundle</td><td>BDL</td></tr> |
| | <tr><td>Can</td><td>CAN</td></tr> |
| | <tr><td>Carboy</td><td>CBY</td></tr> |
| | <tr><td>Carton</td><td>CTN</td></tr> |
| | <tr><td>Case</td><td>CAS</td></tr> |
| | <tr><td>Chest</td><td>CHS</td></tr> |
| | <tr><td>Coil</td><td>COL</td></tr> |
| | <tr><td>Crate</td><td>CRT</td></tr> |
| | <tr><td>Cylinder</td><td>CYL</td></tr> |
| | <tr><td>Drum</td><td>DRM</td></tr> |
| | </table> |
| | </div> |
| | <div style="flex: 1; min-width: 250px;"> |
| | <table class="wikitable" style="font-size: 0.9em; width: 100%; margin-top: 0;"> |
| | <tr><th>Description</th><th>Code</th></tr> |
| | <tr><td>Envelope</td><td>ENV</td></tr> |
| | <tr><td>Keg</td><td>KEG</td></tr> |
| | <tr><td>Lift Van</td><td>LVN</td></tr> |
| | <tr><td>Liquid Bulk</td><td>LBK</td></tr> |
| | <tr><td>Logs</td><td>LOG</td></tr> |
| | <tr><td>Package</td><td>PKG</td></tr> |
| | <tr><td>Pail</td><td>PAL</td></tr> |
| | <tr><td>Pallet</td><td>PLT</td></tr> |
| | <tr><td>Pieces</td><td>PCS</td></tr> |
| | <tr><td>Reel</td><td>REL</td></tr> |
| | <tr><td>Roll</td><td>ROL</td></tr> |
| | <tr><td>Sack</td><td>SAK</td></tr> |
| | <tr><td>Sheet</td><td>SHT</td></tr> |
| | <tr><td>Skid</td><td>SKD</td></tr> |
| | <tr><td>Tank</td><td>TNK</td></tr> |
| | <tr><td>Tote Bin</td><td>TBN</td></tr> |
| | <tr><td>Tube</td><td>TBE</td></tr> |
| | </table> |
| | </div> |
| | </div> |
| | </div> |
|
| |
|
| <u>Address</u>: | | <div class="bc-card" style="margin-top: 20px;"> |
| *The street number and street name of the consignee for this shipment.
| | <h3><i class="fas fa-globe"></i> Common Country of Origin Codes</h3> |
| *Minimum length: 1
| | <p>Use the 2-letter ISO code for the <strong>Country of Origin</strong> column. Common codes include:</p> |
| *Maximum length: 55
| | <table class="wikitable" style="width: 100%;"> |
| | <tr><th>Country</th><th>Code</th><th>Country</th><th>Code</th></tr> |
| | <tr><td>Canada</td><td><code>CA</code></td><td>United States</td><td><code>US</code></td></tr> |
| | <tr><td>Mexico</td><td><code>MX</code></td><td>China</td><td><code>CN</code></td></tr> |
| | <tr><td>Germany</td><td><code>DE</code></td><td>Japan</td><td><code>JP</code></td></tr> |
| | <tr><td>United Kingdom</td><td><code>GB</code></td><td>France</td><td><code>FR</code></td></tr> |
| | <tr><td>India</td><td><code>IN</code></td><td>Italy</td><td><code>IT</code></td></tr> |
| | <tr><td>South Korea</td><td><code>KR</code></td><td>Taiwan</td><td><code>TW</code></td></tr> |
| | </table> |
| | <p style="font-size: 0.9em;"><em>Note: For a complete list of all world country codes, refer to the <a href="https://www.borderconnect.com/data/countries.json" target="_blank">BorderConnect Data JSON</a>.</em></p> |
| | </div> |
|
| |
|
| <u>City</u>: | | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Importing 10,000+ Shipments</h2> |
| *The city name of the consignee for this shipment.
| |
| *Minimum length: 1
| |
| *Maximum length: 30
| |
|
| |
|
| <u>State</u>: | | <div class="bc-card"> |
| *The American State of the consignee for this shipment.
| | <p>For manifests exceeding 9,999 shipments, use the <strong>Link Shipments to Trip</strong> feature.</p> |
| *Must use the 2 letter code of the American state code.
| |
| *State codes must be '''upper case'''.
| |
|
| |
|
| <u>Zip</u>: | | <div class="bc-2col"> |
| *The zip code of the consignee for this shipment.
| | <div> |
| *Must be in the format "12345" or "12345-6789"
| | <h3>Workflow</h3> |
| | <div class="bc-cleanlist"> |
| | 1. <strong>Master Manifest:</strong> Create the first manifest and import the first ~5,000 shipments. |
| | 2. <strong>Linked Manifests:</strong> Create additional manifests (e.g., Trip 123B, 123C). |
| | 3. <strong>Link Field:</strong> In the new manifests, set <strong>Link Shipments to Trip</strong> to the original Trip Number (123). |
| | 4. <strong>Transmit:</strong> Send the master manifest first. Then, send the linked manifests using "Link Shipments to Trip" transmission. |
| | </div> |
| | </div> |
| | <div style="text-align: center;"> |
| | [[File:Link-shipments-to-trip-field.png|thumb|center|800px|Linking Shipments to a Master Trip]] |
| | </div> |
| | </div> |
| | </div> |
|
| |
|
| === Commodity === | | <h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Common Import Errors</h2> |
|
| |
|
| <u>Description</u>: | | <div class="bc-card"> |
| *A description of the goods in this shipment.
| | <h3>Troubleshooting Guide</h3> |
| *Should use plain language and be sufficient to give officer good idea of what is being shipped.
| | <table class="wikitable" style="width: 100%;"> |
| *Generic descriptions such as "freight of all kinds" are not allowed by customs.
| | <tr> |
| *Minimum length: 1
| | <th style="width: 30%;">Error Message</th> |
| *Maximum length: 45
| | <th>Solution</th> |
| | </tr> |
| | <tr> |
| | <td><code>SCAC Code [AAA] is invalid.</code></td> |
| | <td>SCAC must be exactly 4 characters.</td> |
| | </tr> |
| | <tr> |
| | <td><code>Shipment Type [SECTION321] is invalid</code></td> |
| | <td>Check spacing. It must be <code>SECTION 321</code> with a space.</td> |
| | </tr> |
| | <tr> |
| | <td><code>Unknown packaging unit [box]</code></td> |
| | <td>Package codes are case-sensitive. Use uppercase <code>BOX</code>.</td> |
| | </tr> |
| | <tr> |
| | <td><code>Consignee State [California] is invalid</code></td> |
| | <td>Use 2-letter codes (e.g., <code>CA</code>) for states and provinces.</td> |
| | </tr> |
| | </table> |
| | </div> |
|
| |
|
| <u>Value</u>:
| | {{AppPromo}} |
| *The value of the commodity, in U.S. Dollars.
| |
| *'''Numeric only''', with one decimal allowed. Must not include dollar sign, commas, etc.
| |
| *System will round to nearest whole number, or up to 1 if less than 1 before transmitting to customs.
| |
|
| |
|
| <u>Quantity</u>: | | == References == |
| *The quantity of the lowest external packaging unit. (e.g. if shipments consists of 100 pieces packaged in 5 boxes sitting on 1 skid, the quantity should be entered as 5, because boxes are the lowest external packaging unit.)
| | <references /> |
| *Numeric only, with no spaces or special characters. Decimal values not allowed.
| |
|
| |
|
| <u>Quantity Unit</u>:
| | </div> |
| *The type of packaging for the commodity.
| |
| *Must use a 3 letter Package Type code from the table provided.
| |
| | |
| Below are the valid package types for the commodity. E.g. for Cartons, CTN must be entered.<br>
| |
| (Please note that the package type values are case sensitive, and the upload will fail if it is not entered exactly as specified below.)
| |
| | |
| {| class="wikitable"
| |
| |-
| |
| ! Package Type
| |
| ! Value
| |
| ! Package Type
| |
| ! Value
| |
| ! Package Type
| |
| ! Value
| |
| ! Package Type
| |
| ! Value
| |
| |-
| |
| | Bag
| |
| | BAG
| |
| | Carton
| |
| | CTN
| |
| | Heads of Beef
| |
| | HED
| |
| | Roll
| |
| | ROL
| |
| |-
| |
| | Bale
| |
| | BLE
| |
| | Case
| |
| | CAS
| |
| | Keg
| |
| | KEG
| |
| | Sack
| |
| | SAK
| |
| |-
| |
| | Barrel
| |
| | BBL
| |
| | Cask
| |
| | CSK
| |
| | Lift Van
| |
| | LVN
| |
| | Sheet
| |
| | SHT
| |
| |-
| |
| | Basket
| |
| | BSK
| |
| | Chest
| |
| | CHS
| |
| | Liquid Bulk
| |
| | LBK
| |
| | Sides of Beef
| |
| | SID
| |
| |-
| |
| | Bin
| |
| | BIN
| |
| | Coil
| |
| | COL
| |
| | Logs
| |
| | LOG
| |
| | Skid
| |
| | SKD
| |
| |-
| |
| | Bing Chest
| |
| | BIC
| |
| | Container Bulk Cargo
| |
| | CBC
| |
| | Lugs
| |
| | LUG
| |
| | Tank
| |
| | TNK
| |
| |-
| |
| | Box
| |
| | BOX
| |
| | Cord
| |
| | COR
| |
| | Package
| |
| | PKG
| |
| | Tin
| |
| | TIN
| |
| |-
| |
| | Bucket
| |
| | BKT
| |
| | Crate
| |
| | CRT
| |
| | Pail
| |
| | PAL
| |
| | Tote Bin
| |
| | TBN
| |
| |-
| |
| | Bundle
| |
| | BDL
| |
| | Cylinder
| |
| | CYL
| |
| | Parcel
| |
| | PCL
| |
| | Tube
| |
| | TBE
| |
| |-
| |
| | Can
| |
| | CAN
| |
| | Drum
| |
| | DRM
| |
| | Pieces
| |
| | PCS
| |
| | Unit
| |
| | UNT
| |
| |-
| |
| | Can Case
| |
| | CCS
| |
| | Dry Bulk
| |
| | DBK
| |
| | Private Vehicle
| |
| | POV
| |
| | Van Pack
| |
| | VPK
| |
| |-
| |
| | Carboy
| |
| | CBY
| |
| | Gallon
| |
| | GAL
| |
| | Quarters of Beef
| |
| | QTR
| |
| | Vehicle
| |
| | VEH
| |
| |-
| |
| | Carcass
| |
| | CAR
| |
| | Hamper
| |
| | HMP
| |
| | Reel
| |
| | REL
| |
| | Wooden Case
| |
| | WDC
| |
| |}
| |
| | |
| <u>Weight</u>:
| |
| *The gross weight of the commodity.
| |
| *Numeric only, with no spaces or special characters. Decimal values not allowed, should be rounded to the nearest whole number.
| |
| | |
| <u>Weight Unit</u>:
| |
| *The weight unit for the commodity.
| |
| *For Pounds, acceptable values are: "L", "LB", "LBS", "LBR"
| |
| *For Kilograms, acceptable values are: "K", "KG", "KGM"
| |
| | |
| <u>Country of Origin</u>:
| |
| *The country in which the commodity was manufactured, grown or otherwise produced.
| |
| *Must use the 2 letter country code for the country, in upper case letters.
| |
| *The full list of acceptable country codes can be [https://www.borderconnect.com/data/countries.json downloaded here].
| |
| | |
| == Importing Shipments ==
| |
| | |
| Once you have the CSV file populated with data in the correct format and your company has enabled the ACE shipment import buttons, you can then import the shipments.
| |
| | |
| To import the CSV file you must first start a new ACE Manifest or edit an existing ACE Manifest. Then, click the button "Choose File" to navigate locally and select the .csv file you would like to upload. Once the file is selected, click 'Save' on the top left. You will be brought to the ACE Manifest details page where a notice will let you know if the upload was successful, and/or if any errors in the import were found.
| |
| | |
| Next to the import button you will see that this button is for JSON files, but CSV files will also be accepted.
| |
| | |
| [[File:Ace-upload-shipments.png|800px]]
| |
| | |
| == Importing 10,000 Or More Shipments To a Single ACE Manifest ==
| |
| | |
| {{#ev:youtube|LfbA8W-R9S0|360|right|Importing 10,000 or more shipments into an ACE Manifest}}By default users can only upload 9999 shipments into a single ACE Manifest, which is enough for most users who wish to import shipments into an ACE for example. However, in some cases more shipments will need to be added to a single ACE Manifest.
| |
| | |
| Importing 10,000 or more shipments into a single ACE Manifest involves creating multiple ACE Manifests and importing no more than 9999 shipments into each separate ACE Manifest, then moving the imported shipments from the second (or third) ACE manifest, back to the original manifest using the Link Shipments to Trip feature.
| |
| | |
| '''How to Import More than 10,000 Shipments to a Single ACE'''
| |
| | |
| *1. Create your first ACE eManifest, so in the drop down menu select ACE eManifests and select Start New ACE Manifest, and after you enter all your trip details, at the bottom you have the option to upload shipments directly into your ACE Manifest in either a JSON or CSV file format. Now click and locate or drag the file into the manifest. Then on the top left, hover over Save and then select Save and View Trip Details. If you’re adding a significant amount of shipments it may take some time to process the shipment upload so it’s important to be patient during this process. Once this process is complete, you’ll be brought to the ACE Manifest Details page where you can see that your shipments have been successfully imported into the ACE Manifest.
| |
| | |
| *2. Create a new ACE Manifest, so at the top under ACE eManifest select Start New ACE Manifest. For this second trip number you can use the same trip number as previously, only this time adding a B to the end. Next on the top right, ''Show All Fields'' will need to be enabled, which will reveal the field '''Link Shipments to Trip'''. So click into Link Shipments to Trip and assign the original trip that you created initially. This will link all of this trips shipments to that manifest.
| |
| | |
| [[File:Link-shipments-to-trip-field.png|800px]]
| |
| | |
| *3. Next enter the remainder of the trip details, and then at the bottom click and locate or drag the second JSON or CSV file that contains the additional shipments into this manifest. Then go to the top left and hover over Save and select Save and View Trip Details. And just like the first large batch of imports, you will need to be patient as these shipments are imported into BorderConnect. Once the import is complete you will be brought to the ACE Manifest Details page.
| |
| | |
| If you had even more shipments to add to the original manifest, just repeat the process for the second manifest that we created, and create your third ACE manifest while adding “C” to the end of the trip number and import the additional shipments on that manifest.
| |
| | |
| *4. Next Send the first ACE Manifest to CBP, so under ACE Manifests click Search ACE Manifests and then click into or view the original ACE that was created from the ACE Manifest listing page. Once in the ACE Manifest Details page, hover over Send to CBP at the top and click Send Complete Manifest which will move the status to two yellow bars, transmitted. And because this manifest contains a significant amount of shipments, it will take much longer than usual to get processed by CBP and accepted, in some cases up to 20 minutes. But once it does get accepted, it will turn to three blue bars.
| |
| | |
| *5. After the first ACE is on file with CBP you will have to send the second manifest that was created, so again, under ACE eManifests click Search ACE Manifests and View the second ACE Manifest that was created. Once in it, hover over Send to CBP and click ''Link Shipments to Trip'' which will transmit your manifest to CBP linking these shipments to the original manifest at the same time. And after some time it will get accepted and move to three blue bars. Now all the shipments have been successfully accepted and linked to the original first manifest that we created.
| |
| | |
| [[File:Send-link-shipments-to-trip.jpg|300px]]
| |
| | |
| == Common Import Errors ==
| |
| | |
| Listed below are some of the common errors users receive when trying to upload their .csv file into BorderConnect.
| |
| | |
| '''Shipment Control Number Errors'''
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Can't perform import since AUTOFILL shipment numbers are combined with explicitly stated shipment control numbers.
| |
| </pre>
| |
| | |
| Some of the Shipment Control Numbers in your file are using your SCAC plus AUTOFILL, and some are not. To use the Autofill feature, all Shipment Control Numbers must be filled in as SCAC plus AUTOFILL.
| |
| | |
| It is currently also possible to get this error because there are blank rows at the bottom of your CSV file. You may want to use a plain text editor to check your file for rows consisting of only commas and remove those rows from the file.
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| SCAC Code [AAA5] is invalid. Must be 4 alphanumeric characters. [AAA5459071]
| |
| </pre>
| |
| | |
| The SCAC code has an incorrect amount of characters. SCAC should be four letters.
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Shipment Control Number is invalid, it must be 8-16 alphanumeric characters with no spaces and letters must be uppercase. [AAAA545907321321321131]
| |
| </pre>
| |
| | |
| The Shipment Control Number has too many characters. SCN must be between 8-16 characters.
| |
| | |
| | |
| '''Shipment Type Errors'''
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Shipment Type [SECTION 321] is invalid [AAAA5459071]
| |
| </pre>
| |
| | |
| The Shipment Type value is incorrect and should be "SECTION_321". Double check acceptable shipment type values and try to upload again.
| |
| | |
| | |
| '''Shipper Errors'''
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Province of Loading code [BX] unrecognized. [AAAA5459071]
| |
| OR
| |
| Province of Loading code [British Columbia] unrecognized. [AAAA5459071]
| |
| </pre>
| |
| | |
| The Province of Loading for the shipper is not recognized. Format must use the acronym "BC". (ex. "ON", "MB", "NS", etc.)
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Shipper Name [Demo Business Incorporated CO Steven Stevenson Incorporated of Vancouver bla bla] invalid. Must be between 1 and 60 characters, with no accents or other invalid characters. [AAAA5459091]
| |
| </pre>
| |
| | |
| The Shipper Name has too many characters. It must be between 1 and 60 characters.
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Shipper Canadian Postal Code [VSS 1A1] invalid. [AAAA5459219]
| |
| </pre>
| |
| | |
| The shipper postal code is invalid. Should be (letter-number-letter number-letter-number)
| |
| | |
| | |
| '''Consignee Errors'''
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Consignee State [California] is invalid or does not match with country [US]. [AAAA5459219]
| |
| </pre>
| |
| | |
| The state of the consignee is not recognized. Format must use the acronym "CA". (ex. "NY", "WA", "FL", etc.)
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Consignee U.S. Zip Code [4321] invalid. [AAAA5459219]
| |
| </pre>
| |
| | |
| The consignee address has a zip code that is invalid. Zip codes must be five character numbers or ten character numbers (ex. 45180-6789 and must include the dash if the ten character format is used).
| |
| | |
| <u>Note</u>: It is common for spreadsheet programs to strip leading zeroes from fields. E.g. zip code beginning with a zero such as 04321 might be saved as 4321 by the spreadsheet program, which would be an unacceptable zip code for upload to BorderConnect.
| |
| | |
| It may be necessary to look for solutions within the program that you're using to generate the CSV file to remedy this issue. For some spreadsheet programs, saving the number as ''="04321"'' instead of just ''04321'' works.
| |
| | |
| '''Commodity Errors'''
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Unknown packaging unit [box]. [AAAA5459219]
| |
| </pre>
| |
| | |
| The package type is in the incorrect format. The correct variable for the box package type is "BOX". Remember that values are case-sensitive.
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Shipment commodity weight is invalid. It must be numeric [0.63]
| |
| </pre>
| |
| | |
| Commodity weight must be listed in whole numbers only. Should be rounded to the nearest number, or up to 1 if less than 1.
| |
| | |
| <pre style="white-space: pre-wrap;
| |
| white-space: -moz-pre-wrap;
| |
| white-space: -pre-wrap;
| |
| white-space: -o-pre-wrap;
| |
| word-wrap: break-word;">
| |
| Commodity weight unit [POUNDS] is invalid. [AAAA5459219]
| |
| </pre> | |
| | |
| The unit of measure for the weight is incorrect. It must follow the value guidlines for import. In this case if pounds was the unit of weight, the correct value is "LB", "L", "LBS" or "LBR"
| |
|
| |
|
| [[Category:ACE Manifest Guide]] | | [[Category:ACE Manifest Guide]] |
| [[Category:BorderConnect Software User Guide]] | | [[Category:BorderConnect Software User Guide]] |