Click here to Skip to main content
15,880,392 members
Home / Discussions / XML / XSL
   

XML / XSL

 
AnswerRe: VS2005 doesn't like my XML Schema Pin
gritter3-Mar-10 6:41
gritter3-Mar-10 6:41 
AnswerRe: VS2005 doesn't like my XML Schema Pin
Stuart Dootson6-Mar-10 4:58
professionalStuart Dootson6-Mar-10 4:58 
GeneralRe: xml code editor Pin
Covean2-Mar-10 22:21
Covean2-Mar-10 22:21 
QuestionMultiple children in Node question Pin
RCoate1-Mar-10 20:04
RCoate1-Mar-10 20:04 
AnswerRe: Multiple children in Node question Pin
Stuart Dootson1-Mar-10 21:02
professionalStuart Dootson1-Mar-10 21:02 
GeneralRe: Multiple children in Node question Pin
RCoate1-Mar-10 21:56
RCoate1-Mar-10 21:56 
GeneralRe: Multiple children in Node question Pin
Stuart Dootson1-Mar-10 22:04
professionalStuart Dootson1-Mar-10 22:04 
GeneralRe: Multiple children in Node question Pin
RCoate2-Mar-10 11:16
RCoate2-Mar-10 11:16 
OK, here is a simplified version of the input xml.
I have removed data from nodes I am not interested in, but left the nodes so you can get a feel for the structure.
There are two records (DBFile nodes) here - the first one has a single file, the second has two files (i.e. 2 DBDocument nodes).

Person 2 should end up with two records - one for File 2 and one for File 3.

Cheers, Smile | :)

