Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: codebug on May 02, 2018, 07:38:35 AM

Title: How to export Historical Queue report 15 min to a separate CSV file
Post by: codebug on May 02, 2018, 07:38:35 AM

Hello
How can one export Historical Queue report 15 min interval data to a separate CSV file for each interval for a whole week in the Genesys world
And select specific stats to be available.
eg
Date-13:00.csv
Date-13:15.csv
Date-13:30.csv

each file has something like this format..
Queue;Interval;CallVolume;ASA,AHT
Q1;13:00;4;5
Q2;13:00;2;1

any pointers where to start would be appreciated :)

CB

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: Tambo on May 02, 2018, 12:56:34 PM

from what ??

ccpulse, icon, gim, pulse

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: codebug on May 02, 2018, 09:44:24 PM

Hi Tambo
would be in GIM/icon

CB

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: Noufal on May 03, 2018, 06:59:23 AM

do you use Business intelligence for historical report (for GIM), if you have it... its very easy , generate report for the day and drill with date raw first it will come with hour second it will come with 30 min third 15 min

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: Tambo on May 03, 2018, 09:50:43 AM

if you're using GI2 as Noufal says then there shouldn't be any issues, or are you just wanting an export straight out from GIM?

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: codebug on May 03, 2018, 10:32:30 AM

Hi folks
Yes I can generate the report in the web interface..but what I am after is getting the csv files generated in the above  mentioned format in separate files.. as I need this data for one month for example that has the break down for each days 15 min interval  not sure how would u do this ..

CB

Sent from my SM-G925I using Tapatalk

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: cavagnaro on May 03, 2018, 12:41:00 PM

Do a job in sql to export to csv.

Enviado de meu E6633 usando o Tapatalk

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: hsujdik on May 03, 2018, 01:56:14 PM

[quote author=cavagnaro link=topic=10962.msg49808#msg49808 date=1525351260]
Do a job in sql to export to csv.

Enviado de meu E6633 usando o Tapatalk


[/quote]

This way pointed by cavagnaro would be the easiest one. That can be done in GI2 as well, but it would be a pain to do so. If you need help, I can guide you on how you on how you need to build the queries.

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: cavagnaro on May 03, 2018, 01:59:30 PM

Actually is the "easiest" but also the dummiest...I always reject this kind of requests due creating an extra point of failure.
Actually you have a 3rd party tool that will import this export of a DB, the correct solution is your 3rd party app to connect directly to the DB and avoid middle solutions with possible errors.

Enviado de meu E6633 usando o Tapatalk

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: codebug on May 04, 2018, 12:29:14 AM

Hi Cav
Yes agree in ideal situation then connecting to DB directly would be the way to go .. unfortunately we are under the mercy  of 3rd party tool and  how it works

CB

Sent from my SM-G925I using Tapatalk

Title: Re: How to export Historical Queue report 15 min to a separate CSV file
Post by: codebug on May 04, 2018, 12:31:30 AM

[quote author=hsujdik link=topic=10962.msg49811#msg49811 date=1525355774]
[quote author=cavagnaro link=topic=10962.msg49808#msg49808 date=1525351260]
Do a job in sql to export to csv.

Enviado de meu E6633 usando o Tapatalk


[/quote]

This way pointed by cavagnaro would be the easiest one. That can be done in GI2 as well, but it would be a pain to do so. If you need help, I can guide you on how you on how you need to build the queries.
[/quote]Would be awesome if u can help me ..what would query look like

CB

Sent from my SM-G925I using Tapatalk