XML / XSL

Help: XML transform with XSL

21-Jul-05 7:56

Give this a try:

http://www.w3schools.com/xsl/xsl_for_each.asp[^]

Anonymous19-Jul-05 5:40

Re: Help: XML transform with XSL

19-Jul-05 5:40

Hi all,

I'm having a problem with my XSL converting to HTML. I can view all content fine, except the white space is not preserved! I thought whitespace was preserved by default? Confused | :confused:

For example in my XML:

<catalog>
<content>
lines and lines of text
more text
</content>
</catalog>

When transforming I get:

lines and lines of text more text

It's all bunched up...where did the newline characters go?

my XSL contains this:

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

Any ideas? Thanks.

Christian Graus19-Jul-05 11:19

Christian Graus

19-Jul-05 11:19

xsl:preserve-space[^] is what you need.

Christian Graus - Microsoft MVP - C++

Re: Help: XML transform with XSL

Anonymous19-Jul-05 13:14

Re: Help: XML transform with XSL

19-Jul-05 13:14

Thanks for the reply, but I have read that tutorial prior to posting here. I still have an issue with the whitespaces.

Plus W3Schools mentions the following:
Note: Preserving white space is the default setting, so using the <xsl:preserve-space> element is only necessary if the <xsl:strip-space> element is used.

So, by default, I shouldn't have to use the xsl:preserve-space. Although, I have tried either way...and the same result occurred. White-space was not preserved Confused | :confused:

Bluebamboo29-Jun-06 4:48

Bluebamboo

29-Jun-06 4:48

hi, did you resolve this problem, i have the same problem with you D'Oh! | :doh:

, if you've solved, plz tell me~

Webservice against DLL

dabuskol18-Jul-05 20:42

dabuskol

18-Jul-05 20:42

Guys,

Hope I am in the right forum.
What is the difference between the webservice and DLL? Which one is fater? It seems that both of them are the same it depends on how you will use it.
Just a clear explanation since I am new to WEBSERVICE.

I am C# programmer.

Re: Webservice against DLL

DavidNohejl19-Jul-05 2:48

My XmlFile looses its tree hierarchy after saving it

19-Jul-05 2:48

hi,

dabuskol wrote:
What is the difference between the webservice and DLL? Which one is fater? It seems that both of them are the same it depends on how you will use it.

well, when you use webservice, you actually call some methods from dll that is somewhere on the web. Communication (transfer of arguments and return value) is done via SOAP - it is XML based format, so you are close to the right forum Smile | :)

Dll on the other hand, is usualy on the same computer as caller. So obviously it is faster... but advantage of Web Service (WS) is that it is platform independent (all you need is to have implementation of SOAP) since communication is basicaly done via XML. And it is web service - it allows you to execute code on distant servers and get results from them.

I hope I said it understandably.

However, there is some study material:
http://msdn.microsoft.com/webservices/[^]

David

rudy.net18-Jul-05 5:44

rudy.net

18-Jul-05 5:44

Hello,
I read my xml file into a dataset and set the datasource of a datagrid to access one of the datatables. Problem is that when new rows are added to the datagrid, and I call the WriteXml method, the new rows are added at the root.
Following is an example:
<?xml version="1.0" standalone="yes"?>
<root xmlns="http://tempuri.org/Database.xsd">
<Database>
<Positions>
<Position PositionCode="1" PositionName="Operations Supervisor" Salary="0" />
</Positions>
</Database>
</root>

Then I set the DataSource to of a datagrid to "Position" table and after adding a couple of rows, the saved file looks like:
<?xml version="1.0" standalone="yes"?>
<root xmlns="http://tempuri.org/Database.xsd">
<Database>
<Positions>
<Position PositionCode="1" PositionName="Operations Supervisor" Salary="0" />
</Positions>
</Database>
<Position PositionCode="2" PositionName="Secretary" Salary="0"/>
<Position PositionCode="3" PositionName="LazyGuy" Salary="0"/>
</root>

Note that the new rows were added in "/root" instead of in "root/Database/positions"

file containing specification of default namespace

Suman Singh18-Jul-05 4:31

Suman Singh

18-Jul-05 4:31

Hi all,

I want to know the name of the file which contains the specification of default namespace(www.w3.org/2001/XMLSchema) in XML.

Plz help..

Suman Singh

execute xml

18-Jul-05 1:23

Hello,
I have a xml file:

<akis xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<element><sql:query>SELECT @Element</sql:query></element>
<rows><sql:query>EXEC sp_ForXML @Element,'XML'</sql:query></rows>
</akis>

and I need to get the results of that.Is there any way to get them not by running the stored procedure but from the xml itself?

thaks in advance,
akis

Memory leak?

LaxRoth17-Jul-05 21:29

LaxRoth

17-Jul-05 21:29

Hi, i'm trying to load an xml document from C++ with:

MSXML::IXMLDOMDocumentPtr pXMLDocument (__uuidof (MSXML:OMDocument)); // main document parsed

hr = pXMLDocument->loadXML (BSTRTemp); /* trying parse string, if success, we have doc object*/

this method uses offensive memory. i have xml files that are about 100MB size.

i feel the function does not clear the memory. anyone an idea?
if i load 3 times the same file, my memory is full.
Confused | :confused:

suggestion? is there a free method or something?

thank you,

lutz

Re: Memory leak?

Philip Fitzsimons20-Jul-05 5:23

Philip Fitzsimons

20-Jul-05 5:23

loading a 100mb xml file into the DOM model is going to hurt - you can expect it to take up 10 times the size on disk when its in memory....

so you could use the MSXML 3.0 Sax implementation instead...

http://www.xml.com/pub/a/2002/03/06/efficient.html?page=last&x-order=date[^]

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

