|
Home > Archive > Commerce Server General > January 2006 > CS 2002 and MSGP product synchronisation
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 |
CS 2002 and MSGP product synchronisation
|
|
| Brandon Fraser 2006-01-05, 2:49 am |
| Hi All,
I'm sure this has been done before. My products system and inventory will be
managed in MSGP and contains around 15,000 products. This products need to
be synchronised to CS 2002 every night for pricing, new products and
inventory stock level update. I'm thinking of blatting the CS 2002 product
database in a nightly batch update from MSGP. Question is how do I do this.
Is there any step by step guide/implementation white paper from microsoft or
any other company? I've been trying to find this on the net for a few days
with no luck and now turning to the newsgroup for your expertise.
Anyone can recommend the best way of doing this to me?
Thanks,
B
| |
| Ravi Shankar 2006-01-05, 2:49 am |
| Hi Brandon,
You should explore the use of BizTalk for such a purpose and MSGP has an
adapter which will help you integrate Catalog/Order and such flow to/from
MSCS... Additionally there is an example for integrating such components into
Commerce Server available as the Retail2002B2B application in the Retail2002
sample site.
Also included in the RetailB2B site is a document that talks about
integrating external product/inventory/order systems with Commerce Server.
--
Ravi Shankar
"Brandon Fraser" wrote:
> Hi All,
>
> I'm sure this has been done before. My products system and inventory will be
> managed in MSGP and contains around 15,000 products. This products need to
> be synchronised to CS 2002 every night for pricing, new products and
> inventory stock level update. I'm thinking of blatting the CS 2002 product
> database in a nightly batch update from MSGP. Question is how do I do this.
> Is there any step by step guide/implementation white paper from microsoft or
> any other company? I've been trying to find this on the net for a few days
> with no luck and now turning to the newsgroup for your expertise.
>
> Anyone can recommend the best way of doing this to me?
>
>
> Thanks,
>
> B
>
>
>
| |
| Brandon Fraser 2006-01-05, 2:49 am |
| Hi Ravi,
Unfortunately BizTalk is not an option for us. This is for a fairly small
client with not much money to spend. We will have to do it ourself, I mean
extracting the products from MSGP and importing them into MSCRM.
Thanks,
B
"Ravi Shankar" <shankycheil@newsgroup.nospam> wrote in message
news:AB4A6DA0-B1B5-432B-8143-AD37CBCC1D1A@microsoft.com...
> Hi Brandon,
>
> You should explore the use of BizTalk for such a purpose and MSGP has an
> adapter which will help you integrate Catalog/Order and such flow to/from
> MSCS... Additionally there is an example for integrating such components
into
> Commerce Server available as the Retail2002B2B application in the
Retail2002[vbcol=seagreen]
> sample site.
>
> Also included in the RetailB2B site is a document that talks about
> integrating external product/inventory/order systems with Commerce Server.
> --
> Ravi Shankar
>
>
> "Brandon Fraser" wrote:
>
will be[vbcol=seagreen]
to[vbcol=seagreen]
product[vbcol=seagreen]
this.[vbcol=seagreen]
microsoft or[vbcol=seagreen]
days[vbcol=seagreen]
| |
| Ravi Shankar 2006-01-05, 7:56 am |
| Hi Brandon,
BizTalk Server Std version is considered cheap 
The other option you'd have is to write an application using the MSGP API to
help you get the catalog data, frame it into the XML as required by Commerce
Server and use a XMLHTTPServer request to send it across the network to a
Retail2002B2B\CatalogReceive type of service and you're done. Similar
approach for Inventory or you could write Pipeline Components which would
query MSGP on the fly for product inventory. These components you'd embedd
into your basket , total, accept pipelines.
Likewise you'd have to write a pipeline component in Commerce Server which
would be embedded in the Accept stage and submit the order into MSGP (the
Commerce Server order can be converted into an XML using customized
POSchema.xml and XMLDictionaryTransforms class, using XSL script and
transform it into something the MSGP understands and use XMLHttpSend to send
it across to MSGP)...
--
Ravi Shankar
"Brandon Fraser" wrote:
> Hi Ravi,
>
> Unfortunately BizTalk is not an option for us. This is for a fairly small
> client with not much money to spend. We will have to do it ourself, I mean
> extracting the products from MSGP and importing them into MSCRM.
>
> Thanks,
>
> B
>
> "Ravi Shankar" <shankycheil@newsgroup.nospam> wrote in message
> news:AB4A6DA0-B1B5-432B-8143-AD37CBCC1D1A@microsoft.com...
> into
> Retail2002
> will be
> to
> product
> this.
> microsoft or
> days
>
>
>
| |
| Brandon Fraser 2006-01-05, 6:03 pm |
| Hi Ravi,
Thanks for you help. I was thinking something in the like of SQL Server DTS
from the MSGP product table directly into Commerce Server's product table.
Is this doable? It sounds like the easiest way to implement it to me. But
again not exactly sure here since I have very little experience in this
matter. What do you think?
Regards,
B
"Ravi Shankar" <shankycheil@newsgroup.nospam> wrote in message
news:E3B1F806-8221-4EA4-B14D-2D8DF7DFF6B0@microsoft.com...
> Hi Brandon,
>
> BizTalk Server Std version is considered cheap
>
> The other option you'd have is to write an application using the MSGP API
to
> help you get the catalog data, frame it into the XML as required by
Commerce
> Server and use a XMLHTTPServer request to send it across the network to a
> Retail2002B2B\CatalogReceive type of service and you're done. Similar
> approach for Inventory or you could write Pipeline Components which would
> query MSGP on the fly for product inventory. These components you'd embedd
> into your basket , total, accept pipelines.
>
> Likewise you'd have to write a pipeline component in Commerce Server which
> would be embedded in the Accept stage and submit the order into MSGP (the
> Commerce Server order can be converted into an XML using customized
> POSchema.xml and XMLDictionaryTransforms class, using XSL script and
> transform it into something the MSGP understands and use XMLHttpSend to
send[vbcol=seagreen]
> it across to MSGP)...
>
> --
> Ravi Shankar
>
>
> "Brandon Fraser" wrote:
>
small[vbcol=seagreen]
mean[vbcol=seagreen]
an[vbcol=seagreen]
to/from[vbcol=seagreen]
components[vbcol=seagreen]
Server.[vbcol=seagreen]
need[vbcol=seagreen]
do[vbcol=seagreen]
few[vbcol=seagreen]
| |
| Ravi Shankar 2006-01-06, 2:57 am |
| Hi Brandon,
The only issue I see with this is that the underlying Catalog Schema within
the DB is not exactly a published schema by Microsoft. So sure, you'd be able
to figure out what goes where and create a DTS Task but another SP for CS
could break that... The API on the other hand would be supported.
So what you could do is write a DTS Task (ActiveX /w VBScript) which runs on
the commerce server machine (this way you'd have access to the Catalog
object) uses the MSGP database as source and generates a CatalogSchema
compliant XML which you can then upload... And since it is a DTS Task
you'd be able to schedule it too...
--
Ravi Shankar
"Brandon Fraser" wrote:
> Hi Ravi,
>
> Thanks for you help. I was thinking something in the like of SQL Server DTS
> from the MSGP product table directly into Commerce Server's product table.
> Is this doable? It sounds like the easiest way to implement it to me. But
> again not exactly sure here since I have very little experience in this
> matter. What do you think?
>
> Regards,
>
> B
>
> "Ravi Shankar" <shankycheil@newsgroup.nospam> wrote in message
> news:E3B1F806-8221-4EA4-B14D-2D8DF7DFF6B0@microsoft.com...
> to
> Commerce
> send
> small
> mean
> an
> to/from
> components
> Server.
> need
> do
> few
>
>
>
| |
| Colin Bowern 2006-01-06, 2:57 am |
| Hey Brandon,
You can certainly go the way of editing directly in the tables but there
is always the question of what is supported. A better solution might be
to interface with the Catalog web service which will make the changes on
your behalf. The other advantage of going with the Catalog web service from
Feature Pack 1 today is that it puts your code inline with what is coming
out with Commerce Server 2006 (albeit the BizTalk Adapters shipping with
CS2006 might just be worth a BizTalk license).
Cheers,
Colin
[vbcol=seagreen]
> Hi Ravi,
>
> Thanks for you help. I was thinking something in the like of SQL
> Server DTS from the MSGP product table directly into Commerce Server's
> product table. Is this doable? It sounds like the easiest way to
> implement it to me. But again not exactly sure here since I have very
> little experience in this matter. What do you think?
>
> Regards,
>
> B
>
> "Ravi Shankar" <shankycheil@newsgroup.nospam> wrote in message
> news:E3B1F806-8221-4EA4-B14D-2D8DF7DFF6B0@microsoft.com...
>
> to
>
> Commerce
>
> send
>
> small
>
> mean
>
> an
>
> to/from
>
> components
>
> Server.
>
> need
>
> do
>
> few
>
| |
| Brandon Fraser 2006-01-06, 2:57 am |
| Hi Colin,
What's this Catalog web service that you're talking about? I was under the
impression that I have to write my own code to process the catalog XML file
programmatically.
Thanks,
B
"Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
news:86cd1bdd6adf8c7e0793bd4df4e@msnews.microsoft.com...
> Hey Brandon,
>
> You can certainly go the way of editing directly in the tables but there
> is always the question of what is supported. A better solution might be
> to interface with the Catalog web service which will make the changes on
> your behalf. The other advantage of going with the Catalog web service
from
> Feature Pack 1 today is that it puts your code inline with what is coming
> out with Commerce Server 2006 (albeit the BizTalk Adapters shipping with
> CS2006 might just be worth a BizTalk license).
>
> Cheers,
> Colin
>
>
>
| |
| Ravi Shankar 2006-01-06, 7:55 am |
| Brandon,
CatalogWebService is a web service shipped as part of COmmerce Server 2002
Feature Pack 1 which provides a WinForms based application for management of
Catalogs as an alternative to BizDesk.
You do not have to process the Catalog XML manually as long as it conforms
to the MSCS Catalog Schema. The Catalog Schema XDR is available at
http://msdn.microsoft.com/library/?....asp?frame=true
Once you have the Catalog in this format you can use the
CatalogManager.ImportXML call documented at
http://msdn.microsoft.com/library/d....asp?frame=true
to import the catalog. Unfortunately this is not available in the BCL or
through the CatalogWebService currently..
--
Ravi Shankar
"Brandon Fraser" wrote:
> Hi Colin,
>
> What's this Catalog web service that you're talking about? I was under the
> impression that I have to write my own code to process the catalog XML file
> programmatically.
>
> Thanks,
>
> B
>
> "Colin Bowern" <colin.bowern@nospam.officialcommunity.com> wrote in message
> news:86cd1bdd6adf8c7e0793bd4df4e@msnews.microsoft.com...
> from
>
>
>
| |
| Colin Bowern 2006-01-06, 5:54 pm |
| Hey Brandon,
To add to Ravi's note just a word of warning that the schemas that you'll
often encounter in CS2002 were developed prior or during the creation of
a lot of the standards that exist today. Make sure to allocate some extra
time to getting the communication between the programs working.
Cheers,
Colin
[vbcol=seagreen]
> Brandon,
>
> CatalogWebService is a web service shipped as part of COmmerce Server
> 2002 Feature Pack 1 which provides a WinForms based application for
> management of Catalogs as an alternative to BizDesk.
>
> You do not have to process the Catalog XML manually as long as it
> conforms to the MSCS Catalog Schema. The Catalog Schema XDR is
> available at
> http://msdn.microsoft.com/library/?...svr2002/htm/cs_
> rp_xmlrefcatalog_ffdb.asp?frame=true
>
> Once you have the Catalog in this format you can use the
> CatalogManager.ImportXML call documented at
> http://msdn.microsoft.com/library/d...ary/en-us/csvr2
> 002/htm/cs_rp_catalogmanager_zbhs_c.asp?frame=true to import the
> catalog. Unfortunately this is not available in the BCL or through the
> CatalogWebService currently..
>
> "Brandon Fraser" wrote:
>
|
|
|
|
|