|
Joined: Jan 2018
Posts: 21
Member
|
Member
Joined: Jan 2018
Posts: 21 |
Does anyone have experience in using the smdr function on summit? It generates a ip_address.smdr.gz file. I can unzip the file and open the ip_address.smdr file in excel but it isn't very user friendly... what other methods are used to view this type of file or smdr data? Thank you for the info!
Dave
|
|
|
Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.
|
|
|
Joined: Dec 2007
Posts: 6,807 Likes: 18
Retired Admin
|
Retired Admin
Joined: Dec 2007
Posts: 6,807 Likes: 18 |
Generally speaking most SMDR outputs will look unorganized if you don't have Excel setup properly Special Characters, Columns, Rows with both height and width to match the set parameters that are provided such as:
NO | STA | CO | TIME | START | DIAL/CLI/CPN NUM1 | COST | ACCOUNT CODE | DIAL/CLI/CPN DC NUM II |
It also depends on that you have set up for various field entries, that is COST or ACCOUNT CODE.
NO: SMDR record number, optional output, (PGM 177-Button 23) STA: 3 or 4 digit station number CO: 2 or 3 digit CO Line number TIME: Call duration in minutes and seconds START: Date and time call was placed/received NUM I: Flex Field I, for outgoing call displays dialed number, for incoming call displays Ring duration, CLI or CPN (PGM 177-Button 20) COST: Cost of Call ACCOUNT CODE: Account code entered for call NUM II: Flex Field II for incoming call, displays Ring duration, CLI or CPN orblank, (PGM 177-Button 23) DC: Disconnect Cause, optional output (PGM 177-Button 24-5), with value: 01~7F: Follow cause value of Q.931 specification, 81: Disconnected, toll restricted 84/85: Disconnected, disconnect supervision 0: Other
Someone more familiar with Summit and Excel may have a spreadsheet already built or perhaps direct you where you might obtain one.
|
|
|
|
Joined: Jan 2018
Posts: 21
Member
|
Member
Joined: Jan 2018
Posts: 21 |
Thanks for the response and tips, I found an area on their ftp site called reportplus, I think its software your supposed to use to view smdr data.... so I guess I'll be reading some of that info. Vertical doesnt seem to cover anything but basic things in their training.
|
|
|
|
Joined: Dec 2007
Posts: 6,807 Likes: 18
Retired Admin
|
Retired Admin
Joined: Dec 2007
Posts: 6,807 Likes: 18 |
|
|
|
|
Joined: Aug 2003
Posts: 5,154 Likes: 2
Moderator-Vertical, Vodavi
|
Moderator-Vertical, Vodavi
Joined: Aug 2003
Posts: 5,154 Likes: 2 |
You have to purchase one of the reporting packages (Vertical's or a 3rd parties) or manipulate it with a spreadsheet. You can get a lot of information from it with Excel, it just takes a little time.
|
|
|
Forums84
Topics94,384
Posts639,239
Members49,799
|
Most Online5,661 May 23rd, 2018
|
|
1 members (metelcom),
117
guests, and
36
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|