 |
|
|
Show us the input...
Are you expecting there to be multiple DBPart, DBDocument, etc child nodes? 'Cause if not, the xsl:for-each loops really clutter things up...Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
Hi Stuart,
Thanks for the reply.
The input is quite large. I am working on trying to scale down a sample (and remove sensitive data).
The basic form of the input is:
DBArchive
DBAccount
DBFolder
DBFolder
DBFile
DBPart
DBDocument
There are one, two or three DBDocument nodes inside a DBPart node
My thinking at the moment is that the approach of the xsl is wrong and it should use templates more, but I have very little experience with this stuff and am trying to get my head around how xsl templates work. I assume that I need to get the DBDocument information first,and then go back and fill in the rest. I just don't know how to do that.
Cheers.
(I am in Queensland (Aus), so have gone home now.
|
|
|
|
|
|
|
If you can provide a sample, I'm quite happy to help you with your xsl. I've a fair amount of experience with XSL over the years  Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
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,
<!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>
|
|
|
|
|
|
|
Solved it (with a bit of xPath trickery).
The answer was to go to each file node and then back track through parent levels to get the other data.
<xsl:for-each select="DBAccount/DBFolder/DBFile/DBPart/DBDocument/DBVersion">
<File>
<Person>
<xsl:value-of select="../../../Title"/>
</Person>
<Title>
<xsl:value-of select="../Title"/>
</Title>
<BoxLocation>
<xsl:value-of select="../DBMetadataFieldValue/DBMetadataValue/Text"/>
</BoxLocation>
<FileName>
<xsl:value-of select="./ArchiveFileName"/>
</FileName>
<VersionNumber>
<xsl:value-of select="./Number"/>
</VersionNumber>
</File>
</xsl:for-each>
|
|
|
|
|
|
|
| Yeah - I'd was just looking at it and realising that you needed some way of determining what indicated unique files...which you've done... Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
I have a very large XMLDocument with 56,000 child records each having 8 child field elements. The application that i have written performs a complicated process on the XML. It can process 10,000 records in 5 minutes and 20,000 in 25 minutes (increases exponentially) but takes maybe 10 hours to process the 56,000 record (which is unacceptable). Whats the best way to de-batch this XML Document into bite size chunks (eg 10,000 and after 5 iteration will process 50,000. which will execute in 25-30 minutes processing time)
Thanks.
|
|
|
|
|
|
|
How many megabytes is your xml file?
Does the "complicated process" operate on
only one of the 56,000 children independantly,
without refferencing the other children ?
Show me a childNode and tell me about
this "complicated process".
How much free memory does your computer have available ?
|
|
|
|
|
|
|
There is a sample of the child record. And there are 56,000 of them in the xml document. I can realy give you the full details of what the complicated process is doing but part of it is using the Muenchian Method grouping on 'cost_centre' and 'expense_code'.
The app is runningon a dev box 2.50GH, 2GB.
It has 1/2GB free when app is not running
<Transaction>
<Entry>
<payroll_id>payroll_id_0</payroll_id>
<payroll_nm>payroll_nm_0</payroll_nm>
<payRunDate>payRunDate_0</payRunDate>
<payRunID>payRunID_0</payRunID>
<empno>10</empno>
<surname>surname_0</surname>
<forename>forename_0</forename>
<pos_ref>pos_ref_0</pos_ref>
<pos_name>pos_name_0</pos_name>
<element_id>element_id_0</element_id>
<element_name>element_name_0</element_name>
<cost_centre>c11</cost_centre>
<expense_code>e11</expense_code>
<debit_credit>debit_credit_0</debit_credit>
<amount>10</amount>
<signed_amount>10</signed_amount>
</Entry>
<Entry>
....
</Entry>
</Transaction>
|
|
|
|
|
|
|
Why is this invalid?
<xsl:choose>
<xsl:when test="position() mod 2 = 1">
<tr bgcolor="Silver">
</xsl:when>
<xsl:otherwise>
<tr>
</xsl:otherwise>
</xsl:choose>
...
</tr>
Internet Explorer reports the error "End tag 'xsl:when' does not match the start tag 'tr'"
|
|
|
|
|
|
|
The line:
<tr bgcolor="Silver">
is unclosed, so the next closing tag should be </tr> rather than </xsl:when>.txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
|
|
The previous answer told you why the error occurred - here's a solution:
<tr>
<xsl:if test="position() mod 2 = 1">
<xsl:attribute name="bgcolor">Silver</xsl:attribute>
</xsl:if>
...
</tr>Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
I am working on a project for a State Agency where the data is received from multiple private entities and loaded into SQL 2005 tables. The XML schema was designed and published before my involvement with the project and now it cannot be changed. One of the elements to receive (Charges) occurs multiple times within a client but each is for a different concept. Instead of using an attribute to identify the reason for the Charge, they used the element name to do it. For example:
<FERTILIZER_CHARGE>2300</FERTILIZER_CHARGE> -- 20 different charge types identified
instead of
<CHARGE TYPE=”FERTILIZER” AMOUNT=”2300” />
I need to move all the charges to a single table and identify each one with its type but cannot find any examples where the element name is used to update a column in a table. PLEASE HELP!!!
|
|
|
|
|
|
|
i just want to load one image to the picturebox, who's path is stored in xml file. please tell me how to do this.
GIve examples.
|
|
|
|
|
|
|
kpuneeth7 wrote: GIve examples
Without knowing a little about the structure of your XML file and what technology you're using, that would be difficult to do...
But it's simply a case of reading the XML file with an XML parser (think XmlReader in .NET), and finding the node containing the image file's path.
The rest of it (displaying the image in the picture box) is nothing to do with XML.Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
I am using a simple xml file.....
<image>
<img>
C:\Documents and Settings\Imran\Desktop\Picture\apple.jpg
</img>
</image>
And i am using visual studio 2008
C# language.
.net frameworkmodified on Wednesday, February 24, 2010 3:20 AM
|
|
|
|
|
|
|
Here's a short C# program that will read the bit of XML you want and write it to the console.
using System.Xml.XPath;
using System.IO;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string imagePath = new XPathDocument(new StreamReader(args[0])).CreateNavigator().SelectSingleNode("/image/img").Value;
System.Console.WriteLine(imagePath);
}
}
}
I've used XPath to navigate to the required element in the XML file (that's the .SelectSingleNode("/image/img") bit) and read the text there (the .Value bit). Simples.Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
Thanks for the code....
BUt its giving indexoutofrange exception......
HElp
|
|
|
|
|
|
|
| You need to give a command line argument that specifies the XML file...the code comments DO say that.... Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
Thanks dude.....
I got it
Thank u very much
|
|
|
|
|
|
|
I have the following input XML. I want to group all unique Code/ID combination.
<List>
<Section>
<Code>AA</Code>
<ID>11</ID>
<Section>
<Section>
<Code>AA</Code>
<ID>11</ID>
<Section>
<Section>
<Code>CC</Code>
<ID>11</ID>
<Section>
<Section>
<Code>AA</Code>
<ID>22</ID>
<Section>
<Section>
<Code>AA</Code>
<ID>11</ID>
<Section>
<List>
So result should be as shown below.
<Code>AA</Code>
<ID>11</ID>
<Code>CC</Code>
<ID>11</ID>
<Code>AA</Code>
<ID>22</ID>
Im using the Muenchian Method. Currely my XSL (below) is grouping by Code (and not Code/ID combination)
<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var" version="1.0" xmlns:ns0="http://A4C.Interface.HRP.Payroll.Schemas">
<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
<xsl:key name="CCids" match="/List/Section" use="Code"/>
<xsl:template match="/">
<xsl:apply-templates select="/ns0:Payroll" />
</xsl:template>
<xsl:template match="/ns0:Payroll">
<ns0:List>
<xsl:for-each select="/List/Section [generate-id(.)=generate-id(key('CCids',Code))]">
<Section>
<Code>
<xsl:value-of select="code/text()" />
</Code>
<ID>
<xsl:value-of select="id/text()" />
</ID>
</Section>
</xsl:for-each>
</ns0:List>
</xsl:template>
</xsl:stylesheet>
How do i get this to use a Code/ID combination? I tried nested for-each loop but no luck. Thanksmodified on Tuesday, February 23, 2010 11:40 AM
|
|
|
|
|
|
|
Firstly, your key needs to have an expression which reflects what you want to retrieve:
<xsl:key name="CCids" match="/List/Section" use="concat(Code,'|',ID)"/>
And then you need to use that same expression when accessing items referenced by the key.
Oh - and in addition, I would suggest not using a for loop - it's not idiomatic XSL. Here's the file I'd use:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var" version="1.0" xmlns:ns0="http://A4C.Interface.HRP.Payroll.Schemas">
<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" encoding="utf-8"/>
<xsl:key name="CCids" match="/List/Section" use="concat(Code,'|',ID)"/>
<xsl:template match="/">
<ns0:List>
<xsl:apply-templates select="/List/Section [generate-id(.)=generate-id(key('CCids',concat(Code,'|',ID)))]"/>
</ns0:List>
</xsl:template>
<xsl:template match="Section">
<Section>
<Code>
<xsl:value-of select="Code/text()" />
</Code>
<ID>
<xsl:value-of select="ID/text()" />
</ID>
</Section>
</xsl:template>
</xsl:stylesheet>Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
|
|
Thanks..Really helpful 
|
|
|
|
|
|
|
Hi,
I am getting this error There is an error in XML document (1, 2)
When i Deserialize following Xml.
<EnvironmentConfigurations>
<EnvironmentConfiguration>
<EnvironmentName>ABC</EnvironmentName>
<CMSConfiguration>
<Address>net.tcp://localhost:9000/Manager</Address>
<Binding>netTcpBinding</Binding>
<Contract>Common.Interfaces.Server</Contract>
</CMSConfiguration>
</EnvironmentConfiguration>
<EnvironmentConfiguration>
<EnvironmentName>XYZ</EnvironmentName>
<CMSConfiguration>
<Address>net.tcp://localhost:9000/Manager</Address>
<Binding>netTcpBinding</Binding>
<Contract>Common.Interfaces.Server</Contract>
</CMSConfiguration>
</EnvironmentConfiguration>
</EnvironmentConfigurations>modified on Tuesday, February 23, 2010 5:11 AM
|
|
|
|
|
|
|
Deserialize to what? The way in which it's deserialized depends on the type you think it is.
Are you sure this was serialized from .NET? That's not the only way to read and write XML, you know - maybe you should be using an XMLReader and parsing the XML yourself?Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Rant 
Admin