Re: [phpesp-general] Help CSV problems

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

> This works fine for me.  Or it could be I don't understand the problem
> :-)
>
> I created a test survey, 2 questions.  First one "text box", second one
> a "check box" with 3 questions.  I randomly answered the survey several
> times with multiple answer in the "check boxes".  Exported the results,
> opened the exported file in:
> Gnumeric(1.0.6)
> Kspread(2.2.2)
> OpenOffice(current build)
> they all imported perfectly. With  2 columns, first is the "text box",
> second is the "check box" data.
>

No, the problem is when there are checkboxs (that is, possibly multiple
answers for individual questions - arrays).  James is putting them into the
mix seperated by commas and an extra set of quotes (I think).  For some
reason I can't get it to import properly.  I've been manually trying to fix
the text, but I keep breaking it worse.

The other issue is a text area issue where the respondant puts in a carriage
return and screws up the formating (interpretes ^M as a new record and
starts a new row, thereby throwing off the rest of that said record).

On top of it all one of the question's data is being repeated.  The form is
faily complicated and I'm having a tough time finding out where the error
is.  Is it the code, the form, of the export?  James, if you have the time
and inclination (I'm sure you're super busy... but if it will possibly help
others...), I can give you admin access to the CVS export and you can see
what I'm talking about for yourself (maybe it'll be more obvious to you)

I'm trying to help out this non-profit (Giving New England).  I set them up
for them and they've been busily setting up forms and doing surveys about
charity and foundation budget constraints (amounts donated, solicited,
trends etc.)  and it's working out great for them... much better than they'd
hoped.  The only thing is now that they are having trouble with the export.
 I've been doing my best to help them, but I can't seem to find where things
are going wrong, and I also don't quite understand the data structures (how
the tables inter-relate etc).  It'll take some time to figure it all out,
but for now, I'm lost.

That didn't sound like whining did it?  God, I hope not ;) 'cause I love
phpESP.  T-shirt slogan maybe:  "All your surveys are belong to us."

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

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

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