Westell Technologies IVX S-Class manual CSV Smdr format, Format, Example

Page 36

SMDR	IVX S-Class Administrator’s Manual

CSV SMDR format

The comma-separated value (CSV) format is readable from within Microsoft Excel® and other spreadsheet applications.

Note: The CSV format does not support account codes (see page F.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:

"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.

•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 the example, above). Each record is terminated with a line feed and carriage return character.

F.2

Image 36

Contents Administrator’s Manual About ESI Table of contents This page included for pagination purposes only Administrator programming An introduction Administrator dutiesTelephone system features Voice mail features Call from X102 John JamesFeature Phone overlays Administrator CMDProgramming basics System programming overview System parametersProgramming keys Entering alphanumeric charactersSystem fixed numbering plan Remote setting of day, night, holiday and auto modes Prompts for remote settings an outlineIVX S-Class Administrator’s Manual Function 13 Administrator password Accessing user station programmingFunction 1 System parameters Function 142 Automatic time setting Function 143 Clock adjustmentFunction 14 System clock Function 141 Set time/dateFunction 17 System speed-dial Deleting a speed-dial numberThis page included for pagination purposes only Function 32 Extension feature authorization Function 321 Standard feature authorizationFunction 3 Extension programming Function 322 Advanced extension feature authorization Range 5-15.DefaultFunction 371 Access schedule programming Function 37 Rfid programmingACC SCHED1 Name ACC SCHED1 DAY MondayACC SCHED1 MON ACC SCHED1 MON Allow 900 AMACC SCHED1 MON No Deny Time Function 372 Rfid tag number programming Rfid TAG Prog EXT or MBFunction 373 View Rfid tag number Rfid TAG Display EXTFunction 374 ESI Presence Management parameters EPM Rfid Reader Prompts YESX211 Front Door Volume Function 375 Rfid Reader parametersEPM Reader SET EXT Inserted for pagination purposes only Function 5 Voice mail programming Function 53 Guest/info mailboxesGuest mailboxes Info mailboxesBroadcast mailbox Function 54 Answering Machine members MB501Function 55 Message notification Function 551 Station delivery options Function 552 Delivery/paging parametersFunction 56 Cascade notification mailboxes Cascade mailbox optionsCascade notification parameters This page included for pagination purposes only Function 6 Recording Function 61 Re-record main greetingFunction 62 Record directory names Function 633 MOH volume Function 63 Message-on-hold MOH programmingFunction 631 MOH source Function 632 MOH recordingThis page included for pagination purposes only Smdr Tabular Smdr formatCSV Smdr format FormatExample Reporting conventions and rules PC interfaceSmdr format when using account codes Examples One account code entered during an incoming callIndex SmdrIntegrated Answering Machine, D.2 Message notification, D.3