|
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
|
|
|
|
|
Sorry, it was my mistake in the Code, I was writing the dataset also in the output file. It is resolved now.
|
|
|
|
|
# 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>
|
|
|
|
|
how can i access an XML file in vc++ 6.0 using .ini file without using MSXML parser?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
You mean by controls you create dynamically within the XSLT ? Well, you can only create HTML, you can't create asp:xxx controls, they just get added to the page too late. My point though is that you create a proper page, with code behind, then add the contents of your XSLT to the static control for rendering. You can still add other controls and you will get their events. If you have, for example, a button being added to the page every time, rethink your layout, try to remove it from the XSLT. The easiest way to do this is to add C# extensions to your XSLT, and then use them to set the properties of buttons you've added yourself. It's possible to dynamically add controls to the pages collection and get their events, so long as then number/names of the controls don't change and you do it early enough.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
hi..i am stud of comp sci and currently doing some research and developing few steganography techniques that can be applied on xml doc....as far as i have searched there isn't much work done on it....if any one here has stumbled across any related work or 've any knowledge abt it..plz share with me..maybe i 've missed something..it 'll help me alot....plz feel free to let me know if u 've any suggestions regarding steganography & xml...thanks
|
|
|
|
|
|
thanks for not telling me anything  ..it was helpful
|
|
|
|
|
Hi,
I have an XML file and the corresponding schema file generated by XMLSpy Home Edition. How can I create C++ classes from this schema? I am looking for a free tool, if there is such a thing.
Thanks,
Royce
|
|
|
|
|
At the start-up of my application, I need to read XML data that is likely to be spread out over several individual XML files. Data from the first file will be read and updated, then the first file can be closed for the duration of the process. Then the next file will be read and updated, then the file can be closed for the duration of the process. This will occur for all the XML files (there could be 20 or 30 XML files that will likely average about 120k-150k). This will all be done as the application initializes.
This leads to my question. Which parsing model is better suited for my needs: XMLDOM or XML Reader? I recognize that there could be differing opinions on the subject but I would greatly value and appreciate some expert advice.
Speed is probably my biggest issue as I want the application initialization to finish as quickly as possible.
My understanding is that XMLDOM provides quicker read/write access but could take a while to be loaded into memory whereas the XML Reader method provides slower read/write access but doesn’t require the memory overhead or loading time of XMLDOM.
The way I currently have it implemented is with the XML Reader model. I read the XML file, update the data, and write the entire XML file back out. There doesn’t seem to be a better way as this model does not appear to allow random access or in-place data insertion. Am I wrong about this?
Thanks in advance,
-Ian
|
|
|
|
|
hi there,
I am not XML expert, but
Ian Bowler wrote:
My understanding is that XMLDOM provides quicker read/write access but could take a while to be loaded into memory whereas the XML Reader method provides slower read/write access but doesn’t require the memory overhead or loading time of XMLDOM.
The fact that XMLDOM is "faster" is true AFTER it's readed to memory and parsed - and reading and parsing takes time... I don't see reason why using XmlReader should be slower.  It depends on what you with XML. See below.
Ian Bowler wrote:
The way I currently have it implemented is with the XML Reader model. I read the XML file, update the data, and write the entire XML file back out. There doesn’t seem to be a better way as this model does not appear to allow random access or in-place data insertion. Am I wrong about this?
It doesn't allow random access because XmlReader reads XML file sequentionaly - token after token - you never have whole document in memory. If you only update some values,
For .NET world, XmlReader is definitely fastest way how to read XML document.
Some useful links:
Skipping Content with XmlReader[^]
Comparing XmlReader to SAX Reader[^]
Patterns & practices: Chapter 9 — Improving XML Performance[^]
and, finally:
Efficient Techniques for Modifying Large XML Files[^]
(my personal favourite)
Rule of thumb: if you don't need to change structure of XML document ("tree operations"), don't use XmlDocument (if you care about speed and memory). Use XmlReader/XmlWriter instead. If you want to search/select using XPath expression in XML, use XPathDocument.
You should be able to answer core of your question yourself, but I'll do that anyway: if your modifications can be easily done with XmlReader/XmlWriter combination, then it's most probably fastest solution. (in sense of best performing, not ease of programming however)
David
Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidy
|
|
|
|
|
Thanks for your reply. I'm sure those links will be very helpful as I continue to learn XML.
Regards,
Ian
|
|
|
|
|
XMLDOM can be allowed to save edited XML Documents and provides the facility to transform the XML data using XSLT.
raman
|
|
|
|
|
Hi All,
I am trying to build an application in VS.Net which uses Crystal Report 11 to build the rpt file. I have an XML and XSD file as my datasources. I want to view the report in PDF format. Now my source code looks like:
ReportDocument doc = new ReportDocument();
string fileName = Server.MapPath("MyReport.rpt");
doc.Load(fileName);
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("MyXML.xml"));
doc.SetDataSource(ds);
ExportOptions exportOpts = doc.ExportOptions;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.DestinationOptions = new DiskFileDestinationOptions();
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
((DiskFileDestinationOptions)doc.ExportOptions.DestinationOptions).DiskFileName = Server.MapPath("MyPDF.pdf");
doc.Export();
But it gives me the error
"Query Engine Error: 'c:\inetpub\wwwroot\MyWebsite\MyReport.rpt'"
I tried out all the forums but could not find any solution. Someone told me that it is due to xsd file error. But in Crystal Report it is running perfectly OK. Can anyone help.
Edit/Delete Message
|
|
|
|
|
hi there. i was just wondering whether a developer should use wfs/wms in implementing a gml map.
|
|
|
|
|
How do you get the underlying stylesheet content of an XslTransform object in .NET? In other words, how do you know what transformation the XslTransform object does? Assume that the object was created and loaded with something somewhere else, but you don't know what was loaded to it. You want to know exactly what was loaded to it (the content of the stylesheet file that was loaded to the object).
What property of the object will let you see that?
Thanks
Shell
|
|
|
|
|
Currently I'm in the process of writing a simple XSL to transform XHTML to the XML format understood by TallPDF.NET[^].
I struggle with a simple thing: Paragraphs with bold and italic. Here is an example:
<p>This is some text in <b>bold</b> and in <i>italic</i>.</p> Now I want to transform it to something like this:
<textPragraph>
<fragment>This is some text in </fragment>
<fragment bold="true">bold</fragment>
<fragment> and in </fragment>
<fragment italic="true">italic</fragment>
<fragment>.</fragment>
</textParagraph>I.e. make the nested original XHTML into a flat list.
I'm not that XSL-T expert, so maybe someone can answer my questions:
- Is it possible at all to do that in XSL (please remember that I usually don't know which tags are nested inside each other)?
- If yes, could you provide a simple example as a starter for me?
Thanks
Uwe
--
Affordable Windows-based CMS: www.zeta-producer.com
|
|
|
|
|
I have the following code:
Start Date
<xsl:attribute name="value">
<xsl:apply-templates select="StartDateTime">
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
which gives me a selection box with years from 2000 to 2010 and it is working properly. However, I wanted to make it more generic displaying years from current year - 5 to current year + 5. For that I have the following function:
<msxsl:script xmlns:msxsl="urn:schemas-microsoft-com:xslt" language="javascript" implements-prefix="extra">
function getYearListBoxOptions()
{
var sYear;
var sOptions = "";
var dateNow;
var i = 0;
dateNow = new Date();
sYear = dateNow.getYear() - 5;
for (i=0; i < 11; i++)
{
sOptions = sOptions + "<option value=" + '"' + (sYear + i) + '"' + ">" + (sYear + i) + "</option>"
}
return sOptions;
}
Now, the xsl looks like this:
But, I am getting an empty selection box ..Can somebody tell me what is going wrong?
|
|
|
|
|
Reposting as the 1st post had some parts missing
I have the following code:
Start Date
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
which gives me a selection box with years from 2000 to 2010 and it is working properly. However, I wanted to make it more generic displaying years from current year - 5 to current year + 5. For that I have the following function:
function getYearListBoxOptions()
{
var sYear;
var sOptions = "";
var dateNow;
var i = 0;
dateNow = new Date();
sYear = dateNow.getYear() - 5;
for (i=0; i < 11; i++)
{
sOptions = sOptions + "" + (sYear + i) + ""
}
return sOptions;
}
Now, the xsl looks like this:
But, I am getting an empty selection box...Can somebody tell me what is going wrong?
|
|
|
|
|
jignatiu wrote:
Now, the xsl looks like this:
hmm, and where is your XSL?? I think you meant something like
&xsl:template match="select">
....
<xsl:template/>
or am I missing something?
David
Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
