Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.

  • 1.  Topic trend detail csv export

    Posted 01-07-2025 05:26
    Edited by Melinda van den Heever 01-07-2025 06:34
    No replies, thread closed.

    Hi, all.  I have been searching for a solution in terms of understanding the csv format when exporting Topic trend details and other speech analytics related data, but I was not successful.  When I do an export to .csv The interval start date is totally wrong and not all the data in the file is , delimited.  It means that when I convert it to excel format, it replaces some of the data in the document which renders an unusable report.

    I have changed language, I have excluded empty rows which helped to an extent, but the date is totally wrong.  I extracted a report for December 2024 and this is the results.  How do I fix it?  Is it a report or a user problem?

    Interval Start Interval End
    2001/12/24 00:00 1931/12/24 00:30
    2001/12/24 00:00 2002/12/24 00:00
    2002/12/24 00:00 2003/12/24 00:00
    2003/12/24 00:00 2004/12/24 00:00

    There are therefor 2 issues that I struggle with, getting the interval start and interval end date to display correctly and being able to convert .csv to excel without the loss of data.


    #QualityManagement

    ------------------------------
    Melinda van den Heever
    NA
    ------------------------------



  • 2.  RE: Topic trend detail csv export

    Posted 01-07-2025 08:27
    Edited by Melinda van den Heever 01-07-2025 08:50
    No replies, thread closed.

    From further troubleshooting we have done, it seems to be the excel date format that is set to yyyy/mm/dd.  If I open it on my pc, it shows incorrectly, when I open it in web view it displays correct, but it is just a much more tedious way to get to the data.  

    Changing our windows setting to Regional format English(United States) has solved it for now, but I have a great number of users and this will not be practical.  We will continue searching for a better way.

    ------------------------------
    Melinda van den Heever
    NA
    ------------------------------



  • 3.  RE: Topic trend detail csv export

    Posted 01-07-2025 08:37
    No replies, thread closed.

    Hi Melinda,  Excel is always fun.  Sounds like you might be running into some issue with the regional setting on your PC.

    I do a lot in excel an usually I use some string formatting to level set the date in the exports.  

    On export I see a lot of strings and use the Mid() function with something like Datevalue(Mid(x,y,z)&"/"&Mid(x,y,z)&"/"&Mid(x,y,z))



    ------------------------------
    Chris Martin
    Genesys Cloud Analyst
    ------------------------------

    Original Message


  • 4.  RE: Topic trend detail csv export
    Best Answer

    Posted 01-07-2025 08:49
    No replies, thread closed.

    Thank you, we managed to get it to display by changing Regional format from English (South Africa) to English(United States).  So far it has not broken any of our other excel displays with South African formats.

     

    Thanks for the help.

     

     




    Original Message


Related Content