6.2 User Record Format

You can synchronize your databases whenever you add, update, or delete users. The User Record format provides a standard comma-delimited text file that allows you to import or export a user list to other enterprise databases.

The user records are stored in /var/iic/cdr/user.elg on the host specified in addressbk_host in the global-config file for the cluster. The file is rotated daily to /var/iic/cdr/user+<timestamp>.log. You might want to place /var/iic/cdr on a network file system to facilitate the retrieval of user records. Otherwise, you can retrieve the call data records by using tools such as ssh/scp.

Importing user record data is handled through the addressbk.update_contact API call, which is described in the External API document. The database service outputs the data in the following table when users are added, updated, or deleted. The following table describes each of the records, their type, and the maximum length allowed:

Table 6-1 User Record Fields

Record

Type

Maximum Length

Record ID

String: <hostname>-<10-digit sequence number>

11 + <max host name length>

Community ID

4-byte non-negative integer

10

User ID

4-byte non-negative integer

10

Event

Integer:

1 = Added

2 = Updated

3 = Deleted

1

Title

String

32

First Name

String

256

Middle Name

String

256

Last Name

String

256

Suffix

String

32

Company

String

256

Job Title

String

256

Address 1

String

256

Address 2

String

256

State

String

256

Country

String

256

Postal Code

String

32

IIC Screen Name

String

256

Email 1

String

256

Email 2

String

256

Email 3

String

256

Business Phone

String

32

Home Phone

String

32

Mobile Phone

String

32

Other Phone

String

32

Extension

String

32

AIM Screen Name

String

128

Yahoo Screen Name

String

128

MSN Screen Name

String

128

User 1

String

128

User 2

String

128

Default Phone

Integer:

0 - None

1 - Business

2 - Home

3 - Mobile

4 - Other

1

Default Email

Integer:

0 - None

1 - Email 1

2 - Email 2

3 - Email 3

1

Type

Integer:

0 - Registered User

1 - Admin

1

Modified Time

String: <YYYY>-<MM>-<DD>-<HH>-<mm>-<SS>

19

NOTE:Updated user records have zeros for Default Phone and Default Email fields. Deleted records have only the following content fields: Record ID, User ID, Event and Modified Time (that is, Deleted Time).