How to integrate xml into my app?

[dpdoug]

I have a project that lets the client select equipment for rental and the requisition will be sent to the client's SAP system to eventually create a PO.

The order information will be going over in the form of XML using xCBL standards.

I have been programming for 7 years including 1 1/2 years just in asp.net, but I am a newbie to working with XML in programming.

Does anyone have any suggestions where I can start as to how to intergrate this technology into my app? I have studied xml and xsl and related technologies, so this is not so strange to me, but how to glue it all together and make it work is what I don't have a clue to where to start. Any good articles on the subject?

What are the basic steps involved?

 

[SgtPeppa]

You should read up on the System.Xml Namespace! There are lots of possibilities to manipulate and create Xml Data!

Have a look at the XmlDocument, XmlReader, XmlWriter class

heres a link:

http://msdn.microsoft.com/library/d.../html/frlrfSystemXmlXmlDocumentClassTopic.asp

Hope that gets you started!

Stephan

 

[chiph]

If you're in VB6, use the MSXML 4.0 object library.

If you're in Java, I think you can use the Saxon library (not an expert in Java).

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first

 

[dpdoug]

My app is in asp.net.

I have no problem creating xml files, from what I've seen it seems like a pretty simple task to create xml files in .NET.

It's how they are sent and how the client gets them and whatever else they need to get from me is what I'm in the dark about.

Or do you just send them the path to the xml file in a hidden textbox when the form is submitted so they can open it and read it into their database?

 

[flumpy]

Hmm sounds like you are trying to integrate their database into your app. You are perhaps doing this backwards, they need to call your script from _their_ apps and read the xml into _their_ database. You do not "send" XML, you "get" XML.

By all means, allow them to download the XML format your app supplies via the web interface, and perhaps provide another version (pdf, excel, html) for them to peruse off-line. You can also provide API calls (SOAP, perhaps?) somewhere in the documentation/on the site that shows them how to integrate your data in to their systems but don't go as far as trying to send their database your XML! You can't possibly know that information.

XML is not an API and there is no XML magic that makes it work, it is simply human readable data and like any other type of data you (and they) have to process it first and, more importantly, know how to process it.

matt

 

[SgtPeppa]

Do you have the SAP Po Schema? If so you will need to create a Message that is valid acording to Sap!
Then you can push that data to the Sap System using the SAP.Net Connector. Have a look at their Website for further details:

http://www.microsoft-sap.com/

Stephan