Hello, Im new to the forum.
I'm running a OXE R6.0.1 (soon to become R7.1) /CCD/ACR with 350 agents.
For advanced reporting and automated email alerts I have created an Access application that automatically imports scheduled statistics excel files from CCS.
It does the job but it is cumbersome.
I would like to connect directly to Omni's database with a business intelligence tool and work from there.
I have seen posts regarding using cuser in the /usr3/mao directory but I can't figure out if my tables are there.
I am looking for tables with data of Pilots, Pilstats, Agents and Agent sessions.
Couple of questions to get me started.
1. Is CCD statistic data stored in the /usr3/mao. If not where is it?
2. Which tables am i looking for?
3. Somebody got some info on table structure?
4. Any other useful info?
Thanks in advance
CCD statistics/database question
Re: CCD statistics/database question
Hi,
The ccd statitics files are not in the usr3/mao directory. You need specifiq licences to have those files available on OXE. If your system have that licence then those files will be genereted on usr4/afe directory. Those files are not in db format.
If have done one application that can read all the ccd statitics and then i put all the available information in a Access DB file. Like this, anyone can do all the statistics that ccs does, since all tables of the ccs statistics use those values and others that are not available on ccs (ex: calling numbers)
If you want to try it please let me know.
The ccd statitics files are not in the usr3/mao directory. You need specifiq licences to have those files available on OXE. If your system have that licence then those files will be genereted on usr4/afe directory. Those files are not in db format.
If have done one application that can read all the ccd statitics and then i put all the available information in a Access DB file. Like this, anyone can do all the statistics that ccs does, since all tables of the ccs statistics use those values and others that are not available on ccs (ex: calling numbers)
If you want to try it please let me know.
-
jigsaw
Re: CCD statistics/database question
Interesting.
Well, a whole bunch of files in the usr4/afe directory.
How can I try your application?
Will it work independent of release?
Well, a whole bunch of files in the usr4/afe directory.
How can I try your application?
Will it work independent of release?
Re: CCD statistics/database question
Hi,
It works since R4 or R3.2 (i am not sure, need to check the code). Never test it on R7.1. Normaly when new release arrives i check if there is a difference on ccd statistics files and if it is the case i code it.
Send me the files /usr4/afe/catalog.cfg, /usr2/descript/deliv_id, /usr3/afe/parameters.cfg, /usr4/afe/evYYMMDD.sta and /usr4/afe/tcYYMMDD.sta and if exists the tcYYMMDD.Z. YY=year; MM=Mounth; DD=day
to me (sadim@clix.pt) and i will send you back the access db file. Then if you consider that the information is suitable for you, i will send you the app.
Important note: when you retrive the files from the pabx, do not forget to retrieve them in binary mode
It works since R4 or R3.2 (i am not sure, need to check the code). Never test it on R7.1. Normaly when new release arrives i check if there is a difference on ccd statistics files and if it is the case i code it.
Send me the files /usr4/afe/catalog.cfg, /usr2/descript/deliv_id, /usr3/afe/parameters.cfg, /usr4/afe/evYYMMDD.sta and /usr4/afe/tcYYMMDD.sta and if exists the tcYYMMDD.Z. YY=year; MM=Mounth; DD=day
to me (sadim@clix.pt) and i will send you back the access db file. Then if you consider that the information is suitable for you, i will send you the app.
Important note: when you retrive the files from the pabx, do not forget to retrieve them in binary mode
