XML / XSL

Re: Think i found the problem, but don't know how to fix it

27-Jul-06 22:00

Here is the part that contains the xml where the data is that i need to display

<TablePop>
<TableInfo Key="0">
<ClientName>Estelle</ClientName>
<ClientSurname>Van Graan</ClientSurname>
</TableInfo>
<TableInfo Key="1">
<ClientTitle>Mr</ClientTitle>
<ClientName>Natalie</ClientName>
<ClientSurname>Liebenberg</ClientSurname>
</TableInfo>
<TableInfo Key="2">
<ClientTitle>Mr</ClientTitle>
<ClientName>Irma</ClientName>
<ClientSurname>Du Plessis</ClientSurname>
</TableInfo>
<TableInfo Key="3">
<ClientTitle>Mr</ClientTitle>
<ClientName>Sandra</ClientName>
<ClientSurname>Nortje</ClientSurname>
</TableInfo>
<TableInfo Key="4">
<ClientTitle>Mr</ClientTitle>
<ClientName>Sandra</ClientName>
<ClientSurname>Nortye</ClientSurname>
</TableInfo>
<TableInfo Key="5">
<ClientTitle>Mr</ClientTitle>
<ClientName>Kathy</ClientName>
<ClientSurname>Ferreira</ClientSurname>
</TableInfo>
<TableInfo Key="6">
<ClientTitle>Mr</ClientTitle>
<ClientName>Antionette</ClientName>
<ClientSurname>Viloene</ClientSurname>
</TableInfo>
<TableInfo Key="7">
<ClientTitle>Mr</ClientTitle>
<ClientName>Lindsay</ClientName>
<ClientSurname>Scot</ClientSurname>
</TableInfo>
<TableInfo Key="8">
<ClientTitle>Mr</ClientTitle>
<ClientName>Waynand</ClientName>
<ClientSurname>Wessels</ClientSurname>
</TableInfo>
<TableInfo Key="9">
<ClientTitle>Mr</ClientTitle>
<ClientName>Anja</ClientName>
<ClientSurname>Eggers</ClientSurname>
</TableInfo>
<TableInfo Key="10">
<ClientTitle>Miss</ClientTitle>
<ClientName>Susca</ClientName>
<ClientSurname>Watts</ClientSurname>
</TableInfo>
<TableInfo Key="11">
<ClientTitle>Prof</ClientTitle>
<ClientName>Elsabe</ClientName>
<ClientSurname>Van Zyl</ClientSurname>
</TableInfo>
</TablePop>

He who laughs last...

Support12328-Jul-06 1:43

28-Jul-06 1:43

The part where i put

<xsl:for-each select=".|following-sibling::TablePop/TableInfo[position() < $STOP]">
<xsl:apply-templates select="."/>
</xsl:for-each>

I don't thing that the Template TablePop actualy gets applied. How do i go about it. Any help would be greatly appreciated.

Thank you in advance...

He who laughs last...

Thank you anyway

Support12328-Jul-06 2:52

28-Jul-06 2:52

Thank you anyway, i found the answer myself. It was hard but i did it. If any one needs an example, i have one Wink | ;)

He who laughs last...

FO Question

Are Jay27-Jul-06 9:57

Are Jay

27-Jul-06 9:57

I'm sorry closest forum on this topic.

<br />
fo:region-body padding-top="2in" padding-bottom=".5in" column-count="2" column-gap="10pt"<br />

At first when I started testing with this the columns were constructed fill the left first then the right but now that I'm using live data (Murphy's law ) it's filling the columns by alternating the data right then left right then left etc.....

I want it to fill left side first and when that is full go to the right side and fill it.

ANY HELP would be appricated.

Dustin Metzgar27-Jul-06 10:12

27-Jul-06 10:12

Could you modify your post to either ignore HTML tags or replace each < with a < and > with a >? All that can be seen of your XML is this:

fo:region-body padding-top="2in" padding-bottom=".5in" column-count="2" column-gap="10pt"

Logifusion[^]

Are Jay27-Jul-06 11:03

Are Jay

27-Jul-06 11:03

I'm sorry but that's all I posted. Is there other code your looking for?

I also failed to mention I don't use the FO alot, so.....

Support12327-Jul-06 21:45

27-Jul-06 21:45

Can you post a little more of your xsl file? I'm also new to fo but maby i can help...

He who laughs last...

Parsing XML Server Response

Are Jay28-Jul-06 4:46

Are Jay

28-Jul-06 4:46

Links to xsl and sample screen shot [^][^]

FrancisMH26-Jul-06 20:35

FrancisMH

26-Jul-06 20:35

Hi,
I have recently been thrown in the deep end with XML programming and need help. I am developing a web-site for my ISP and need to intergrate the XML functionality my down-stream provider has. At the moment I am able to send a request and get a response ok but I can't for the life of me figure out how to parse the response:

