File Transfers

File-based exchange supports file formats like .csv, .xml or EDIFACT and allows for easy integration.

File Formats

All files do not have specific naming requirements. Columns in .csv files or fields in .xml files can be named as they are used in the creating system or as per our data model as a guideline.

Data Model

CSV (Preferred)

Uploaded .csv files are accepted and should meet the following requirements:

• The first row needs to contain headings.

• The delimiter can be , ; | + or TAB.

• Quoting can be strict or non-strict, with char ' or ".

• File encoding should be UTF-8, alternatively ASCII or ISO 8859-1 is also accepted.

Technically UTF-8-SIG, UTF-16, and latin-1 are also accepted. UTF-16 characters should not be inserted into non UTF-16 files.

A sample file can be downloaded here.

566B

sample-upload.csv

Open

Sample .csv file

JSON (Preferred)

Uploaded .json files are accepted.

A sample file can be downloaded here.

1KB

sample-upload.json

Open

Sample .json file

XML

Uploaded .xml documents are accepted. Simple, nested .xml documents are preferred over .csv files if trackings are to be uploaded with a list of articles.

A sample file and the schema for a tracking can be downloaded here.

1KB

ParcelLabTrackingUpload.xml

Open

Sample .xml file

3KB

ParcelLabTrackingUpload.xsd

Open

XSD schema

EDIFACT

Uploaded EDIFACT files are accepted and should follow the UN/EDIFACT IFTMIN specifications. You can test files for compatibility using our edi-iftmin parser.

Fixed Files

Uploaded .fixed files are accepted. These are like .csv files except instead of delimiter characters, columns end after a fixed number of characters in .fixed files.

A sample file can be downloaded here.

434B

sample-upload.fixed

Open

Sample .fixed file

Transfer Channels

Uploaded files are archived by the system after successful import (that is: moved out of the import folder). The import is event-driven and should be done a couple of seconds after upload depending on the size of the uploaded file.

Credentials are assigned by our Support team as required for the services used.

SFTP (Certificate)

The preferred transfer channel is through our SFTP server with certificate based authentication.

FTP servers can be either through parcelLab's servers or yours as follows:

• For parcelLab's servers (hub2.parcellab.com), we share a SSH key (certificate).

• For your servers, we can connect either using a username/password or with a SSH key (certificate).

Protocol: SFTP
Server: hub.parcellab.com
Port: 22

You need to provide parcelLab with your Public Key in OpenSSL format according to RFC4253. A compatible key format can be created like this:

• MacOS, Linux, Unix: Run ssh-keygen -P "" -m PEM -f key_name in the terminal. You will generate two files in the current directory and you need to share your SSH Public Key in the key_name.pub file with us.

• Windows: With PuTTY, you can generate the key pair with the Public Key in PUB format, and the Private Key in PPK format. Again, only share your Public Key with us.

SFTP (Password)

As an alternative to certificate based access, parcelLab also allow for authentication via password. For this, our team will generate a username and a random, secure password and share it with you.

Protocol: SFTP
Server: hub2.parcellab.com
Port: 22

SFTP Legacy Data

With regards to legacy SFTP servers, if you put files on servers that do not distinguish between folders and files, this can cause errors when parcelLab try to download the files and can create delays. As a result, the FTP server must support the MLSD command and the LIST alone is not sufficient.

Download

Our system can also download files via FTP-SSL and SFTP. In that case, requests will come from the following:

Request IP for Downloads:
18.197.138.147

Please fill in our contact form and provide us with the server address, protocol, port, and access credentials.