<!DOCTYPE DBArchive SYSTEM "http://support.docbanq.com/DTDs/DocBanqArchive_Version2.dtd">
<DBArchive>
	<ArchiveVersion attrname="String"></ArchiveVersion>
	<DBAccount attrname="Account">
		<Name attrname="String"></Name>
		<Identifier attrname="String"></Identifier>
		<Number attrname="Integer"></Number>
		<DBFolder attrname="Content">
			<DBIdentifier attrname="Identifier">
				<Value attrname="String"></Value>
			</DBIdentifier>
			<MaximumVersions attrname="Integer"/>
			<InheritPermission attrname="Boolean"></InheritPermission>
			<HideFromUnprivilegedUser attrname="Boolean"/>
			<Description attrname="String"></Description>
			<Title attrname="String"></Title>
			<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
			<DBAccountUser attrname="CreatedBy">
				<LoginID attrname="String"></LoginID>
			</DBAccountUser>
			<CreatedDateTime attrname="Datetime"></CreatedDateTime>
			<ObjectID attrname="Identifier"></ObjectID>
			<DBFolder attrname="Object">
				<DBIdentifier attrname="Identifier">
					<Value attrname="String"></Value>
				</DBIdentifier>
				<MaximumVersions attrname="Integer"/>
				<InheritPermission attrname="Boolean"></InheritPermission>
				<HideFromUnprivilegedUser attrname="Boolean"/>
				<Description attrname="String"></Description>
				<Title attrname="String"></Title>
				<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
				<DBAccountUser attrname="CreatedBy">
					<LoginID attrname="String"></LoginID>
				</DBAccountUser>
				<CreatedDateTime attrname="Datetime"></CreatedDateTime>
				<ObjectID attrname="Identifier"></ObjectID>
				<DBFile attrname="Object">
					<DBIdentifier attrname="Identifier">
						<Value attrname="String"></Value>
					</DBIdentifier>
					<DisposalScheduleSet attrname="Date"></DisposalScheduleSet>
					<ActionDate attrname="Date"></ActionDate>
					<DisposalAction attrname="String"></DisposalAction>
					<Description attrname="String"></Description>
					<Title attrname="String">Person Name 1</Title>
					<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
					<DBAccountUser attrname="CreatedBy">
						<LoginID attrname="String"></LoginID>
					</DBAccountUser>
					<CreatedDateTime attrname="Datetime"></CreatedDateTime>
					<ObjectID attrname="Identifier"></ObjectID>
					<DBPart attrname="Object">
						<Number attrname="Integer"></Number>
						<ContentFrom attrname="Date"/>
						<ContentTo attrname="Date"/>
						<PhysicallyExists attrname="Boolean"></PhysicallyExists>
						<DBParticipant attrname="BorrowedBy"/>
						<DBParticipant attrname="Custodian"/>
						<DBLocation attrname="Location"/>
						<DBRecordStatus attrname="Status">
							<Value attrname="String"></Value>
						</DBRecordStatus>
						<ActionedDateTime attrname="Datetime"></ActionedDateTime>
						<DBAccountUser attrname="ActionedBy">
							<LoginID attrname="String"></LoginID>
						</DBAccountUser>
						<Description attrname="String"></Description>
						<Title attrname="String"></Title>
						<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
						<DBAccountUser attrname="CreatedBy">
							<LoginID attrname="String"></LoginID>
						</DBAccountUser>
						<CreatedDateTime attrname="Datetime"></CreatedDateTime>
						<ObjectID attrname="Identifier"></ObjectID>
						<DBDocument attrname="Object">
							<DBUser attrname="CheckedOutBy"/>
							<CheckedOutDateTime attrname="Datetime"/>
							<CheckedOutReason attrname="String"></CheckedOutReason>
							<DBIdentifier attrname="Identifier">
								<Value attrname="String"></Value>
							</DBIdentifier>
							<Title attrname="String">Title 1</Title>
							<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
							<DBAccountUser attrname="CreatedBy">
								<LoginID attrname="String"></LoginID>
							</DBAccountUser>
							<CreatedDateTime attrname="Datetime"></CreatedDateTime>
							<ObjectID attrname="Identifier"></ObjectID>
							<Description attrname="String"></Description>
							<DBMetadataFieldValue attrname="MetadataFieldValue">
								<DBMetadataField attrname="MetadataField">
									<FieldName attrname="String">Box Location</FieldName>
									<Type attrname="String"></Type>
									<Rule attrname="String"></Rule>
								</DBMetadataField>
								<DBMetadataValue attrname="MetadataValue">
									<Text attrname="String">Location 1</Text>
									<Date attrname="Date"/>
									<DBParticipant attrname="Participant"/>
								</DBMetadataValue>
							</DBMetadataFieldValue>
							<DBVersion attrname="Version">
								<ArchiveFileName attrname="String">File Name 1</ArchiveFileName>
								<Number attrname="Integer">Version 1</Number>
								<FileExtension attrname="String"></FileExtension>
								<FileAvailable attrname="Boolean"></FileAvailable>
								<PhysicalSpaceUsage attrname="Integer"></PhysicalSpaceUsage>
								<CreatedDateTime attrname="Datetime"></CreatedDateTime>
								<DBAccountUser attrname="CreatedBy">
									<LoginID attrname="String"></LoginID>
								</DBAccountUser>
								<Comments attrname="String"></Comments>
								<IndexString attrname="String"></IndexString>
							</DBVersion>
						</DBDocument>
					</DBPart>
				</DBFile>
				<DBFile attrname="Object">
					<DBIdentifier attrname="Identifier">
						<Value attrname="String"></Value>
					</DBIdentifier>
					<DisposalScheduleSet attrname="Date"></DisposalScheduleSet>
					<ActionDate attrname="Date"></ActionDate>
					<DisposalAction attrname="String"></DisposalAction>
					<Description attrname="String"></Description>
					<Title attrname="String">Person Name 2</Title>
					<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
					<DBAccountUser attrname="CreatedBy">
						<LoginID attrname="String"></LoginID>
					</DBAccountUser>
					<CreatedDateTime attrname="Datetime"></CreatedDateTime>
					<ObjectID attrname="Identifier"></ObjectID>
					<DBPart attrname="Object">
						<Number attrname="Integer"></Number>
						<ContentFrom attrname="Date"/>
						<ContentTo attrname="Date"/>
						<PhysicallyExists attrname="Boolean"></PhysicallyExists>
						<DBParticipant attrname="BorrowedBy"/>
						<DBParticipant attrname="Custodian"/>
						<DBLocation attrname="Location"/>
						<DBRecordStatus attrname="Status">
							<Value attrname="String"></Value>
						</DBRecordStatus>
						<ActionedDateTime attrname="Datetime"></ActionedDateTime>
						<DBAccountUser attrname="ActionedBy">
							<LoginID attrname="String"></LoginID>
						</DBAccountUser>
						<Description attrname="String"></Description>
						<Title attrname="String"></Title>
						<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
						<DBAccountUser attrname="CreatedBy">
							<LoginID attrname="String"></LoginID>
						</DBAccountUser>
						<CreatedDateTime attrname="Datetime"></CreatedDateTime>
						<ObjectID attrname="Identifier"></ObjectID>
						<DBDocument attrname="Object">
							<DBUser attrname="CheckedOutBy"/>
							<CheckedOutDateTime attrname="Datetime"/>
							<CheckedOutReason attrname="String"></CheckedOutReason>
							<DBIdentifier attrname="Identifier">
								<Value attrname="String"></Value>
							</DBIdentifier>
							<Title attrname="String">Title 2</Title>
							<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
							<DBAccountUser attrname="CreatedBy">
								<LoginID attrname="String"></LoginID>
							</DBAccountUser>
							<CreatedDateTime attrname="Datetime"></CreatedDateTime>
							<ObjectID attrname="Identifier"></ObjectID>
							<Description attrname="String"></Description>
							<DBMetadataFieldValue attrname="MetadataFieldValue">
								<DBMetadataField attrname="MetadataField">
									<FieldName attrname="String">Box Location</FieldName>
									<Type attrname="String"></Type>
									<Rule attrname="String"></Rule>
								</DBMetadataField>
								<DBMetadataValue attrname="MetadataValue">
									<Text attrname="String">Location 2</Text>
									<Date attrname="Date"/>
									<DBParticipant attrname="Participant"/>
								</DBMetadataValue>
							</DBMetadataFieldValue>
							<DBVersion attrname="Version">
								<ArchiveFileName attrname="String">File Name 2</ArchiveFileName>
								<Number attrname="Integer">Version 2</Number>
								<FileExtension attrname="String"></FileExtension>
								<FileAvailable attrname="Boolean"></FileAvailable>
								<PhysicalSpaceUsage attrname="Integer"></PhysicalSpaceUsage>
								<CreatedDateTime attrname="Datetime"></CreatedDateTime>
								<DBAccountUser attrname="CreatedBy">
									<LoginID attrname="String"></LoginID>
								</DBAccountUser>
								<Comments attrname="String"></Comments>
								<IndexString attrname="String"></IndexString>
							</DBVersion>
						</DBDocument>
						<DBDocument attrname="Object">
							<DBUser attrname="CheckedOutBy"/>
							<CheckedOutDateTime attrname="Datetime"/>
							<CheckedOutReason attrname="String"></CheckedOutReason>
							<DBIdentifier attrname="Identifier">
								<Value attrname="String"></Value>
							</DBIdentifier>
							<Title attrname="String">Title 3</Title>
							<SpaceUsageKB attrname="Integer"></SpaceUsageKB>
							<DBAccountUser attrname="CreatedBy">
								<LoginID attrname="String"></LoginID>
							</DBAccountUser>
							<CreatedDateTime attrname="Datetime"></CreatedDateTime>
							<ObjectID attrname="Identifier"></ObjectID>
							<Description attrname="String"></Description>
							<DBMetadataFieldValue attrname="MetadataFieldValue">
								<DBMetadataField attrname="MetadataField">
									<FieldName attrname="String">Box Location</FieldName>
									<Type attrname="String"></Type>
									<Rule attrname="String"></Rule>
								</DBMetadataField>
								<DBMetadataValue attrname="MetadataValue">
									<Text attrname="String">Location 3</Text>
									<Date attrname="Date"/>
									<DBParticipant attrname="Participant"/>
								</DBMetadataValue>
							</DBMetadataFieldValue>
							<DBVersion attrname="Version">
								<ArchiveFileName attrname="String">File Name 3</ArchiveFileName>
								<Number attrname="Integer">Version 3</Number>
								<FileExtension attrname="String"></FileExtension>
								<FileAvailable attrname="Boolean"></FileAvailable>
								<PhysicalSpaceUsage attrname="Integer"></PhysicalSpaceUsage>
								<CreatedDateTime attrname="Datetime"></CreatedDateTime>
								<DBAccountUser attrname="CreatedBy">
									<LoginID attrname="String"></LoginID>
								</DBAccountUser>
								<Comments attrname="String"></Comments>
								<IndexString attrname="String"></IndexString>
							</DBVersion>
						</DBDocument>
					</DBPart>
				</DBFile>
			</DBFolder>
		</DBFolder>
	</DBAccount>
