Security Escort Technical Reference Manual 7.0 Importing a
Subscriber Database
EN 77
Table 1:Importing a Subscriber Database
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Data Fields in |
| Excel |
|
| Restrictions |
|
|
|
|
| ||
| Required Order |
| Column |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Subscriber Name |
| A |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
| ||||||||
| Subscriber ID |
| B |
|
| This | field | can | be | up | to | twelve characters. This field can contain |
|
|
|
|
|
|
| only | ALPHA, numeric and | the dash ASCII characters. |
| ||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Here Phone |
| C |
|
| This | field | can | be | up | to | sixteen characters. This field can contain |
|
| Number |
|
|
|
| only | numeric, “#”, “*”, | “(“, “)”, comma and the dash ASCII |
| ||||
|
|
|
|
|
| ||||||||
|
|
|
|
|
| characters. |
|
|
|
|
|
| |
| Here Address 1 |
| D |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the “?’. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Here Address 2 |
| E |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
| |||||||
| Here City |
| F |
|
| This | field | can | be | up | to | twenty characters. This field can contain |
|
|
|
|
|
|
| any printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Here State |
| G |
|
| This | field | can | be | up | to | three characters. This field can contain |
|
|
|
|
|
|
| only | ALPHA | ASCII characters. |
| ||||
|
|
|
|
|
|
| |||||||
| Here Zip |
| H |
|
| This | field | can | be | up | to | ten characters. This field can contain only |
|
|
|
|
|
|
| ALPHA, numeric | and the dash ASCII characters. |
| |||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Away Phone |
| I |
|
| This | field | can | be | up | to | sixteen characters. This field can contain |
|
| Number |
|
|
|
| only | numeric, “#”, “*”, | “(“, “)”, comma and the dash ASCII |
| ||||
|
|
|
|
|
| ||||||||
|
|
|
|
|
| characters. |
|
|
|
|
|
| |
| Away Address 1 |
| J |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the ‘?’. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Away Address 2 |
| K |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
| |||||||
| Away City |
| L |
|
| This | field | can | be | up | to | twenty characters. This field can contain |
|
|
|
|
|
|
| any printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Away State |
| M |
|
| This | field | can | be | up | to | 3 characters. This field can contain only |
|
|
|
|
|
|
| ALPHA ASCII characters. |
|
| |||||
|
|
|
|
|
|
|
| ||||||
| Away Zip |
| N |
|
| This | field | can | be | up | to | 10 characters. This field can contain only |
|
|
|
|
|
|
| ALPHA, numeric | and the dash ASCII characters. |
| |||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplemental |
| O |
|
| This | field | can | be | up | to | 254 characters. This field can contain any |
|
| Text Field 1 |
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
| ||||||||
| Supplemental |
| P |
|
| This | field | can | be | up | to | 254 characters. This field can contain any |
|
| Text Field 2 |
|
|
|
| printable ASCII character except the ‘?”. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplemental |
| Q |
|
| This | field | can | be | up | to | 254 characters. This field can contain any |
|
| Text Field 3 |
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
| ||||||||
| Supplemental |
| R |
|
| This | field | can | be | up | to | 254 characters. This field can contain any |
|
| Text Field 4 |
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pager Phone |
| S |
|
| This | field | can | be | up | to | 16 characters. This field can contain only |
|
| Number |
|
|
|
| numeric, “#”, “*”, “(“, | “)”, comma and the dash ASCII characters. |
| |||||
|
|
|
|
|
| ||||||||
| Pager Password |
| T |
|
| This | field | can | be | up | to | 6 characters. This field can contain only |
|
|
|
|
|
|
| numeric, and ALPHA ASCII characters. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pager Pager ID |
| U |
|
| This | field | can | be | up | to | 10 characters. This field can contain only |
|
|
|
|
|
|
| numeric ASCII characters. |
| ||||||
|
|
|
|
|
|
| |||||||
| Subscriber Type |
| V |
|
| 0 Unclassified, 1 | Commuter, 2 Faculty, 3 Resident, 4 Security, 5 |
| |||||
|
|
|
|
|
| Staff, 6 Installer, 7 Out of Service, 8 Watchman, 9 Visitor, 10 |
| ||||||
|
|
|
|
|
| Point type, 11 | Acknowledgement. This field should contain only |
| |||||
|
|
|
|
|
| numeric ASCII characters. |
| ||||||
|
|
|
|
|
|
|
|
|
|
| |||
| Handicapped Type |
| W |
|
| 0 No | handicap, | 1 Blind, | 2 Deaf, 3 Handicapped, 4 Wheel chair. This |
| |||
|
|
|
|
|
| field should contain | only numeric ASCII characters. |
| |||||
|
|
|
|
|
|
| |||||||
| Transmitter ID |
| X |
|
| This | field | may | be | up | to | 9 characters. This field should contain only |
|
|
|
|
|
|
| numeric ASCII characters. |
| ||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Away Name |
| Y |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character except the “?”. |
| ||||||
|
|
|
|
|
|
| |||||||
| Image Filename |
| Z |
|
| This | field | can | be | up | to | 30 characters. This field can contain any |
|
|
|
|
|
|
| printable ASCII character that is valid for a file name. |
| ||||||
|
|
|
|
|
|
| |||||||
| Height Feet |
| AA |
| This field should contain only numeric ASCII characters. |
| |||||||
| Height Inches |
| AB |
|
| field should | contain only numeric ASCII characters. |
|