Re: Xml data import
- Date: Sat, 13 Dec 2014 01:31:35 +0000
- From: Sayth Renshaw <flebber.crue@xxxxxxxxx>
- Subject: Re: Xml data import
And does that then lead you to use Fabric?
On Sat, 13 Dec 2014 9:06 AM Larry Martell <larry.martell@xxxxxxxxx> wrote:
> On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw <flebber.crue@xxxxxxxxx>
> > So it is definitely achievable, I see other db's converting xml2json etc
> > 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>
> >> ----- 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.
> >> > are the best way to get data into mysql, do I have to hack with
> >> That's going to depend on the complexity of your XML and how much of
> >> complexity you want preserved. There's definitely libraries out there
> >> 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
> >> ones.
> >> > My goal is to be able create queries and send csv files out for
> >> 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