The copy of the CTPS
data file distributed to Licensees will contain telephone numbers
only; it will not contain name, address or any other information.
1. Full Downloads
For a full data file download, the file can be downloaded in one of two formats:
- spaces separating the National Number
Dial from the remainder of the telephone number
- or with no spaces between the National Number Dial and the remainder of the telephone number
An example of some records in the two formats is shown below:
1.1 With Spaces
Description |
Length |
Format |
National Number Dial |
5 |
Numeric, left justified, with a trailing blank if required. |
Remainder of Telephone Number |
7 |
Numeric, right justified, with a leading blank, if required. |
Record Operator |
2 |
Carriage return/line feed pair. |
This format is illustrated further below:
| Example Number |
Telephone Number National Number Dial |
Telephone Number Remainder |
Record Separator |
0207 3787244 |
0 |
2 |
0 |
7 |
|
3 |
7 |
8 |
7 |
2 |
4 |
4 |
CR |
LF |
01635 506160 |
0 |
1 |
6 |
3 |
5 |
|
5 |
0 |
6 |
1 |
6 |
0 |
CR |
LF |
0191 5657153 |
0 |
1 |
9 |
1 |
|
5 |
6 |
5 |
7 |
1 |
5 |
3 |
CR |
LF |
|
07775 338653 |
0 |
7 |
7 |
7 |
5 |
|
3 |
3 |
8 |
6 |
5 |
3 |
CR |
LF |
Most telephone numbers held on the CTPS data file will be in one of the first two formats. The last example represents a mobile telephone number.
1.2 Without Spaces
This format is similar to the previous one, except that the telephone number has the spaces between the National Number Dial and the remainder of the number have been stripped and have been appended as spaces to the end of the number to keep the length to twelve characters.
|
Description |
Length |
Format |
|
Telephone Number |
Upto 12 |
Numeric, left justified, with a trailing blank if required. |
|
Spaces characters to keep the length of the record to twelve characters if required. |
0 or more |
0 or more spaces |
|
Record Operator |
2 |
Carriage return/line feed pair. |
This format is illustrated further below:
| Example Number |
Telephone Number record |
Record Separator |
|
0207 3787244 |
0 |
2 |
0 |
7 |
3 |
7 |
8 |
7 |
2 |
4 |
4 |
|
CR |
LF |
|
01635 506160 |
0 |
1 |
6 |
3 |
5 |
5 |
0 |
6 |
1 |
6 |
0 |
|
CR |
LF |
0191 5657153 |
0 |
1 |
9 |
1 |
5 |
6 |
5 |
7 |
1 |
5 |
3 |
|
CR |
LF |
07775 338653 |
0 |
7 |
7 |
7 |
5 |
3 |
3 |
8 |
6 |
5 |
3 |
|
CR |
LF |
2. Changes Since
The formats available for the changes since downloads are similar to the options available for the full download except that additions and deletions to each record in the data file is marked with the letter "A" or "D" respectively.
This is shown in the example below:
2.1 With Spaces
Description |
Length |
Format |
National Number Dial |
5 |
Numeric, left justified, with a trailing blank if required. |
Remainder of Telephone Number |
7 |
Numeric, right justified, with a leading blank, if required. |
| Letter to denote update type:
"A" for and addition, "D" for a deleted telephone number. |
1 |
Text |
Record Operator |
2 |
Carriage return/line feed pair. |
This format is illustrated further below:
| Example Number |
Telephone Number National Number Dial |
Telephone Number Remainder |
Update Type |
Record Separator |
|
0207 3787244 |
0 |
2 |
0 |
7 |
|
3 |
7 |
8 |
7 |
2 |
4 |
4 |
A |
CR |
LF |
01635 506160 |
0 |
1 |
6 |
3 |
5 |
|
5 |
0 |
6 |
1 |
6 |
0 |
A |
CR |
LF |
0191 5657153 |
0 |
1 |
9 |
1 |
|
5 |
6 |
5 |
7 |
1 |
5 |
3 |
D |
CR |
LF |
07775 338653 |
0 |
7 |
7 |
7 |
5 |
|
3 |
3 |
8 |
6 |
5 |
3 |
A |
CR |
LF |
2.2 Without Spaces
Again This format is similar to the "Without spaces, Full download", except that that additions and deletions to each record in the data file is marked with the letter "A" or "D" respectively.
|
Description
|
Length
|
Format
|
|
Telephone Number
|
Upto 12
|
Numeric, left justified, with a trailing blank if required.
|
|
Spaces characters to keep the length of the record to twelve
characters if required.
|
0 or more
|
0 or more spaces
|
|
Letter to denote update type:
"A" for and addition, "D" for a deleted telephone number.
|
1
|
Text
|
|
Record Operator
|
2
|
Carriage return/line feed pair.
|
This format is illustrated further below:
| Example Number |
Telephone Number record |
UpdateType |
Record Separator |
|
0207 3787244 |
0 |
2 |
0 |
7 |
3 |
7 |
8 |
7 |
2 |
4 |
4 |
|
A |
CR |
LF |
|
01635 506160 |
0 |
1 |
6 |
3 |
5 |
5 |
0 |
6 |
1 |
6 |
0 |
|
D |
CR |
LF |
|
0191 5657153 |
0 |
1 |
9 |
1 |
5 |
6 |
5 |
7 |
1 |
5 |
3 |
|
D |
CR |
LF |
|
07775 338653 |
0 |
7 |
7 |
7 |
5 |
3 |
3 |
8 |
6 |
5 |
3 |
|
A |
CR |
LF |
3. SFTP Access - For more information: Word Doc - PDF
The full data file can also be downloaded via SFTP. If you have subscribed to receive the full downloads, you can follow the instructions below to download the CTPS data file in compressed or uncompressed format, with or without spaces.
1. SFTP to ftp.tps-online.org.uk and type in your username and password when prompted.
2. You can retrieve the readme.txt document found in your home directory, which will describe the files available for download.
3. The table below describes the full data file files that you can retrieve and their location. (The exact format of each record is identical to relevant format described previously).
|
Subdirectory |
Filename |
Description |
|
\ctps |
ctps.dat |
Full uncompressed cTPS data file, with spaces between the NND and telephone number |
|
ctps.zip |
Full compressed cTPS data file, with spaces between the NND and telephone number |
|
ctps_ns.dat |
Full uncompressed cTPS data file, with no spaces between the NND and telephone number |
|
ctps_ns.zip |
Full compressed cTPS data file, with no spaces between the NND and telephone number |
4. Other formats
These other distribution methods are also available but they are not available through the web site. Contact the CTPS if you need to order these formats.
It is the responsibility of the CTPS licensee to integrate use of the data file into their everyday working practices.
The way in which they choose to do this is entirely up to the licensee and will not be defined by CTPS or its agents. For example,
those sites which have sophisticated automatic telemarketing systems, may well adopt a different strategy to those with a more modest set-up.
We are unable to offer specific advice on suppression software. Should you need any advice please contact your software supplier.
CD-ROM
For full licenses, Acxiom will provide the CTPS telephone numbers in ASCII variable
comma-delimited format in ISO 9660 format. |