XML / XSL Discussion Boards

Thanks a lot Erik! This is exactly what I want.

I happened to get another solution, I posted here for the benefits of others:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:itpc="http://iptc.org/std/nar/2006-10-01/">
	<xsl:output method="xml" indent="yes" encoding="utf-8"/>
	<xsl:template match="/itpc:newsMessage">
		<MyData>
			<MyTransmitId>
				<xsl:value-of
                select="itpc:header/itpc:transmitId"/>
			</MyTransmitId>
			<MyHeadline>
				<xsl:value-of
                select="itpc:itemSet/itpc:newsItem/itpc:contentMeta/itpc:headline"/>
			</MyHeadline>
			<MyContent>
				<xsl:copy-of
                select="itpc:itemSet/itpc:newsItem/itpc:contentSet/itpc:inlineXML/*"/>
			</MyContent>
		</MyData>
	</xsl:template>
</xsl:stylesheet>

I would like to write queries over an XML data set using the XQuery language virsion 1.0 or 2.0
and generate single XML output file for the following xml files :

authors.xml

<br />
<authors><br />
<author><br />
<name>AMADEO, Giovanni Antonio</name><br />
<born-died>b. ca. 1447, Pavia, d. 1522, Milano</born-died><br />
<nationality>Italian</nationality><br />
<biography> Giovanni Antonio Amadeo was an Italian early Renaissance sculptor, architect, and engineer..</biography><br />
</author><br />
</authors><br />

---------------------------------
artworks.xml

<br />
<artworks><br />
<artwork><br />
<title> Fade of the church </title><br />
<author> AMADEO, Giovanni Antonio </author><br />
<date>1473</date><br />
<technique> Marble <technique><br />
<location> Certosa, Pavia </location><br />
<form> architecture </form><br />
<type>religious</type><br />
</artwork><br />
</artworks><br />

----------------------------------

Sample for the expected output :

output.xml

<br />
<authors><br />
<author><br />
<name>AMADEO, Giovanni Antonio</name><br />
<born-died>b. ca. 1447, Pavia, d. 1522, Milano</born-died><br />
<nationality>Italian</nationality><br />
<biography>Giovanni Antonio Amadeo was an Italian early Renaissance sculptor, architect, and engineer..</biography><br />
<artworks form="architecture"><br />
<artwork date="1473"><br />
<title>Fade of the church</title><br />
<technique>Marble</technique><br />
<location>Certosa, Pavia</location><br />
</artwork><br />
</artworks><br />
</authors><br />

I would like to merge these two XML documents and create a new XML file, in which the following information should be stored for each author: name, born-died, nationality,biography, and all artworks. The artworks are grouped by form and then sorted on date. For each artwork, title, technique, and location are stored.

thank you .
Edit/Delete Message

And what exactly is your question?

I have two xml files "authors.xml" and "artworks.xml"
I want to write queries over the XML data set in a file "combine.xq" using the XQuery language virsion 1.0 or 2.0
and generate single XML output file "output.xml" .

Thanks

Neno99 wrote:
I want to write queries over the XML data set

So, once again, what is your problem or question?

The best things in life are not things.

You already told us what you want to do.

That is not a question.

If you want someone to write the entire solution for you then you should ask that. Someone might do it. Or not.

Hi can anyone tell me, how to bind a data to class objects from a list, so that i can pass it in xml request..

here is my code in xsd generated class.

