XML / XSL

Help Required from XML guys - XMLIsland

18-Apr-06 14:55

// s_invoices contains the XML
string s_invoices;
XmlDocument doc = new XmlDocument();
doc.LoadXml(s_invoices);

string xpath =
"/Order_Invoice_Outgoing_Array_Element" +
"/Order_Invoice_Outgoing_Element" +
"/interface_transaction/child::text()";

XmlElement root = doc.DocumentElement;

XmlText interface_transaction =
(XmlText)root.SelectSingleNode(xpath);

if (interface_transaction != null)
{
Console.WriteLine(interface_transaction.Value);
}

Please note that "interface_transaction" is an element node not an attribute node.

Selvakumar.R17-Apr-06 20:49

Selvakumar.R

17-Apr-06 20:49

Hi I am developeing a web application in asp.net using vb.net and vbscript. In this I need XML data manipulation from server side to client side. I get data from Serverside ie
/*
txtXML= ds.getxml() 'here txtXML is hidden text box.
*/

and in client side
/*
strXML= document.Form1.txtXML.value
set objXMLDoc= CreateObject("Microsoft.XMLDom")
objXMLDoc.async= "false"
objXMLDoc.loadXML(strXML)

set ElementList = objXMLDoc.getElementsByTagName("Customers")
for i=0 to ElementList.length - 1
set objElementChild= ElementList.item(i).childnodes.item(1)
MsgBox objElementChild.text
next
*/

Here the problem is user can view all the xml data stored in the hidden text box. If he right click web page and click view source, he can view whole xmldata. I want to hide these data from user, and dont want to store any wehre else in the physical location.
Can i directly access any node from xml file ie parent node or child node or its attribute.
Please help me... with example project.
<NewDataSet>
<Customers id="001">
<Name>
<Fname>Maximas</Fname>
<Lname>Shel</Lname>
</Name>
<Sex>Male</Sex>
</Customers>
........
........
</NewDataSet>

can i access/ search any node from this xml like (fname,sex) and manipulate lname or sex for particular node.

Please help me... it is very urgent... i am in big trouble.....

Maximasshel

Re: Help Required from XML guys - XMLIsland

Paddy Boyd17-Apr-06 23:50

Paddy Boyd

17-Apr-06 23:50

Does it have to be done on the client side in this fashion?

Re: Help Required from XML guys - XMLIsland

Selvakumar.R18-Apr-06 1:57

Selvakumar.R

18-Apr-06 1:57

hi,
yes, i need it in client side, you can do it in your on ways both in server and client side(above specified code is just an example). We are using a client grid and it doesnot require posting. The reason is that loading thousands of data in each posting is difficult. Now i am maintaing a string and populate client grid from that string. And based on this string i am doing various operation like add,edit,search, grouping etc. Now i came to know that xml data manipulation is easier than string manipulation.
So i need solution in client side. Just i tried transfer xml data from server to client side using hidden text box. but user can able to view the whole data. I dont want alow this.
If any one know the solution pls help me.
If there is any better way of populating and transfering xml data to client side is also acceptable.
Rose | [Rose]

Maximasshel

Re: Help Required from XML guys - XMLIsland

George L. Jackson18-Apr-06 15:06

18-Apr-06 15:06

You can place your XML document on the web server and access it as follows:

<xml id="customer_id" src="http://www.codeproject.com/xmlFile.xml"></xml>

FOP

Support12317-Apr-06 20:04

Support123

17-Apr-06 20:04

Hi All

I have both the XML and XSL files named: SummarizedLedgerReport.xml, SummarizedLedgerReport.xsl

I need to know how to convert these two files to PDF using FOP(Formatting Objects Processor). I'v read up on it but i'm still not shure how to go about it.

Any advice is more then welcome

find rasult from xml

discktopsultan@hotmail.com15-Apr-06 23:57

15-Apr-06 23:57

i am using the following code to select rows in xml with a condition name = strVar:
"/accounts/account[name='"+strVar+"']/name"

my problem is,
how can i select rows with condition that name date is like strVar,
in SqlServer i use "select * from account where name like '%"+strVar+"%', but i ont know how it work with XML.

sultan

George L. Jackson17-Apr-06 3:19

17-Apr-06 3:19

XPath has a few functions that may help:

contains - Returns true if the first argument string contains the second argument string; otherwise returns false.

starts-with - Returns true if the first argument string starts with the second argument string; otherwise returns false.

substring - Returns the substring of the first argument starting at the position specified in the second argument and the length specified in the third argument.

substring-after - Returns the substring of the first argument string that follows the first occurrence of the second argument string in the first argument string.

substring-before - Returns the substring of the first argument string that precedes the first occurrence of the second argument string in the first argument string.

string-length - Returns the number of characters in the string.

Example:

"/accounts/account[contains(name,'" + strVar + "')]/name"

Another option is to select all of the "account" nodes and then filter out unwanted selected nodes using regular expressions or string funtions in your favorite managed or unmanaged language.

discktopsultan@hotmail.com17-Apr-06 23:28

17-Apr-06 23:28

Dear Mr George L. Jackson,
Thanks alot for your help, its exactlly what iam looking for and its work well. Big Grin | :-D

Sultan

