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:
RM Royal Mail
LC Local Collect
YYYY Year Date of file creation
MM Month Date of file creation
DD Day 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
|
# |
Name |
Type |
Max Length |
Comments |
|
1. |
Record Type |
C |
1 |
This will always be H |
|
2. |
Date |
D |
8 |
Date file created in format ddmmyyyy |
|
3. |
PO Records |
D |
6 |
The number of Post Office Records contained in the file |
|
4. |
CSP Records |
D |
6 |
The number of CSP Records contained in the file |
Detail Record
|
# |
Name |
Type |
Max Length |
Comments |
|
1 |
Record Type |
C |
1 |
This will always be D |
|
2 |
Office Type |
C |
3 |
values of either CSP (for RM Customer Service Points) or POL(for Post Offices) |
|
3 |
Office number/reference |
D |
7 |
The unique identifier for the office. |
|
4 |
Office Name |
C |
50 |
The office name |
|
5 |
Address Line 1 |
C |
50 |
Address Line 1 |
|
6 |
Address Line 2 (if relevant) |
C |
50 |
Address Line 2 (will be blank if not relevant) |
|
7 |
Address Line 3 (if relevant) |
C |
50 |
Address Line 3 (will be blank if not relevant) |
|
8 |
Address Line 4 (if relevant) |
C |
50 |
Address Line 4 (will be blank if not relevant) |
|
9 |
Address Line 5 (if relevant) |
C |
50 |
Address Line 5 (will be blank if not relevant) |
|
10 |
Town |
C |
50 |
Town |
|
11 |
Postcode |
C |
10 |
Postcode |
|
12 |
Longitude (if available) |
C |
10 |
Longitude value for the office location (will be blank if not available) |
|
13 |
Latitude (if available) |
C |
10 |
Latitude value for the office location (will be blank if not available) |
|
14 |
Monday Open 1 |
D |
5 |
First opening time on Monday in format hh:mm (in 24hr clock format) |
|
15 |
Monday Open 2 |
D |
5 |
Second opening time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
16 |
Monday Open 3 |
D |
5 |
Third opening time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
17 |
Monday Close 1 |
D |
5 |
First Closing time on Monday in format hh:mm (in 24hr clock format) |
|
18 |
Monday Close 2 |
D |
5 |
Second Closing time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
19 |
Monday Close 3 |
D |
5 |
Third Closing time on Monday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
20 |
Tuesday Open 1 |
D |
5 |
First opening time on Tuesday in format hh:mm (in 24hr clock format) |
|
21 |
Tuesday Open 2 |
D |
5 |
Second opening time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
22 |
Tuesday Open 3 |
D |
5 |
Third opening time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
23 |
Tuesday Close 1 |
D |
5 |
First Closing time on Tuesday in format hh:mm (in 24hr clock format) |
|
24 |
Tuesday Close 2 |
D |
5 |
Second Closing time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
25 |
Tuesday Close 3 |
D |
5 |
Third Closing time on Tuesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
26 |
Wednesday Open 1 |
D |
5 |
First opening time on Wednesday in format hh:mm (in 24hr clock format) |
|
27 |
Wednesday Open 2 |
D |
5 |
Second opening time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
28 |
Wednesday Open 3 |
D |
5 |
Third opening time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
29 |
Wednesday Close 1 |
D |
5 |
First Closing time on Wednesday in format hh:mm (in 24hr clock format) |
|
30 |
Wednesday Close 2 |
D |
5 |
Second Closing time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
31 |
Wednesday Close 3 |
D |
5 |
Third Closing time on Wednesday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
32 |
Thursday Open 1 |
D |
5 |
First opening time on Thursday in format hh:mm (in 24hr clock format) |
|
33 |
Thursday Open 2 |
D |
5 |
Second opening time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
34 |
Thursday Open 3 |
D |
5 |
Third opening time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
35 |
Thursday Close 1 |
D |
5 |
First Closing time on Thursday in format hh:mm (in 24hr clock format) |
|
36 |
Thursday Close 2 |
D |
5 |
Second Closing time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
37 |
Thursday Close 3 |
D |
5 |
Third Closing time on Thursday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
38 |
Friday Open 1 |
D |
5 |
First opening time on Friday in format hh:mm (in 24hr clock format) |
|
39 |
Friday Open 2 |
D |
5 |
Second opening time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
40 |
Friday Open 3 |
D |
5 |
Third opening time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
41 |
Friday Close 1 |
D |
5 |
First Closing time on Friday in format hh:mm (in 24hr clock format) |
|
42 |
Friday Close 2 |
D |
5 |
Second Closing time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
43 |
Friday Close 3 |
D |
5 |
Third Closing time on Friday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
44 |
Saturday Open 1 |
D |
5 |
First opening time on Saturday in format hh:mm (in 24hr clock format) |
|
45 |
Saturday Open 2 |
D |
5 |
Second opening time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
46 |
Saturday Open 3 |
D |
5 |
Third opening time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
47 |
Saturday Close 1 |
D |
5 |
First Closing time on Saturday in format hh:mm (in 24hr clock format) |
|
48 |
Saturday Close 2 |
D |
5 |
Second Closing time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
49 |
Saturday Close 3 |
D |
5 |
Third Closing time on Saturday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two Closing times) |
|
50 |
Sunday Open 1 |
D |
5 |
First opening time on Sunday in format hh:mm (in 24hr clock format) |
|
51 |
Sunday Open 2 |
D |
5 |
Second opening time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one opening time) |
|
52 |
Sunday Open 3 |
D |
5 |
Third opening time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one or two opening times) |
|
53 |
Sunday Close 1 |
D |
5 |
First Closing time on Sunday in format hh:mm (in 24hr clock format) |
|
54 |
Sunday Close 2 |
D |
5 |
Second Closing time on Sunday in format hh:mm (in 24hr clock format) (will be blank if office only has one Closing time) |
|
55 |
Sunday Close 3 |
D |
5 |
Third 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 1 |
07:30 |
|
Open 2 |
13:00 |
|
Open 3 |
18:00 |
|
Close 1 |
12:00 |
|
Close 2 |
17:00 |
|
Close 3 |
20:00 |
Or
|
Open 1 |
07:30 |
|
Open 2 |
13:00 |
|
Open 3 |
|
|
Close 1 |
12:00 |
|
Close 2 |
17:00 |
|
Close 3 |
|
Or
|
Open 1 |
07:30 |
|
Open 2 |
|
|
Open 3 |
|
|
Close 1 |
18:00 |
|
Close 2 |
|
|
Close 3 |
Click HERE to see an example of PUDO Location file.
The response is a list of locations with addresses and opening times.
To create a shipping label with Local Collect please:
- use the 'c/o' prefix in the destinationCompanyName together with the Local Collect address
- service enhancement code 22 for Local Collect
- service enhancement code 14 for SMS notification with a valid customer mobile number, so that the end consumer can be notified via SMS when the parcel is ready for collection
Please note: It is not possible to get a Local Collect label without those two service enhancements.
The list of services for which the Local Collect can be used can be found in Royal Mail Service Matrix.
Example label: