A standard Portal Export creates either a CSV or XML file that is sent to an FTP. The files are generated when shipments are submitted or transmitted and will return the shipment status.
A technical consultant from nShift creates the Portal Export setup but this article gives you an overview of the data and fields included in the standard format. If you need a customized file with different data or event triggers, please contact our sales department for a quote.
Sections in this article
File output - XML example
Example of a standard XML file.
<?xml version="1.0" encoding="utf-8"?>
<Shipments>
<Shipment>
<OrderNumber>84531</OrderNumber>
<Number>70730254433173517</Number>
<PackageNumber>00370730254433173529</PackageNumber>
<Name1>John Doe</Name1>
<Street1>Test Street 1</Street1>
<CarrierName>PostNord</CarrierName>
<ProductName>Parcel</ProductName>
<EventDate>2022-10-28 08:44</EventDate>
<EventStatusText>The delivery of the shipment item is in progress</EventStatusText>
<NormalizedStatusID>2000</NormalizedStatusID>
<Price1>100.0</Price1>
<Price2>120.0</Price2>
<SubmitDate>2022-10-28 08:43</SubmitDate>
<LinesSummedWeights>10</LinesSummedWeights>
<VolumeCM>1000</VolumeCM>
<NumberOfPackages>1</NumberOfPackages>
<SenderName1>Jane Doe</SenderName1>
<CustomField1>4321</CustomField1>
</Shipment>
</Shipments>
File output - CSV example
Standard CSV example including headers:
Ordernumber;Shipment number;Receiver Name1;Receiver Address1;Carrier;Product;Status date;Status;Price 1;Price 2;Submit date;Weight;Volume;Number of colli;Sender Name1;Custom Field1;
1234;70730254433173517;John Doe;Test Street 1;PostNord;Parcel;2022-10-28 08:44;Transmitted;100.0;120.0;2022-10-28 08:43;10;0;1;Jane Doe;4321
Standard CSV example without headers
1234;70730254433173517;John Doe;Test Street 1;PostNord;Parcel;2022-10-28 08:44;Transmitted;100.0;120.0;2022-10-28 08:43;10;0;1;Jane Doe;4321
Normalized status codes
The field <NormalizedStatusID> contains a code that equals a status event. This list contains all possible status codes and event names:
System
1000 - Created
1001 - Transmit
1002 - Deleted
1003 - Internal
1004 - Customer advised
1005 - Undelete
1007 - Onboarded to container
1008 - Offboarded from container
In Transit
2000 - In Transit
2001 - Out for delivery
2002 - Ready for pickup
2003 - Arrived at terminal/hub
2004 - Collected by carrier
2005 - Customs Clearance
2008 - Departed from terminal/hub
Delivered
3000 - Delivered
3001 - Partially delivered
3002 - Carded
3003 - Delivered to neighbor
Information
4000 - Other status
4001 - Update ETA
4002 - Change of address
4003 - Notification(s)/Advise
4004 - Booking information confirmed
4005 - Measurement/Price Update
Carrier exception
5000 - Carrier Exception
5001 - Other incident
5002 - Delayed
5003 - Damaged
5004 - Change to delivery
5005 - Misrouted
5006 - Failed delivery attempt
5007 - Return to sender
5008 - Lost
5009 - Force majeure
Receiver Exception
6000 - Other incident
6001 - Return to sender
6002 - Customer refused
6003 - No property access
6004 - Delivery canceled
6005 - Carded
Sender Exception
7000 - Other incident
7001 - Delivery canceled
7002 - Return to sender
7003 - Insufficient address
7004 - Missing booking info