Developer Support »

CSV values causing new lines in Excel, data too large  (See more user questions)

Hi

Are you using Microsoft Excel to open the CSV file? I used it for test
purposes and was able to replicate the problem.

The problem is with Excel. If you have a look at the CSV file in a text
editor, you will see that it does not have the new lines in it, it is
written as it should be.

I made a test CSV file manually, without using my script, I simply typed out
one in Notepad and made it 7,000 words long, 39,000 characters in total
(including spaces) and got the same problem in Excel with the new lines
appearing. So I am happy to say it isn't a problem with the script!

Looks to me like the problem is occurring around the 32K size, this is one
of those "magic numbers" that might be a limitation in Excel. I will see if
I can get more info on it for you. Just checked it out. Excel limits the
cell size to 32K:

http://office.microsoft.com/en-gb/excel/HP051992911033.aspx

The CSV file from the script is in good order, so you might be able to open
it in another application??

Best wishes.

Charles Sweeney
https://formtoemail.com
The world's easiest feedback script!

----- Original Message -----
Sent: Monday, September 28, 2009 1:41 PM
Subject: RE: New Question


Hi Charles,

I am using the CSV attachment option as this is being mailed to an outside
email address and the person in question doesn't have access to our servers.


Thank you,


-----Original Message-----
Sent: Sunday, September 27, 2009 1:51 PM
Subject: Re: New Question

Hi

Good to hear from you. Sorry for the delay in replying.

I haven't had that reported before. I will try to replicate it and get back
to you.

Are you using the CSV attachment option or writing the CSV file to the
server?

Best wishes.

Charles Sweeney
https://formtoemail.com
The world's easiest feedback script!

----- Original Message -----
Sent: Thursday, September 24, 2009 3:00 PM
Subject: New Question


Hi Charles,

Nothing too extrenuous I hope.
I am hoping to use the script on a new form that requires output to csv.
I have set it all up and it does generates the csv with the fields, etc
but one of the fields in the form is a textarea that will have a very
very long string of characters and that causes the csv output to break.
The text area is being divided in 3 or 4 separate cells in the csv which
is not ideal as the long string is supposed to be all together.
I could find the lines that write to the csv file but no mention to a
character limit. Is there a way to make sure that all characters input
in a text area in the form be written together to the csv?


Thank you,