A standard PortalData Export sends a CSV or XML file to an FTP server when shipments are submitted or transmitted. The file contains the shipment status. An nShift technical consultant creates the export setting, and this article gives you an overview of the data and fields in the standard format.
If you need a customized file with different data or event triggers, contact our sales department for a quote. To see what you can choose in a customized export, see Getting started with PortalData Export.
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