View Full Version : XML problem!

10-02-2007, 04:31 PM
Hey guys!

I am new to XML and style sheet. I got this file and I need to put all the data into a database (any - mysql, excel, filemaker). Are there any software to do this? I have tried Excel and Access but it doesnt import the data the way i want. In access i get the tables but cant generate report because there is no relationship defined. Please tell me what am i looking at? I think its a xml schema? How do i get data from this xml into database? I have this file with content that looks like this -

<?xml version="1.0" encoding="UTF-8" ?>
- <idaxs xmlns="http://bla.bla.com/ida/idaxs/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="/xsds/idaxs_2_0.xsd">
- <project xmlns="">
<projectDescription>AoA DVD RIPPER </projectDescription>
- <subject>
<subjectInfo item="DX Group">Normal</subjectInfo>
- <visit>
<visitIdentifier>Month 12</visitIdentifier>
- <assessment name="PPRD ">
- <component name="PPRD Total Score">
<assessmentScore attribute="PPRCORE">29.00</assessmentScore>
- <study>
- <series>
- <imagingProtocol>
<description>HSFG 4i/16s</description>
- <protocolTerm>
<protocol term="Manufacturer">AoA </protocol>
<protocol term="Mfg Model">TY-</protocol>
<protocol term="Soundtrack">C-11 LLLP</protocol>
<protocol term="Rows">128.00000</protocol>
<protocol term="Columns">128.00000</protocol>
<protocol term="Number of movie">63.00000</protocol>
<protocol term="Frames">4.00000</protocol>
<protocol term="Pixel Spacing X">0.22483</protocol>
<protocol term="Pixel Spacing Y">0.22483</protocol>
<protocol term="Color">0.24250</protocol>
<protocol term="Subtitle">none</protocol>
<protocol term="Counts Source">Dynamic </protocol>
<protocol term="Equity Correction" />
<protocol term="Equilibrium Correction">Batch</protocol>
<protocol term="Molar Correction">Bad</protocol>
<protocol term="Reconstruction">Corrupted </protocol>
<protocol term="RGB Correction">Simulated 3D</protocol>
<protocol term="Music">JUH-56</protocol>