My Phone Techs

Computers & Internet => Computers, Software & Accessories => Topic started by: bmreen on May 09, 2011, 10:48:39 AM

Title: SMDR IP collector
Post by: bmreen on May 09, 2011, 10:48:39 AM
I don't know where this subject belong so I will start here. I need to know what y'all are doing with customers that have Call Accounting software that does not have its own IP collector. I have a couple of lawyers that use Equitrac software and they can only collect SMDR via serial or file. Well the systems we are dealing with today do not all have serial interfaces on them any more. I have been trying to use PuTTY on them with a script my IT guy has wrote for it, but it seem to be giving use a lot of problems running the batch file and executing the process efficiently. Has anybody run in to this yet, and if you have what did you do to collect the SMDR via IP and submit the file for the Call Accounting software?
Title: Re: SMDR IP collector
Post by: CMDL_GUY on May 09, 2011, 11:08:07 AM
Try using PABXSoft.  I have a contact there if you want it.
Title: Re: SMDR IP collector
Post by: bmreen on May 09, 2011, 07:46:05 PM
We are not looking to replace the Call accounting software as the same program tracks their copies,postage,calls and matereal on a per client basis. They just don't have an SMDR IP collector module with their software. All we have to do is provide a ASCII file every night so they can import the SMDR from.
Title: Re: SMDR IP collector
Post by: MacGyver on May 10, 2011, 10:32:05 AM
Bobby I don't know if this would work for your situation, but about a year ago we were troubleshooting a problem at a remote site and needed to monitor the SMDR locally.  Fortunately all our client sites are connected to us by VPN.  We simply had the computer that was connected to the cabinet write the SMDR log to a shared folder on one of our machines here by static IP.  Another option that comes to mind would be using the Scheduled Tasks Manager to run a bat file every night, and have the bat file copy the SMDR text file to the location where they do the ASCII import.

Added:  After writing this I realized I may have misunderstood your original post.  Obviously if you have no machine connected to the cabinet, and were looking for an IP interface from the cabinet to go directly across the LAN this wouldn't really fit your application.
Title: Re: SMDR IP collector
Post by: bmreen on May 10, 2011, 09:00:03 PM
We do currently have a pc connected to the system collecting the SMDR with PuTTY and have a batch file in the Scheduled Task to run at XX:XX time everynight. And thats the problem is that the batch does not run smoothly or efficiently. Some times Putty doesn't shutdown all the way before it tries to restart it or the batch can not find PuTTY.exe to kill it to allow the file to be copied. Its just all sorts of problems. Here is a copy of the batch file that I am running if anybody sees anything different I can do to it let me know. PLEASE.


@echo off
rem Alternative Communications SMDR capture process Bobby Mreen

rem Kill Putty Process
rem Note: Do Not Force Kill Process
taskkill /IM PUTTY.EXE /IM PuTTYPortable.exe

copy "C:\Alternative Communications\PuTTYPortable\Logs\putty.log" "C:\Alternative Communications\PuTTYPortable\Logs\current smdr_log.txt"


rem Restart Capture Process
"C:\Alternative Communications\PuTTYPortable\PuTTYPortable.exe" @smdr





   
Title: Re: SMDR IP collector
Post by: Kumba on May 11, 2011, 01:24:14 PM
So all you need to do, is take the SMDR output from the IP of the phone system, and send it out the serial port?

Sounds like about 10 lines in PERL. You can even install ActivePERL on windows so you don't need a whole separate machine. I would imagine a programmer could knock it out in an hour or two unless it's not as simple as forwarding the messages from Point A to Point B.
Title: Re: SMDR IP collector
Post by: bmreen on May 11, 2011, 03:00:41 PM
All I need to do is capture SMDR via IP and supply a text file for Equitrac to import it. I just need some way to do it automatically every night consistently.
Title: Re: SMDR IP collector
Post by: MacGyver on May 11, 2011, 08:09:34 PM
I would imagine a programmer could knock it out in an hour or two unless it's not as simple as forwarding the messages from Point A to Point B.


If you go that route I can recommend http://www.scriptlance.com/

