pattr, xml, and spreadsheets

May 25, 2007 at 6:25pm

pattr, xml, and spreadsheets

hi-

i’m working on an interactive music therapy program with harvard med school.

we are trying out pattr to collect data during therapy sessions and it seems to work very well for our purposes…

however, the xml file written does not convert very easily to spreadsheet programs for data analysis.

has anyone dealt with such issues?

if so, do you have any advice for flexible xml parsing into spreadsheet formats?

hope this isn’t too tangential…

thanks
brian

#32096
May 25, 2007 at 10:33pm

This looks like it might be useful: http://www.xmlfox.com/ , but I’ve
never tried it. Otherwise, you’d need to write a converter (probably
to a tab- or comma-delimited format) for the files using (least
painlessly) a text processing language like Perl or Ruby, both of can
help you with the XML parsing.

jb

Am 25.05.2007 um 20:25 schrieb Brian_Knoth:

>
> hi-
>
> i’m working on an interactive music therapy program with harvard
> med school.
>
> we are trying out pattr to collect data during therapy sessions and
> it seems to work very well for our purposes…
>
> however, the xml file written does not convert very easily to
> spreadsheet programs for data analysis.
>
> has anyone dealt with such issues?
>
> if so, do you have any advice for flexible xml parsing into
> spreadsheet formats?
>
> hope this isn’t too tangential…
>
> thanks
> brian

#105076
May 26, 2007 at 8:21am

He,
I used tinyxmlw3cdom.js (http://xmljs.sourceforge.net/) parser with a [js] objects. it’s quite simple and useful.
You can build your js to convert the pttr xml files to a standard text file. Otherwise you can use a [js] to store directly your data in a formatted text file.

#105077
May 26, 2007 at 8:22am

He,
I used tinyxmlw3cdom.js (http://xmljs.sourceforge.net/) XML parser with a [js] objects. it’s quite simple and useful.
You can build your js to convert the pttr xml files to a standard text file. Otherwise you can use a [js] to store directly your data in a formatted text file.

#105078
May 30, 2007 at 1:02am

thanks much for the input!!

i’ll let you know how this works

#105079
May 30, 2007 at 1:03am

thanks! i’ll let you know how it works…

#105080

You must be logged in to reply to this topic.