|
|
|
|
Joined: May 2008
Posts: 11
Member
|
|
Member
Joined: May 2008
Posts: 11 |
Hello,
Has anyone here had any luck on pulling data from the ESI ACD database that VIP writes to (it is a .cdb file)? We have the need to pull some simple data out (# of calls, # of abandons, etc) and are not sure what kind of database this is or (once we get into it) what the data definitions are. Any information regarding this would be greatly appreciated.
Paul
|
|
|
Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.
|
|
|
|
Joined: Jan 2006
Posts: 212
Member
|
|
Member
Joined: Jan 2006
Posts: 212 |
Do you have the ACD admin Software? If you do then you can get the reports you need. The other reports from the SMDR are pretty generic.
Cosmo
|
|
|
|
|
Joined: Aug 2002
Posts: 2,608
Moderator-ESI, Shoretel
|
|
Moderator-ESI, Shoretel
Joined: Aug 2002
Posts: 2,608 |
The "supervisor" software also offers you some advanced options as well.
|
|
|
|
|
Joined: Jul 2003
Posts: 766
Member
|
|
Member
Joined: Jul 2003
Posts: 766 |
You can get that info on the ACD reports in the esi programmer software.
|
|
|
|
|
Joined: May 2008
Posts: 11
Member
|
|
Member
Joined: May 2008
Posts: 11 |
Yes, we do have the VIP Supervisor (ACD Admin, whatever you want to call it) software, as well has the ESI programmer software, but we didn't want the canned reports. We were actually looking to pull the data into a SQL database and customize our own reports...which we did accomplish. If anyone else happens to be looking, .cdb is a 'compact database' that will open up just fine in MS Access. The data definitions are more or less apparent from the data. From then it was a piece of cake for our DBA to pull the data over to SQL and now we actually pull that data into SQL and can customize the reports.
|
|
|
|
Forums84
Topics94,521
Posts639,995
Members49,851
| |
Most Online5,661
May 23rd, 2018
|
|
|
1 members (justbill),
275
guests, and
45
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|
|
![[Linked Image]](https://sundance-communications.com/images/banners/nextgen154x64.jpg)