</DBArchive>

AnswerRe: Multiple children in Node question Pin
RCoate2-Mar-10 19:35
RCoate2-Mar-10 19:35 
GeneralRe: Multiple children in Node question Pin
Stuart Dootson2-Mar-10 21:46
professionalStuart Dootson2-Mar-10 21:46 
QuestionHow to de-batch very large XMLDocument into bit size chunks Pin
ONeil Tomlinson28-Feb-10 7:39
ONeil Tomlinson28-Feb-10 7:39 
AnswerRe: How to de-batch very large XMLDocument into bit size chunks Pin
daveyerwin28-Feb-10 8:44
daveyerwin28-Feb-10 8:44 
GeneralRe: How to de-batch very large XMLDocument into bit size chunks Pin
ONeil Tomlinson1-Mar-10 6:33
ONeil Tomlinson1-Mar-10 6:33 
QuestionUnclosed tr tag Pin
John Jones II26-Feb-10 4:35
John Jones II26-Feb-10 4:35 
AnswerRe: Unclosed tr tag Pin
Richard MacCutchan26-Feb-10 5:23
mveRichard MacCutchan26-Feb-10 5:23 
AnswerRe: Unclosed tr tag Pin
Stuart Dootson26-Feb-10 7:45
professionalStuart Dootson26-Feb-10 7:45 
QuestionXML schema - Element name used to identify item problem... - need to use the element name to identify value when importing into SQL 2005 tables Pin
VicarH25-Feb-10 7:37
VicarH25-Feb-10 7:37 
QuestionDisplay a image in picturebox Pin
kpuneeth723-Feb-10 20:36
kpuneeth723-Feb-10 20:36 
AnswerRe: Display a image in picturebox Pin
Stuart Dootson23-Feb-10 20:50
professionalStuart Dootson23-Feb-10 20:50 
GeneralRe: Display a image in picturebox [modified] Pin
kpuneeth723-Feb-10 21:01
kpuneeth723-Feb-10 21:01 
GeneralRe: Display a image in picturebox Pin
Stuart Dootson23-Feb-10 21:36
professionalStuart Dootson23-Feb-10 21:36 
GeneralRe: Display a image in picturebox Pin
kpuneeth723-Feb-10 23:53
kpuneeth723-Feb-10 23:53 
GeneralRe: Display a image in picturebox Pin
Stuart Dootson24-Feb-10 0:08
professionalStuart Dootson24-Feb-10 0:08 
GeneralRe: Display a image in picturebox Pin
kpuneeth724-Feb-10 1:26
kpuneeth724-Feb-10 1:26 
QuestionMultiple group using Muenchian Method [modified] Pin
ONeil Tomlinson23-Feb-10 4:15
ONeil Tomlinson23-Feb-10 4:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.