XML / XSL

4-Apr-05 4:15

I want to transform dataset data to a text file. I am doing it using XSLT. It is getting transformed but rows are displayed one after the other not on a new line. How do I insert a New line character after each row in the text file. Is there any other way to export data from a dataset to a text file. The text file will be a fixed length test file.

Please help me as soon as possible

Christian Graus4-Apr-05 10:30

4-Apr-05 10:30

Why are you using XSLT ? Surely you can just iterate through the rows without turning the dataset to an XML document ? Then you can use Environment.Newline to stuff a line in between. You can also just put a return in your XSLT though, that should work.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Daredeviljpr4-Apr-05 19:18

4-Apr-05 19:18

I have lacs of records and it will take lot of time to iterate through each record. What does "return" mean in the statement "You can also just put a return in your XSLT though, that should work." If I write "return" in XSLT it will simply write return in the text file.

Stuart Dootson4-Apr-05 21:56

Stuart Dootson

4-Apr-05 21:56

Dinesh Thakan wrote:
I have lacs of records and it will take lot of time to iterate through each record.

That's all the XSLT is doing....

Dinesh Thakan wrote:
What does "return" mean in the statement "You can also just put a return in your XSLT though, that should work."

Christian means a 'carriage-return'. If you put the numeric entities 
 into your XSLT, that should insert a new-line?

Stuart Dootson

'Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p'

Daredeviljpr5-Apr-05 5:13

5-Apr-05 5:13

Thanks Christian Graus and Stuart Dootson for your support. I was able to get the line feed in my text file. Now there is another problem, the XML gets written in my text file after the transformed data. The xsl being used is given below.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:AES="urn:my-scripts" >

<xsl:output method="text"/>
<msxsl:script language="VB" implements-prefix="AES">

Function ReturnCharacter
return VbCrlf
End Function
</msxsl:script>

<xsl:template match="/">
<xsl:for-each select="NewDataSet/Table">
<xsl:value-of select="CustomerID"/>
<xsl:value-of select="CompanyName"/>
<xsl:value-of select="ContactName"/>
<xsl:value-of select="Country"/>
<xsl:value-of select="Phone"/>
<xsl:value-of select="AES:ReturnCharacter()"/>
</xsl:for-each>
</xsl:template>

</xsl:stylesheet>

<big><b>The OutPut is: </b></big> In the output you can see the xml appended at the last. I do not want thi sXML in my text document. What should I do.

TRAIHTrail's Head Gourmet ProvisionersHelvetius NagyUSA(206) 555-8257
VAFFEVaffeljernetPalle IbsenDenmark86 21 32 43
VICTEVictuailles en stockMary SaveleyFrance78.32.54.86
VINETVins et alcools ChevalierPaul HenriotFrance26.47.15.10
WANDKDie Wandernde KuhRita MüllerGermany0711-020361
WARTHWartian HerkkuPirkko KoskitaloFinland981-443655
WELLIWellington ImportadoraPaula ParenteBrazil(14) 555-8122
WHITCWhite Clover MarketsKarl JablonskiUSA(206) 555-4112
WILMKWilman KalaMatti KarttunenFinland90-224 8858
WOLZAWolski ZajazdZbyszek PiestrzeniewiczPoland(26) 642-7012
<NewDataSet><Table><CustomerID>ALFKI</CustomerID><CompanyName>Alfreds Futterkiste</CompanyName><ContactName>Maria Anders</ContactName><Country>Germany</Country><Phone>030-0074321</Phone></Table><Table><CustomerID>ANATR</CustomerID><CompanyName>Ana Trujillo Emparedados y helados</CompanyName><ContactName>Ana Trujillo</ContactName><Country>Mexico</Country><Phone>(5) 555-4729</Phone></Table><Table><CustomerID>ANTON</CustomerID><CompanyName>Antonio Moreno Taquería</CompanyName><ContactName>Antonio Moreno</ContactName><Country>Mexico</Country><Phone>(5) 555-3932</Phone></Table><Table><CustomerID>AROUT</CustomerID><CompanyName>Around the Horn</CompanyName><ContactName>Thomas Hardy</ContactName><Country>UK</Country><Phone>(171) 555-7788</Phone></Table><Table><CustomerID>BERGS</CustomerID><CompanyName>Berglunds snabbköp</CompanyName><ContactName>Christina Berglund</ContactName><Country>Sweden</Country><Phone>0921-12 34

Daredeviljpr5-Apr-05 5:21

5-Apr-05 5:21

Sorry, it was my mistake in the Code, I was writing the dataset also in the output file. It is resolved now.

hp10811-May-05 4:20

hp108

11-May-05 4:20

# Adding a carriage return (WITHOUT SPACES): <xsl:text>& # x 0 D ;</xsl:text>

# Adding a line feed (WITHOUT SPACES): <xsl:text>& # x 0 A ;</xsl:text>

<xsl:template match="/">
<xsl:for-each select="NewDataSet/Table">
<xsl:value-of select="CustomerID"/>
<xsl:value-of select="CompanyName"/>
<xsl:value-of select="ContactName"/>
<xsl:value-of select="Country"/>
<xsl:value-of select="Phone"/>
<xsl:text>& # x 0 A ;</xsl:text>
</xsl:for-each>
</xsl:template>

YOU DO NOT NEED
<msxsl:script language="VB" implements-prefix="AES">

Function ReturnCharacter
return VbCrlf
End Function
</msxsl:script>

Question

reema13-Apr-05 21:27

reema1

3-Apr-05 21:27

how can i access an XML file in vc++ 6.0 using .ini file without using MSXML parser?

Re: Question

Christian Graus4-Apr-05 10:29

Using code behind with xml - xsl

4-Apr-05 10:29

you are putting xml in your .ini file ? I guess you can use iostreams to read the file, but then you're parsing it as plain text. If you want to parse it as XML, C++ does not have that facility, that's what the MSXML parser is for.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

dataset+xml schema

Dpriya3-Apr-05 18:43

Dpriya

3-Apr-05 18:43

Hi,
I 've a function which takes 2 parameters, a dataset , path to XSD file. Based on contents of the xsd file i need to modify data in daatset to generate appropriate xml.How do I do this?

Thanks in advance
Priya

Maarook3-Apr-05 11:19

Maarook

3-Apr-05 11:19

I'm combining XML and XSLT server side and I send HTML back to the client. What I'd like to know is if I can use/create a code behind for this HTML page and if yes: how?

Thanks

Re: Using code behind with xml - xsl

Christian Graus3-Apr-05 13:45

Re: Using code behind with xml - xsl

3-Apr-05 13:45

This is an ASP.NET question. Put a static control on your page, and fill it with the result of your XSLT transform.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Maarook3-Apr-05 20:20

Maarook

3-Apr-05 20:20

Thanks, but how can I catch user events send by the static control? In a regular page it's done simply by making a code behind page. However, if I combine XML en XSLT serverside, the result is a page without even a name, let alone a code behind page/link to it.

Thanks

Re: Using code behind with xml - xsl

Christian Graus4-Apr-05 10:27