XML / XSL

Re: XML Binding with Java

6-Jul-05 10:23

What kind of database? Can it export data as XML (e.g MSSQL can)? Is there any reason why not to use standard Java classes (JAXP) for working with XML? (link here[^])

David

qadirchalla@yahoo.com6-Jul-05 11:04

qadirchalla@yahoo.com

6-Jul-05 11:04

Hi David,

The database is Oracle 9i. The values in the XML tags are the field values from database. So there are two tasks : 1) Retrieving values from database 2) Write a XML validating against a schema.

Will I be able to validate against a schema while writing a XML using JAXP?

Thanks and Regards,
Abdul Qadir

Rendering xforms in xslt

korayyersel6-Jul-05 0:03

korayyersel

6-Jul-05 0:03

Hi people,
i have to change my html-form tags to xform tags in my xsl-file. i have added the xform namespace and changed the html-tags to xform-tags. and added <object id="FormsPlayer".. like in xhtml. but after transforming i dont get the form. i really couldn't find anything about it on the web. it is always about xhtml. can any body give me a link or a tip to begin??

i am sending now the original version with html-form.

thanx in advance

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xf="http://www.w3.org/2002/xforms" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.w3.org/2002/06/xhtml2">

<xsl:param name="format"></xsl:param>
<xsl:param name="e_anfang"></xsl:param>
<xsl:param name="e_anzahl"></xsl:param>

<xsl:template match="page">
<html>
<head><title>Cocoon - MA.BS.KY.CK</title></head>
<body bgcolor="#CCFFFF">
<h1 align="center" style="font-family:arial; font-size:30pt; color:#000066 ">Cocoon Projekt - Gruppe MA.BS.KY.CK</h1>
<xsl:apply-templates/>

<div style="text-align:left; padding:20px; margin:25px; position:relative; left Blush | :O

; top

;background-color:#BDEDFF;
position:relative; left Blush | :O

; top

;height:100; width:%100;border:thin solid lightblue;">
<p style="position: absolute; left Blush | :O

; top

;font-size:23pt; font-weight:bold; color:darkblue;font-family:arial;font-style:italic">Tagebuch</p>
<br></br><br></br><br></br>

<div style="background-color:#B4CFEC">
<br></br>

<p id="t2">2- Welches Übungsblatt wollen Sie sehen?</p>
<form action="ausgabe">
<select name="e_anfang">
<option>1</option><option>2</option><option>3</option><option>4</option><option>5</option><option>6</option><option>7</option>
</select>
<select name="format">
<option>pdf</option><option>html</option>
</select>
<input name="e_anzahl" type="hidden" value="1"></input>
<input type="submit" value="OK"></input>
</form>

<br></br>
</div>

</div>

</body>
</html>
</xsl:template>
</xsl:stylesheet>

XML relational data

Member 17770424-Jul-05 10:51

Member 1777042

4-Jul-05 10:51

Hi can someone please help

I have a XML and XSD file. My XML file holds three tables. 1 table holds the main data and the other two are used for lookups.

I want to display the data from the XML file in a grid, having used the lookup table to reslove descriptions.

this is my XML file

<newdataset>
<analysis>
<id>2
<description>test desc

<station>
<id>0
<description>All Listening

<analysis_id>2
<station_id>0
<demographic_id>1
<sweep_id>2004Q1
<value>99.9

<demographics>
<id>1
<description>old people

I would like to use VB.Net. I would also like to do some seltion on the XML file to selcct certain data such as demographic ID etc.

has anybody else done this?

Re: XML relational data

toujin4-Jul-05 14:06

toujin

4-Jul-05 14:06

Hi kiterjohnso

Assuming you're outputting HTML, this XSL should do the transformation you're after. Then you can use the ASP.NET XML web control to perform the XSLT transformation on the XML file server side.

<?xml version = "1.0"?>
<xsl:stylesheet version = "1.0"
xmlns:xsl = "http://www.w3.org/1999/XSL/Transform">
<xsl:template match = "NewDataSet">

<table border = "2">

<xsl:for-each select = "Data">

<xsl:variable name = "Analysis_ID">
<xsl:value-of select = "Analysis_ID"/>
</xsl:variable>

<xsl:variable name = "Station_ID">
<xsl:value-of select = "Station_ID"/>
</xsl:variable>