<form method="post" action="https://www.downstreamserver/xmlrequest.php" >
<%Response.Write("<input type=""hidden"" name=""xmlrequest"" value=""" & strXML & """>")%>
<input type="submit" name="submit" value="submit">

</form>

When the Submit button is pressed I get an XML page from the server which is being displayed in my browser. I want to use the information in the XML and place into a table on the page. I apologise for being such a newbie but I really need help with this.

James Boag. Genius

Re: Parsing XML Server Response

FrancisMH31-Jul-06 14:16

FrancisMH

31-Jul-06 14:16

It took me a while but I figured it out. Had to use a combination of Web Request and XMLTextReader (See MSDN).

James Boag. Genius

XSD code generation problems!

richiemac26-Jul-06 2:09

richiemac

26-Jul-06 2:09

Hi all,

I'm trying to use the xsd.exe to generate some c# classes. I don't have a problem with creating the classes, however, they are all generated in the same file. My question is, can I set the tool so that it creates these classes in separate .cs files or is there another freely available tool that can do the same thing.

thanks in advance guys.
rich

Re: XSD code generation problems!

richiemac26-Jul-06 2:12

richiemac

26-Jul-06 2:12

... or is there a tool around that will parse the .cs file for classes and create separate files. I don't how easy it is to do this but wouldn't feel conficent of doing it mysel. Smile | :)

How to get back color of table-cell from XML ??? [modified]

Rizwan Bashir26-Jul-06 0:58

Rizwan Bashir

26-Jul-06 0:58

I have an XML file which will contain the color of Table Cell.. i-e Blue,Green,Red depending upon the values. Is there any way to assign back-ground color of cell from these vales ????
I have tried variable and direct but in vain.the error comes when I write this

'@AIV = Variable which contains red,green or yellow

<fo:table-cell background-color="@AIV">
or
<fo:table-cell background-color='<xsl:value-of select="@AIV" />'>

Any Solution would be highly appreciated

-- modified at 6:58 Wednesday 26th July, 2006

Trasnsform XML from string

offengenden25-Jul-06 6:20

25-Jul-06 6:20

The problem is that I do not have any files. The XML I have stored in a variable (string or XmlDocument). And the second problem is that I need to return string that contains HTML.

Dustin Metzgar25-Jul-06 6:34

25-Jul-06 6:34

So what is your question?

Logifusion[^]

offengenden25-Jul-06 6:36

25-Jul-06 6:36

I don't know how to do this in C#.

Dustin Metzgar25-Jul-06 6:58

25-Jul-06 6:58

Don't know how to do what? You say you've got an XML stored in a string or an XmlDocument and you want to transform it to HTML. Do you have a stylesheet? Do you have to parse it with C# code? Do you have to handle both strings and XmlDocuments? Have you written any code yet? What does it do?

In order for someone to be able to help you, you have to explicitly spell out what you need help on. We can't read your mind.

Logifusion[^]

offengenden25-Jul-06 7:27

25-Jul-06 7:27

Ok, I have to build function in C# with next functionality:
1. The function must get two parameters: first is a string that holds xml, second is a string that holds a path to the XLS file.
2. The function must transform XML to HTML (according to XLS) and return it as a string.
That's all!

Dustin Metzgar25-Jul-06 7:42

25-Jul-06 7:42

Use System.Xml.Xsl.XslCompiledTransform:

XslCompiledTransform xslt = new XslCompiledTransform();
xslt.Load("output.xsl");

That loads the XSL. Now you have to perform the transformation using the Transform method. You'll have to pass it an XmlReader and XmlWriter since you start and end with a string.

XmlReader xr = new XmlReader(new StringReader(myInputString));
StringBuilder sb = new StringBuilder();
XmlTextWriter xtw = new XmlTextWriter(new StringWriter(sb));
xslt.Transform(xr, xtw);
return sb.ToString();

Logifusion[^]

offengenden25-Jul-06 10:57

An understanding of the USMT and how it works. [modified]

25-Jul-06 10:57

Thank you very much!
P.S.
I changed
XmlReader xr = new XmlReader(new StringReader(myInputString));
to
XmlReader xr = XmlReader.Create(new StringReader(myInputString));
And thank you again!

Sivaprasad C25-Jul-06 0:26

Sivaprasad C

25-Jul-06 0:26

Hi all,

about USMT and explain how it works?

Please let me know how to start, how to program an USMT (User State Migration Tool)

-- modified at 7:11 Tuesday 25th July, 2006

Page-Sequence in fop [modified]

Support12324-Jul-06 0:37

Re: Here is my xml layout [modified]

24-Jul-06 0:37

Hi All,

i want to create a page sequence for every page that has a table on it to minimize the memory consumption of fop...

i want it to look like this:

[-------------------------Heading--------------------------]
[--------------------------Date----------------------------]
<This is where the page sequence should start>
ClientName-------ClientSurname
Jan--------------Smit
Piet-------------Poggenpoel
Gert-------------Koekemoer
Jaun-------------Du Randt
Sandra-----------Smith
Sam--------------Watkens
James------------Small
James------------Dalton
Peter------------Edison
Hennie-----------Hannekom
Werner-----------Pienaar
Frik-------------Delport
Mariska----------de Lange
Sam--------------de Lange
<This is where i want the page sequence to stop>
<Now The Start of a new page sequence>
ClientName-------ClientSurname
Jan--------------Venter
Hanno------------Britz
Jannie-----------Jobert
Sannie-----------Jobert
Wilma------------Molen
Willie-----------Pretorius
<End of the page sequence>

<div class="ForumSig">He who laughs last...</div>

Support12324-Jul-06 0:52

Re: one page sequence for each TableEnties

24-Jul-06 0:52

<?xml version="1.0"?>
<?xml-stylesheet type='text/xsl' href='ClientLookUpResult.xsl'?>
<ClientLookUp>
<Title>
<Heading>Client Look-Up Result</Heading>
<DateCreated>Date Created: 24 July 2006 03:56 PM</DateCreated>
</Title>
<TableEntries>
<ClientName1>Yes</ClientName1>
<ClientSur1>Yes</ClientSur1>
<TableInfo Key="0">
<ClientName>Estelle</ClientName>
<ClientSurname>Van Graan</ClientSurname>
</TableInfo>
<TableInfo Key="1">
<ClientName>Natalie</ClientName>
<ClientSurname>Liebenberg</ClientSurname>
</TableInfo>
<TableInfo Key="2">
<ClientName>Irma</ClientName>
<ClientSurname>Du Plessis</ClientSurname>
</TableInfo>
<TableInfo Key="3">
<ClientName>Sandra</ClientName>
<ClientSurname>Nortje</ClientSurname>
</TableInfo>
<TableInfo Key="4">
<ClientName>Sandra</ClientName>
<ClientSurname>Nortye</ClientSurname>
</TableInfo>
<TableInfo Key="5">
<ClientName>Kathy</ClientName>
<ClientSurname>Ferreira</ClientSurname>
</TableInfo>
<TableInfo Key="6">
<ClientName>Antionette</ClientName>
<ClientSurname>Viloene</ClientSurname>
</TableInfo>
<TableInfo Key="7">
<ClientName>Lindsay</ClientName>
<ClientSurname>Scot</ClientSurname>
</TableInfo>
<TableInfo Key="8">
<ClientName>Waynand</ClientName>
<ClientSurname>Wessels</ClientSurname>
</TableInfo>
<TableInfo Key="9">
<ClientName>Anja</ClientName>
<ClientSurname>Eggers</ClientSurname>
</TableInfo>
<TableInfo Key="10">
<ClientName>Susca</ClientName>
<ClientSurname>Watts</ClientSurname>
</TableInfo>
<TableInfo Key="11">
<ClientName>Elsabe</ClientName>
<ClientSurname>Van Zyl</ClientSurname>
</TableInfo>
<TableInfo Key="12">
<ClientName>Magriet</ClientName>
<ClientSurname>Fourie</ClientSurname>
</TableInfo>
<TableInfo Key="13">
<ClientName>Adele</ClientName>
<ClientSurname>Van Eck</ClientSurname>
</TableInfo>
<TableInfo Key="14">
<ClientName>Elna</ClientName>
<ClientSurname>Booysen</ClientSurname>
</TableInfo>
<TableInfo Key="15">
<ClientName>Claudia</ClientName>
<ClientSurname>Henkel</ClientSurname>
</TableInfo>
<TableInfo Key="16">
<ClientName>Marius</ClientName>
<ClientSurname>Barnard</ClientSurname>
</TableInfo>
<TableInfo Key="17">
<ClientName>Heilet</ClientName>
<ClientSurname>Van Zyl</ClientSurname>
</TableInfo>
<TableInfo Key="18">
<ClientName>Frances</ClientName>
<ClientSurname>Bredenkamp</ClientSurname>
</TableInfo>
<TableInfo Key="19">
<ClientName>Carol</ClientName>
<ClientSurname>Waterston</ClientSurname>
</TableInfo>
<TableInfo Key="20">
<ClientName>Carly</ClientName>
<ClientSurname>Steyn-Pillay</ClientSurname>
</TableInfo>
<TableInfo Key="21">
<ClientName>Suzann</ClientName>
<ClientSurname>Stoman</ClientSurname>
</TableInfo>
<TableInfo Key="22">
<ClientName>Brett</ClientName>
<ClientSurname>Deeve</ClientSurname>
</TableInfo>
<TableInfo Key="23">
<ClientName>Lynn-Ann</ClientName>
<ClientSurname>Fuchsloch</ClientSurname>
</TableInfo>
<TableInfo Key="24">
<ClientName>Corina</ClientName>
<ClientSurname>Koorson</ClientSurname>
</TableInfo>
<TableInfo Key="25">
<ClientName>Debbie</ClientName>
<ClientSurname>Visagie</ClientSurname>
</TableInfo>
<TableInfo Key="26">
<ClientName>Francois</ClientName>
<ClientSurname>Coetzee</ClientSurname>
</TableInfo>
</TableEntries>
</ClientLookUp>

Support12324-Jul-06 0:57