SMDR Manipulation

[bpafc]

Hi guys,

Not sure if this is possible but I cant think of a better place to ask than Tek-Tips

We recently installed a telephone system into a resort of timeshare apartments and one of the stipulations was that it had to integrate with the existing front of house software. Upon speaking with the software house we found out that the software used an interface that was in relation to the LG GDK (our system is an LG eMG80 so is a newer derivative and we hoped would be a breeze to workaround). The software house are unable to work with our output as they say it is missing information - we are unable to replicate this output via our system settings and we are exploring alternatives.

The 1st 3 or 4 columns are an exact match and at the end of the day these are all the software should need to bill calls (extension, CLI, time etc)

What I am trying to find out is:

Can we spit our SMDR to a bat file or something that can then append each line with the missing information and output it again to telnet?

Any help suggestions greatly received

 

[IPGuru]

it would certainly be technically possible to write a program to read the smdr from the PBX modify it & then output it again.
You are not going to do it with a simple bat file though, you are going to need a programmer of some sort to create this for you


A Maintenance contract is essential, not a Luxury.
Do things on the cheap & it will cost you dear

 

[lopes1211]

Not sure what you're trying to "append" if you only need the 1st 4 columns which are already valid. Maybe have the smdr software save a daily txt file to x:\RAWDATA\daily.txt, then have a script read the 1st 4 columns of that file at 12:45am and save into a new file x:\PROCESSED-DATA\daily.txt. Then have the rental software pull the file at 1am from the x:\PROCESSED-DATA\daily.txt. It doesn't sound like it would be too hard to find something to "throw away" columns 5+.

-CL