xml + xslt convert to rtf problem

[chris]

Hi there,
I create an XML file from a dataset like this:

System.IO.Strea mWriter xmlSW = new System.IO.Strea mWriter(FILENAM E);
dsUserData1.Wri teXml(xmlSW, XmlWriteMode.Wr iteSchema);
xmlSW.Close();

Which gives me this XML file:

<NewDataSet>
<tblUserData>
<User_ID>Admini strator</User_ID>
<User_Name>So me Name</User_Name>
<User_Position> Analyst Programmer</User_Position>
<User_Departmen t>Forensic & Special</User_Department >
<User_Phone>0 3 9632 0872</User_Phone>
<User_Fax>03 9632 0875</User_Fax>
</tblUserData>
</NewDataSet>

Now I convert the XML to an rtf file with the help of a xslt file:

string filename = @"\Inetpub\wwwr oot\PersonalDat a\xml\"+strTmp+ ".xml";
XslTransform xslt = new XslTransform();
xslt.Load(FILEN AME);
XPathDocument xpathdocument = new XPathDocument(f ilename);

XmlTextWriter writer = new
XmlTextWriter(@ "\Inetpub\wwwro ot\PersonalData \xml\"+strTmp+" .rtf",
System.Text.Enc oding.Default);

xslt.Transform( xpathdocument, null, writer, null);
writer.Close();

This is the according XSLT file:

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:styleshe et xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:text>{\rtf 1</xsl:text>
<xsl:for-each select="NewData Set/tblUserData">
<xsl:text>\b </xsl:text>
<xsl:value-of select="User_Na me"/>
<xsl:text>\b0 </xsl:text>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Po sition"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_De partment"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Ph one"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Fa x"/>
</xsl:for-each>
<xsl:text>}</xsl:text>
</xsl:template>
</xsl:stylesheet>

But the problem is that the & is not converted into &.

Some Name
Analyst Programmer
Forensic &amp; Special
03 9632 0872
03 9632 0875

What could be the problem here? I tried using Schema as well, still the same
problem. Please help

Thank you

Chris

[Dinh Duy Tran]

Chris,

Your XML file is not a well formed XML file.
A well fromed XML file should not contains & but &amp;.
The xslt.Transform( ) "smart" enough to convert &amp; to & if the
<xsl:output method="text" /> was used.
I ran your example with &amp; in the Xml file and here is what I got:
{\rtf1\b Some Name\b0 \par Analyst Programmer\par Forensic & Special\par 03
9632 0872\par 03 9632 0875}

So you might want to check your output Xml file and make sure that it was
written correctly.

Duy
CSDP/MCSD

"chris" <ch***@discussi ons.microsoft.c om> wrote in message
news:B5******** *************** ***********@mic rosoft.com...

Hi there,
I create an XML file from a dataset like this:

System.IO.Strea mWriter xmlSW = new System.IO.Strea mWriter(FILENAM E);
dsUserData1.Wri teXml(xmlSW, XmlWriteMode.Wr iteSchema);
xmlSW.Close();

Which gives me this XML file:

<NewDataSet>
<tblUserData>
<User_ID>Admini strator</User_ID>
<User_Name>So me Name</User_Name>
<User_Position> Analyst Programmer</User_Position>
<User_Departmen t>Forensic & Special</User_Department >
<User_Phone>0 3 9632 0872</User_Phone>
<User_Fax>03 9632 0875</User_Fax>
</tblUserData>
</NewDataSet>

Now I convert the XML to an rtf file with the help of a xslt file:

string filename = @"\Inetpub\wwwr oot\PersonalDat a\xml\"+strTmp+ ".xml";
XslTransform xslt = new XslTransform();
xslt.Load(FILEN AME);
XPathDocument xpathdocument = new XPathDocument(f ilename);

XmlTextWriter writer = new
XmlTextWriter(@ "\Inetpub\wwwro ot\PersonalData \xml\"+strTmp+" .rtf",
System.Text.Enc oding.Default);

xslt.Transform( xpathdocument, null, writer, null);
writer.Close();

This is the according XSLT file:

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:styleshe et xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:text>{\rtf 1</xsl:text>
<xsl:for-each select="NewData Set/tblUserData">
<xsl:text>\b </xsl:text>
<xsl:value-of select="User_Na me"/>
<xsl:text>\b0 </xsl:text>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Po sition"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_De partment"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Ph one"/>
<xsl:text>\pa r </xsl:text>
<xsl:value-of select="User_Fa x"/>
</xsl:for-each>
<xsl:text>}</xsl:text>
</xsl:template>
</xsl:stylesheet>

But the problem is that the & is not converted into &.

Some Name
Analyst Programmer
Forensic &amp; Special
03 9632 0872
03 9632 0875

What could be the problem here? I tried using Schema as well, still the
same
problem. Please help

Thank you

Chris

[Oleg Tkachenko [MVP]]

chris wrote:

Now I convert the XML to an rtf file with the help of a xslt file:
Nope, you are converting it to XML file, because you are transforming to
XmlTextWriter.
XmlTextWriter writer = new
XmlTextWriter(@ "\Inetpub\wwwro ot\PersonalData \xml\"+strTmp+" .rtf",
System.Text.Enc oding.Default);

xslt.Transform( xpathdocument, null, writer, null);
writer.Close(); <xsl:output method="text" />

This is ignored when transformtion is done to XmlWriter or XmlReader.
Transform to TextWriter or Stream instead.

--
Oleg Tkachenko [XML MVP, MCP]
http://blog.tkachenko.com