Web lists-archives.com

Re: Xml data import

On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw <flebber.crue@xxxxxxxxx> wrote:
> So it is definitely achievable, I see other db's converting xml2json etc to
> get it in.

I use this https://github.com/hay/xml2json

> Sends odd that xml had done great document qualities but as a data format
> it seems rather hard to work with.


> On Fri, 12 Dec 2014 9:55 PM Johan De Meersman <vegivamp@xxxxxxxxx> wrote:
>> ----- Original Message -----
>> > From: "Sayth Renshaw" <flebber.crue@xxxxxxxxx>
>> > Subject: Xml data import
>> >
>> > I have an xml data feed with xsd, it's complex in elements not size. Wray
>> > are the best way to get data into mysql, do I have to hack with xquery?
>> That's going to depend on the complexity of your XML and how much of that
>> complexity you want preserved. There's definitely libraries out there that
>> can map XML (tree) structures onto relational structures; although it's
>> been so long since I played with XML that I really couldn't tell you which
>> ones.
>> > My goal is to be able create queries and send csv files out for analysis
>> in
>> > R and plots in ggplot2. Also render done other off the initial days to
>> the
>> > Web usually xslt from xml.
>> I suppose that worstcase you could use XSLT to transform into a flatter
>> structure, maybe even CSV?
>> --
>> Unhappiness is discouraged and will be corrected with kitten pictures.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql