We assume you have experience working with Import Setups.
What We're Automating
Normally, after importing shipment data, you'd go to the Outbox, select a stack or multiple shipments, right-click, and choose "Transmit Selected Shipments". This generates and sends the EDI to the carrier.
Basic Data Import and Shipment Creation
Start with a CSV containing your shipment data. Example:
"Packages";"SE";"Test 1";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10"
"Packages";"NO";"Test 2";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10"
"Packages";"SE";"Test 3";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10"
"Packages";"NO";"Test 4";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10"
"Packages";"SE";"Test 5";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10"
"Packages";"NO";"Test 6";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10"
"Packages";"SE";"Test 7";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10"
"Packages";"NO";"Test 8";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10"
Configure your import setup (semicolon delimited) with these field mappings:
- F1 (CarrierCode): Shipping service.
- F2 (Actor Alias): Actor.
- F3 (Ordernumber): Order.
- F4-F8 (Receiver): Name, Address, Postcode, City, Country.
- F9 (Number): Number of lines to be generated.
- F10 (Contents): Item description.
- F11 (Weight): Shipment weight.
Importing this CSV creates shipments in your Outbox.
Automating with Transmit Group ID
Modify your import setup:
- F12 (Custom Field 1 -> Reference): This will store your "Transmit Group ID" (e.g., "RouteA", "RouteB"). Add this column to your CSV.
- E1 (Project -> Reference): Set to "Transmit ID: ". Displays the Transmit Group ID in the "Project Name" column.
- E2 (Transmit Group ID -> Import): Set to
<F12>
. This is crucial: it assigns the F12 value as the Transmit Group ID.
Updated CSV example:
"Packages";"SE";"Test 1";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10";"RouteA"
"Packages";"NO";"Test 2";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10";"RouteB"
"Packages";"SE";"Test 3";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10";"RouteA"
"Packages";"NO";"Test 4";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10";"RouteA"
"Packages";"SE";"Test 5";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10";"RouteA"
"Packages";"NO";"Test 6";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10";"RouteB"
"Packages";"SE";"Test 7";"Test Name 1";"Test Address1";"22222";"Lund";"SE";"1";"Test Shipment";"10";"RouteA"
"Packages";"NO";"Test 8";"Test Name 1";"Test Address1";"0850";"Oslo";"NO";"1";"Test Shipment";"10";"RouteB"
After importing, shipments are grouped by Transmit ID in the Outbox.
Full Automation with Import Commands
This eliminates manual Outbox interaction.
- Import Setup: Add F13: Command -> Import.
- Define CMD_TRANSMIT: In the "Commands" tab of your import setup, create a command named "CMD_TRANSMIT" linked to the "Transmit shipments" Service.
- "Packages": Matches your import setup's Carrier code.
- "RouteB": The target Transmit Group ID.
- "CMD_TRANSMIT": The command to execute.
- Empty fields: Required for correct field positioning.
Create a separate CSV to trigger transmission. To transmit "RouteB":
"Packages";"";"";"";"";"";"";"";"";"";"";"RouteB";"CMD_TRANSMIT"
Importing this command CSV using your configured import setup automatically transmits all shipments with the specified Transmit Group ID ("RouteB" in this example).
The shipments disappear from the Outbox upon successful transmission.