View Full Version : XML Automate upload/doanload ??

08-13-2002, 04:15 PM
Hi guys,

I would appreciate if you could answer my questions as I have to send the feedback to management soon.

We are in the process of reviewing a system that would store our orders and manipulate them in their system as we send data to them. This could be a text file.

But, Now we are thinking about using XML and the vendor already has XML part in place (but in two steps).

One is "Download XML Orders" and other is "Upload XML Order". So, we need to download the orders in XML format and the make changes in XML file as we made in our system and then upload it again in XML format using their system.

Now this issue is that we are maintaing orders in "our" system and we have to make extra steps and efforts to reflect the data into their system

Basically we want to automate the XML uploading to their ("vendor's) system as the changes occur in our system. We don't want to download the XML data and make changes and upload again.

I guess I have explained a lot in detail about the needs.

Please pass on some views and suggestions !! Any help is appreciated.

Thanks a lot.


Alex Vincent
08-14-2002, 02:55 AM
Whew. That's a spicy meatball. :)

The key, I suppose, is not in how they store the XML documents, but in the bridges they build to the XML data.

To give you an analogy, let's consider how I typically develop a server-side webpage. I start with MySQL (which stores the information in a database), to expressly define how I want the data formatted. Then I build the HTML pages for the user interface. Then I build PHP scripts as bridges between the user interface and the MySQL database.

If your client were talking about MySQL, I'd recommend you look at the PHP (or Perl, which is another server-side language that can access MySQL). Your client is talking about XML.

So, that brings to mind something else. Specifically, how do you want to note changes in XML files, and upload only those changes... and then have the server translate those changes back into the original XML files?

Also, in what way is the server receiving the XML files and storing them? In what way is the server returning XML files to you?

If my hunch about the essence of your question is correct, this thread belongs in Server-side programming help. Please tell me if I'm right or wrong, so I can react accordingly. :cool:

08-14-2002, 03:41 PM
Hi Alex,

Yes, the question is real spicy!!!

Well, a part of your answer your a correct. And let me clear few things about the scenario if I understood your answer(with my limited knowledge about their system, I was just told about the objective and given the training manual of the system).

Alex] The key, I suppose, is not in how they store the XML documents, but in the bridges they build to the XML data.
NRastogi] That's true. Doesn't matter how they store it on their system. Key is how we two parties communicate? We use "Progress" database and don't what they use for severside and that's what I wonder how to automate the two database changes using XML.

If we download the XML file for orders from their system (whatever database they are using they have the XML download and upload procedure in place and defined the fields and format for the XML data), guessing for automation we need to generate the XML file off our Progress database and compare "their" and "ours" and overwrite "treir" with "ours" changes ??? Correct me if I am wrong !! But how ???? Never dealt w/ XML automation before, got the basic traning on XML !

Please suggest me what way should I go? I am sorry if I have repeated my question if other words or something!

If you think that this thread belongs in Server-side programming help, Please move it there and we'll see if somebody has answer to this.

Thanks again Alex, I don't have much information about their end for now!!


Alex Vincent
08-16-2002, 04:28 AM
Moved. Question: Do you know what server-side languages are involved? (PHP, Perl, etc).

08-17-2002, 02:48 AM
hi , google 'XML RPC' which is a nice(ish) transport (via HTTP) using XML as the data format, there are XML-RPC implementations available for most of the major languages, I have played around with XMPRPC servers in PHP but still cant find a good reason to use XML rather than just serialise the data etc, but thats between 2 systems I have control over, wheras XML should make the transfer platform independant

anyway http://www.xmlrpc.com/