You post what you want and programmers bid on the project.  Last time I did it the first bid was about $500.  By the next morning when I checked in I had a message saying "I've already written this for you" with a link to where I could download it.  He asked for $50 and I sent him $100.  It was well worth it.
Title: Re: SMDR IP collector
Post by: Kumba on May 12, 2011, 08:51:56 PM
As simple as the program is you really don't need a strong programmer. Just make sure you can tell them it need a config file where you tell it the IP and port to connect to, and then a file to store the dump to. If you find a VB programmer the better as that's native winders.
Title: Re: SMDR IP collector
Post by: matherton on May 28, 2011, 12:26:18 AM
What about http://www.lantronix.com/device-networking/external-device-servers/mss100.html (http://www.lantronix.com/device-networking/external-device-servers/mss100.html).  I use these handy little devices to give me full remote access to SVMI-4e voicemails over IP (and access to the serial port on SVMI-20e over IP remotely).  Point your IP SMDR packets to this little device, it should convert it to serial to send to your existing smdr box.

I find them on ebay for about 60$ usually...
Title: Re: SMDR IP collector
Post by: MacGyver on July 14, 2015, 03:40:44 PM
I saw some activity in this thread earlier and thought I'd update it.

I had been playing with the idea of creating COM Port redirector to open a virtual COM Port session that would map to an IP.  Fortunately it seems to be an easy fix.

Stacey fought this battle on an install a couple of weeks ago, and the call accounting software company assured her that the Ethernet to Serial adapters worked well.  If fact they even had one in use in their own office.  We're about to start battling this as the demise of Inter-Tel has us moving some clients over to the NEC.
Title: Re: SMDR IP collector
Post by: ttech on July 14, 2015, 04:40:51 PM
We use the ipocket for smdr and PMS.  Ip from the phone system, Serial to the computer.
Title: Re: SMDR IP collector
Post by: MacGyver on July 14, 2015, 05:05:24 PM
We use the ipocket for smdr and PMS.  Ip from the phone system, Serial to the computer.


Don, when you said iPocket my mind went to the other "iPocket."

Are there any issues or is it seamless?

Also where are you sourcing them?

I assume this is the one you're referencing:

http://www.precidia.com/products/ipocket_232/

(http://www.precidia.com/wp-content/uploads/2012/10/front_back-copy.jpg)

(http://www.precidia.com/wp-content/uploads/2012/07/ipocket_lg.gif)
Title: Re: SMDR IP collector
Post by: CMDL_GUY on July 14, 2015, 05:36:15 PM
We use the ipocket for smdr and PMS.  Ip from the phone system, Serial to the computer.

This is what Mitel uses for their hotel/motel interface.
Title: Re: SMDR IP collector
Post by: Keighlar on July 14, 2015, 06:53:27 PM
This is what Mitel uses for their hotel/motel interface.

This is the application we needed a converter for also.  The SL1100 only outputs IP, but the existing Hotel/Motel software interfaced via serial.
Title: Re: SMDR IP collector
Post by: MacGyver on July 14, 2015, 07:23:54 PM
Larry is it seamless or are there challenges? 
Title: Re: SMDR IP collector
Post by: ttech on July 15, 2015, 07:12:51 PM
I Pocket is seamless programs with hyperterminal

here is a screenshot of a PMS i have on an NEC

(http://i2.photobucket.com/albums/y24/donbaker/ipocket.jpg)
Title: Re: SMDR IP collector
Post by: MacGyver on July 15, 2015, 07:17:35 PM
That's awesome Don.  Thank you for the information.  That's going to solve a real issue on an upcoming job. :054:
Title: Re: SMDR IP collector
Post by: CMDL_GUY on July 15, 2015, 08:40:07 PM
Larry is it seamless or are there challenges? 

I don't know how I missed this!

What Don said!   :066:
Title: Re: SMDR IP collector
Post by: silversam on July 16, 2015, 02:08:48 PM
Looks like a snazzy little gadget! Back in the day I did a HUGE amount of work connecting Serial Devices. (Especially capture and storage) When everything went IP I thought for sure all that work had to go away.

Sam
Title: Re: SMDR IP collector
Post by: ttech on July 16, 2015, 06:27:43 PM
There is also a virtual serial port to IP if you google it. 
Title: Re: SMDR IP collector
Post by: MacGyver on July 17, 2015, 10:08:09 AM
There is also a virtual serial port to IP if you google it. 

That may be the same thing I was considering when I mentioned a COM Port redirector which I believe is more of a Linux term.  This may be a more stable option though.  I've never gone the virtual route, but was considering it.