INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

IPOCC Abandoned Call Report

IPOCC Abandoned Call Report

(OP)
I posted something yesterday for which Janni78 responded but cannot locate the thread so I am posting it again. I am installing a new IPO SE with IPOCC v10 and am trying to run a detailed abandoned call report which needs to include date/time, caller id, topic, call length, etc. Is there anyway to create a custom report in IPOCC that will include all of that information? Thanks again.

RE: IPOCC Abandoned Call Report

Hi again =)

You can only get this by pulling data from the TR database and creating your own report.
I think you'll be fine just using tr.levelonedata and sorting it by ta_connectionstate and looking for the value 'Abandoned%'

"Trying is the first step to failure..." - Homer

RE: IPOCC Abandoned Call Report

(OP)
Thanks Janni78, I appreciate the quick response. Please forgive me, I am very new to the IPOCC. Took the class a few months ago and just starting my first install. Do you know of any documentation that would walk me through creating my own report? I've been searching online without much luck.

RE: IPOCC Abandoned Call Report

There isn't really any, it's a database that stores calldata that can be used but it's not described that well in the docs.

"Trying is the first step to failure..." - Homer

RE: IPOCC Abandoned Call Report

(OP)
Can you tell me what program you use to pull/query the data and create the report? Maybe I could figure it out from there.

RE: IPOCC Abandoned Call Report

I've built my own interface for it but Crystal Reports or similar might do the trick.

"Trying is the first step to failure..." - Homer

RE: IPOCC Abandoned Call Report

(OP)
Thanks again, I appreciate the help!!

RE: IPOCC Abandoned Call Report

Hy,

Regarding the reports I have a question so please correct me if I'm wrong: can we use other software that will just connect to the ipocc database, take data from there and do whatever we want with it ? :D

Thank you,
Vlad C.

RE: IPOCC Abandoned Call Report

You can connect to the IPOCC TR database to make custom reports.

This is not the same dat that IPOCC uses for reporting although it uses it for the Agent Status and Contact Detail views.

"Trying is the first step to failure..." - Homer

RE: IPOCC Abandoned Call Report

I'm sorry, but what is IPOCC TR database?

RE: IPOCC Abandoned Call Report

On the IPOCC postgres there are several databases, one of them is called TR and holds statistics data.

"Trying is the first step to failure..." - Homer

RE: IPOCC Abandoned Call Report

Gotcha!

Thanks ! :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close