public partial class SetValue
    {

        private string dANameField;

        private string dAIDField;

        private SetValueType setValueTypeField;

        /// <remarks/>
        public string DAName
        {
            get
            {
                return this.dANameField;
            }
            set
            {
                this.dANameField = value;
            }
        }

        /// <remarks/>
        public string DAID
        {
            get
            {
                return this.dAIDField;
            }
            set
            {
                this.dAIDField = value;
            }
        }

        /// <remarks/>
        public SetValueType SetValueType
        {
            get
            {
                return this.setValueTypeField;
            }
            set
            {
                this.setValueTypeField = value;
            }
        }
    }

    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true, Namespace = "http://xml.abc.com/ns/msjava/lrm")]
    [System.Xml.Serialization.XmlRootAttribute(Namespace = "http://xml.abc.com/ns/msjava/lrm", IsNullable = false)]
    public partial class SetValueType
    {

        private string valueTypeIDField;

        private string valueTypeField;

        private string valueField;

        private Function functionField;

        private Field fieldField;

        /// <remarks/>
        public string ValueTypeID
        {
            get
            {
                return this.valueTypeIDField;
            }
            set
            {
                this.valueTypeIDField = value;
            }
        }

        /// <remarks/>
        public string ValueType
        {
            get
            {
                return this.valueTypeField;
            }
            set
            {
                this.valueTypeField = value;
            }
        }

        /// <remarks/>
        public string Value
        {
            get
            {
                return this.valueField;
            }
            set
            {
                this.valueField = value;
            }
        }

        /// <remarks/>
        public Function Function
        {
            get
            {
                return this.functionField;
            }
            set
            {
                this.functionField = value;
            }
        }

        /// <remarks/>
        public Field Field
        {
            get
            {
                return this.fieldField;
            }
            set
            {
                this.fieldField = value;
            }
        }
               
    }

here i have to do something, so that i can add the data in this list to class type(SetValueType), so that later i will convert it into xml format..

 SetValue DAESetvalue = new SetValue
            {
                DAID=oSetValue.DAID,
                DAName=oSetValue.DAName
            };
            DADirective.SetValue = DAESetvalue;

List<SetValueType> SetValueTypeList = new List<SetValueType>();
GetValueTypeCondition(gValueTypeCondition,SetValueTypeList);
public void GetValueTypeCondition(Grid gValueTypeCondition,List<SetValueType> SetValueTypeList)
        {
            int rowcount = 0;
            if (gValueTypeCondition.RowDefinitions != null)
                rowcount = gValueTypeCondition.RowDefinitions.Count;
            for (int i = 0; i < rowcount; i++)
            {
                SetValueType oSetValueType = new SetValueType();                
               // bool isValueType = false;
                foreach (UIElement element in gValueTypeCondition.Children.Cast<UIElement>().Where(element => Grid.GetRow(element) == i))
                {
                    if (element is ComboBox)
                    {
                       // isValueType = true;
                        ComboBox cbvaluetype = (ComboBox)element;

                        if (cbvaluetype.Uid != null)
                        {
                          Object obj = ((ComboBoxItem)(cbvaluetype.SelectedItem)).Tag;
                            if (obj != null)
                            {                              
                                if (cbvaluetype.Uid == DataKey.FUNCTION_KEY)
                                {
                                    DAFunction dafunction = (DAFunction)obj;
                                    oSetValueType.ValueTypeID = "2";
                                    oSetValueType.ValueType = "Function";

                                    oSetValueType.Function.FunctionID = dafunction.FunctionID;
                                    oSetValueType.Function.FunctionName = dafunction.FunctionName;
                                    oSetValueType.Function.DataType1 = dafunction.DataType1;
                                    oSetValueType.Function.DataType2 = dafunction.DataType2;
                                    oSetValueType.Function.DataType3 = dafunction.DataType3;
                                }
                                else if (cbvaluetype.Uid == DataKey.COLUMN_CONDITION_KEY)
                                {
                                    DAColumn dacobj = (DAColumn)obj;
                                    oSetValueType.ValueTypeID = "3";
                                    oSetValueType.ValueType = "Field";
                                    oSetValueType.Field.FieldID = dacobj.id;
                                    oSetValueType.Field.FieldValue = dacobj.name;
                                }
                            }
                        }
                    }
                    else if (element is TextBox)
                    {
                        TextBox txtValueType = (TextBox)element;
                        switch (txtValueType.Uid)
                        {
                            case DataKey.TEXT_VALUE_KEY:
                                oSetValueType.ValueTypeID = "1";
                                oSetValueType.ValueType = "Value";
                                oSetValueType.Value = txtValueType.Text.Replace("_", "").Trim();
                                break;
                            case DataKey.TEXT_FUNCTION_VALUE_KEY:
                                oSetValueType.Function.FunctionValue = txtValueType.Text.Replace("_", "").Trim();                                
                                break;
                        }
                    }
                }
                //if (isValueType)
                    SetValueTypeList.Add(oSetValueType);
            }
        }

