creating 1000 xml files with different values agn and agn

[Madhu Harchandani]

Hello
i am working in a project in which i am using xnat technology in that data is entered through xml files only i need to enter 1000 records .so it is very cumbersome to create 1000 xml files So i need a simple way so that i can create and insert 1000 records in xnat database

this is the xml file which i want to generate again and again with some different values Plz could someone helps me get over this problem



<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSPY v2004 rel. 3 U (http://www.xmlspy.com)-->
<Subject xmlns="http://nrg.wustl.edu/xnat" xmlns:xnat="http://nrg.wustl.edu/xnat" xmlns:prov="http://www.nbirn.net/prov" xmlns:xdat="http://nrg.wustl.edu/xdat" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://nrg.wustl.edu/xnat ../src/schemas/xnat/xnat.xsd" ID="XNAT004">

<investigator>
<title>Dr</title>
<firstname>Richard</firstname>
<lastname>Joseph</lastname>
<institution>WUSTL</institution>
<department>DENTAL</department>
<email>[e-mail]</email>
<phone>314-452-8977</phone>
</investigator>
<demographics xsi:type="xnat:demographicData">
<dob>1976-07-03</dob>
<gender>female</gender>
<handedness>left</handedness>
</demographics>
<experiments>
<experiment xsi:type="xnat:mrSessionData" ID="XNAT005_MR1" session_type="Best Ever">
<date>1999-08-13</date>
<time>14:20:00-05:00</time>
<note>String</note>
<investigator ID="1">
<xnat:title>Dr</xnat:title>
<xnat:firstname>Richard</xnat:firstname>
<xnat:lastname>Joseph</xnat:lastname>
<xnat:institution>WUSTL</xnat:institution>
<xnat:department>DENTAL</xnat:department>
<xnat:email>[e-mail]</xnat:email>
<xnat:phone>314-452-8977</xnat:phone>
</investigator>
<validation status="COMPLETE">
<method>Script</method>
<date>1999-08-13</date>
<notes>None</notes>
</validation>
<subject_ID>XNAT004</subject_ID>
<scanner>Scanner 1</scanner>
<marker>Marker 1</marker>
<stabilization>Stabilization 1</stabilization>
<operator>Operator 1</operator>
<prearchivePath>pre_archive</prearchivePath>
<scans>
<xnat:scan ID="XNAT005_MR1_SCAN1" type="MPRAGE">
<xnat:note>3</xnat:note>
<xnat:quality>usable</xnat:quality>
<xnat:parameters>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientation>Sag</xnat:orientation>
<xnat:fov x="256" y="256"/>
<xnat:matrix x="224" y="256"/>
<xnat:partitions>0</xnat:partitions>
<xnat:tr>9.7</xnat:tr>
<xnat:te>4.0</xnat:te>
<xnat:ti>20.0</xnat:ti>
<xnat:flip>10</xnat:flip>
<xnat:sequence>mpr_ns_t1_4b195.wkc</xnat:sequence>
<xnat:origin>CAP/CAP_MPRAGEx2.prg</xnat:origin>
<xnat:scanTime>16:04:09</xnat:scanTime>
</xnat:parameters>
<xnat:file cachePath="cache_archive_path" content="MPRAGE_RAW" format="IMA" URI="XNAT003_MR1_SCAN1/RAW/114-5-440.ima" xsi:type="xnat:imageResource">

<xnat:dimensions volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientation>Sag</xnat:orientation>
</xnat:file>
<xnat:validation>
<xnat:method>arc_validate</xnat:method>
<xnat:date>2005-12-02</xnat:date>
</xnat:validation>
</xnat:scan>
<xnat:scan ID="XNAT005_MR1_SCAN2" type="MPRAGE">
<xnat:note>4</xnat:note>
<xnat:quality>usable</xnat:quality>
<xnat:parameters>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientation>Sag</xnat:orientation>
<xnat:fov x="256" y="256"/>
<xnat:matrix x="224" y="256"/>
<xnat:partitions>0</xnat:partitions>
<xnat:tr>9.7</xnat:tr>
<xnat:te>4.0</xnat:te>
<xnat:ti>20.0</xnat:ti>
<xnat:flip>10</xnat:flip>
<xnat:sequence>mpr_ns_t1_4b195.wkc</xnat:sequence>
<xnat:origin>CAP/CAP_MPRAGEx2.prg</xnat:origin>
<xnat:scanTime>16:10:47</xnat:scanTime>
</xnat:parameters>
<xnat:file cachePath="cache_archive_path" content="MPRAGE_RAW" format="IMA" URI="XNAT003_MR1_SCAN1/RAW/114-6-568.ima" xsi:type="xnat:imageResource">

<xnat:dimensions volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientation>Sag</xnat:orientation>
</xnat:file>
<xnat:validation>
<xnat:method>arc_validate</xnat:method>
<xnat:date>2005-12-02</xnat:date>
</xnat:validation>
</xnat:scan>
</scans>
<reconstructions>
<reconstructedImage ID="XNAT005_MR1_RECON1" baseScanType="MPRAGE" type="MPRAGE">
<inScans>
<scanID>XNAT005_MR1_SCAN1</scanID>
</inScans>
<in>
<xnat:file cachePath="cache_archive_path" content="MPRAGE_RAW" format="IMA" URI="XNAT005_MR1_SCAN1/RAW/114-5-440.ima" xsi:type="xnat:imageResource">

<xnat:dimensions volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientation>Sag</xnat:orientation>
</xnat:file>
</in>
<out>
<xnat:file content="GFC" format="ANALYZE" URI="XNAT003_MR1_SCAN1/PROCESSED/MPRAGE/T88_111/XNAT003_MR1_SCAN1_mpr_n4_111_t88_gfc.img" xsi:type="xnat:imageResource">

<xnat:dimensions volumes="1" x="176" y="208" z="176"/>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.0"/>
<xnat:orientation>Tra</xnat:orientation>
</xnat:file>
<xnat:file content="T88" format="IFH" URI="XNAT003_MR1_SCAN1/PROCESSED/MPRAGE/T88_111/XNAT003_MR1_SCAN1_mpr_n4_111_t88.4dfp.img" xsi:type="xnat:imageResource">

<xnat:dimensions volumes="1" x="176" y="208" z="176"/>
<xnat:voxelRes units="mm" x="1.0" y="1.0" z="1.0"/>
<xnat:orientation>Tra</xnat:orientation>
</xnat:file>
</out>
</reconstructedImage>
</reconstructions>
</experiment>
</experiments>
</Subject>

[jkmyoung]

I'm not sure what database type you're using, but you may want to try using BULK LOAD.

How are you currently loading your xml into your database?