XML / XSL

DataSet - reading in and XML Document

9-Feb-04 3:02

You've got three choices.

1) Change the schema. Can't do it.
2) Change the transform. How are you using it?
3) Go away.

Re: XSLT

Large Data File9-Feb-04 3:32

Large Data File

9-Feb-04 3:32

I'm using a .NET framework v1.0 so i'm restricted with which overload i can use in the transfrom method. What i do is give the Xsl a XPathNavigator that i created from the XmlDocument, i give it null for the arguments and a stream to write to:

<br />
string transfrormerStyleSheet = LoadTransfrormer();<br />
XmlDocument transformationDocument = new XmlDocument();<br />
transformationDocument.LoadXml(transfrormerStyleSheet);<br />
XmlNodeReader transformationReader = new XmlNodeReader(transformationDocument);<br />
XmlDocument guiXmlDocument = new XmlDocument();				<br />
xmlDocument.LoadXml(xmlAsString);	<br />
<br />
XslTransform transformer = new XslTransform(); <br />
transformer.Load(transformationReader);<br />
<br />
XPathNavigator xpn = xmlDocument.CreateNavigator();<br />
FileStream fs = new FileStream(Environment.CurrentDirectory+"\\TempXMLstream.xml",FileMode.Create);<br />
StreamWriter sw = new StreamWriter(fs,System.Text.Encoding.UTF8);<br />
transformer.Transform(xpn,null,sw);<br />
sw.Flush();<br />
sw.Close();<br />
fs.Close();<br />

I need the stream to be in UTF8 specificly.

Member 64401630-Jan-04 7:49

Member 644016

30-Jan-04 7:49

I am trying to read an XML document into a .NET DataSet object. I used the XSD.EXE utility to generate a schema file for this XML document. This schema has re-ocurring elements that I would like to load as records into my DataSet. However, I only want to load certain child elements as fields into the DataSet record.

Is there a way I can modify this schema file such that I can use the DataSet.ReadXml method to parse this XML file and create the proper table rows??

Thanks

Re: DataSet - reading in and XML Document

Rebreath27-Feb-04 11:18

Rebreath

27-Feb-04 11:18

What exactly are you using the dataset object for?

Matthew R. Sannes
Docsoft
Technical Marketing Specialist
www.docsoft.com
msannes@docsoft.com

Most efficient way to save changes made in xmlDoc?

sinnen29-Jan-04 8:29

sinnen

29-Jan-04 8:29

