Parsing and processing data from Avaya CM3.x PBX

[ashok]

As specified in the tutorial "Parsing and processing data from PBX " I am not able to convert date time to the required format.

[ashok]

I have followed the exactly as per the example specified in the tutorial only difference is I have used Advance TCP IP data logger instead of serial data logger Please sugguest ASAP

[Arthur Grasin]

Please, attach a backup copy of your configuration (you may create it with help of File menu) and your data example within a file (you may create the file with help of our software too) and I'll verify your settings. Then I'll suggest something.

[ashok]

i have got the license for the latest version. could u please suggest

[ashok]

i identified the mistake. Date & time is working thanks

[Arthur Grasin]

I'm sorry for my late reply. Weekend.

Could you post your settings for the parser for other users?

[ashok]

There was a mistake from my end where in the data format for date was specified was incorrect (DDMMYY) instead of MMDDYY.

Now i need your help in translating string hmmss to duration

Attached is the data & backup of configuration in txt format

[Arthur Grasin]

You need to specify the "Time" data type for the "Time" field and specify the "nn:ss" time format (w/o quotes) on the "Data format" tab. Why are you using Advanced TCP/IP Data Logger nstead of our PBX logger? The PBX logger already contains the configured parser for Avaya.

[ashok]

Actually when i changed the time format as specified by u which works fine for data which is related to time field. But i am looking for field called duration which is actually the talk time of the call
Example: talk time of an outbound / inbound call was 0min 15sec raw data which will be printed is 00015
which is in HMMSS. if i specfy the format given by you, application will translate to 12:01:05.

Please suggest.

I am not using PBX logger as this application has default/standard avaya parser. I am using custom Avaya CDR parameters

[Arthur Grasin]

You may extract the call date and time to one fields with the "datetime" type and use the corresponding format option. In this case, for the duration you may use the "Time" format option.