Windows Server

Colin Bowern · Guest

I'm looking to export my orders through to a BizTalk Server 2004
orchestration. I've successfully generated a schema from POSchema.xml so I
can modify it to the appropriate structure that I'm using in the orderform.
I haven't come across (although I'm still researching) a way to export an
XDR schema from the BTS2004 development tools so I can use the XDR Schema
with the DictionaryXMLTransforms interop class.

Does anyone have any insight on how they are managing the POSchema.xml
today? Are you using something other than DictionaryXMLTransforms to
transform the PurchaseOrder.Xml dump to a cleaner XML format?

Thanks,
Colin

Ravi Shankar · Guest

Hi Colin,

We recently did an integration between Commerce Server, BizTalk 2002 and
Navision 3.2 where we did it the following way

1. Create a pipeline component in MSCS which used the
DisctionaryXMLTransform to convert the PO into XML and uses XMLHTTP to send
it across to a BTS HTTP Receive Function. One point of caution for
DictionaryXMLTransform is that it does not handle the "DateTime" format
correctly... ie: when you convert the PO as per the poschema.xml (available
in Retail2002 solution) the will fail validation in BTS because it converted
the dates into "yyyyMMdd hh:mm" format while the correct XML DateTime
representation is "yyyyMMddThh:mm". So in the pipeline component after a
transformation, the datetime values were amended maually before passing them
to BTS.

2. On the BTS side the OrderReceive was handled through the
BizTalkHTTPReceive.dll (HTTP Receive function synchronous submission) and
mapped to the NAVISION SO schema and then passed on through the Navision AIC
through to NAVISION.

In BTS 2004, the HTTP Receive function still exists so you should be able to
get the PO across. The critical point was realizing that
DictionaryXMLTransform did not handle the DateTime transformation correctly.
--
Ravi Shankar

Colin Bowern · Guest

Hi Ravi,

Thanks for the heads-up on the date. I'll keep an eye out for that. With
regards to adding fields to the POSchema.xml did you edit it by hand or did
the BTS2002 editor support the save/export of XDR Schemas? BTS2004 can import
but doesn't seem to have an export function for XDR-S.

Cheers,
Colin

Ravi Shankar · Guest

the poschema.xml is a BizTalk Compatible schema (so it shoudl be in an XDR
format). In BTS2002, I did a open and save to webdav... and used the BizTalk
Editor to add/modify the schema.

In BTS2004, You should be able to add it to a BTS project through "add",
"existing" and open it in VS.Net for addition/modifications..
--
Ravi Shankar

Colin Bowern · Guest

Hey Ravi,

The only thing you can do with XDR Schemas is import them. If you add an
existing item it will just open it up in a text editor view. I guess I'll
need to pull a copy of BTS2002 down from MSDN.

Cheers,
Colin

Philip · Guest

Hi Ravi and Colin,

Can you help? We are trying to get training on commerce gateway for the
last 3 months with no success. We have done a lot of works with Biztalk
2002, and 2004 with ERP. Can you let me know what we need to do to hook it
to Navision 3.7 or 4.0

--
Philip

Ravi Shankar · Guest

Hi Philip,

Navision 3.7 has a component called the Navision Application Server &
Navision Commerce Gateway... the Application Server provides connectivity to
the NAVISION back-end while the Commerce Gateway provides the AIC (BizTalk
2002) that you can use to integrate Navision through BizTalk. The Commerce
Gateway has the XDR schemas for various business objects such as Sales Order,
Invoice, Shipment Notification, Goods Receipts and such..

For more NAVISION related queries you should try the Navision group (?).
--
Ravi Shankar

Colin Bowern · Guest

Hey Philip,

I gave up on trying to edit the POSchema and instead I am serializing the
order through strongly-typed .NET wrapper of the OrderGroup. It was faster
to go that route than deal with the older stuff.

If you guys are looking to deploy CS at Bell I'd contact your MS account
rep and get into the CS2006 TAP to get a look at the next release (and while
you're at it fix my DSL line! <grin>).

Cheers,
Colin

jcollin · Guest

Hi Colin
Sorry to jump in like this - but I'm facing somewhat of th
same problem. In your last message you say you used a strong-type
.NET wrapper. What are you generating that from, the POSchema.xsd i
so are you manually adding the extra fields you need? And at tha
point are you just pulling the data by brute force from th
Dictionary object and assigning them to the class?

Jim

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1