new Version R16.1

[ghost]

Hello and thanks for reading,

i use Avaya CMS 16.1 and yml version16.yml don't work, in manual of this version i see other struct, someone have this new version Ex: version16.1.yml ???

again thanks for reading

[bklang]

The documentation on this variant of ECHI appears to be here: http://downloads.avaya.com/css/P8/documents/100089905

If you are interested in copying the existing version16.yml and modifying it to match 16.1, I would be happy to include it in the next release. It should be a relatively small change from Version 16, though I have not yet read closely to determine the differences.

[ghost]

Thanks dude, your support is very important, created under the new version based on the book you said, actually there were some changes and I still can not identify where I'm wrong:

[ghost]

ECH File construct, order is important, as the application sequentially reads the file Source: http://downloads.avaya.com/css/P8/documents/100089905 Version 16.1 echi_records:

• name: callid type: int length: 4
• name: acwtime type: int length: 4
• name: onholdtime type: int length: 4
• name: consulttime type: int length: 4
• name: disptime type: int length: 4
• name: duration type: int length: 4
• name: segstart type: datetime length: 4
• name: segstart_utc type: datetime length: 4
• name: segstop type: datetime length: 4
• name: segstop_utc type: datetime length: 2
• name: talktime type: int length: 4
• name: netintime type: int length: 4
• name: origholdtime type: int length: 4
• name: queuetime type: int length: 4
• name: ringtime type: int length: 4
• name: dispivector type: int length: 2
• name: dispsplit type: int length: 2
• name: firstivector type: int length: 2
• name: split1 type: int length: 2
• name: split2 type: int length: 2
• name: split3 type: int length: 2
• name: trunkgroup type: int length: 2
• name: tklocid type: int length: 2
• name: origlocid type: int length: 2
• name: answerlocid type: int length: 2
• name: obslocid type: int length: 2
• name: uuilen type: int length: 2
• name: assist type: bool length: 1
• name: audiodifficulty type: bool length: 1
• name: conference type: bool length: 1
• name: daqueued type: bool length: 1
• name: holdabn type: bool length: 1
• name: malicious type: bool length: 1
• name: observingcall type: bool length: 1
• name: transferred type: bool length: 1
• name: agentreleased type: bool length: 1
• name: acdnum type: int length: 1
• name: calldisp type: int length: 1
• name: disppriority type: int length: 1
• name: holds type: int length: 1
• name: segment type: int length: 1
• name: ansreason type: int length: 1
• name: origreason type: int length: 1
• name: dispsklevel type: int length: 1
• name: events0 type: int length: 1
• name: events1 type: int length: 1
• name: events2 type: int length: 1
• name: events3 type: int length: 1
• name: events4 type: int length: 1
• name: events5 type: int length: 1
• name: events6 type: int length: 1
• name: events7 type: int length: 1
• name: events8 type: int length: 1
• name: ucid type: int length: 21
• name: dispvdn type: int length: 16
• name: eqloc type: int length: 10
• name: firstvdn type: int length: 16
• name: origlogid type: int length: 16
• name: anslogid type: int length: 16
• name: lastobserver type: int length: 16
• name: dialednumber type: int length: 25
• name: callingparty type: int length: 25
• name: collectdigits type: int length: 17
• name: cwcdigits type: int length: 17
• name: callingII type: int length: 3
• name: cwcs0 type: int length: 17
• name: cwcs1 type: int length: 17
• name: cwcs2 type: int length: 17
• name: cwcs3 type: int length: 17
• name: cwcs4 type: int length: 17
• name: vdn2 type: int length: 16
• name: vdn3 type: int length: 16
• name: vdn4 type: int length: 16
• name: vdn5 type: int length: 16
• name: vdn6 type: int length: 16
• name: vdn7 type: int length: 16
• name: vdn8 type: int length: 16
• name: vdn9 type: int length: 16
• name: asaiuui type: int length: 97
• name: interruptdel type: int length: 1
• name: agentsurplus type: int length: 1
• name: agentskilllevel type: int length: 1
• name: prefskilllevel type: int length: 1
• name: padding type: string length: 45

ACD table definition derived from acd.dat

echi_acds:

• name: acd_id type: str length: 255
• name: acd_number type: str length: 255
• name: name type: str length: 255

