XML / XSL Discussion Boards

MSXML 5.0 SDK

Andy H5-Mar-07 3:52

Andy H

5-Mar-07 3:52

Does anyone know where I can obtain a copy of the MSXML 5.0 SDK?

Re: MSXML 5.0 SDK

Dmitry Khudorozhkov5-Mar-07 7:12

Dmitry Khudorozhkov

5-Mar-07 7:12

As far as I know, MSXML 5 is not available for download.

MSXML 6 SDK is available:

http://www.microsoft.com/downloads/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=en

-------------------------
Don't worry, be happy Blush | :O

)

Re: MSXML 5.0 SDK

Andy H5-Mar-07 7:55

Andy H

5-Mar-07 7:55

Thanks for your reply. But according to MS's web site MSXML 6.0 does not cater for digitally signing an XML document which is what I need to be able to do.

I need to:

(1) Perform a C14N transform on the part of an XML doc.
(2) Produce a Sha1 digest of the result from (1) above.
(3) Convert the result from (2) above into a Base64 string.

If anyone knows how to do this using MSXML 6.0 I would be very interested to hear. Otherwise, I need to know how to get hold of MSXML 5.0. Was MSXML 5.0 on any of the MSDN disks?

Re: MSXML 5.0 SDK

Stefan Troschuetz5-Mar-07 19:52

Stefan Troschuetz

5-Mar-07 19:52

Maybe the classes inside the System.Security.Cryptography.Xml namespace can help you. For example, there is a XmlDsigC14NTransform that is probably what you're looking for.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: MSXML 5.0 SDK

Andy H5-Mar-07 20:30

Andy H

5-Mar-07 20:30

Thanks for that information on the .NET namespace, with all respect I was already aware of that namespace, but I am not using .NET and cannot in the application for which I am writing. I am presently investigating the Apache library.

Merging 2 XML documents

w13RTH70Lo4-Mar-07 2:58

w13RTH70Lo

4-Mar-07 2:58

guys i am selecting some data from SQL database and then handling it in XML and then exporting it into Excel file. i did it. but then again i included a new XML document in XSLT using

<xsl:variable name="ed" select="document('stu.xml')/data/room">

and when i again run the code it does not select anything from "stu.xml" means from second document. but when i make a new application andpaste the same code over there then it runs fine why it is not running with the previous code.

I love .NET

passing array as argument in XSLt

w13RTH70Lo3-Mar-07 2:55

w13RTH70Lo

3-Mar-07 2:55

how can i pass an array as an argument in xslt.

I love .NET

XSLT exception handling

rana742-Mar-07 19:29

rana74

2-Mar-07 19:29

We test a particular constriant in our XSLT and throw a custom exception on failure:

<xsl:when test="......">
<xsl:value-of
select="exception:throwException('Recording failed')">

Here exception is defined as:
xmlns:exception="http://..../util.exception.ValidationExceptionThrower"
The problem is that this kind of exception handling by-passes the java code.
In our Java client,we have the following:

{
.........

TransformerFactory tFactory = TransformerFactory.newInstance();

transformer = tFactory.newTransformer(source);
....
StreamResult result = new StreamResult();
java.io.ByteArrayOutputStream outputXmlResult = new
java.io.ByteArrayOutputStream();
result.setOutputStream(outputXmlResult);
transformer.transform(xmlsource, result);
setOutXml(outputXmlResult.toString());

return "Success";

}

catch(ValidationException ex) {
System.out.println("INSIDE VALIDATIONEXCEPTION");
......
}
finally {
return "failure";
}

}

The exception thrown by XSLT does not get trapped by the error handler in the client.
How can XSLT be adapted to throw a 'catchable' exception.

Read xml file into HTML table

thedom228-Feb-07 13:41

thedom2

28-Feb-07 13:41

Trying to read xml file into html table.

pretty simple stuff. I got an example off the net to work BUT only in IE, I would like it to work atleast in a few browsers rather than just one being IE.

I tried:
opera
netscape
firefox
but didnt display xml data.

Can anyone see if the code should be changed or have any suggestions to do this simple task

<br />
<html xmlns="http://www.w3.org/1999/xhtml"><br />
<head><br />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><br />
<title>Markets</title><br />
<br />
</head><br />
<br />
<body><br />
<br><br />
<xml id="Markets" src="markets.xml"></xml><br />
<br />
<table border="1" datasrc="#Markets"><br />
<br />
<thead><br />
<tr><th>Name</th><br />
<th>Location</th><br />
<th>Date</th><br />
</tr><br />
</thead><br />
<br />
<tbody><br />
<tr><br />
<td><span datafld="name"></span></td><br />
<td><span datafld="Location"></span></td><br />
<td><span datafld="date"></span></td><br />
</tr><br />
</tbody><br />
</table><br />
<br />
</body><br />
</html><br />
<br />

Re: Read xml file into HTML table

Stefan Troschuetz28-Feb-07 21:11

Stefan Troschuetz

28-Feb-07 21:11

Take a look at this: XML Application[^] The note at the beginning clearly states that a data island (the xml tag) only works in Internet Explorer.

Re: Read xml file into HTML table

thedom21-Mar-07 0:17

thedom2

1-Mar-07 0:17

can anyone suggest a cross browser compatible code then ?
surely this is a task that has been done many times ?

thanks anyway Stefan

Re: Read xml file into HTML table

Stefan Troschuetz1-Mar-07 0:40

Stefan Troschuetz

1-Mar-07 0:40