<xsl:variable name = "Demographic_ID">
<xsl:value-of select = "Demographic_ID"/>
</xsl:variable>

<tr>
<td>
<xsl:value-of select = "../Analysis[ID =

$Analysis_ID]/Description"/>
</td>

<td>
<xsl:value-of select = "../Station[ID =

$Station_ID]/Description"/>
</td>

<td>
<xsl:value-of select = "../Demographics[ID =

$Demographic_ID]/Description"/>
</td>
</tr>

</xsl:for-each>

</table>

</xsl:template>
</xsl:stylesheet>

I think you may want individual records in your XML file though, e.g.

<Demographics>
<Demographic />
<Demographic />
<Demographic />
</Demographics>

Otherwise, I don't see how the XPath can distinguish between multiple Demographic, Section and Analysis table rows.

Re: XML relational data

Member 17770425-Jul-05 9:42

Member 1777042

5-Jul-05 9:42

Hi toujin,

Thanks for this.

I am actually trying to develop a window app in VB.net. I was hoping to use a grid control.

My XML file is as below (my previous attemp went a bit wrong!)

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Analysis>
<ID>2</ID>
<Description>test desc</Description>
</Analysis>
<Station>
<ID>0</ID>
<Description>All Listening</Description>
</Station>
<Data>
<Analysis_ID>2</Analysis_ID>
<Station_ID>0</Station_ID>
<Demographic_ID>1</Demographic_ID>
<Sweep_ID>2004Q1</Sweep_ID>
<Value>99.9</Value>
</Data>
<Demographics>
<ID>1</ID>
<Description>old people</Description>
</Demographics>
</NewDataSet>

I would like to join these tables (or nodes?) to each other as you would with relational tables.

Is this possible or am i trying to use XML files for something it is not able to do.

Many thanks for your help

help needed for parsing XML document

satishrg1-Jul-05 9:04

satishrg

1-Jul-05 9:04

hi,

I need to get only the values of 2 nodes in the whole XML document and Even if the nodes are repeated in the XML document I need to get only the first nodes value.

Can any one suggest how to do this with the sample code.

Thanks in advance,
Satish.

Re: help needed for parsing XML document

DavidNohejl1-Jul-05 13:22

Need help creating objects from xml file!!

1-Jul-05 13:22

OK, I'll try. Use Sytem.Xml.XmlTextReader for this.

This is only example, since I don't know what nodes you want to read or how your XML file looks like.

int i = 0; // counter
while( reader.Read() && i<2)
{
  if( reader.NodeType == XmlNodeType.Element)
  {
    i++;
    node1 = reader.InnerXml; // get value of node (=>  change this line in order to work with real NodeType)
  }
}

Does it help?

David

Web Service chat?

wakkerjack1-Jul-05 3:45

wakkerjack

1-Jul-05 3:45

I want to make a chatting application using web services. Ne1 have an idea on how to do this?

Ur contribution is extremely valuable Smile | :)

richiemac30-Jun-05 0:44

30-Jun-05 0:44

Hi all,

I have a .xml file that looks similar to this,

<real_time_data_screen>

<screen_title>
<english>Screen Title</english>
<alternate_language>xzScreen xzTitle</alternate_language>
</screen_title>
<screen_classification>4294967295</screen_classification>
<screen_group>256</screen_group>

<guage_configuration>
<name>
<english>Guage Name</english>
<alternate_language>xzGuage xzName</alternate_language>
</name>
<guage_id>2</guage_id>
<units>
<english>Units</english>
<alternate_language>xzUnits</alternate_language>
</units>
<minimum>1</minimum>
<maximum>10</maximum>
<sections>
<number>10</number>
<limits>10</limits>
<color>234</color>
</sections>
</guage_configuration>

<analogue_variable>
<name>
<english>Variable Name</english>
<alternate_language>xzVariable xzName</alternate_language>
</name>
<input_values>
<minimum>1</minimum>
<maximum>10</maximum>
</input_values>
<output_values>
<minimum>1</minimum>
<maximum>10</maximum>
</output_values>
<needle_color>234</needle_color>
<guage_id>2</guage_id>
</analogue_variable>

<digital_led>
<name>
<english>LED Name</english>
<alternate_language>xzLED xzName</alternate_language>
</name>
<variable_id>2</variable_id>
<clear_color>255</clear_color>
<set_color>0</set_color>
</digital_led>