Agents table definition derived from agname.dat

echi_agents:

• name: group_id type: str length: 255
• name: login_id type: str length: 255
• name: name type: str length: 255

Aux Reasons table definition derived from aux_rsn.dat

echi_reasons:

• name: group_id type: str length: 255
• name: aux_reason type: str length: 255
• name: name type: str length: 255

CWC definition derived from cwc.dat

echi_cwcs:

• name: group_id type: str length: 255
• name: cwc type: str length: 255
• name: name type: str length: 255

Split table definition derived from split.dat

echi_splits:

• name: acd_number type: str length: 255
• name: split_number type: str length: 255
• name: name type: str length: 255

Trunk Group table definition derived from tkgrp.dat

echi_trunks:

• name: acd_number type: str length: 255
• name: trunk_group type: str length: 255
• name: name type: str length: 255

VDN definition derived from vdn.dat

echi_vdns:

• name: group_id type: str length: 255
• name: vdn type: str length: 255

• name: name type: str length: 255

  Vector definition derived from vector.dat

  echi_vectors:

• name: acd_number type: str length: 255
• name: vector_number type: str length: 255
• name: name type: str length: 255

[ghost]

have any idea ?

[ghost]

And This is error:

Wed Apr 04 16:24:09 -0300 2012 (396) Initialized the database Wed Apr 04 16:24:09 -0300 2012 (396) ECHI-Converter daemon started with these settings:

Wed Apr 04 16:24:09 -0300 2012 (396) get_ftp_files method Wed Apr 04 16:24:09 -0300 2012 (396) Successfully connected to the ECHI FTP server Wed Apr 04 16:24:09 -0300 2012 (396) Using a single ftp session to fetch the files Wed Apr 04 16:24:09 -0300 2012 (396) Successfully connected to the ECHI FTP server Wed Apr 04 16:24:09 -0300 2012 (396) Closed ftp session. Wed Apr 04 16:24:09 -0300 2012 (396) set_directory method Wed Apr 04 16:24:09 -0300 2012 (396) convert_binary_file Wed Apr 04 16:24:09 -0300 2012 (396) File size: 204803 Wed Apr 04 16:24:09 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:09 -0300 2012 (396) Version 16 Wed Apr 04 16:24:09 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:09 -0300 2012 (396) File_number 1102 Wed Apr 04 16:24:11 -0300 2012 (396) <====================START RECORD 0 ====================> Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) callid { type => int & length => 4 } value => 14972003 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) acwtime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) onholdtime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) consulttime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) disptime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) duration { type => int & length => 4 } value => 1345 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) segstart { type => datetime & length => 4 } value => Fri Feb 17 12:05:47 UTC 2012 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) segstart_utc { type => datetime & length => 4 } value => Fri Feb 17 09:05:47 UTC 2012 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) segstop { type => datetime & length => 4 } value => Fri Feb 17 12:28:12 UTC 2012 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) segstop_utc { type => datetime & length => 2 } value => Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) talktime { type => int & length => 4 } value => 1329470892 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) netintime { type => int & length => 4 } value => 54 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) origholdtime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) queuetime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) ringtime { type => int & length => 4 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) dispivector { type => int & length => 2 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) dispsplit { type => int & length => 2 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) firstivector { type => int & length => 2 } value => 1301 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) split1 { type => int & length => 2 } value => 1301 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) split2 { type => int & length => 2 } value => 1301 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) split3 { type => int & length => 2 } value => 1301 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) trunkgroup { type => int & length => 2 } value => -1 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) tklocid { type => int & length => 2 } value => -1 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) origlocid { type => int & length => 2 } value => 91 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) answerlocid { type => int & length => 2 } value => 1 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) obslocid { type => int & length => 2 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) uuilen { type => int & length => 2 } value => 1 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) assist { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) audiodifficulty { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) conference { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) daqueued { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) holdabn { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) malicious { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) observingcall { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) transferred { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) agentreleased { type => bool & length => 1 } value => N Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) acdnum { type => int & length => 1 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) calldisp { type => int & length => 1 } value => 0 Wed Apr 04 16:24:11 -0300 2012 (396) dump_binary method Wed Apr 04 16:24:11 -0300 2012 (396) Error processing ECHI file - malformed UTF-8 character

[bklang]

The logs are interesting but they will not provide enough information to actually create a V16.1 definition. I can't promise anything quickly, but if you want me to take a look please give me an example data file create by the Avaya CMS. Please also send me your modified version16.1.yml so I can compare (a pull request for this would be best).

[ghost]

Thanks, I sent e-mail all the data requested

[ghost]

if you want you can post information for others, believe that these data will help many with the same problem

[ghost]

These are the files

https://github.com/downloads/brunobst/echi-converter/chr0001.180 http://cloud.github.com/downloads/brunobst/echi-converter/New16.1.yml

[ghost]

Hello, do not worry about the time but you have something new about the files ECHI

Thanks Man

[treicy]

Hi i need too this new version, thanks for help, you save my job heheh ^^

[ghost]

Mannnnnnnn I found the erro

in line of padding your type is String not STR

Thanks and bye ^^

[bklang]

Great! Would you mind sending a pull request so I can include this in a future version?

[ghost]

Do it, don't' worry, but i don't know how use this "pull request" XD

i use 16.1 CMS and this script now is working

[treicy]

Thanks Bruno it working Now !!!!!!!!

[treicy]

Hello Bruno, I have a doubt, the time in UTC is three hours late in comparison to the ticket that generates avaya, how to fix this?

[treicy]

hi i found the error is in time zone, but where i change this ???

[bklang]

I think this issue may have been closed accidentally.

@ghost: I checked the difference between our version16.yml and your 16.1.yml from http://cloud.github.com/downloads/brunobst/echi-converter/New16.1.yml. It looks like most of the changes are replacing "str" with "int", but that does not seem to make sense to me. Would you mind explaining the changes you made to get it to work?

[treicy]

I sent an email to bruno and he sent this model to version 16.1, we note that the sum of all bytes result in 621, using this value plus avaya manual for this model we can use the system normally

[treicy]

This is a new version 16.1.

[treicy]

ECH File construct, order is important, as the application

sequentially reads the file

Source: http://downloads.avaya.com/css/P8/documents/100089905

Version 16

echi_records:

• name: callid type: int length: 4
• name: acwtime type: int length: 4
• name: onholdtime type: int length: 4
• name: consulttime type: int length: 4
• name: disptime type: int length: 4
• name: duration type: int length: 4
• name: segstart type: datetime length: 4
• name: segstart_utc type: datetime length: 4
• name: segstop type: datetime length: 4
• name: segstop_utc type: datetime length: 4
• name: talktime type: int length: 4
• name: netintime type: int length: 4
• name: origholdtime type: int length: 4
• name: queuetime type: int length: 4
• name: ringtime type: int length: 4
• name: dispivector type: int length: 2
• name: dispsplit type: int length: 2
• name: firstivector type: int length: 2
• name: split1 type: int length: 2
• name: split2 type: int length: 2
• name: split3 type: int length: 2
• name: trunkgroup type: int length: 2
• name: tklocid type: int length: 2
• name: origlocid type: int length: 2
• name: answerlocid type: int length: 2
• name: obslocid type: int length: 2
• name: uuilen type: int length: 2
• name: assist type: bool length: 1
• name: audiodifficulty type: bool length: 1
• name: conference type: bool length: 1
• name: daqueued type: bool length: 1
• name: holdabn type: bool length: 1
• name: malicious type: bool length: 1
• name: observingcall type: bool length: 1
• name: transferred type: bool length: 1
• name: agentreleased type: boolint length: 1
• name: acdnum type: int length: 1
• name: calldisp type: int length: 1
• name: disppriority type: int length: 1
• name: holds type: int length: 1
• name: segment type: int length: 1
• name: ansreason type: int length: 1
• name: origreason type: int length: 1
• name: dispsklevel type: int length: 1
• name: events0 type: int length: 1
• name: events1 type: int length: 1
• name: events2 type: int length: 1
• name: events3 type: int length: 1
• name: events4 type: int length: 1
• name: events5 type: int length: 1
• name: events6 type: int length: 1
• name: events7 type: int length: 1
• name: events8 type: int length: 1
• name: ucid type: str length: 21
• name: dispvdn type: str length: 16
• name: eqloc type: str length: 10
• name: firstvdn type: str length: 16
• name: origlogid type: str length: 16
• name: anslogid type: str length: 16
• name: lastobserver type: str length: 16
• name: dialednumber type: str length: 25
• name: callingparty type: str length: 24
• name: collectdigits type: str length: 17
• name: cwcdigits type: str length: 17
• name: callingII type: str length: 3
• name: cwcs0 type: str length: 17
• name: cwcs1 type: str length: 17
• name: cwcs2 type: str length: 17
• name: cwcs3 type: str length: 17
• name: cwcs4 type: str length: 17
• name: vdn2 type: str length: 16
• name: vdn3 type: str length: 16
• name: vdn4 type: str length: 16
• name: vdn5 type: str length: 16
• name: vdn6 type: str length: 16
• name: vdn7 type: str length: 16
• name: vdn8 type: str length: 16
• name: vdn9 type: str length: 16
• name: asaiuui type: str length: 97
• name: interruptdel type: int length: 1
• name: agentsurplus type: int length: 1
• name: agentskilllevel type: int length: 1
• name: prefskilllevel type: int length: 1

