|
Technical Specifications for File
Formats
The copy of the TPS database distributed to Subscribers will contain telephone numbers only; it will not contain name, address or any other information.
1. Full Downloads
For a full database download, the file can be downloaded in one of two formats:
- spaces separating the National Dialing Code from the remainder of the telephone number
- or with no spaces between the National Dialing Code 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 Dialing Code |
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 Dialing Code |
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 |
|
07860 338653 |
0 |
7 |
8 |
6 |
0 |
|
3 |
3 |
8 |
6 |
5 |
3 |
CR |
LF |
Most telephone numbers held on the TPS database 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 Dialing Code 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 |
07860 338653 |
0 |
7 |
8 |
6 |
0 |
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 database is marked with the letter "A" or "D" respectively.
This is shown in the example below:
2.1 With Spaces
Description |
Length |
Format |
National Dialing Code |
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 Dialing Code |
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 |
07860 338653 |
0 |
7 |
8 |
6 |
0 |
|
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 database 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 |
|
07860 338653 |
0 |
7 |
8 |
6 |
0 |
3 |
3 |
8 |
6 |
5 |
3 |
|
|
A |
CR |
LF |
3. FTP Access
The full database can also be downloaded via FTP. If you have subscribed to receive the full downloads, you can follow the instructions below to download the TPS database in compressed or uncompressed format, with or without spaces.
1. FTP 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 database files that you can retrieve and their location. (The exact format of each record is identical to relevant format described previously).
|
Subdirectory |
Filename |
Description |
|
\tps |
tps.dat |
Full uncompressed TPS database, with spaces between the NDC and telephone number |
|
tps.zip |
Full compressed TPS database, with spaces between the NDC and telephone number |
|
tps_ns.dat |
Full uncompressed TPS database, with no spaces between the NDC and telephone number |
|
tps_ns.zip |
Full compressed TPS database, with no spaces between the NDC and telephone number |
|
\fps |
fps.dat |
Full uncompressed FPS database, with spaces between the NDC and telephone number |
|
fps.zip |
Full compressed FPS database, with spaces between the NDC and telephone number |
|
fps_ns.dat |
Full uncompressed FPS database, with no spaces between the NDC and telephone number |
|
fps_ns.zip |
Full compressed FPS database, with no spaces between the NDC and telephone number |
4. Other formats
The TPS database can be distributed to subscribers in one of the following ways.
- Website Download
- CD Rom (For full files only)
- IBM Cartridge
- Paper (Hard Copy)
In each case, it is the responsibility of the TPS subscriber to integrate use of the database into their
everyday working practices. The way in which they choose to do this is entirely up to the subscriber and will
not be defined by TPS 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.
Website Download
Please visit the web page at www.tpsonline.org.uk where you will be able
to complete the application forms online. Upon receipt of payment you will then be provided with a password
and login and have the option to receive the full data file compressed or uncompressed, or selection by NND codes,
the percentage will be provided on the web page. You will also be able to select to receive the TPS Data File
regularly via email.
CD-ROM
For full files, Acxiom will provide the TPS telephone numbers in ASCII variable comma-delimited format in ISO 9660 format.
IBM Cartridge
Cartridge is supplied on standard 18-track non-IDRC (3480 compatible) cartridges containing EBCDIC-encoded
telephone numbers. Current estimates suggest that the entire file will occupy one such file.
Hardcopy
Paper-based output may be requested by very small or non-computerised telemarketing companies. To keep the
volume of paper to a minimum, and because small telemarketing companies often undertake very regional activity,
those Subscribers who receive data on paper may define a geographical sub-set of the file which they wish to receive.
Subscribers should supply TPS with a list of National Number Dial (NND) codes when applying for a licence or they
can request one or more counties. |