IPO Release 6.0 SMDR work around? 4

[fedphone]

In prior releases - we used Delta server to generate CSV files for clients to look at call data. Pretty basic - worked great - R6 - Delta server is gone and support says clients need to purchase call accounting to capture that same data

Does anyone know of a basic app (maybe an Access DB app) that will do the same thing that might be cheap to do the same thing? call accounting is overkill for what we need which can be handled with a spreadsheet....

Anyone got a solution?

 

[amriddle01]

You could use the following, it's written for multiple sites but can obviously be used for only one, all credit goes to Intigrant :

There is a free alternative for that when you do not need Billing software and if you dont have a available PC on each location.

You can use NC.EXE for this purpose.
This can be found here :

http://www.softlookup.com/display.asp?id=25576

In IP Office 4.1+ > System > CDR/SMDR you enable SMDR fill in the IP Address of the receiving PC and enter a port number, each location must have a different (free) port number.

Copy nc.exe to the harddisk of the PC and make a dos batch file for each location like this:
( save the bold contents as "SMDR_sitex.bat" )

FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
md C:\Avaya\SMDR\SiteName
c:\nc.exe -l -p 8881 >> C:\Avaya\SMDR\SiteName\%mm%_smdr.txt &

8881 is the port number!


create a batch file for each location.
Open the Windows TASK manager and schedule the batch files to run daily at 00:01 hour and let the task run for 24 hours.
There will be a SMDR file for each day named "01-12-2009_smdr.txt" were 01-12-2009 will be the date the file was created.



ACSS (SME)
APSS (SME)

http://www.ipoffice.tel

 

[intrigrant]

Thanks for the credits, i am writing a program which collects and store the data in a mssql database.
No fancy things, just a service collecting data from one or more sites.
Once finished i may share it or sell it for a few bucks depends on the interest for it.

 

[amriddle01]

Sounds good, not quite sure why they deliberately crippled Delta server TBH

ACSS (SME)
APSS (SME)

http://www.ipoffice.tel

 

[intrigrant]

The Delta Server connection is very unsecure and with emulating the Delta Server with software you can access allmost all resources in IP Office, so basically you could setup long distance calls with the emulating software.

The same thing about Phone Manager, these connections are also very unsecure and can easily be hacked although these connections are linked to users and not that easy to use for toll fraud.

I have done both just for the fun of it but it did made me think about it when i found how easy it is.
The new CCR and One-x Portal connections are a lot safer.

 

[Albus]

Why not use MV-CDR?
It's a free tool from avaya support site.

You can use it to collect CDR data from IPO and CM and save it in a file. It even supports multiple sites.

 

[amriddle01]

Does it work with SMDR though, CDR isn't available anymore

ACSS (SME)
APSS (SME)

http://www.ipoffice.tel

 

[intrigrant]

Doesn't work, i tried.

 

[Albus]

Do we talk about the same?
Before we had delta server and get a text file on the server. This was SMDR. Now with 6.0 we have to use System|CDR to enable SMDR output. The format is the same. MV-CDR can receive this an write it into a file.
It's free, it runs as a service, and it works.

 

[fedphone]

Albus.... previous posts say that MV-CDR doesnt work with IP Office ... do you have this working? where do i find MV-CDR...? I got a guy that wont pay me til i get SMDR into a file

 

[mforrence]

If MV-CDR doesn't work - go to aggsoft.com and download their PBX logger. It costs $80 +/- but will work right off the bat. On the other hand, I'd be interested in MV-CDR also if it works and is free. A link to the software would be appreciated - I couldn't find it on the support site.
Cheers!
Mike

 

[intrigrant]

http://support.avaya.com/css/appman...ownloads/P1098/10.0.x/C2009071016424840875797

 

[Albus]

fedphone,

I have it installed here and it's working.
The tool can do a lot more then just receive data and write it to a file. But I think this part is either complicated to setup or only for ACM.
It is OK as a simple replacement for Delta Server.

 

[fedphone]

YES - Advanced PBX Logger works from aggsoft.com - $50 - pretty simple install although i had to get a little help from my data guy. Solved my issue and got me paid

Thanks

 

[mforrence]

So, I solved the problem, yet no star? What's up with that?

Cheers!
Mike

 

[amriddle01]

Clearly nobody likes you Mike

ACSS (SME)
APSS (SME)

http://www.ipoffice.tel

 

[fedphone]

what the hell is a star?

And clearly amriddle - you have too much time on your hands

 

[fedphone]

ok - i gave him a star

 

[TomMills]

And clearly amriddle - you have too much time on your hands "

bit of a harsh statement to make about one of the most helpful people on here.

http://www.twitter.com/tem1985

ACSS-SME
fo shizzle ma nizzle.

 

[amriddle01]

He's right though

ACSS (SME)
APSS (SME)

http://www.ipoffice.tel