PDA

View Full Version : XML problem!



neo_philiac
10-02-2007, 03: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="">
<projectIdentifier>HSFG</projectIdentifier>
<projectDescription>AoA DVD RIPPER </projectDescription>
<siteKey>006</siteKey>
- <subject>
<subjectIdentifier>006_S_0000</subjectIdentifier>
<researchGroup>Cat</researchGroup>
<subjectSex>M</subjectSex>
<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>
</component>
</assessment>
</visit>
- <study>
<studyIdentifier>1154811</studyIdentifier>
<subjectAge>72.6700</subjectAge>
<ageQualifier>Y</ageQualifier>
<weightKg>0.0000</weightKg>
<postMortem>F</postMortem>
- <series>
<seriesIdentifier>39049</seriesIdentifier>
<modality>PET</modality>
<dateAcquired>2007-09-06</dateAcquired>
- <imagingProtocol>
<imageUID>72078</imageUID>
<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>
</protocolTerm>
</imagingProtocol>
</series>
</study>
</subject>
</project>
</idaxs>

Thanks