ACD table definition derived from acd.dat

echi_acds:

• name: acd_id type: str length: 255
• name: acd_number type: str length: 255
• name: name type: str length: 255

Agents table definition derived from agname.dat

echi_agents:

• name: group_id type: str length: 255
• name: login_id type: str length: 255
• name: name type: str length: 255

Aux Reasons table definition derived from aux_rsn.dat

echi_reasons:

• name: group_id type: str length: 255
• name: aux_reason type: str length: 255
• name: name type: str length: 255

CWC definition derived from cwc.dat

echi_cwcs:

• name: group_id type: str length: 255
• name: cwc type: str length: 255
• name: name type: str length: 255

Split table definition derived from split.dat

echi_splits:

• name: acd_number type: str length: 255
• name: split_number type: str length: 255
• name: name type: str length: 255

Trunk Group table definition derived from tkgrp.dat

echi_trunks:

• name: acd_number type: str length: 255
• name: trunk_group type: str length: 255
• name: name type: str length: 255

VDN definition derived from vdn.dat

echi_vdns:

• name: group_id type: str length: 255
• name: vdn type: str length: 255
• name: name type: str length: 255

Vector definition derived from vector.dat

echi_vectors:

• name: acd_number type: str length: 255
• name: vector_number type: str length: 255
• name: name type: str length: 255

[treicy]

I do not know very well using this forum,: P but I think that is enough to test

[bklang]

Thanks @treicy, I will see what has changed in your paste relative to our verison16.yml.

[treicy]

bklang you need a file to test?

[bklang]

I have one from Bruno, but another sample would be welcome (yes, please). Also, please confirm the version of the Avaya CMS you are running, or at least the ECHI version.

[treicy]

I'm using version of CMS 16.1 and found a version that "ECHI-converter 0.4.4" Bruno uses the same as, used the same file that the bruno released and it worked, also tried with my tickets and this ok

[treicy]

the value to the manual avaya segstop_utc is 2 bytes, but in the ECHI can only collect some information when I place, 4 bytes

[treicy]

something new ?

[treicy]

Hello can close this issue, my problem was resolved.

Thanks so much

[treicy]

Hello I am in Brazil and the schedule generated by the ECHI is 3 hours at least, I used this method to correct the time, I edited the file Echi-converter.rb on line 206 Time.at value = (value +10800). utc, added the value "10800" which is more "03:00:00", perhaps most users found this problem, just managed to solve

[treicy]

Thanks for all your support, I'm closing this request

[bklang]

@treicy, this sounds more like a timezone issue. You may want to try setting the TZ environment variable before you start echi-converter, OR you may need to verify that the timezone is correct on the Avaya. In either case, please open a separate issue if you believe this is a real bug. I'm leaving this open until Bruno's changes get verified and merged.

[treicy]

understand, how I solve this so I do not think need to open another ticket, I talk often with Bruno, he does not know much about Ruby but got this "trick" hehe, really appreciate all the help I received, but an hour my boss is satisfied with these results, thank you and continue with this great job

[AlexeyZAO]

Hello @ghost, Could you please upload example file for ver. 16.1 one more time. This link https://github.com/downloads/brunobst/echi-converter/chr0001.180 dont work. I am very need it for test. Thanks in advance