On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw <flebber.c...@gmail.com> 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. Indeed. > On Fri, 12 Dec 2014 9:55 PM Johan De Meersman <vegiv...@tuxera.be> wrote: > >> >> ----- Original Message ----- >> > From: "Sayth Renshaw" <flebber.c...@gmail.com> >> > 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