</real_time_data_screen>

I need to read through this file and create objects and update attributes depending on the data in this file. The objects will be screen, gauge, analogue and digitalLed. I've got very basic knowledge of xml and can just about read through the file and get elements and the corresponding value. How would I best go about reading throuh the file and when I find a screen tag (for instance) create a screen object and anything within that tag be written to the object.

Hope this makes sense and thanks in advance.

richiemac1-Jul-05 0:13

1-Jul-05 0:13

Not any ideas??? Frown | :(

Gavin Jeffrey1-Jul-05 2:20

Gavin Jeffrey

1-Jul-05 2:20

you may want to have a look at serialization check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexxml/html/xml01202003.asp[^]
or maybe do a search on google for serialization. I think (not sure here) but you need to have an object already defined before you can deserialize xml to it.
Another way (and im not sure if it is a good way) would be to go through the xml similar to this way:
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.load(xmlSource);
XmlNode screenNode = doc.documentElement.selectSingleNode("//real_time_data_screen")
now you have your screen portion of the xml and you can use that node to select whatever you want from the screen section e.g.
screenNode.selectSingleNode("//screen_title")

Something like that I anyways.

richiemac1-Jul-05 7:03

1-Jul-05 7:03

Thanks for the help. I'll look at it over the weekend and hopefully sort it out. I've sort of got it doing what I want but it's not retty and I know there's a better way.

Thank again for the pointers.

richiemac8-Jul-05 1:01

IE Requirements for DOM and XSLT?

8-Jul-05 1:01

This is what I came up with,

I used the XmlTextReader class to read start elements and then read the element strings. Info on the XmlTextReader class can be found here

Here's a small sample

vReader->ReadStartElement ( "screen_title" );<br />
			m_screen->EnglishTitle = vReader->ReadElementString ( "english" );<br />
			m_screen->AlternateTitle = vReader->ReadElementString ( "alternate_language" );<br />
		vReader->ReadEndElement (); // screen_title<br />
		m_screen->Classification = vReader->ReadElementString ( "screen_classification" );<br />
		m_screen->Group = vReader->ReadElementString ( "screen_group" );

Not great but for small simple Xml files this seems to do the job required.

Anonymous29-Jun-05 8:08

Anonymous

29-Jun-05 8:08

Hello,

What are the minimum IE requirements for DOM and XSLT?

Re: IE Requirements for DOM and XSLT?

DavidNohejl29-Jun-05 8:29

Re: IE Requirements for DOM and XSLT?

29-Jun-05 8:29

What do you mean by minimal requirements? Version of IE? here[^] are features of newest IE... look for DOM and MSXML features. However I don't know since when these features are present in IE, nor do I know if it was really your question. Blush | :O

David

Christian Graus29-Jun-05 11:59

Christian Graus

29-Jun-05 11:59

Version 5, I believe. But you can download the MSXML dll seperately, I dunno how well it fits in with IE if you do.

Christian Graus - Microsoft MVP - C++

infopath: need help

Steven M Hunt28-Jun-05 6:37

Steven M Hunt

28-Jun-05 6:37

I have just been put in charge of designing an infopath form to integrate into sharepoint services. Since I'm new to infopath, I need some help with a few things. First, I need to be able to load a picture from a link on the sharepoint list without using base64. Second, I have to have a text box which will update the database entries shown as the user types. Right now I have been using conditional formatting, but I'm unsure how to get the text box to trigger it after every character entered in the control.

Thanks in advance
-- Steve

Need resources for C++ & XML

Wheatbread28-Jun-05 5:03

Wheatbread

28-Jun-05 5:03

Hi! I was just given a project to read XML from a server and display the contents in our software. I figure there's an XML parser out there I wouldnt have to reinvent it, but I'm not sure what/where/how etc. I learned XML/XSL/XSLT 2 yrs ago, barely used it, and never with C++.

CAn someone give me info/advice on where to start? I'm not a DOM/COM expert just a C++/VC++ developer who's done more communication development than web stuff.

Any help would be useful. I have books on XML/XSL/XSLT, but none relating it to C++.

THanks in advance.
-C

Re: Need resources for C++ & XML

DavidNohejl28-Jun-05 7:12