Re: Memory leak?

LaxRoth21-Jul-05 21:04

LaxRoth

21-Jul-05 21:04

hi, thx for your answers. after several tests i think i will have to do this. Laugh | :laugh:

XML to Text with "C#"

fcn][Stampede17-Jul-05 9:07

fcn][Stampede

17-Jul-05 9:07

Hi guys,
I've tried some stuff with XML and XSLT in Java. I had to develop an application that would transform various standards (XML and text) into one overall standard (XML) and then into some other formats (again XML and text). I did it by using Xerces for the text->xml and xml->xml stuff, but it couldn't do the transformations from XML to text.

I know want to do the same thing with "C#" and again I don't know how to transform xml to text.

Does anyone know if it is possible with XSLT? And if yes, how can it be done?

greetz

Stampede

PS: An example of the transformation I need to do would be the following:

<myDoc>
<firstNode>asdf1</firstNode>
<secondNode>asdf2</secondNode>
<thirdNode>
<fourthNode>asdf3</fourthNode>
</thirdNode>
</myDoc>

this would be transformed into something like the following:

firstNode:'asdf1'
secondNode:'asdf2'
thirdNode#fourthNode:'asdf3'

Of course this is only an example, but I think it shows what I want to do.

Re: XML to Text with "C#"

Gavin Jeffrey17-Jul-05 21:02

Gavin Jeffrey

17-Jul-05 21:02

It should be possible check out this tutorial
http://www.w3schools.com/xsl/default.asp[^]

change in schema file

qadirchalla@yahoo.com17-Jul-05 1:50

qadirchalla@yahoo.com

17-Jul-05 1:50

Hi,

We are making use of SourceGenerator of Castor to generate Java class file from a given schema file and based on the class files we are calling the set functions of the respective classes to populate the corresponding tags in the XML file. We use the marshall function to generate the XML.

We might change the schema file in future, i.e. move some child tags in some different parent tags. for e.g.

excerpt of a schema file.

<empaddress>
<street> Street1
<pincode> 111111

<companyaddress>
<city> XYZ

New schema file:

<empaddress>
<pincode> 111111

<companyaddress>
<street> Street1
<city> XYZ

As it is visible, that <street> tag is moved under <companyaddress> tag. This change triggers change in the names of get/set functions for the corresponding classes and thus generates error during marshalling. Could you please suggest some steps, wherein no code change is required apart from class generation, to accomodate this change in schema file.

Thanks and Regards,
Abdul Qadir

Thanks and Regards,
Abdul Qadir

XSLT HTML > XML Transform

eggie514-Jul-05 7:06

eggie5

14-Jul-05 7:06

I have an xslt file that I use to transform an XML document to a html page. Can I use that same xslt file to change the html back to the original XML?

/\ |_ E X E GG

DavidNohejl14-Jul-05 7:38

14-Jul-05 7:38

I don't see how. Plus your HTML would have to be well formed XML (but that's ok because you surely have XHTML, right?) If the transformation is "1:1", it should be easy to write transfromation (X)HTML->XML based on original one. Maybe it could be even automatized.

David

malharone22-Jul-05 10:33

malharone

22-Jul-05 10:33

Your inverse XSLT may not always be accurate. Mathematically speaking,
f(x)=y, where X is the Xml file, f is the xslt file, and y is the output HTML. But it is also possible f(x2) is also y. So what I'm trying to get is that once you have a "Y", you may not always be able to distinctly identify which input xml produced that result as you may not have preserved all of the input elements/attributes in the output.

DavidNohejl22-Jul-05 10:48

22-Jul-05 10:48

malharone wrote:
Your inverse XSLT may not always be accurate.

You are of course right.

Key phrase in my "solution" is
If the transformation is "1:1"

I had in mind some special cases... Smile | :)

example:

// xml
<article>
<title>My Article</title>
<author>Me</author>
<chapter>Chapter 1</chapter>
<text>My Article</text>
</article>

//html
<html>
<head>
<title>My Article</title>
</head>
<body>
<h1>My Article</h1>
<p>My Article</p>
<center>© Me 2005</center>
</body>
</html>

should be easy no?

David

"Stay Kul And Happy" I.A.

malharone22-Jul-05 10:53

malharone

22-Jul-05 10:53

I think simple cases as such should not have any problems. Places where you'd run into issues is when Xslt groups/aggregates and/or sorts the data.

Though bit challenging, you'll have to make sure that the formatting does not change when going XML->HTML. If it does, you'll have to take care of the special case.

I'm not sure if the following is a typo. But if it is not, then your conversion from HTML->XML will lose "Chapter 1" value.
dnh wrote:
My Article

- Malhar

DavidNohejl22-Jul-05 11:03

22-Jul-05 11:03

malharone wrote:
I think simple cases as such should not have any problems. Places where you'd run into issues is when Xslt groups/aggregates and/or sorts the data.

I agree.

malharone wrote:
I'm not sure if the following is a typo. But if it is not, then your conversion from HTML->XML will lose "Chapter 1" value.

yeah damnit, I forgot that Big Grin | :-D

It should be only quick example... But you have the idea... and since none of us know how exactly eggie's XML/HTML/XSLT looks like, we won't get anywhere I guess.

David

xml and crystal report

yitong13-Jul-05 20:42

yitong

13-Jul-05 20:42

hello..

i'm trying to do a system which the crystal report will display the data generate from my class coding.

but i know one way is to use xml to read the data from calss first. and then crystal report only can display the data from xml file....

how can i do that? totally no idea on how to do...
if anyone knows that, pls help.... thanks a lot

XML to DataGrid

Anonymous12-Jul-05 9:50