XML / XSL

31-Oct-04 7:33

hi Makay,
I belive Word (at least latest version) can do a lot of work for you. I am in similar situation, cuz I have to convert XML data into .doc. I'm gonna do it using XSLT transfomation (XML->HTML) and then simply load HTML file into Word and save it like a .doc (using automation).
Best regards,
David 'DNH' Nohejl

Never forget: "Stay kul and happy" (I.A.)

XPath expression

Anonymous29-Oct-04 22:50

Anonymous

29-Oct-04 22:50

I'm writing a small application that is supposed to get metadata from an SQL server database and store that information as xml.

Here is a part of an example xml file:

<database name="the_name">
<structure>
<table name="table_name">
<pk>PK</pk>
<column name="PK">
<type>int</type>
<identity>
<startvalue>5</startvalue>
<increment>2</increment>
</identity>
</column>

The <identity> part is optional for each <column>. So what I want is an xpath expression that can get me the name of the <column> that has an <identity> part.
I tried these two expressions. They dont get the name of the column but I thought it would get the <column> node atleast:

/database/structure/table[@name='" + tableName + "'/column/identity]
/database/structure/table[@name='" + tableName + "'][/column/identity]

Here 'tableName' is a variable I insert there, and the name of that is correct.
Anyone knows how to do this? Is it even possible with one xpath expression?

Re: XPath expression

Stuart Dootson29-Oct-04 23:05

Stuart Dootson

29-Oct-04 23:05

For your example, try this:

"/database/structure/table[@name='" + tableName + "']/column[identity]/@name"

Evaluating this in XMLSpy (after substituting the table name, obviously) gives me the name attribute with value 'PK'. Adding more columns with an identity child element leads to their names also being returned.

HTH

Stuart Dootson

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

XML Element Naming

ITMan29-Oct-04 4:35

ITMan

29-Oct-04 4:35

Hi All,
I have a doubt regarding XML elements naming.
Let say I have an XML document having an element
called .
If I add a sub-element to the element with the
same name for e.g.

Is the above structure recommendable?
Will this structure cause any problems while parsing the XML file
using MSXML DOM parser?

Please guide me.
Thanks in advance,
Abhishek.

HTML from XML

Boniolopez27-Oct-04 23:57

27-Oct-04 23:57

Hi all,
once more starter question.
I am starting with XML and XSLT. I created XML document and XSLT to it. But the IE shows to me not what I expect. Can I somehow see the HTML, which comes after the transformation? (Or how can I debug my stuff?)
Thanks,
boni

DavidNohejl28-Oct-04 1:49

28-Oct-04 1:49

show some source, plz...
Boniolopez wrote:
But the IE shows to me not what I expect.
What does it show?
btw It's good to see that you are starting with XSLT Wink | ;)

If I saw this post litle earlier, I would not suggest u this in post above Blush | :O

Never forget: "Stay kul and happy" (I.A.)

Boniolopez28-Oct-04 2:55

28-Oct-04 2:55

Hi Dave,
thank you for your very clear answer in my previous posting. Now I understand the idea, and what I have to do.
Algthouth I don't think, that it is worse to post my XSL errors into forum so far Smile | :)

. . The question is how can I debug the output of the transformation myself. I want to see the HTML code, which is generated after the transformation, but if I make "show source" in the IE, it shows the XML before the transformation. Is it some magic too, whic looks like
magic_tool input.xml input.xsl >output.txt

Thanks in advance,
boni

DavidNohejl28-Oct-04 6:10

28-Oct-04 6:10

Boniolopez wrote:
if I make "show source" in the IE, it shows the XML before the transformation.
Of course it does. Original XML is real source stored in file, isn't it? If you want to see transformed source, transform your XML into HTML, then save transformed HTML into file and only then open this file in IE. If you work in .NET, magic tool can be XslTransform class for System.Xml.Xsl namespace. Write little app which saves transformed XML into HTML file or something like that. With MSDN or google it won't be difficult task.
David

Never forget: "Stay kul and happy" (I.A.)

Boniolopez28-Oct-04 9:29

28-Oct-04 9:29

Thank you for your great help.

Visualize XML

Boniolopez26-Oct-04 11:21

26-Oct-04 11:21

Hi all,
am new with xml, so may be the question is not very correct. I have the xlm description of the electonic shema. This description includes nodes (i.e. transistors, resistors ...) and wires. Now I want to visualize the circuit with intenet explorer. I have somehow to make IE to understand, that when it meet in XML transistor it has to take the picture transistor.gif... After all elements are placed it has to draw the wires in the optimal way (route on the fly?I have an algorithm but don't know where to put it in xml).
I have absolutely no idea how XML can be visualized. Please could you give me the starting point.
Thanks,
Boni

Re: Visualize XML

DavidNohejl27-Oct-04 10:17

27-Oct-04 10:17

hi Boni,
oh oh... i only see lots of xslt and javascript and CSS Cry | :((

or plug-in to IE. Yeah, plug-in shoud be better option, but still it's quite difficult I think (I never made any plugin). At least, it is possible to archive your goal Wink | ;)

However, IMO its far easier to make win app for it instead of use IE.
best regards,
David 'DNH' Nohejl

Never forget: "Stay kul and happy" (I.A.)

Re: Visualize XML

Boniolopez27-Oct-04 23:02

27-Oct-04 23:02

Hi David, hi all
thank you very much for your reply.
I have now easier question. Lets leave the routing outside (As far as I understand you javascript and plug-in are from routing, right?). How can I say the IE that if it meets a tag "Transistor" to take a picture "transistor.gif". Is it easy? Do I supposed to use XSLT or CSS? (sorry, I don't know much about both and the resources I could find so far about XSLT was not very clear. On other side I use CSS to change font colors on the page and so on, but don't know how it can help to solve my problem.)
Thanks alot,
Boni

Re: Visualize XML

DavidNohejl28-Oct-04 1:33