VARIANT to XML? - XML / XSL Discussion Boards

Re: What wrong with this clause??

Tida15-Aug-02 2:55

Tida

15-Aug-02 2:55

I got an idea from your opinion.

Thanks a lot. Big Grin | :-D

Re: What wrong with this clause??

Ranjan Banerji15-Aug-02 3:33

Ranjan Banerji

15-Aug-02 3:33

in line: strVolume="d:\Shared Volume"; you need to have strVolume="d:\\Shared Volume";

This will not show up as an error when u compile but as a warning about some escape characters. Always check warnings. Your code should not only be error free but also warning free. This could be another reason why your code did not work as your code will resolve to D:Share Volume while you are matching d:\shared......

Schema: exclude element from occuring within itself?

Jonnie White13-Aug-02 1:49

Jonnie White

13-Aug-02 1:49

Hi!

I want to exclude an element from appearing within itself. I'm not sure if this is possible using XML Schema though. Can anyone clear this up for me please?

To exclude itself from appearing as a child I could use:

<xs:element name="person">
<xs:complexType>
<xs:element name="person" maxOccurs="0"/>
</xs:complexType>
</xs:element>

However, this doesn't exclude this element from appearing deeper in the hierarchy (e.g. as a grandchild) or does it? If not, is it possible?

Thanks

Jonnie

P.S. It may be apparent, that I'm a total newbie to XML Schema, but need to assess what is possible before diving in Smile | :)

Embedded html

Lilian Chan-Grant6-Aug-02 10:03

Lilian Chan-Grant

6-Aug-02 10:03

Is there a way to make a heterogeneous XML/HTML file print like you'd wish it would? The following is XML, but our db person placed some HTML data in our data. It just prints like the html tags. I was hoping someone knew a fancy xsl thing. I just wish she had made it a separate note.

XML:
<specificnotes>
- <note>
<classification>U
<type>Undesignated
<note>Left/right.

- <note>
<classification>U
<type>Undesignated
<note>REQUIREMENTS

Software	Option 1	Option 2

XSL Stylesheet uses default output method.

Thanks,
Lilian

Re: Embedded html

Lilian Chan-Grant7-Aug-02 9:28

Lilian Chan-Grant

7-Aug-02 9:28

Just in case anyone runs into this problem, here's the solution:

use the tag disable-output-escaping="yes" in your value of.

exslt set:distinct template order

Chris_D5-Aug-02 6:30

Chris_D

5-Aug-02 6:30

Hi, I have the following XSL code:

The set:distinct template from exslt.org:

<xsl:template name="set:distinct">
<xsl:param name="nodes" select="/.." />
<xsl:choose>
<xsl:when test="not($nodes)" />
<xsl:otherwise>
<xsl:apply-templates select="$nodes[1][not(. = $nodes[position() > 1])]" mode="set:distinct"/>
<xsl:call-template name="set:distinct">
<xsl:with-param name="nodes" select="$nodes[position() > 1]" />
</xsl:call-template>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

and the following call to it:

<xsl:variable name="distinctVnames">
<xsl:call-template name="set:distinct">
<xsl:with-param name="nodes" select="//@vname" />
</xsl:call-template>
</xsl:variable>

After this the call variable value is a string with all distinct vname attributes of my xml document. thats fine. But the vname attributes appear in the result string in document order.

Does anybody have an idea how to change this in order to obtain the vname attributes in alphabetical order? Thank you very much!

XML Schema for Office Web Component ver 9 and 10?

Dmitry Novikov2-Aug-02 8:03

Dmitry Novikov

2-Aug-02 8:03

Hi!
Does anybody have XML Schemas for OWC 9 and 10?
Thanks,
Dmitry.

VARIANT to XML?

mali1-Aug-02 19:34

mali

1-Aug-02 19:34

Could anyone give me any advice on how to convert a VARIANT data type to XML?

thanks

Re: VARIANT to XML?

Ranjan Banerji2-Aug-02 5:05

Ranjan Banerji

2-Aug-02 5:05

Could you be a little more explicit. For example do you have a VARIANT holding a string like <tag>blah and you wish to put this into an XML document?

Or do you have a variant with some data not known and you wish to generate an XML out of it s contents. Well then what should your XML look like? Under what element would you want your VARIANT data to go?

Either way you could look into XMLDOMDocument40 LoadXML function.

Hope this helps.

Web Services Implementation Guide

Stanford Powers31-Jul-02 18:27

Stanford Powers

31-Jul-02 18:27

Getting value from stuff you don't own is a compelling
idea. Just think, someone else has created something
that has value, and has made it available to you. You
can now leverage its value in ways that makes all
parties richer. That's the promise of web services.

You need to know about web services. The advent of
standards-based web services marks a new era of
system development. First mainframe, then client-server,
the Web, now web services makes it possible to leverage
every legacy system of the past and do so much more
with your information assets.

Architag Press, a division of Architag International
Corporation, announces the publication of Web Services
Implementation Guide, Volume 1: Getting Started, by
Brian E. Travis and Mae Ozkan.

Sample chapters of the book is available at
http://www.architag.com/press/wsig.

This book will show you what a web service is, and
how you can align your internal systems and external
trading partner interactions to take advantage of this
new concept in system integration.

You will learn about the "Three Steps to Web Services":

* Automate internal systems
* Determine integration points
* Expose integration points as web services

This book is for systems architects, developers,
and I.T. decision makers.

Highlights in this book:

* Written in a light, entertaining style.
* Emphasis on architectural design for web services.
* A tutorial on the state of web services standards.
* Plenty of real-life examples of web service use.
* Tutorials on the key technologies: XML, SOAP,
WSDL and UDDI.
* Code samples of key XML-based web services
technologies and extensions.
* Companion Web site with all code samples and
late-breaking information.
----
Download sample chapters of Web Services Implementation
Guide at http://www.architag.com/press/wsig/.
Stanford Powers, Publisher Architag International Corp
Phone: 866-898-0001 Outside US: +1-303-426-3126
Email: spowers@architag.com

Loadxmlerror

suresh_sathya28-Jul-02 18:53

suresh_sathya

28-Jul-02 18:53

Hi,
I am having some content in textfile.iam reading the content from file by using API called Read file.I convert this string to bstr using (_bstr_t)string and then i called the method LoadXML(string,bool).But when iam parsing this iam not getting output.
why it is so.

Thanks in advance.

Re: Loadxmlerror

Roman Nurik28-Jul-02 20:32

Roman Nurik

28-Jul-02 20:32

if you're using MSXML, there is a method to load an XML file given a filename, not the file's contents... look it up in the MSXML SDK

- Roman -

Re: Loadxmlerror

Colin Leitner29-Jul-02 14:15

Colin Leitner

29-Jul-02 14:15

Try this:

<nobr>Dim xml

Set xml = CreateObject("MSXML2.DOMDocument")

If Not WScript.Arguments.Count = 1 Then

  WScript.Echo "Usage: cscript loadxml.vbs <xml-file.xml>"

  WScript.Quit 0

End If

