BizTalk Server Applications Integration - XML of Commerce Server 2002 -> Biztalk 2004

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > August 2004 > XML of Commerce Server 2002 -> Biztalk 2004





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author XML of Commerce Server 2002 -> Biztalk 2004
TalkBiz

2004-08-13, 7:48 am

Dear experts,

I must process a purchase order which comes from Commerce Server
2002. My colleague coded an e-commerce site with c# and he gave me an XML
file corresponding to a submitted purchase order.


I think Biztalk Server 2004 is not made to function with XML
files generated by Commerce Server 2002. When you see the "fake" XML
generated by Commerce Server :
--------------------------------------------------------------------------
<OrderGroup version="1.0"><DICTIONARY
xmlns:dt="uuid:304FB305-29A4-11d3-B0D4-00C04F8ED7A2" version="1.0">
<DICTITEM key="saved_cy_shipping_total"><VALUE
dt:dt="decimal">15</VALUE></DICTITEM>
<DICTITEM key="order_status_code"><VALUE dt:dt="i4">1</VALUE></DICTITEM>
<DICTITEM key="user_id"><VALUE dt:dt="string"
xml-space="preserve">{8D253B5D-23BE-477E-AA81-0102C3E387E1}</VALUE></DICTITEM>
<DICTITEM key="g_UserIDChangedBy"><VALUE dt:dt="string"
xml-space="preserve">{8D253B5D-23BE-477E-AA81-0102C3E387E1}</VALUE></DICTITEM>
....
....
---------------------------------------------------------------------------------------

based on an XDR schema like :

---------------------------------------------------------------------------------------
<?xml version="1.0"?>
<!-- Generated by using BizTalk Editor on Tue, Apr 24 2001 04:18:48 PM -->
<!-- Microsoft Corporation (c) 2000 (http://www.microsoft.com) -->
<Schema name="orderform" b:BizTalkServerEditorTool_Version="1.0"
b:root_reference="orderform" b:standard="XML"
xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes"
xmlns:b="urn:schemas-microsoft-com:BizTalkServer">
<b:SelectionFields/>

<ElementType name="orderform" content="eltOnly" model="open">
<b:RecordInfo/>
<AttributeType name="payment_method">
<b:FieldInfo/></AttributeType>
<AttributeType name="billing_address_id">
<b:FieldInfo/></AttributeType>
<AttributeType name="PayloadID">
....
....
---------------------------------------------------------------------------------------

you deduce one thing : you can't work with this stuff and Biztalk 2004 (even
if you convert your XDR file to an XML schema with .xsd extension, generated
by a tool in Biztalk 2004).

If any Microsoft expert can tell me how to process XML coming from Commerce
Server 2002 with Biztalk server 2004, he'll save us. This is very critical to
our project and we are stucked since one week.

I suggested a solution : when the purchase order is submitted, save it to the
database and then generate the XML and XML schema corresponding to the
purchase order form, doing :

DataSet.GetXML() and DataSet.GetXmlSchema()

But nobody agrees with me : they tell that we need a generic XML schema for
all purchase orders and what I do with the Dataset corresponds to a
particular case. True, but is there a better solution ?

Hope you understand my mail. Don't hesitate a second if you have an idea, a
suggestion, a remark ...


thanks a lot,
Paniny

PS : we are now installing Biztalk 2002 at the office. If Commerce Server
integrates with Biztalk 2002, we won't purchase Biztalk 2004 and all I
learned about Biztalk 2004 since 2 months would be a waste of time and energy


Jeff Lynch

2004-08-13, 7:48 am

See my reply posted in microsoft.public.biztalk.general

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/



"TalkBiz" <TalkBiz@discussions.microsoft.com> wrote in message
news:762EF0D3-88E1-4299-B647-E7C7073EDF85@microsoft.com...
> Dear experts,
>
> I must process a purchase order which comes from Commerce

Server
> 2002. My colleague coded an e-commerce site with c# and he gave me an XML
> file corresponding to a submitted purchase order.
>
>
> I think Biztalk Server 2004 is not made to function with XML
> files generated by Commerce Server 2002. When you see the "fake" XML
> generated by Commerce Server :
> --------------------------------------------------------------------------
> <OrderGroup version="1.0"><DICTIONARY
> xmlns:dt="uuid:304FB305-29A4-11d3-B0D4-00C04F8ED7A2" version="1.0">
> <DICTITEM key="saved_cy_shipping_total"><VALUE
> dt:dt="decimal">15</VALUE></DICTITEM>
> <DICTITEM key="order_status_code"><VALUE dt:dt="i4">1</VALUE></DICTITEM>
> <DICTITEM key="user_id"><VALUE dt:dt="string"
>

xml-space="preserve">{8D253B5D-23BE-477E-AA81-0102C3E387E1}</VALUE></DICTITE
M>
> <DICTITEM key="g_UserIDChangedBy"><VALUE dt:dt="string"
>

xml-space="preserve">{8D253B5D-23BE-477E-AA81-0102C3E387E1}</VALUE></DICTITE
M>
> ...
> ...
> --------------------------------------------------------------------------

-------------
>
> based on an XDR schema like :
>
> --------------------------------------------------------------------------

-------------
> <?xml version="1.0"?>
> <!-- Generated by using BizTalk Editor on Tue, Apr 24 2001 04:18:48 PM -->
> <!-- Microsoft Corporation (c) 2000 (http://www.microsoft.com) -->
> <Schema name="orderform" b:BizTalkServerEditorTool_Version="1.0"
> b:root_reference="orderform" b:standard="XML"
> xmlns="urn:schemas-microsoft-com:xml-data"
> xmlns:dt="urn:schemas-microsoft-com:datatypes"
> xmlns:b="urn:schemas-microsoft-com:BizTalkServer">
> <b:SelectionFields/>
>
> <ElementType name="orderform" content="eltOnly" model="open">
> <b:RecordInfo/>
> <AttributeType name="payment_method">
> <b:FieldInfo/></AttributeType>
> <AttributeType name="billing_address_id">
> <b:FieldInfo/></AttributeType>
> <AttributeType name="PayloadID">
> ...
> ...
> --------------------------------------------------------------------------

-------------
>
> you deduce one thing : you can't work with this stuff and Biztalk 2004

(even
> if you convert your XDR file to an XML schema with .xsd extension,

generated
> by a tool in Biztalk 2004).
>
> If any Microsoft expert can tell me how to process XML coming from

Commerce
> Server 2002 with Biztalk server 2004, he'll save us. This is very critical

to
> our project and we are stucked since one week.
>
> I suggested a solution : when the purchase order is submitted, save it to

the
> database and then generate the XML and XML schema corresponding to the
> purchase order form, doing :
>
> DataSet.GetXML() and DataSet.GetXmlSchema()
>
> But nobody agrees with me : they tell that we need a generic XML schema

for
> all purchase orders and what I do with the Dataset corresponds to a
> particular case. True, but is there a better solution ?
>
> Hope you understand my mail. Don't hesitate a second if you have an idea,

a
> suggestion, a remark ...
>
>
> thanks a lot,
> Paniny
>
> PS : we are now installing Biztalk 2002 at the office. If Commerce Server
> integrates with Biztalk 2002, we won't purchase Biztalk 2004 and all I
> learned about Biztalk 2004 since 2 months would be a waste of time and

energy
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com