so any help like how to do it...

If I understand the question.

You have a XSD which represent a type X.

You want to to create XML that has a list of X values.

That of course is invalid in terms of the XSD. By definition the XSD does not define a list so it cannot include a list.

So your choice are change the XSD, use a different XSD or don't use a list (as a single XML production.)

Dear all,

In my application i have an XML like this..
I want to perform a search in this XML Based on SubID, ModuleId, TaskName, between start and end dates. Please help me. Also i need all the parents of the searched nodes without siblings.

<Tasks>
<Task TaskId=1 PId=0 SubId=0 ModuleId=0 TaskName="Task 1" StartDate="1 Apr 2011" EndDate="12 Apr 2011">
	<Task TaskId=2 PId=1 SubId=0 ModuleId=0 TaskName="Task 2" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
	<Task TaskId=3 PId=1 SubId=0 ModuleId=0 TaskName="Task 3" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
	<Task TaskId=4 PId=1 SubId=0 ModuleId=0 TaskName="Task 4" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
	<Task TaskId=5 PId=1 SubId=1 ModuleId=0 TaskName="Task 5" StartDate="1 Apr 2011" EndDate="12 Apr 2011">
		<Task TaskId=6 PId=5 SubId=0 ModuleId=0 TaskName="Task 6" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
		<Task TaskId=7 PId=5 SubId=0 ModuleId=0 TaskName="Task 7" StartDate="1 Apr 2011" EndDate="12 Apr 2011">
			<Task TaskId=8 PId=7 SubId=0 ModuleId=0 TaskName="Task 8" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
		</Task>
		<Task TaskId=9 PId=5 SubId=0 ModuleId=0 TaskName="Task 9" StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
	</Task>
	<Task TaskId=10 PId=1 SubId=0 ModuleId=0 TaskName="Task 10"  StartDate="1 Apr 2011" EndDate="12 Apr 2011"/>
</Task>
</Tasks>

Please help

Regards,
DJ

I am not answering your entire question, but I have a thought about one component of it:

Do you have any control over the date format of the initial XML that is provided to you?

If you were to receive the date values in ISO format (YYYY-MM-DD), then you could use a simple string comparison (greater than or less than) in your xpath or xsl to determine whether the dates fall in date ranges.

--Greg

OK, I posted another XPath query a few days ago and you might think that by now I should have figured this stuff out a little better, but...

I need to retrieve the ts_value from the following XML snippet where the ts_date is a specific value. The document is:

<timeSeries>
		<ts><ts_date>2010-06-30</ts_date><ts_value>1.235648</value></ts>
		<ts><ts_date>2010-07-31</ts_date><ts_value>564654.235648</value></ts>
		<ts><ts_date>2010-08-31</ts_date><ts_value>5465465.235648</value></ts>
		<ts><ts_date>2010-09-30</ts_date><ts_value>952031.235648</value></ts>
	</timeSeries>

I'm trying to follow the xpath syntax I've seen on the web as much as possible.

/timeSeries/ts[ts_date='2010-09-30']

But I'm getting no results.

Anyone?

Smokie, this is not 'Nam. This is bowling. There are rules.
www.geticeberg.com

Got it!

Here is the XPath to retrieve the ts_value for the particular ts_date node :

C#

String xPath = "/timeSeries/ts[ts_date='2010-06-30']/ts_value";

Your xpath will return the whole node "ts" node. To get to the "ts_value" node, you have to add this : /ts_value.

and then retrieve its value :

C#

XmlNode node = xmlDoc.SelectSingleNode(xPath);
String nodeValue = node.InnerText;

Hope it helped! Smile | :)

People with high attitude deserve the standing ovation of our highest finger!

My Blog![^]

Nice one!! I think I was trying to be too iterative; the parser was returning null because I wasn't selecting the ts_value to return.

Cheers!

