Jump to content

Recommended Posts

Afternoon,

I am running a report that has the Call Description field in it, When I run the report out to a CSV File

The description field doesn't populate the full information, it only shows a small part, however in the data preview section when creating the report it shows the whole description?

please see screen shots, is this a bug?

Capture.PNG

Capture1.PNG

Share this post


Link to post
Share on other sites

Thanks for your post.  I have managed to replicate something similar to what you are getting.  When I opened the downloaded CSV directly into Excel, I had some descriptions where only the first couple of words were displayed.  I then opened the CSV file in Notepad and all of the information was in the CSV file which pointed to Excel having an issue with some of the descriptions.  In my case it might be line breaks or carriage returns.  In your report it might be to do with the "quotes" not being managed correctly.

I was wondering if you could check by opening your your CSV in Notepad or Notepad ++ and have a look and see if you are getting the same as I did.  If so maybe post back the full text content of one of the fields that is not displaying.  It might be that there are some hidden characters in there that Excel is not recognizing or characters that Excel just doesn't like.   By the look of your descriptions I'm guessing that you are either taking questions from a custom Progressive Capture form and mapping them to the description field or maybe using a Web Form and these are coming in by email?

Regards,

James

Share this post


Link to post
Share on other sites

Hi @yelyah.nodrog

It turned out that on my CSV in Excel the data was there, I just hadn't clicked on the cell itself to see all the content.  As well as looking at the file using Notepad, could you also let me know if you give a second click on the cell, where it appears to have missing information, to see if it extends to show more.

Regards,

Jmaes 

Share this post


Link to post
Share on other sites

Hey James, The first thing I did was expand the cell but you are right you have to physically double click on each one to expand them, Just noticed I can highlight the Numbers column and double click and this expands them all! Mystery Solved!

Thankyou Muchly!

Hayley.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...