Re: Xml data import
- Date: Fri, 12 Dec 2014 21:52:53 +0000
- From: Sayth Renshaw <flebber.crue@xxxxxxxxx>
- Subject: 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.
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
> > My goal is to be able create queries and send csv files out for analysis
> > R and plots in ggplot2. Also render done other off the initial days to
> > 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.