Smokie, this is not 'Nam. This is bowling. There are rules.
www.geticeberg.com

Heeeeelp please,

I have problems to build my own xsd file.
I need to create tags xsd for these tags xml:

<Condition>
<Value Vtype=“Color”>

<List Value=“RE|GB=Red;FR=Rouge"/>
<List Value=“BL|GB=Blue;FR=Bleu"/>
<List Value=“BK|GB=Black;FR=Noir"/>
</Value>
<Value Vtype=“Form”>

<List Value=“RE|GB=Rectangel;FR=Rectangle"/>
<List Value=“CI|GB=Circle;FR=Cercle"/>
</Value>
</Condition>

what i want is to link Tags 1 to value of attribute type of elemt Value.
example: if i have in XML

<Value Vtype=“Color”>

it should be followed by Tags_1 not Tags_2 and reverse.

I would like to know how to do that too - although I have a sneaky feeling it can't be done

I wrote a small .Net app that validates an XML with an XSD.
It looks like it is working, until I did the following below.

the XML is validated although the attribute is restricted to 8 chars.
What could I be doing wrong?

many thanks.

[Solved]
like this:

public static void Validate(string xml_file, string xsd_file, string xmlnamespace){
    schemaexception = null;
    validationexception = null;
    XmlReader reader  = null;
    XmlReaderSettings xmlreadersettings = new XmlReaderSettings();
    XmlSchemaSet myschema = new XmlSchemaSet();
    try{
        xmlreadersettings.Schemas.Add(xmlnamespace, xsd_file);
        xmlreadersettings.ValidationType = ValidationType.Schema;
        xmlreadersettings.ValidationEventHandler += new ValidationEventHandler(xmlreadersettings_ValidationEventHandler);
        reader = XmlReader.Create(xml_file, xmlreadersettings);
        while(reader.Read());
    }                                               //end try
    catch (XmlException XmlExp){
        schemaexception = XmlExp;
    }                                               //end catch
    catch(XmlSchemaException XmlSchExp){
        schemaexception = XmlSchExp;
    }                                               //end catch
    catch(Exception GenExp){
        schemaexception = GenExp;
    }                                               //end catch
    finally{
        reader.Close();
    }                                               //end finally
}

[/Solved]

[EDIT]I found an online tool dat also validates the xml against the xsd and that seems to work. it even says what the exact error is. I'll have to have a look at the .Net code. If anyone has a good article about it, let me know. (I'll also, of course, search for myself)[/EDIT]

xml

<MyCode value="abcdefSSSgh"/>

xsd

<xs:element name="MyCode" minOccurs="1">
  <xs:complexType>
    <xs:attribute name="value" use="required">
      <xs:simpleType>
        <xs:restriction base="xs:string">
          <xs:length value="8"/>
        </xs:restriction>
      </xs:simpleType>
    </xs:attribute>
  </xs:complexType>
</xs:element>

.Net code

