creating 1000 xml files with different values agn and agn

1 New Member

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"?>

<Subject xmlns="http://nrg.wustl.edu/xnat" xmlns:xnat="htt p://nrg.wustl.edu/xnat" xmlns:prov="htt p://www.nbirn.net/prov" xmlns:xdat="htt p://nrg.wustl.edu/xdat" xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocat ion="http://nrg.wustl.edu/xnat ../src/schemas/xnat/xnat.xsd" ID="XNAT004">

<investigator >
<title>Dr</title>
<firstname>Rich ard</firstname>
<lastname>Josep h</lastname>
<institution>WU STL</institution>
<department>DEN TAL</department>
<email>w.s@emai l.com</email>
<phone>314-452-8977</phone>
</investigator>
<demographics xsi:type="xnat: demographicData ">
<dob>1976-07-03</dob>
<gender>femal e</gender>
<handedness>lef t</handedness>
</demographics>
<experiments>
<experiment xsi:type="xnat: mrSessionData" ID="XNAT005_MR1 " session_type="B est Ever">
<date>1999-08-13</date>
<time>14:20:0 0-05:00</time>
<note>String</note>
<investigator ID="1">
<xnat:title>D r</xnat:title>
<xnat:firstname >Richard</xnat:firstname>
<xnat:lastname> Joseph</xnat:lastname>
<xnat:instituti on>WUSTL</xnat:institutio n>
<xnat:departmen t>DENTAL</xnat:department >
<xnat:email>w.s @email.com</xnat:email>
<xnat:phone>3 14-452-8977</xnat:phone>
</investigator>
<validation status="COMPLET E">
<method>Scrip t</method>
<date>1999-08-13</date>
<notes>None</notes>
</validation>
<subject_ID>XNA T004</subject_ID>
<scanner>Scanne r 1</scanner>
<marker>Marke r 1</marker>
<stabilization> Stabilization 1</stabilization>
<operator>Opera tor 1</operator>
<prearchivePath >pre_archive</prearchivePath>
<scans>
<xnat:scan ID="XNAT005_MR1 _SCAN1" type="MPRAGE">
<xnat:note>3</xnat:note>
<xnat:quality>u sable</xnat:quality>
<xnat:parameter s>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientati on>Sag</xnat:orientatio n>
<xnat:fov x="256" y="256"/>
<xnat:matrix x="224" y="256"/>
<xnat:partition s>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>CA P/CAP_MPRAGEx2.pr g</xnat:origin>
<xnat:scanTime> 16:04:09</xnat:scanTime>
</xnat:parameters >
<xnat:file cachePath="cach e_archive_path" content="MPRAGE _RAW" format="IMA" URI="XNAT003_MR 1_SCAN1/RAW/114-5-440.ima" xsi:type="xnat: imageResource">

<xnat:dimension s volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientati on>Sag</xnat:orientatio n>
</xnat:file>
<xnat:validatio n>
<xnat:method>ar c_validate</xnat:method>
<xnat:date>20 05-12-02</xnat:date>
</xnat:validation >
</xnat:scan>
<xnat:scan ID="XNAT005_MR1 _SCAN2" type="MPRAGE">
<xnat:note>4</xnat:note>
<xnat:quality>u sable</xnat:quality>
<xnat:parameter s>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientati on>Sag</xnat:orientatio n>
<xnat:fov x="256" y="256"/>
<xnat:matrix x="224" y="256"/>
<xnat:partition s>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>CA P/CAP_MPRAGEx2.pr g</xnat:origin>
<xnat:scanTime> 16:10:47</xnat:scanTime>
</xnat:parameters >
<xnat:file cachePath="cach e_archive_path" content="MPRAGE _RAW" format="IMA" URI="XNAT003_MR 1_SCAN1/RAW/114-6-568.ima" xsi:type="xnat: imageResource">

<xnat:dimension s volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientati on>Sag</xnat:orientatio n>
</xnat:file>
<xnat:validatio n>
<xnat:method>ar c_validate</xnat:method>
<xnat:date>20 05-12-02</xnat:date>
</xnat:validation >
</xnat:scan>
</scans>
<reconstruction s>
<reconstructedI mage ID="XNAT005_MR1 _RECON1" baseScanType="M PRAGE" type="MPRAGE">
<inScans>
<scanID>XNAT005 _MR1_SCAN1</scanID>
</inScans>
<in>
<xnat:file cachePath="cach e_archive_path" content="MPRAGE _RAW" format="IMA" URI="XNAT005_MR 1_SCAN1/RAW/114-5-440.ima" xsi:type="xnat: imageResource">

