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:
RM | Royal Mail |
LC | Local Collect |
YYY | 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/refence | 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 |
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.
Updated about 1 month ago