Web lists-archives.com

Re: Xml data import




So it is definitely achievable, I see other db's converting xml2json etc to
get it in.

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

Sayth

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