contact
support
Download
order
news
AGG Software Forums
September 08, 2024, 03:57:38 AM
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: Welcome on our forum!
Home
Help
Search
Login
Register
AGG Software Forums
>
Online Help Center
>
Data loggers and plug-ins
>
Avaya IP Office Data Parser
Pages: [
1
]
2
« previous
next »
Print
Author
Topic: Avaya IP Office Data Parser (Read 110273 times)
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Avaya IP Office Data Parser
«
on:
April 21, 2009, 07:42:35 PM »
I am currently trying to implement an SMDR logging solution, I have been evaluating your product, i have managed to configure it to import the SMDR data into a SQL DB in real time, which is exactly what we are looking for, however, the only fields imported were:
CALL_TIME, CALL_DURATION, CALL_DURATION_S, RING, CALLER_PHONE, CALL_TYPE, DIALLED_PHONE, ACC
The fields that are available in the SMDR on an Avaya IP office are:
Call_Start, Call_Duration, Ring_Duration, Caller_Direction, Dialled_number, Dialled_number, Account_Is_Internal, Call_ID_Continuation, Party1_Device, Party1_Name, Party2_Device, Party2_Name, Hold_Time, Park_Time, AuthValid, AuthCode, User_Charged, Call_Charge,
Currency, Amount_at_Last_User_Change, Call_Units, Units_at_Last_User_Change, Cost_per_Unit, MarkUp
Is there any plans to modify the Avaya IP Office Parser to cater for the other fields presented in the SMDR?
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #1 on:
April 21, 2009, 09:08:28 PM »
Simply attach a file with your data example with description of columns within the file and we'll prepare the parser for you. Because your PBX is freely configurable, then attach fields configuration from your PBX too.
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #2 on:
April 22, 2009, 11:06:17 AM »
Thanks for the reply, my data file is attached.
Here is the script i used to create the table:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PBXDATA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PBXDATA]
GO
CREATE TABLE [dbo].[PBXDATA] (
[ID] [decimal](10, 0) IDENTITY (1, 1) NOT NULL,
Call_Start [datetime] NULL ,
Call_Duration [datetime] NULL ,
Ring_Duration [nvarchar] (40) NULL ,
Caller_Direction [nvarchar] (40) NULL ,
Dialled_number [nvarchar] (40) NULL ,
Dialled_number1 [nvarchar] (40) NULL ,
Account_Is_Internal [nvarchar] (40) NULL ,
Call_ID_Continuation [nvarchar] (40) NULL ,
Party1_Device [nvarchar] (40) NULL ,
Party1_Name [nvarchar] (40) NULL ,
Party2_Device [nvarchar] (40) NULL ,
Party2_Name [nvarchar] (40) NULL ,
Hold_Time [nvarchar] (40) NULL ,
Park_Time [nvarchar] (40) NULL ,
AuthValid [nvarchar] (40) NULL ,
AuthCode [nvarchar] (40) NULL ,
User_Charged [nvarchar] (40) NULL ,
Call_Charge [nvarchar] (40) NULL ,
Currency [nvarchar] (40) NULL ,
Amount_at_Last_User_Change [nvarchar] (40) NULL ,
Call_Units [nvarchar] (40) NULL ,
Units_at_Last_User_Change [nvarchar] (40) NULL ,
Cost_per_Unit [nvarchar] (40) NULL ,
MarkUp [nvarchar] (40) NULL,
) ON [PRIMARY]
GO
Please let me know if you need any more information from me?
THANK YOU!
PBX_Data.zip
(0.42 KB - downloaded 4 times.)
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #3 on:
April 24, 2009, 11:04:08 AM »
Hi there,
When do you think you will be able to look into this parser issue for me?
thanks
Andrew
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #4 on:
April 27, 2009, 01:43:47 PM »
If we can get this sorted i am 99% certain we will be buying your software, can you please give me some indication on this issue?
many thanks
Andrew
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #5 on:
April 30, 2009, 08:55:40 AM »
Andrew, I'm sorry for my late reply. Please, use the settings from the attached image and capture the data to a binary log file. Did you create the previous file with help of our data export plug-in?
s1.jpg
(39.72 KB, 468x456 - viewed 29 times.)
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #6 on:
April 30, 2009, 10:40:46 AM »
That's the SMDR file that the phone switch creates.
I have the logs created already, i have attached one for you now.
223.1.1.120_10000-log20090430.txt
(0.98 KB - downloaded 12 times.)
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #7 on:
April 30, 2009, 12:58:16 PM »
Please, unpack the attached file to Program folder\Plugins\pbxparser\Configs and replace the original file with new one. We've added parser items for all columns. You can bind it to your database table columns within the data export plug-in. Please, let me know about results.
Avaya IP Office Phone [CSV].zip
(1.41 KB - downloaded 11 times.)
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #8 on:
April 30, 2009, 01:42:17 PM »
Arthur,
Thanks for this, i started to bind to the database, but it appears the Parser does not have all the fields.
I came across these three before i stopped looking at it:
Call_Start, Calller_Direction, Dialled_Number
Is the parser you complied incomplete as to the Fields i listed in my DB Table?
thank you for your help...
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #9 on:
April 30, 2009, 01:54:50 PM »
These columns are mapped to standard columns of our software:
Call_Start to CALL_TIME
Calller_Direction to CALL_TYPE
Dialled_Number to DIALED_PHONE
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #10 on:
April 30, 2009, 02:04:00 PM »
Arhtur, would you be soo kind as to show me the translations for all the elements in the Parser to the titles i have used in my DB similar to your last post, but to cover all items?
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #11 on:
April 30, 2009, 02:18:22 PM »
Have some errors also:
30/04/09 12:16:09
30/04/09 12:16:09 Avaya IP Office Phone [CSV]. Item: CALL_UNITS. Error occurred while converting string value "" to "Integer" data type ('' is not a valid integer value)
30/04/09 12:16:09 Avaya IP Office Phone [CSV]. Item: LAST_UNITS. Error occurred while converting string value "" to "Integer" data type ('' is not a valid integer value)
30/04/09 12:16:09 pbxlogger. Unable to write to database [[Microsoft][ODBC SQL Server Driver]Invalid precision value]
30/04/09 12:16:09
30/04/09 12:16:10 pbxlogger. Unable to write to database [[Microsoft][ODBC SQL Server Driver]Invalid precision value]
30/04/09 12:16:10
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #12 on:
April 30, 2009, 02:23:05 PM »
Most fields have same item name and description (item name is in uppercase), except
Call_Start - CALL_TIME
Ring duration - RING
Caller - CALLER_PHONE
Direction - CALL_TYPE
Called_number - CALLED_PHONE
Dialled_Number - DIALED_PHONE
Is_Internal - FLAG1
Call ID - CALL_ID
Continuation - FLAG2
AuthValid - FLAG3
P.S. The updated version is attached. The data type for CALL_UNITS, LAST_UNITS has been changed to "string".
Avaya IP Office Phone [CSV].zip
(1.4 KB - downloaded 9 times.)
«
Last Edit: April 30, 2009, 02:24:40 PM by Arthur Grasin
»
Logged
AndrewParker
Jr. Member
Karma: +0/-0
Posts: 17
Re: Avaya IP Office Data Parser
«
Reply #13 on:
April 30, 2009, 02:48:18 PM »
Thanks again.
Error i get now is:
30/04/09 12:47:47 pbxlogger. Unable to write to database [[Microsoft][ODBC SQL Server Driver]Invalid precision value]
30/04/09 12:47:47
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: Avaya IP Office Data Parser
«
Reply #14 on:
April 30, 2009, 07:40:45 PM »
I'll try to create a table with your structure and test it with your data. Could you create a backup copy of your current configuration from the File menu and attach it?
Logged
Pages: [
1
]
2
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
News & Feedbacks
-----------------------------
=> News and Updates
=> Site Comments
-----------------------------
Online Help Center
-----------------------------
=> Advanced Serial Port Monitor
=> Data loggers and plug-ins
=> Data loggers ActiveX
=> Advanced USB Port Monitor
=> Virtual Null Modem
=> Software for DNC and CNC
=> Other questions
-----------------------------
Development
-----------------------------
=> Feature Requests
Loading...