Importing complex XML data into a database
#1
Scooby Regular
Thread Starter
Join Date: Mar 1999
Location: The Great White North
Posts: 25,080
Likes: 0
Received 0 Likes
on
0 Posts
Importing complex XML data into a database
Here's a good one for you.
I've got some complex XML data (Mac OS X System Profiler report in XML format) and I would like, if at all possible, to import this into a database, preferably mac based, but it's not a problem if it's PC based.
The idea here is that I have the hardware reports generated automatically and put onto a server (that's the easy bit), I can view the data on the server, but I can't actually do any comparisons or searches, for example, search for all machines running Mac OS X 10.4.x with 256MB of RAM.
It's for this reason I'd like to import the data into a database so I can easilly find that information and generate a report on that search, or any other search I desire.
Anyone have any bright ideas on how to do this? I've looked at Filemaker Pro, and it does have an XML import, but it looks like I'd need an XSL stylesheet, and this data isn't simple row and column deal (see below) thus the XSL file would be a little complex, if it's possible to do it at all.
You can view/download the xml file here
I've got some complex XML data (Mac OS X System Profiler report in XML format) and I would like, if at all possible, to import this into a database, preferably mac based, but it's not a problem if it's PC based.
The idea here is that I have the hardware reports generated automatically and put onto a server (that's the easy bit), I can view the data on the server, but I can't actually do any comparisons or searches, for example, search for all machines running Mac OS X 10.4.x with 256MB of RAM.
It's for this reason I'd like to import the data into a database so I can easilly find that information and generate a report on that search, or any other search I desire.
Anyone have any bright ideas on how to do this? I've looked at Filemaker Pro, and it does have an XML import, but it looks like I'd need an XSL stylesheet, and this data isn't simple row and column deal (see below) thus the XSL file would be a little complex, if it's possible to do it at all.
You can view/download the xml file here
Last edited by Markus; 06 October 2006 at 03:54 PM.
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM