Versions Compared

Old Version 4

changes.mady.by.user Former user

Saved on

compared with

New Version 5

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Upload a file in the format explained below
  2. Click on "process file"
  3. We will email you the file back, with the addition of a new column "RESULT" containing the transport-product, or possibly an error message. Specify the email-address in step 1.

General notes about the format

  • We support both Excel- and CSV-files.
  • Encoding: The files are assumed to be encoded as ISO-8859-1.
  • Columns
    • The order of the columns is not important.
    • The header-line (with the column names) is essential. Each column MUST have our documented names (i.e. ORDER_ID or CONSIGNEE_NAME). 
    • We give an error if there are any unknown column names in the file. The file should therefore not have any other column names than those documented here. 
  • For CSV, the field separator is semi colon (;).
  • The columns can be quoted, if so, use ("").

Format definition

The Flow Selfservice system makes use of Parcel Booking API, so please refer to the documentation for more information on possible error-codes.

Name

Mandatory

Description

Max length

Type

Example

ORDER_ID

External order ID
Typically identifies each customer for this distribution.

12StringA345
CONSIGNEE_NAMEYes

Name of customer

105StringOla Nordmann
CONSIGNEE_COUNTRYCODEYesCountry code, according to ISO 3166-1.3StringNO
CONSIGNEE_ADDRESS

Combined address information with the following format:

  • Street name
  • Street number (with leading space)
  • Entrance
  • Floor type (only relevant for countryCode=NO)
    • H (main floor)
    • U (basement)
    • L (attic)
    • K (cellar)
  • Floor number
  • Flat numer
35StringStorgaten 11A H0202
CONSIGNEE_ZIPYesAlso known as postal code.9String0155
CONSIGNEE_CITYYesAlso known as postal name.35StringOSLO
CONSIGNEE_PHONE_1
This can be used for automated SMS notification.100String+47 402 10 000
CONSIGNEE_PHONE_2
This can be used for automated SMS notification.100String+47 402 20 000
CONSIGNEE_EMAIL
This can be used for automated email notification.100String

ola@nordmann.no

CONSIGNOR_NAMEYes

Name of customer




CONSIGNOR_COUNTRYCODEYesCountry code, according to ISO 3166-1.


CONSIGNOR_ADDRESS

Combined address information with the following format:

  • Street name
  • Street number (with leading space)
  • Entrance
  • Floor type (only relevant for countryCode=NO)
    • H (main floor)
    • U (basement)
    • L (attic)
    • K (cellar)
  • Floor number
  • Flat numer



CONSIGNOR_ZIPYesAlso known as postal code.


CONSIGNOR_CITYYesAlso known as postal name.


CONSIGNOR_PHONE
This can be used for automated SMS notification.


CONSIGNOR_EMAIL

This can be used for automated email notification.




WEIGHT

Measuring unit is gram.

n/aWhole number600
VOLUME

Measuring unit is cubic decimeter.

n/aDecimal number4
LENGTH

Measuring unit is centimeter.

n/aDecimal number120
HEIGHT

Measuring unit is centimeter.

n/aDecimal number5
WIDTH
Measuring unit is centimeter.n/aDecimal number12
CONTENT

Description of the contents. This can be placed on some shipping labels.

70StringBrown shirt
CONTENT_VALUE
Currency is according to the location of the shopId.n/aDecimal number580
GENERIC_1

A piece of generic information that will be retained through the process and given back in the resulting file.


Text
GENERIC_2
A piece of generic information that will be retained through the process and given back in the resulting file.
Text
GENERIC_3
A piece of generic information that will be retained through the process and given back in the resulting file.
Text
GENERIC_4
A piece of generic information that will be retained through the process and given back in the resulting file.
Text
GENERIC_5
A piece of generic information that will be retained through the process and given back in the resulting file.
Text

Template-file and examples

flow_selfservice_example.csv

...