Hi!
I´m using a xml document as a prices list for different customers.
The pricelist is often updated as prices changes and new
customers are added to the pricelist.
Now i`m a bit confused on how I should save the price list as there
are several ways of doing this. I could use:

XmlTextWriter tr = new XmlTextWriter("xmlPriceList.xml",null);
tr.Formatting=Formatting.Indented;

- xmlDoc.WriteContentTo(tr);

tr.Close();

or

- xmlDoc.WriteTo(tr)

or even

xmlDoc.save(..)

which one shall I choose? further I want to make sure my xmlDoc is well formed before it´s saved, but I don´t know how?

Thx

Thomas Andersson

XSLT - how to preserve empty spaces?

Cristoff26-Jan-04 9:26

Re: XSLT - how to preserve empty spaces?

26-Jan-04 9:26

I have an .xml file like this:
<group>
<line> some text</line>
<line> some text</line>
<line/>
<line> some text</line>
<line> some text</line>
</group>

and I want to transform it to a table like:

some text

but the empty raw never appears. Empty tags are ignored? How can I preserve them?

Not Active26-Jan-04 10:03

Re: XSLT - how to preserve empty spaces?

26-Jan-04 10:03

Where is your transform?

This should do it.

<xsl:for-each select="group/item">
<tr><td><xsl:value-of select="."/></td></tr>
</xsl:for-each>

Cristoff29-Jan-04 7:00

29-Jan-04 7:00

this is my transoform (part of the style sheet)

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"></td>
<td width="30" align="center"></td>
<td class="PoetryTitle"><xsl:value-of select="poem/stave/title"/></td>
<td width="10"></td>
</tr>
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"></td>
<td width="30" align="center"></td>
<td class="PoetrySubtitle"><xsl:value-of select="poem/stave/subtitle"/></td>
<td width="10"></td>
</tr>
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"></td>
<td width="30" align="center"></td>
<td class="EmptyLine">.</td>
<td width="10"></td>
</tr>
<xsl:for-each select="poem/stave">
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"><xsl:value-of select="number"/></td>
<td width="30" align="center"></td>
<td ><xsl:value-of select="verse"/></td>
<td width="10"></td>
</tr>
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"></td>
<td width="30" align="center"></td>
<td class="EmptyLine"><xsl:value-of select="emptyline"/></td>
<td width="10"></td>
</tr>
<tr>
<td width="80" valign="top"></td>
<td width="45" align="right" class="number"></td>
<td width="30" align="center"></td>
<td class="PoetryComments"><xsl:value-of select="notes"/></td>
<td width="10"></td>
</tr>

</xsl:for-each>
</table>

this...

Cristoff29-Jan-04 7:21

Re: XSLT - how to preserve empty spaces?

29-Jan-04 7:21

<xsl:value-of select="."/>

why the "."?

my workaround is: <emptyline>.<emptyline> and the color of the . is set to the background, so it looks like an empty line.

another problem is that I have text formated like this:
<line>first line</line>
<line> second line</line>
<line>third line</line>

but it appears like this (after transformation)
first line
second line
third line

"& nbsp ;" is rejected as invalid so I cannot use it for formatting.

Anonymous8-Feb-04 19:09

Anonymous

8-Feb-04 19:09

This should work:
<xsl:text disable-output-escaping="yes"> </xsl:text>

Edward

I'm lazy - How to do it without learning XSLT :)

Cristoff22-Jan-04 0:48

Re: I'm lazy - How to do it without learning XSLT :)

22-Jan-04 0:48

Hi,

I need to convert some .xml files into tables so that they can be viewed in a web browser.
Is there a way to do that without to need learning XML/XSLT Smile | :)

If now what is the easiest and quickest way to do that? (I doubt I'll need to do anything similar again)

Is it possible to use XML/XSLT to generate these tables as a part of .html page created as a template with Dreamweaver.

Thank you! I've got scared by the size of these books about XML Wink | ;)

Not Active22-Jan-04 10:57

Re: I'm lazy - How to do it without learning XSLT :)

22-Jan-04 10:57

XSLT for Dummies, learn to write XML transforms without reading.

Now wouldn't that be great.

You're going to have to get over it and learn something.

Cristoff23-Jan-04 0:37

Re: I'm lazy - How to do it without learning XSLT :)

23-Jan-04 0:37

thanx

Any easy online sources to get me running in half a day Smile | :)

I don't have much time to spend on that, which is the main problem.

Matthew Hazlett28-Jan-04 8:24

Matthew Hazlett

28-Jan-04 8:24

You can do somthing like this:

dim nodes as xmlnodelist = xmlDoc.selectnodes("//root/whatever")
dim node as xmlnode

for each node in nodes
response.write("<div class=""" & node.name & """>" & node.innerText & "</div>");
next

This is kinda kludgy, you really want to use an xslt file Smile | :)

But doing this you could create tables by making div tables with the sytlesheet.

Check this place out for info on XSLT:
XSLT Tutorial

Re: I'm lazy - How to do it without learning XSLT :)

Cristoff29-Jan-04 6:55

Re: I'm lazy - How to do it without learning XSLT :)

29-Jan-04 6:55

I already read the XSLT tutorial Smile | :)

it doesn't seem that hard as I thought. I have actually done almost all I wanted Smile | :)

.
The only problem now is that I currently support XML compatible browsers only.

BTW. I've checked your article here and there is no source code attached to it.

Regards

Matthew Hazlett29-Jan-04 9:44

Matthew Hazlett

29-Jan-04 9:44

Thanks for telling me, I fixed the link...

XSLT - Adding whitespace to a string

cheezdog20-Jan-04 17:08

cheezdog

20-Jan-04 17:08

Hi,

I'm trying to convert the value of an element, into a string of a certain amount of characters - right justified.

e.g. <abc>123456</abc> into a 10-character string - " 123456"

How would this be done, if possible?

Re: XSLT - Adding whitespace to a string

Philip Fitzsimons21-Jan-04 3:19

Philip Fitzsimons

21-Jan-04 3:19

not easy to do in xslt - here is the "pure" way (you could just embed some c# code in the xslt)

xml source document:

<br />
<document><br />
   <abc>1234</abc><br />
   <abc>234234</abc><br />
   <abc>21321</abc><br />
   <abc>91243149384</abc><br />
</document><br />

xslt document:

<br />
<?xml version="1.0" encoding="UTF-8" ?><br />
<xsl:stylesheet <br />
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
   version="1.0"><br />
   <br />
    <xsl:output method="xml" <br />
         media-type="text/xml" <br />
         indent="yes"<br />
         encoding="UTF-8"/><br />
   <br />
   <xsl:template name="document"><br />
      <xsl:apply-templates select="abc" /><br />
   </xsl:template><br />
   <br />
   <xsl:template name="abc"><br />
      <xsl:call-template name="padstring"><br />
         <xsl:with-param name="times" select="10 - string-length(text())" /><br />
         <xsl:with-param name="string"><xsl:value-of select="text()" /></xsl:with-param><br />
      </xsl:call-template>                  <br />
   </xsl:template><br />
<br />
   <xsl:template name="padstring"><br />
      <xsl:param name="current">1</xsl:param><br />
      <xsl:param name="times" /><br />
      <xsl:param name="string" /><br />
      <xsl:param name="paddingchar">&#32;</xsl:param><br />
      <br />
      <xsl:if test="$times &gt; 0)><br />
         <xsl:value-of select="$paddingchar" /><br />
      </xsl:if><br />
      <br />
      <xsl:if test="not($times &lt; $current) and $current != $times"><br />
         <xsl:call-template name="padstring"><br />
            <xsl:with-param name="current" select="$current + 1" /><br />
            <xsl:with-param name="times" select="$times" /><br />
            <xsl:with-param name="string" select="$string" /><br />
            <xsl:with-param name="paddingchar" select="$paddingchar" /><br />
         </xsl:call-template><br />
      </xsl:if><br />
   </xsl:template><br />
<br />
</xsl:stylesheet><br />

should work...

"When the only tool you have is a hammer, a sore thumb you will have."

Dynamic Link Creation in ASP.Net Page /XSL

laker_6616-Jan-04 7:27

laker_66

16-Jan-04 7:27

I'm a newbie,so please bear I have asp.net page which gets input from the user . I had to convert that input to xml and send it to the 3rd party database and get the output in xml . I convert that xml to html using XSL file by using Load and Transform methods in .NET

My XSL is similar to this .

This is simple part which is done .
The tricky part is After i display i do want to provide links to the elements displayed . I want to provide a link for these elements
so that when the user hits the link, the link spawn's another search and returns the result .I Was wondering how would i do that . Do i have to call etxernal objects from XSL to call the same ASPX page which i used previously to generate the original response.

Any thoughts appreciated...

Not Active19-Jan-04 0:53

19-Jan-04 0:53

One way would be to use an xml data island and some javascript to search and return the results while on the client side. Using a postback mechanism you could also post-back to your aspx and display the requested results.

laker_6619-Jan-04 6:25

laker_66

19-Jan-04 6:25

Mark, I was thinking almost in the same lines as you mentioned to use javascript . But my search is actually not to an xml file its actually to a 3rd party xml database(xml webservice) . so i was thinking actually
to pass the values from XSL file to the aspx page and get the results .

Not Active19-Jan-04 10:12

19-Jan-04 10:12

Depending on the size of the data returned and your requirements you could still use the xml data island. As the page is initially rendered stuff the xml data island with the return from your database query. Then it is all client side javascript. Faster responses for the user but of course it only works for IE.