Business Phone Systems

Previous Thread
Next Thread
Print Thread
Rate Thread
#625579 11/18/18 06: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 Demo
VoIP Demo
Joined: Dec 2007
Posts: 6,750
Likes: 10
Retired Admin
*****
Offline
Retired Admin
*****
Joined: Dec 2007
Posts: 6,750
Likes: 10
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,750
Likes: 10
Retired Admin
*****
Offline
Retired Admin
*****
Joined: Dec 2007
Posts: 6,750
Likes: 10
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,148
Moderator-Vertical, Vodavi
*****
Offline
Moderator-Vertical, Vodavi
*****
Joined: Aug 2003
Posts: 5,148
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
Topics93,832
Posts636,788
Members49,649
Most Online5,661
May 23rd, 2018
Popular Topics(Views)
Today's Birthdays
AWhite, jnimmick, MarkTPN
Newest Members
Lazlo, devben, bubblegum, Carl Arnold, Marjan Shaw
49,649 Registered Users
Top Posters(30 Days)
ramo 13
pvj 11
Toner 9
Who's Online Now
0 members (), 34 guests, and 38 robots.
Key: Admin, Global Mod, Mod
Contact Us | Sponsored by Atcom: Business Phone Systems | Terms of Service

Sundance Communications is not affiliated with any of the above manufacturers.
©Copyright Sundance Communications 1998-2023
Powered by UBB.threads™ PHP Forum Software 7.7.5