web statisticsweb stats

Business Phone Systems

Previous Thread
Next Thread
Print Thread
Rate Thread
#625579 11/18/18 02:58 PM
Joined: Jan 2018
Posts: 21
Dave Me Offline OP
Member
OP Offline
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

Atcom VoIP Phones
VoIP Demo

Best VoIP Phones Canada


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,800
Likes: 18
Retired Admin
*****
Offline
Retired Admin
*****
Joined: Dec 2007
Posts: 6,800
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.




Dean
Photographs:
https://www.instagram.com/deanwilsoncanby/
https://fstoppers.com/profile/deanwilsoncanby
https://www.facebook.com/Dean-Wilson-Photography-112841337020414

Please don't confuse your "Internet Search" with my licenses, certifications and over 30 years experience.

"Thank you for calling Technical Support. If you feel you have reached this number in error, please hang up and press redial."
Joined: Jan 2018
Posts: 21
Dave Me Offline OP
Member
OP Offline
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,800
Likes: 18
Retired Admin
*****
Offline
Retired Admin
*****
Joined: Dec 2007
Posts: 6,800
Likes: 18
Good to hear...I guess.


Dean
Photographs:
https://www.instagram.com/deanwilsoncanby/
https://fstoppers.com/profile/deanwilsoncanby
https://www.facebook.com/Dean-Wilson-Photography-112841337020414

Please don't confuse your "Internet Search" with my licenses, certifications and over 30 years experience.

"Thank you for calling Technical Support. If you feel you have reached this number in error, please hang up and press redial."
Joined: Aug 2003
Posts: 5,154
Likes: 2
Moderator-Vertical, Vodavi
*****
Offline
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.


Moderated by  EV607797, MnDave, nfcphoneman 

Link Copied to Clipboard
Forum Statistics
Forums84
Topics94,314
Posts638,919
Members49,775
Most Online5,661
May 23rd, 2018
Popular Topics(Views)
213,070 Shoretel
190,283 CTX100 install
188,553 1a2 system
Newest Members
PeterG, lyte, 4thright, dcl, Mansour
49,774 Registered Users
Top Posters(30 Days)
Toner 19
jsaad 5
dans 4
teleco 4
Who's Online Now
0 members (), 125 guests, and 27 robots.
Key: Admin, Global Mod, Mod
Contact Us | Sponsored by Atcom: One of the best VoIP Phone Canada Suppliers for your business telephone system!| Terms of Service

Sundance Communications is not affiliated with any of the above manufacturers. Sundance Phone System Forums - VOIP & Cloud Phone Help
©Copyright Sundance Communications 1998-2024
Powered by UBB.threads™ PHP Forum Software 7.7.5