Recent content by travis13

Greetings - I am wondering if anyone can help me figure this out... I am trying to calculate an Average Handle time using the PostCallProcessingTime and the TalkTime components in the AgentByApplicationStat tables. My confusion is around PostCallProcessingTime... does it include time spent in...

Greetings - I am trying to build a custom report using Crystal 8.5 and linking directly to the tables through the ICCM_Preview_DSN. I need to report on application performance, and include an Average Handle Time calculation ((Talk Time + PostCallProcessing)/Handled Calls). Has anyone done...

The DTS package that I used created the tables and brought over all existing data. I want to only bring over the data from yesterday. I am sure I can do this through DTS, just not quite sure about the SQL piece... I am using the DTS Query Builder to select the data and am having trouble with...

Greetings - I need to import yesterday's data from an Informix database every morning. Can someone please suggest the best way to go about setting this up? (I'm a SQL newbie...) I have created the SQL db and copied all existing data using DTS, I just need to keep the data up-to-date with the...

Right on.. that worked perfectly. Thank you!

Greetings- I have setup a form that is opened during the AutoExec that I would like to display for 10 seconds, then continue with the rest of the AutoExec unless the user cancels. Is there a way to do this?? Thanks for your help!! t

Thanks for your responses! I am looking at a few of the solutions on Ken's site. I have downloaded the trials of cViewManager and CrystalDesk from Recrystallize.com (neither of which have I had success yet...) and am about to download Visual CUT (thanks Ido). I have looked briefly at Crystal...

Greetings - is there a way tol automatically run a report using Crystal Reports 8.5? I want to be able to schedule reports to be run during the early AM so that the resulting PDF files can be made available through an intranet site. Thanks in advance.

Does anyone know what the difference between these formulas are... =+D4/E4 =D4/E4 What does the "+" do on the first formula?

Greetings - I some help! I am trying to calculate an average that uses some criteria to determine whether or not to include a piece of data. I have cells A1 thru A4 with the following data: 0%, 100%, 75%, 97%. I need to come up with the average - but I want to throw out the lowest and the...

Does anyone know if there is a report that can be run that shows all agents logins and the skills and skill levels assigned to that login? Thanks

John - good stuff. I think I am making some progress! One question - will this copy all of the data again, or will it only copy the records since the last import?

Thanks Warwick. Would this be done through a sql statement, or is there an option somewhere using the DTS wizard?

It is setup to maintain data for a certain number of days - but 31 days isn't good enough for me. I need to maintain all hourly, daily, weekly, and monthly skill, agent, and vdn data indefinately.

The Informix DB is attached to our Avaya CMS system, collecting call center data. The CMS system only stores intraday (half-hourly) data for ~30 days, which is insufficient for historical reporting purposes. I want to pull all of the data for the previous day out of Informix and append the SQL...