I was able to get this working by exporting with a Macro that re-formats the first sheet to look presentable. In order for it to email out the report using a macro you have to have excel installed on the scheduling pc.
They are only using three things to pull from because IPOCC can't pull the...
I disagree, usually the Call Center Application has reporting built into it and I don't have to build applications to do what should be included. If there was an explanation on what each variable of each table of each database did, I might build an Access Database that did all the reporting...
@janni78 - Pulling the data myself would be great if I was the IT guy on site and could do this on a regular basis for them. Giving this to a call center and expecting a Call Center Supervisor to get data from 3 or 4 different places depending on the report doesn't go well when Xima or BBX has...
I have a customer that wants reports automatically generated for the day prior but does no want them exported and emailed. Basically they want to log into the UI double-click the report and it shows yesterday's data. I set this up but it won't seem to run at all unless I tell it to email out...
@janni78 - Thank you. I was hoping to hear something better. It seems if you want reporting data from IPOCC you have to either connect to the postgres database or spend hours reformatting what it exports.
I actually made a macro enabled excel sheet that specifically outputs in the correct format. I gave this to the customer and they don't seem to have any issues. Please see the attached file. If you are nervous opening a macro excel sheet from a stranger below is the macro I used in text form so...
I am trying to create an inbound call report that shows all the calls between 1pm - 2pm (and every other hour) throughout the entire month (24 rows with the total for each hour from the entire month). I was able to get it to work by creating a new table for each hour on in the historical report...
When I did a 9.0 to 10.0 Upgrade I had to do the upgrade then install the license but I don't remember getting an error when I tried loading it before the upgrade. Instead I think it just didn't do anything when I uploaded the XML file.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.