[phpesp-general] survey_export_csv.inc weirdness

[James O'M. <ja...@pa...>]

I'm not sure if it's a problem with OpenOffice or what, but I get weird
import errors in OpenOffice when I import a csv (made with phpESP 1.4beta3).
 If there are line breaks in the data field, it get's imported to OpenOffice
as a new record/line and then of course throws off the spreadsheet.  Also,
on some of the fields there some weirdness on the "," that are delimiting
and the commas that are part of the text... again, throwing of data by one
field all the way down.

I corrected it in survey_export_csv.inc by changing the delimiter to a ^
which I find works very well, as it almost never turns up in respondant
fields.  Now the other issue of windows line breaks ^M in some comment
fields might be an OpenOffice issue or an export issue.  Anybody know what
the specified end of record is for a csv file?  If it's a newline then
there's a problem.

Maybe stripping all newlines from textarea elements is the solution?

How's the dbf export coming along?

-- 
  _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/

  James O'Malley
  Altamente.com
  +1(787)296-1540

  _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/