public static Exception Validate(string xml_file, string xsd_file, string xmlnamespace){
    Exception xmlexception = null;
    XmlReader reader  = null;
    XmlSchemaSet myschema = new XmlSchemaSet();
    try{
        reader = XmlReader.Create(xml_file);
        myschema.Add(xmlnamespace, xsd_file);
        reader.Settings.Schemas.Add(myschema);
        while (reader.Read());
    }                                               //end try
    catch (XmlException XmlExp){
        xmlexception = XmlExp;
    }                                               //end catch
    catch(XmlSchemaException XmlSchExp){
        xmlexception = XmlSchExp;
    }                                               //end catch
    catch(Exception GenExp){
        xmlexception = GenExp;
    }                                               //end catch
    finally{
        reader.Close();
    }
    return xmlexception;

V.

modified on Friday, March 25, 2011 6:07 AM

I have just downloaded the Codegenerator add in to LiquidStudio.

I'm underwhelmed. It doesnt appear to give me anything more than I get when I run the scheme through the Visual Studio add in XSD.EXE

Am I missing something?

Ger

Hello
I am new to this world and perhaps starting at the wrong end. Anyway. I am developing a web shop. I want to display product information from another source that I have access to. That source is in xml file format.
my question is: How can I do display the data from another source on my web side?

Hope someone can help.
Thank you
Halldor

1. Get the xml
2. Parse it
3. Create something from that appropriate to your site (consumable by the rest of your site)
4. Pass that off to the rest of your site.

More precise details depends on more precise details of the xml and your site.

Thank you jschell
I am a little bit closer to what to do. I am trying to build a web shop (with out the cart and the check out functon) and need to display the data on my web site. I have few question´s:

1. Is the XML a separate file stored at my server or is the xml integrated in the xml?
2. Can I use html to display the data in the xml or is java or css necessary?

Thank you
Halldor

Halldor

Hi,
I have this code to generate xml file;

XmlTextWriter				myXmlTextWriter = new XmlTextWriter ("D:/New Folder/MyXmlff.xml",System.Text.Encoding.UTF8);
		      myXmlTextWriter.Formatting = Formatting.Indented;
			  myXmlTextWriter.WriteStartDocument(false);
			  myXmlTextWriter.WriteStartElement("root");
			  myXmlTextWriter.WriteAttributeString("xmlns","urn:iso:std:iso:20022:tech:xsd:pain.001.001.02"); 
			  myXmlTextWriter.WriteStartElement("pain.001.001.02");
                          myXmlTextWriter.WriteComment("Section A : Group Header");
		          myXmlTextWriter.WriteStartElement("GrpHdr");
		          myXmlTextWriter.WriteStartElement("MsgId");
myXmlTextWriter.Flush();
            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.WriteEndElement();
			myXmlTextWriter.Close();

the problem is the attribute of the root appears always in other tags like this:

<root xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">
<pain.001.001.02>
<salarié xmlns="A01">

<grphdr>
<msgid>
<credttm xmlns="25/02/2011 04:50:31">
<btchbookg xmlns="True">
<nboftxs xmlns="1">
<ctrlsum xmlns="100">
<grpg>
<initgpty>
</Salarié>
</pain.001.001.02>
</root>
but i want that xmlns appears ONLY as an attribute of the root like this:

<document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.02">

<pain.001.001.02>

<grphdr>

<msgid>FVIR/101230/1

<credttm>2010-12-30T17:02:21

thank u for u help
hugs
<btchbookg>false

I assume this is a small fragment of your code, not the entire body of the method. Does the number of calls to WriteEndElement in your program match the number of calls to WriteStartElement?

I have an algorithm to parse a complex XML document using DOM via a recursive 'Navigate' function. Values are ultimately displayed on a form. New nddes are added to the document by supplying a ancestry list to a 'Create node' function, while nodes are updated by making use of Xpath.

Sounds very good but I dont like it because of all the hardcoded nodenames.

Now I have taken the corresponding XSD and laundered it through XSD.EXE to give me a set of classes that correspond to the XML document.

I like the idea that I can de-serialize the XML document into this class, present the data on a form, make any changes and serialize it out to a new XML document. Is it really that simple?

The first thing that troubles me is that I could potentially be rewriting the entire document just to correct a single spelling mistake...

Ger

Hi All,

We want to generate xml file based on schema file.

Only the xml file is generated we need to populate data by passing objects, because we need to generate so many xml file.

Final output should be a xml file with data.

New to xml,Please help me with this.

Thanks in advance.

Ramkumar
("When you build bridges you can keep crossing them. ")

http://ramkumarishere.blogspot.com

See my post above. If you are using Visual Studio there's a utility called XSD.exe which you run form the VS command prompt.

XSD.exe <Schemaname1.XSD> <Schemaname2.XSD> /c

this will generate a class based on your XSD's - Note if your schema imports from another schema then that schema name has to be included in the command. The /c at the end will give you a C# class.

While I am exploring going down this route, I currently use the document object model (DOM) using a recursive Navigate algorithm from Ch 14 of Stehen Fraser's "Pro Visual C++/CLI and the .NET 3.5 Platform". My post above gives more insight into how I use this.

I also draw heavily from Bipin Joshi's "Beginning XML with C# 2008 From Novice to Professional"

Ger