If Not xml.load(WScript.Arguments(0)) Then

  WScript.Echo "The XML file couldn't be loaded:"

  WScript.Echo " Error: " + xml.parseError.reason + _

               " Error code: 0x" + Hex(xml.parseError.errorCode)

  WScript.Echo " in File """ + xml.parseError.url + """"

  WScript.Echo " @ row " + CStr(xml.parseError.line) + ", col " + CStr(xml.parseError.linepos)

  If Not xml.parseError.srcText = "" Then

    WScript.Echo

    WScript.Echo xml.parseError.srcText

    WScript.Echo String(xml.parseError.linepos - 1, "-") + "^"

  End If

  WScript.Quit -1

Else

  WScript.Echo "XML file loaded sucessfully."

End If

' Sucessfully loaded DOM tree is now available in the xml var

WScript.Echo xml.xml

How to use
Save the code above as 'loadxml.vbs'
Type in your console 'wscript //H:cscript' to use the console version of your wscript host.
Goto to the subdirectory with your xml data and the script.
Type 'loadxml anyfile'

Voilá!

The function used to load the file is 'load' Big Grin | :-D

. Returns true/false wether it could load the file or not.

Good night everybody I need some sleep... zzzzzz Sleepy | :zzz:

zzzzzz

Re: Loadxmlerror

Domenic Denicola31-Jul-02 10:14

Domenic Denicola

31-Jul-02 10:14

How'd you get that beautiful syntax highlighting? OMG | :OMG:

-Domenic Denicola- [CPUA 0x1337]
MadHamster Creations

"I was born human. But this was an accident of fate - a condition merely of time and place. I believe it's something we have the power to change..."

Re: Loadxmlerror

Colin Leitner1-Aug-02 10:14

Colin Leitner

1-Aug-02 10:14

I do it by hand Dead | X|

. But I'm writing on a tool for highlighting to HTML code wich I will publish as an article Wink | ;)

.

Guess what I can already render XML to HTML! (no XSLT, cause it reads also comments, PIs etc.) All ya need is VBS and MSXML 3. But I still need a few weeks Cry | :((

"Empty" XML Document

kenlefeb24-Jul-02 3:14

kenlefeb

24-Jul-02 3:14

Has anyone else ever run across the need to generate an "empty" XML Document based on a Schema? I am using XSD schemas to define the state behind a VB form, using XPath expressions to implementing binding between nodes in the document and controls on the forms. I would like to generate a blank document when I load the form, so that all my XPath expressions are valid, even if they return no value.

Any ideas?

Thanks!

Rendering XML using JSP

Hitu22-Jul-02 18:58

Hitu

22-Jul-02 18:58

Hello,

I want to render XML on server side using JSP. How do I do it? Please give me some tips.

Thanks
Hitesh

Re: Rendering XML using JSP

Sharad Ganesh29-Jul-02 19:33

Sharad Ganesh

29-Jul-02 19:33

hi,

What exactly do u mean by render XML ? Do u want to parse the XML and display the contents onto the browser ? If so, u can use the xerces parser which is an open-source from IBM-Apache. You can get it at http://xml.apache.org. Get the JAR - xerces.jar.

Rgds,
Sharad Ganesh

Re: Rendering XML using JSP

1-Aug-02 9:57

just use XSL Smile | :)

- Roman -

How to create a xml schema that maps to a file directory tree structure

22-Jul-02 12:43

In case I want to create a xml schema to map with file directory tree structure, I tried the following schema:

<xs:element name="Manifest">
<xs:complexType>
<xs:sequence>
<xs:element ref="Manifest" maxOccurs="unbounded" />
<xs:element ref="Directory" maxOccurs="unbounded" />
<xs:element ref="File" maxOccurs="unbounded" />
</xs:sequence>
<xs:attribute name="name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Directory">
<xs:complexType>
<xs:sequence>
<xs:element ref="Directory" maxOccurs="unbounded" />
<xs:element ref="File" maxOccurs="unbounded" />
</xs:sequence>
<xs:attribute name="name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="File">
<xs:complexType>
<xs:attribute name="name" type="xs:string" />
</xs:complexType>
</xs:element>

However, this schema will not allow me to generate a dataset in .NET because I use "file" and "directory" node recursively. I'd like to know how to solve this problem so that I can get a dataset out of it. Thanks in advance.
Wink | ;)

Sakda Chaiworawitkul

Using SSL with XML POST

Sid Forcier22-Jul-02 8:02

Sid Forcier

22-Jul-02 8:02

I need to POST XML data (via an ASP application) to an entity who has provided me a spec that seems a bit incomplete and their tech support is of no help. The spec says (to summarize) that "the user system (my app) will transmit the XML data through an HTTPS URI using a digital certificate".
Is it evident whether the application will use a server or a client certificate? Since my server is POSTing data to their server I would assume that I need a client certificate. However, I'm being told that I need a server certificate. If that's the case, how do I forward my server certificate to the URI I'm POSTing to.
Am I insane or incredibly naive? Can you even tell from the little information I've (been) given? Any additional links or resources would be appreciated. I've dug up very little info on Server to Server XML/SSL stuff.

Beginner XSL problem

tomiga17-Jul-02 1:49

tomiga

17-Jul-02 1:49

Welcome
I have XML file:

<br />
<doc><br />
<field><br />
  <name> myName</name><br />
  <value> some value</value><br />
</field><br />
<field><br />
  <name> otherName</name><br />
  <value> other value</value><br />
</field><br />
</doc><br />

I have created XSL file:

<br />
<xsl:template match="/"><br />
	<!-- transform fields --><br />
   <xsl:for-each select="field"><br />
		<xsl:choose><br />
			<!-- i want get data from myName field --><br />
			<xsl:when test="cd[name='myName']"><br />
				<xsl:value-of select="value"/>				                <xsl:when><br />
		<xsl:choose>   <br />
   </xsl:for-each><br />
</xsl:template><br />

unfortunately it doesn't create output file as:
some value

What is wrong?

Re: Beginner XSL problem

MS le Roux17-Jul-02 5:26

MS le Roux

17-Jul-02 5:26

Change the select attribute of the <xsl:for-each> element to either "doc/field" or "//field". <field> is not the root element; it's a child element.
Change the test attribute of the <xsl:when> element to contain the value "name=' myName'".

Re: Beginner XSL problem

tomiga17-Jul-02 5:35

tomiga

17-Jul-02 5:35

thx
(there was no space in oryginal Wink | ;)

but correct version of test shoud look like

<br />
xsl:when test="name='myName'"<br />

XSL Transform Textarea Problem w/IE6?

DVryce12-Jul-02 3:07

DVryce

12-Jul-02 3:07

I've seen this issue noted a few other places on the web, but so far no good solutions have been found.

I have an XSL file I'm using to transform some XML. This XSL file has existed for a long time now and has always worked on version of IE <= 5.5. Some of our clients are now moving to an IE6 environment and I've found that the new version of the XML parser included with IE6 messes up when performing the transform.

Specifically, when the transform attempts to output a textarea block, with code similar to this:

<DIV>
<TEXTAREA size="40," style="width:100%">
<xsl:attribute name="FIELD_TYPE">s</xsl:attribute>
<xsl:attribute name="DATA_TYPE">T</xsl:attribute>
</TEXTAREA>
</DIV>

The closing textarea tag is never output to the HTML when using the XML parser included with IE6. In IE <= 5.5 however this works just fine.

Has anybody else experienced similar problems, or have a suggestion for a solution? It would be appreciated! Thanks!

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