Forums > MaxMSP

pattr, xml, and spreadsheets

May 25, 2007 | 6:25 pm

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


May 25, 2007 | 10:33 pm

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


May 26, 2007 | 8:21 am

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.


May 26, 2007 | 8:22 am

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.


May 30, 2007 | 1:02 am

thanks much for the input!!

i’ll let you know how this works


May 30, 2007 | 1:03 am

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


Viewing 6 posts - 1 through 6 (of 6 total)