ESI IVX X-Class User's Guide download pdf (Page 42)

Feature description: SMDR IVX X-Class Administrator’s Manual

G.2

CSV SMDR format

The comma-separated value (CSV) format is readable from within Microsoft Excel

and other spread-

sheet applications.

Note: The CSV format does not support account codes (see page G.4).

A CSV record is output for each completed call, and represented as follows (word-wrapped):

Format:

"T","MMDDYYYY","HHMMSS","HHMMSS","NNN","XXXXXXXXXX. . .XXX","CCCCCCCCCC. . .CCC","LL"

Example A (with Esi-Link):

"I","07042002","000852","000059","101","2144229700","ESTECH SYS INC. ","01","04","54"

Example B (no Esi-Link):

"O","10312003","221502","020512","190","12125551212",""," "," ","11"

The fields are:

• Call type (“T”) — Outbound (“O”), inbound (“I”) or transferred (“T”).

• Start date (“MMDDYYYY”) — Eight characters, zero-filled.

• Start time (“HHMMSS”) — Six characters, zero-filled; 24 hour clock.

• Duration (“HHMMSS”) — Six characters, zero-filled.

• Extension number (“NNN”) — Four characters, space-filled, right-justified.

• Digits dialed/Caller ID (“XXXXXXXX . . . XXX”) — Up to 28 characters, null-filled.

• Caller ID name (“CCCCCCCCC . . . CCC”) — Up to 24 characters, null-filled.

• Esi-Link home location number (“EE”)

— Two characters (two-digit suffix).

• Esi-Link remote location number (“RR”)

— Two characters, null-filled (two-digit suffix).

• Line number (“LL”) — Three characters, null-filled, right-justified.

Each field is delimited with double quote marks and separated with a single comma. Null fields are still

included as place holders (as shown in Example B, above). Each record is terminated with a line feed

and carriage return character.

Used only when Esi-Link is enabled and programmed. Esi-Link SMDR records are generated at only the home location.

1 2 ... 37 38 39 40 41 42 43 44 45 46

No comments

ESI IVX X-Class User's Guide Page 42