I think the safest way regarding browser compatibility is to use XSL/XSLT to transform the XML document into a plain XHTML document without any fancy browser specific stuff.
A good starting point for reading is this XSLT Tutorial[^]. Besides this, I'm quite sure the internet is full of more resources. Simply google for the involved technologies.

Re: Read xml file into HTML table

thedom21-Mar-07 15:33

thedom2

1-Mar-07 15:33

thanks for your assistance stefan Smile | :)

helping converting doc,txt,rtf to xml

yacastr28-Feb-07 5:36

yacastr

28-Feb-07 5:36

I am looking for either a schema or non-3rd party parser to convert a doc,txt, or rtf to xml.

Thank you in advance.

Any help would be greatly appreciated.

Re: helping converting doc,txt,rtf to xml

led mike28-Feb-07 5:48

led mike

28-Feb-07 5:48

You are looking for a non-3rd party parser? OMG | :OMG:

I guess you might mean "free" parser? Ever heard of GOOGLE? It is a "SEARCH ENGINE" and therefore helps you "look for things"!

led mike

Re: helping converting doc,txt,rtf to xml

yacastr28-Feb-07 6:03

yacastr

28-Feb-07 6:03

Maybe I am not explaining myself correctly. I am currently trying to programmatically convert a doc,txt, or rtf to xml so that I retrieve specific information from its content.

I have been searching for a corresponding schema or a non 3rd party xml parser so that I can apply to code to my application so that I may be able to parse the data within the document.

I have looked everywhere. I cannot use a third party product for this.

I am writing a web app in asp.net/vb.net. The final product will be launched on a closed network.

Re: helping converting doc,txt,rtf to xml

led mike28-Feb-07 6:42

led mike

28-Feb-07 6:42

yacastr wrote:
I have been searching for a corresponding schema or a non 3rd party xml parser

yacastr wrote:
convert a doc,txt, or rtf to xml

A XML parser is "not" going to convert any non-XML format into XML. MSWord can export doc and rtf to WordML, I don't know if it will also export "TXT" to WordML. See Google results[^]

led mike

Only Selected portion of XML to Ecel

w13RTH70Lo27-Feb-07 20:55

w13RTH70Lo

27-Feb-07 20:55

hi i have a problem but could not find its solutions i hope you people can help me,

i am fetching data from SQL2000 using XMLSQL so now data is in XML format and then i am accessing that data through XSLT and displaying into a web page in HTML table format and now i want to Export that selected info [that is in HTML table format] in Excel file. how can i do that.

note: i dont want to export the whole info that comes directly from the Query i want to do some manipulation on resulted query data and then want to export new info into Excel file.

regards

I love .NET

Re: Only Selected portion of XML to Ecel

nirmalamari7-Mar-07 14:56

nirmalamari

7-Mar-07 14:56

Store the manipulated data in another dataset and then transfer that data alone.

XPATH query to get the child elemets of a node

madhusri27-Feb-07 17:24

madhusri

27-Feb-07 17:24

Hi,

Heres a sample XML document:

<?xml version="1.0" encoding="utf-8"?>
<Sample>
<Name>

<FName>A</FName>

<MName>M</MName>

<LName>B</LName>
</Name>
<ID>1</ID>
</Sample>

If i get the count of childnodes of the node <name>, using the following statement: xmlNamenode.Childnodes.count, it returns 6 (i.e) it also includes the comments as a child node. Is there any way to directly get the count of number of elemets (excluding comment nodes) instead of alll the childnodes?

Thanks and Regards
Madhu

Re: XPATH query to get the child elemets of a node

Stefan Troschuetz27-Feb-07 22:18

Stefan Troschuetz

27-Feb-07 22:18

Maybe this one document.SelectNodes("/*").Count

Re: XPATH query to get the child elemets of a node

madhusri28-Feb-07 2:20

madhusri

28-Feb-07 2:20

Hi,
Thanks. it solved the issue...

Thanks and Regards
Madhu

Nesting XmlTextWriter

Brady Kelly27-Feb-07 9:03

Brady Kelly

27-Feb-07 9:03

I am using XmlTextWriter in a function to create a Document element. The function returns e.g. the following:

<Document>
<UserID>ID blah blah</UserID>
</Document>

Now I call this function once for each document inside another method that creates one single XML message containing all <Document> elements. I would like to know how I can insert the text returned from the Document function into the XML message, and keep the correct indenting, as happens when I call WriteElementString.

Re: Nesting XmlTextWriter

Stefan Troschuetz27-Feb-07 22:32

Stefan Troschuetz

27-Feb-07 22:32

Would it be an option to pass an XmlTextWriter into the method that writes the document element, so in the method that creates the overall xml message you instanciate one XmlTextWriter and pass it to the method together with each document.?

Implementing XSLT constraint

rana7427-Feb-07 0:49

rana74

27-Feb-07 0:49

We are trying to enforce a couple of business constrainrs with XPATH .
A sample xml node is as follows:
.....
.....
<event>
<element>IE</element>
<elementtype>browser</elementtype>
<eventtype>Navigate</eventtype>
<value>http://www.....com/</value>
</event>
.......
.......

If we need to ensure that the XML has ATLEAST one 'element' node containing text as "IE" we do:
<xsl:template match="element[count(IE) < 1]" >
<xsl:text>ERROR: Atleast one IE element needed</xsl:text>
</xsl:template>

But we need to ensure that ATLEAST one of the IE 'event' nodes has a combination of 'element' as IE and 'value' node containing the text "Logout" i.e.

<event>
<element>IE</element>
<elementtype>....</elementtype>
<eventtype>Navigate</eventtype>
<value>...Logout...</value>
</event>

How do we enforce this occuurrence constraint through template?

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