<xnat:dimension s volumes="1" x="256" y="256" z="128"/>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.25"/>
<xnat:orientati on>Sag</xnat:orientatio n>
</xnat:file>
</in>
<out>
<xnat:file content="GFC" format="ANALYZE " URI="XNAT003_MR 1_SCAN1/PROCESSED/MPRAGE/T88_111/XNAT003_MR1_SCA N1_mpr_n4_111_t 88_gfc.img" xsi:type="xnat: imageResource">

<xnat:dimension s volumes="1" x="176" y="208" z="176"/>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.0"/>
<xnat:orientati on>Tra</xnat:orientatio n>
</xnat:file>
<xnat:file content="T88" format="IFH" URI="XNAT003_MR 1_SCAN1/PROCESSED/MPRAGE/T88_111/XNAT003_MR1_SCA N1_mpr_n4_111_t 88.4dfp.img" xsi:type="xnat: imageResource">

<xnat:dimension s volumes="1" x="176" y="208" z="176"/>
<xnat:voxelRe s units="mm" x="1.0" y="1.0" z="1.0"/>
<xnat:orientati on>Tra</xnat:orientatio n>
</xnat:file>
</out>
</reconstructedIm age>
</reconstructions >
</experiment>
</experiments>
</Subject>

Mar 15 '08 #1

Subscribe Reply

2047

jkmyoung

2,057

Recognized Expert Top Contributor

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?

Mar 17 '08 #2

Similar topics

2784

Installing, creating database, updating schema?

by: Robin Tucker | last post by:

Hi there, I have a database on my test machine that will need to be installed on users machines. I would like to create the database with the given schema on the users machine and also with some suitable default values in the tables. I note that although I can script the schema so that re-creating the structure of the database is simple on the users machine, I cannot script the contents of the tables also (automatically). What I would...

Microsoft SQL Server

2175

VB.NET: DirectoryServices Member.Count limit of 1000

by: kovac | last post by:

The System.directoryservices.dll has an error, and this error was described in http://support.microsoft.com/default.aspx?scid=kb;en-us;839424 At the moment we have Framework version v1.0.3705 and I have remove System.directoryservices.dll from current Framework version v1.0.3705. In state of old version I load die new System.directoryservices.dll from the Framework version v1.1.4322. I work with the following function of Joe Kaplan...

.NET Framework

2846

Creating or Getting a Dataset from a grid

by: Filippo Pandiani | last post by:

I have a grid that shows the file list from a folder. On the postback, how do I get a Dataset from this grid? Thanks, Filippo.

C# / C Sharp

10845

Security/Distribution Group Member.Count limit of 1000

by: Terry E Dow | last post by:

Howdy, I am having trouble with the objectCategory=group member.Count attribute. I get one of three counts, a number between 1-999, no member (does not contain member property), or 0. Using LDIFDE as a comparison I get the same results. No members means just that, an empty group. Zero means that the DirectorySearcher.SizeLimit has been exceeded....

C# / C Sharp

2191

How to replace 1000 different values in 250 files in a fast method?

by: serge | last post by:

I managed to put together C# code and have it do the following: 1- Get all the table names that start with the letter "Z" from sysobjects of my SQL 2000 database and put these table names inside an array variable. 2- Loop through each table name inside the array 1 to 1000 tables

C# / C Sharp

7675

Creating a time class - Homework

by: nono909 | last post by:

I wrote the following time class for the following assignment.i need help in completing this program pleasee. Write a class to hold time. Time is the hour, minute and seconds. Write a constructor that will allow the user of your class to initialize a time or set the time to all zeros if not initialized. Include all the operators listed above. Your program will need to read from a file of times and commands. There will be a number at the top...

C / C++

1781

problems creating lots of directories

by: Charlie Bear | last post by:

i'm really stuck with this one can anyone help! i have a website that uses c#. it creates a series of directories and files from an xml source. when the xml changes, the directory that the change applies to is deleted and recreated. All the children for that directory are also re created (as the parent directory then has a different name). the problem i have is that *sometimes* the files or directories don't get created. It either...

C# / C Sharp

2982

creating ManualResetEvent in thread

by: =?Utf-8?B?YmJn?= | last post by:

Hi all, I read somewhere "using kernel stuff in thread is not good.." if ManualResetEvent object is created in thread but not actually used, will it affect performance? Bob

C# / C Sharp

12801

Creating a script interpreter using C#

by: jkimbler | last post by:

As part of our QA of hardware and firmware for the company I work for, we need to automate some testing of devices and firmware. Since not everybody here knows C#, I'm looking to create a new scripting language that makes writing automated tests simpler. Really, I'm looking to kind of abstract the power of the C# language into a simpler language that's easier to learn. The script files would be interpreted by a script interpreter...

C# / C Sharp

8969

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9266

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9209

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8215

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6054

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4570

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3280

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2748

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2193

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General