discktopsultan@hotmail.com18-Apr-06 1:55

18-Apr-06 1:55

If i whant to search in more than one field in the same expression for ex:
i want to find the name of persons where they have middle name like 'Var1' and jobname like 'Var2'

So how can i use the apove expression ?

Sultan

George L. Jackson18-Apr-06 14:15

18-Apr-06 14:15

You can use the "and", "or" or "not()" operators.

Example:

"/accounts/account[contains(middle,'" + Var1 + "') and contains(jobname,'" + Var2 + "')]/name"

Of course, you will have to use the appropriate XPath function to do the proper search.

discktopsultan@hotmail.com18-Apr-06 23:36

I need a direction about XML/XSL/XSLT etc.

18-Apr-06 23:36

dear George L. Jackson
I unable to thank you as due,
and in the end thank you very much.

sultan

Cristoff13-Apr-06 20:57

Cristoff

13-Apr-06 20:57

I've used simple XSLT to convert XML to a web page but now I wonder how far can I go. That's why I want to ask a few questions what is possible.

Is it possible to create a full web site just using XML?

I want the transformations to occur on the server if possible. How can I do it. I have no idea at all. I have probably PHP support on the server (I'm not quite sure) but I can neither program it nor I want to learn it (except very basic stuff if needed) due to time constraints.

My goal is to create a web catalog that I feed with XML files about each product and images and they are displayed in particular order. So when I want to change something I just upload a new XML file or image. That's all. The goods won't be too many, maybe just a couple of hundereds or even much less.

Is this possible to create with XML/XSL/XSLT?

Which good modern book do you recommend me to read about that topic?

Thank you very much!

Michael A. Barnhart14-Apr-06 11:49

Michael A. Barnhart

14-Apr-06 11:49

Cristoff wrote:
Is it possible to create a full web site just using XML?

Yes and No.

You can define the content. But as you point out, it does need some xsl/xslt processing.

Cristoff wrote:
but I can neither program it nor I want to learn it

I will say a big problem. Developing good xslt is programing really. (Or call it another art form.)

Your issue is what enviroment do you want to use. If you are serious that you do not have time. Then I think that is your answer, you do not have time. Really depends on what you call basic stuff.

Cristoff wrote:
Is this possible to create with XML/XSL/XSLT?

Yes, very much so. Now which option to you want and what constraints do your clients force upon you?

Do a search on AJAX, and Apache Cocoon for some options. Now my guess is you do not have time for either. So what are you comfortable developing dynamic pages now? Select it, add xml processing and generate the basic pages just as you always have. Then add the content by getting the values of the xml element content from either the DOM or SAX models (for small and simpler to understand probably the DOM)

"Every new day begins with possibilities. It's up to us to fill it with things that move us toward progress and peace.” (Ronald Reagan)

Cristoff14-Apr-06 19:15

Cristoff

14-Apr-06 19:15

I have to clarify a few things here first. I hope I'll succeed. Smile | :)

I want to help you help me!

Michael A. Barnhart wrote:
Cristoff wrote:
Is it possible to create a full web site just using XML?
Yes and No.

Michael A. Barnhart wrote:
but I can neither program it nor I want to learn it

I will say a big problem. Developing good xslt is programing really. (Or call it another art form.)

I don't want to learn PHP but the server supports only PHP and MySQL. I'd rather use ASP.NET but it is not available.

I want to learn XSLT. My concern is if just XSLT and all other XML techs are enough for the job.
I know that IE 6, Firefox etc. have full support of XML, XSLT etc. so they can do the processing on the client side but I also want the site to be viewed by older browser so I need to process the date on the server. I just have no idea what is needed for the job. A special server or to program the processing in PHP, ASP.NET...

Michael A. Barnhart wrote:
Your issue is what enviroment do you want to use. If you are serious that you do not have time. Then I think that is your answer, you do not have time. Really depends on what you call basic stuff.

Well, I don't want to learn PHP because that will be the first and the last project I'll ever do with it but I'll definitely have much more use just for XML/XSLT. I already have done a personal site with both technologies and it works fine Smile | :)

(No you cannot view it, it is not on the web).

The site I'm working now is made mostly of static HTML pages + some JavaScript. I'm doing it with Dreamweaver. Once it is done I really have no time constraints to come up with a new version.
This time I would like to have all the data as XML that I can be created by another person manually.
Then when needed just the XML files are replaced without the need to change everything else (the way it is now).

If I had access to a server that supports .NET. I wouldn't have asked here at all.

Michael A. Barnhart15-Apr-06 1:25

Michael A. Barnhart

15-Apr-06 1:25

Sounds like you are most of the way then. Assuming the arrangement of the page is basically static, you can output the html declarations (header and body wrapping elements) with either text output from PHP or the initial output from the xslt processing. Then you add the changing html (table rows, or what ever) via the matching loops you have with the xslt processing. The XSLT process does not have to output xml. You do not have to learn much php, just enough to read in the xml file and then start the xslt processing.

Cristoff wrote:
If I had access to a server that supports .NET.

Same boat I am in right now. I have just about convinced myself to go with a different and more expensive service to add the capability.

"Every new day begins with possibilities. It's up to us to fill it with things that move us toward progress and peace.” (Ronald Reagan)