PUDO data via SFTP

The PUDO (Pick Up & Drop Off) SFTP solution provides you all locations in one file, that you can store as a library. The file will be generated on daily basis.

File Naming

All tracking data files will use the following naming convention:
RMLCyyyymmdd.CSV

The elements in the filename are defined as follows:

RMRoyal Mail
LCLocal Collect
YYYYear date of file creation
MMMonth date of file creation
DDDay date of file creation

For example, a file generated on 09th September 2019 at 5.32pm would be: RMLC20190909.CSV


File Structure Overview

Each file will consist of a full list of available locations each day and should completely replace the previous days file.


File Format

The file will be in CSV format with comma delimiters.
The table below describes the records and fields that will be present in the data file for each PUDO locations.


Header Record

#NameTypeMax LengthComments
1Record TypeC1This will always be H
2DateD8Date file created in format ddmmyyyy
3PO RecordsD6The number of Post Office Records contained in the file
4CSP RecordsD6The number of CSP Records contained in the file

Detail Record

#NameTypeMax LengthComments
1Record TypeC1This will always be D
2Office TypeC3Values of either CSP (for RM Customer Service Points) or POL(for Post Offices)
3Office number/refenceD7The unique identifier for the office
4Office NameC50The office name
5Address Line 1C50Address Line 1
6Address Line 2 (if relevant)C50Address Line 2 (will be blank if not relevant)
7Address Line 3 (if relevant)C50Address Line 3 (will be blank if not relevant)
8Address Line 4 (if relevant)C50Address Line 4 (will be blank if not relevant)
9Address Line 5 (if relevant)C50Address Line 5 (will be blank if not relevant)
10TownC50Town
11PostcodeC10Postcode
12Longitude (if available)C10Longitude value for the office location (will be blank if not available)
13Latitude (if available)C10Latitude value for the office location (will be blank if not available)
14Monday Open 1D5First opening time on Monday in format hh:mm (in 24hr clock format)
15Monday Open 2D5Second opening time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
16Monday Open 3D5Third opening time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
17Monday Close 1D5First Closing time on Monday in format hh:mm (in 24hr clock format)
18Monday Close 2D5Second Closing time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time
19Monday Close 3D5Third Closing time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
20Tuesday Open 1D5First opening time on Tuesday in format hh:mm (in 24hr clock format)
21Tuesday Open 2D5Second opening time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
22Tuesday Open 3D5Third opening time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
23Tuesday Close 1D5First Closing time on Tuesday in format hh:mm (in 24hr clock format)
24Tuesday Close 2D5Second Closing time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
25Tuesday Close 3D5Third Closing time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
26Wednesday Open 1D5First opening time on Wednesday in format hh:mm (in 24hr clock format)
27Wednesday Open 2D5Second opening time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
28Wednesday Open 3D5Third opening time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
29Wednesday Close 1D5First Closing time on Wednesday in format hh:mm (in 24hr clock format)
30Wednesday Close 2D5Second Closing time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
31Wednesday Close 3D5Third Closing time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
32Thursday Open 1D5First opening time on Thursday in format hh:mm (in 24hr clock format)
33Thursday Open 2D5Second opening time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
34Thursday Open 3D5Third opening time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
35Thursday Close 1D5First Closing time on Thursday in format hh:mm (in 24hr clock format)
36Thursday Close 2D5Second Closing time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
37Thursday Close 3D5Third Closing time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
38Friday Open 1D5First opening time on Friday in format hh:mm (in 24hr clock format)
39Friday Open 2D5Second opening time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
40Friday Open 3D5Third opening time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
41Friday Close 1D5First Closing time on Friday in format hh:mm (in 24hr clock format)
42Friday Close 2D5Second Closing time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
43Friday Close 3D5Third Closing time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
44Saturday Open 1D5First opening time on Saturday in format hh:mm (in 24hr clock format)
45Saturday Open 2D5Second opening time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
46Saturday Open 3D5Third opening time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
47Saturday Close 1D5First Closing time on Saturday in format hh:mm (in 24hr clock format)
48Saturday Close 2D5Second Closing time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
49Saturday Close 3D5Third Closing time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)
50Sunday Open 1D5First opening time on Sunday in format hh:mm (in 24hr clock format)
51Sunday Open 2D5Second opening time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time)
52Sunday Open 3D5Third opening time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times)
53Sunday Close 1D5First Closing time on Sunday in format hh:mm (in 24hr clock format)
54Sunday Close 2D5Second Closing time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time)
55Sunday Close 3D5Third Closing time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times)

🚧

PLEASE NOTE:

Each office can have up to a maximum of 3 opening windows in a day. So, an offices open/close profile for any day could look like per below:

Open 107:30
Open 213:00
Open 318:00
Close 112:00
Close 217:00
Close 320:00

OR

Open 107:30
Open 213:00
Open 3
Close 112:00
Close 217:00
Close 3

OR

Open 107:30
Open 2
Open 3
Close 118:00
Close 2
Close 3

📘

Note

If you want to proceed with setting this up you will need to do the following:

  • Enable PUDO via the Royal Mail Integration Activation screen.
  • Create a location for us to connect to and reach out to our Onboarding team and raise a request for PUDO data via SFTP, along with providing us with your RSA Public Key.
  • We will then respond back and provide you with your connection details.