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
>> > 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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql