PierrickLozach
commented
4 years ago Response from Dan:
In talking with others about how they are handling this we found another way around this.
Once I export the data, I open the .csv file.
From there I select the first column and then select Data, then Text to Columns
In the dialog box I select Delimited
In the next dialog box I select Tab, semicolon & Comma
Select Next
This imports the data into the correct columns
Just sharing what we found as this seems to work for the individuals that were having issues.
Sample files:
Export Dan.csv does not work. Export Dave.csv works.
Exports.zip
Took me a while to find the issue. It’s because (for some reason), the double quote at the end of “Genesys Cloud” is missing and there are 2 double quotes as well for each field. That confuses the format detection:
I used a text editor to replace them with single double quotes by replacing: • ; “” to ;” • “”; to “; • [“” to [“ • “”] to “] • Cloud; to Cloud”; • Engage; to Engage”; • Connect; to Connect”;
Save the file, open in Excel using the Data/From Text/CSV option (make sure you select the Delimiter to “Semicolon”) and voilà!