Re: [phpesp-general] Help CSV problems

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

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.



On Fri, Apr 19, 2002 at 09:15:50PM -0400, James O'Malley wrote:
> I noticed that you made some changes in the survey_export_csv.inc code after
> we went back and forth on March 26th.  I'm still having the same problems
> with exporting data though.  And now on top of that I can't force the
> survey_export_csv.inc to use another delimiter other than the comma.  I've
> tried importing checkbox data (multiple answers in one field) in gnumeric,
> openoffice, staroffice, and kspread and they all shift cells upon import.
> 
> If I want to modify the delimiters, where would I find them now (am thinking
> either tab or ^ for delimiter)?  The two join statements in
> survey_export_csv.inc don't seem to do the trick.  (hehe, I don't comment my
> code either).
> 
> Perhaps, I'm going about this all wrong... go back to the beginning.  If I
> want to look at the data by respondant (as in tabular form), how would I do
> that?  Is anybody else out there got a fancy schmancy query tool that will
> build web-tables of the data or whatnot?  It's got so much cool relational
> table stuff I'm not sure the whole structure and relationship will fit in my
> head inside of a month or two... must stop babbling and upgrade my CPU
> *knocks head*.
> 
> Thanks for any info you can provide.
> 

-- 
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