Re: [phpesp-general] Help CSV problems

[Matthew G. <gr...@mu...>]

Well I'm stumped....

At least for small surveys/data sets I think James is handling and
exporting check boxes and essays correctly.  It could be that
something is breaking on the large surveys/data that you have.

What version of phpESP are you using?

My example surveys data export looks like this:
TEST,TEST_CHECK
"blah","no,yes"
"asdasd","maybeso,no"
"adsffg4e","maybeso,no,yes"
"hhhh","maybeso,yes"
"hhhh","no"
"hhhh","yes"
"hhhh","maybeso"

When imported into one of the before mentioned applications, the
results looks like this(if my formating doesn't get destroyed by the
listserv):

TEST	      TEST_CHECK
-----	      ---------
blah	      no,yes
asdasd	      maybeso,no
adsffg4e      maybeso,no,yes
hhhh	      maybeso,yes
hhhh	      no
etc....

This is the correct behavior.

Also...
I added a "essay" question to my test survey. I added several "carriage
returns" to my responses then exported again.  Gnumeric opened the
file correctly.

TEST	      TEST_CHECK	TEST_ESSAY
-----	      ---------		---------
dsfgdfg	      yes,maybeso	this is a test of the emergency broadcast system



On Sun, Apr 21, 2002 at 11:21:26PM -0400, James O'Malley wrote:
> > 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."
> 

-- 
brought to you by, Matthew Gregg...
one of the friendly folks in the IT Lab.
--------------------------------------\
The IT Lab (http://www.itlab.musc.edu) \____________________
Probably the world's premier software development center.
Serving: Programming, Tools, Ice Cream, Seminars