BorderConnect Wiki

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

← Older edit
No edit summary
Tag: Reverted
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 52: Line 52:
<p>You must use the official template to ensure your data maps correctly.</p>
<p>You must use the official template to ensure your data maps correctly.</p>
<div class="bc-cleanlist">
<div class="bc-cleanlist">
* <strong>Download:</strong> [https://www.borderconnect.com/dist/ace-shipment-csv-template.csv ACE Shipment CSV Template].
* <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).
* <strong>Format Rule:</strong> Do not rename, remove, or reorder the column headers. Always save as <strong>.csv</strong> (Comma Separated Values).
</div>
</div>
</div>
</div>


<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Field Specifications</h2>
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 3: Prepare Your Data</h2>


<div class="bc-card">
<div class="bc-card">
Line 77: Line 77:
</table>
</table>


<h3>Commodity & Units</h3>
<h3>Commodity Data</h3>
<div class="bc-cleanlist">
<div class="bc-cleanlist">
* <strong>Quantity Unit:</strong> Must use a valid 3-letter package code (e.g., <code>BOX</code>, <code>CTN</code>, <code>PLT</code>, <code>SKD</code>).
* <strong>Description:</strong> Plain language description of goods (max 45 chars).
* <strong>Weight:</strong> Whole numbers only. Round up if necessary.
* <strong>Value:</strong> Numeric only. No dollar signs (e.g., <code>1500.50</code>).
* <strong>Weight Unit:</strong> Use <code>L</code>, <code>LB</code>, <code>LBS</code> for pounds or <code>K</code>, <code>KG</code>, <code>KGM</code> for kilograms.
* <strong>Weight:</strong> Whole numbers only (round up).
</div>
</div>
</div>
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Step 4: Importing into BorderConnect</h2>
<div class="bc-card">
<p>Once your file is ready, follow these specific steps to upload it into the system.</p>
<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>
<h3>2. Locate the Import Tool</h3>
<div class="bc-cleanlist">
* On the <strong>ACE eManifest Details</strong> page, scroll down to the <strong>Shipments</strong> section.
* 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]]
<h3>3. Upload and Process</h3>
<div class="bc-cleanlist">
* Click <strong>Choose File</strong> and select your prepared <code>.csv</code> file from your computer.
* Click <strong>Save</strong> or <strong>Import</strong>.
* The system will process the file immediately.
</div>
<h3>4. Verify Results</h3>
<div class="bc-cleanlist">
* <strong>Success:</strong> You will see a green confirmation message, and your shipments will appear in the list below.
* <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>
<h2 style="margin-top: 40px; border-bottom: 2px solid #eee; padding-bottom: 10px;">Reference Codes</h2>
<div class="bc-card">
<h3><i class="fas fa-balance-scale"></i> Weight Unit Codes</h3>
<p>Only the following codes are accepted for the <strong>Weight Unit</strong> column:</p>
<table class="wikitable" style="width: 100%;">
<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>
<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>
<div class="bc-2col">
<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>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>
<div class="bc-card" style="margin-top: 20px;">
<h3><i class="fas fa-globe"></i> Common Country of Origin Codes</h3>
<p>Use the 2-letter ISO code for the <strong>Country of Origin</strong> column. Common codes include:</p>
<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>
</div>


Line 101: Line 223:
</div>
</div>
<div style="text-align: center;">
<div style="text-align: center;">
[[File:Link-shipments-to-trip-field.png|thumb|center|Linking Shipments to a Master Trip]]
[[File:Link-shipments-to-trip-field.png|thumb|center|800px|Linking Shipments to a Master Trip]]
</div>
</div>
</div>
</div>
Retrieved from "https://wiki.borderconnect.com/index.php?title=ACE_Shipment_CSV_Upload_Feature_(ACE_Manifest)"