Commerce Server Catalog - Catalog Migration

Author

Catalog Migration

Ravi Shankar

2004-05-20, 2:43 am

Hi,

Is there a mechanism whereby using an export and import
we can change the "product" type definition of a product ?

AND

Would FP1 Catalog Manager allow me to assign multiple
products to a category in a single operation ?

Regards.

Vinayak Tadas[MSFT]

2004-05-20, 5:42 pm

1. You should first delete the product from the catalog and then import
it with the new definition. Your xml should look something like
<Catalog name="Catalog1" variantUID="Variantcode"
productUID="ProductCode" DefaultLanguage="en-US" ReportingLanguage="en-US"
languages="en-US">
<Product DateChanged="2004-05-20T12:30:28" listprice="0"
action="delete" ProductCode="Book" />
<Product Definition="newdefinition" listprice="0" ProductCode="Book"
.................................. >
</Product>
</Catalog>

2. Yes you can assign multiple products to a category in a single
operation.

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

--------------------
Content-Class: urn:content-classes:message
From: "Ravi Shankar" <shankar.nospam@hp.com>
Sender: "Ravi Shankar" <shankar.nospam@hp.com>
Subject: Catalog Migration
Date: Wed, 19 May 2004 23:29:12 -0700
Lines: 11
Message-ID: <f97701c43e33$c3e27930$a001280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcQ+M8PiteK58F7ORpyzQDjz9suqOw==
Newsgroups: microsoft.public.commerceserver.catalog
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.catalog:4611
NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
X-Tomcat-NG: microsoft.public.commerceserver.catalog

Hi,

Is there a mechanism whereby using an export and import
we can change the "product" type definition of a product ?

AND

Would FP1 Catalog Manager allow me to assign multiple
products to a category in a single operation ?

Regards.

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

Ravi Shankar

2004-05-21, 7:56 am

Thanks.

The FP1 Catalog Manager is cool

Only issue I see is that no more CSV Imports

or I'm=20
missing something..

Regards.

>-----Original Message-----
>1. You should first delete the product from the=20
catalog and then import=20
>it with the new definition. Your xml should look=20
something like=20
> <Catalog name=3D"Catalog1" variantUID=3D"Variantcode"=20
>productUID=3D"ProductCode" DefaultLanguage=3D"en-US"=20
ReportingLanguage=3D"en-US"=20
>languages=3D"en-US">
> <Product DateChanged=3D"2004-05-20T12:30:28"=20
listprice=3D"0"=20
>action=3D"delete" ProductCode=3D"Book" />=20
> <Product Definition=3D"newdefinition" listprice=3D"0"=20
ProductCode=3D"Book" =20
>.................................. >=20
> </Product>
> </Catalog>=20
>
>2. Yes you can assign multiple products to a category in=20
a single=20
>operation.=20
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms=20
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit=20
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>
>
>--------------------
>Content-Class: urn:content-classes:message
>From: "Ravi Shankar" <shankar.nospam@hp.com>
>Sender: "Ravi Shankar" <shankar.nospam@hp.com>
>Subject: Catalog Migration
>Date: Wed, 19 May 2004 23:29:12 -0700
>Lines: 11
>Message-ID: <f97701c43e33$c3e27930$a001280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset=3D"iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcQ+M8PiteK58F7ORpyzQDjz9suqOw=3D=3D
>Newsgroups: microsoft.public.commerceserver.catalog
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl=20
microsoft.public.commerceserver.catalog:4611
>NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
>X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
>Hi,
>
>Is there a mechanism whereby using an export and import=20
>we can change the "product" type definition of a=20
product ?
>
>AND
>
>Would FP1 Catalog Manager allow me to assign multiple=20
>products to a category in a single operation ?
>
>Regards.
>
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms=20
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit=20
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>

Vinayak Tadas[MSFT]

2004-05-21, 5:55 pm

We did not add the CSV import functionality to FP1. You can script that
using COM CatalogManager object. Do you use CSV imports and exports for
your catalog system?

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

--------------------
Content-Class: urn:content-classes:message
From: "Ravi Shankar" <shankar.nospam@hp.com>
Sender: "Ravi Shankar" <shankar.nospam@hp.com>
References: <f97701c43e33$c3e27930$a001280a@phx.gbl>
<Grn6ZSqPEHA.3972@cpmsftngxa10.phx.gbl>
Subject: RE: Catalog Migration
Date: Fri, 21 May 2004 03:23:45 -0700
Lines: 102
Message-ID: <1027e01c43f1d$b28ca620$a501280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcQ/HbKK0KHPVzNvSpyAwaJ/DyJsHQ==
Newsgroups: microsoft.public.commerceserver.catalog
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.catalog:4616
NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
X-Tomcat-NG: microsoft.public.commerceserver.catalog

Thanks.
The FP1 Catalog Manager is cool

Only issue I see is that no more CSV Imports

or I'm
missing something..
Regards.
>-----Original Message-----
>1. You should first delete the product from the
catalog and then import
>it with the new definition. Your xml should look
something like
> <Catalog name="Catalog1" variantUID="Variantcode"
>productUID="ProductCode" DefaultLanguage="en-US"
ReportingLanguage="en-US"
>languages="en-US">
> <Product DateChanged="2004-05-20T12:30:28"
listprice="0"
>action="delete" ProductCode="Book" />
> <Product Definition="newdefinition" listprice="0"
ProductCode="Book"
>.................................. >
> </Product>
> </Catalog>
>
>2. Yes you can assign multiple products to a category in
a single
>operation.
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use. © 2002 Microsoft
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>
>
>--------------------
>Content-Class: urn:content-classes:message
>From: "Ravi Shankar" <shankar.nospam@hp.com>
>Sender: "Ravi Shankar" <shankar.nospam@hp.com>
>Subject: Catalog Migration
>Date: Wed, 19 May 2004 23:29:12 -0700
>Lines: 11
>Message-ID: <f97701c43e33$c3e27930$a001280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcQ+M8PiteK58F7ORpyzQDjz9suqOw==
>Newsgroups: microsoft.public.commerceserver.catalog
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.commerceserver.catalog:4611
>NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
>X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
>Hi,
>
>Is there a mechanism whereby using an export and import
>we can change the "product" type definition of a
product ?
>
>AND
>
>Would FP1 Catalog Manager allow me to assign multiple
>products to a category in a single operation ?
>
>Regards.
>
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use. © 2002 Microsoft
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

Ravi Shankar

2004-05-22, 5:52 am

CSV Import is the simplest of things when one is=20
migrating existing catalog/products structures. The=20
problem point was the category assignments in BizDesk.=20
Now with Catalog Manager the category assignments has=20
become very simple

Anyways, I would create a XML from the CSV file and=20
import that... but had to write the program to create the=20
XML

Regards.

>-----Original Message-----
>We did not add the CSV import functionality to FP1. You=20
can script that=20
>using COM CatalogManager object. Do you use CSV imports=20
and exports for=20
>your catalog system? =20
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms=20
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit=20
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>
>
>
>
>--------------------
>Content-Class: urn:content-classes:message
>From: "Ravi Shankar" <shankar.nospam@hp.com>
>Sender: "Ravi Shankar" <shankar.nospam@hp.com>
>References: <f97701c43e33$c3e27930$a001280a@phx.gbl>=20
><Grn6ZSqPEHA.3972@cpmsftngxa10.phx.gbl>
>Subject: RE: Catalog Migration
>Date: Fri, 21 May 2004 03:23:45 -0700
>Lines: 102
>Message-ID: <1027e01c43f1d$b28ca620$a501280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset=3D"iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcQ/HbKK0KHPVzNvSpyAwaJ/DyJsHQ=3D=3D
>Newsgroups: microsoft.public.commerceserver.catalog
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl=20
microsoft.public.commerceserver.catalog:4616
>NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
>X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
>Thanks.
>The FP1 Catalog Manager is cool

>Only issue I see is that no more CSV Imports

or I'm=20
>missing something..
>Regards.
>catalog and then import=20
>something like=20
variantUID=3D"Variantcode"=20[vbcol=seagreen]
>ReportingLanguage=3D"en-US"=20
>listprice=3D"0"=20
>ProductCode=3D"Book" =20
in=20[vbcol=seagreen]
>a single=20
and=20[vbcol=seagreen]
>confers no rights.
>Corporation. All rights
>specified at
>http://www.microsoft.com/security. Please
>microsoft.public.commerceserver.catalog:4611
>product ?
and=20[vbcol=seagreen]
>confers no rights.
>Corporation. All rights
>specified at
>http://www.microsoft.com/security. Please
>
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and=20
confers no rights.
>You assume all risk for your use. =A9 2002 Microsoft=20
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms=20
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit=20
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>

Vinayak Tadas[MSFT]

2004-05-24, 4:37 pm

Instead of converting the CSV to XML you can use the COm objects or the PIA
to import the CSV file itself. Wouldn't that be much simpler?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks

--------------------
Content-Class: urn:content-classes:message
From: "Ravi Shankar" <shankar.nospam@hp.com>
Sender: "Ravi Shankar" <shankar.nospam@hp.com>
References: <f97701c43e33$c3e27930$a001280a@phx.gbl>
<Grn6ZSqPEHA.3972@cpmsftngxa10.phx.gbl>
<1027e01c43f1d$b28ca620$a501280a@phx.gbl>
<M3MP0Q2PEHA.304@cpmsftngxa10.phx.gbl>
Subject: RE: Catalog Migration
Date: Sat, 22 May 2004 00:36:10 -0700
Lines: 185
Message-ID: <1094a01c43fcf$73e1e220$a501280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcQ/z3PFNUw8aWkCTbGHXFtMavIorQ==
Newsgroups: microsoft.public.commerceserver.catalog
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.catalog:4624
NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
X-Tomcat-NG: microsoft.public.commerceserver.catalog

CSV Import is the simplest of things when one is
migrating existing catalog/products structures. The
problem point was the category assignments in BizDesk.
Now with Catalog Manager the category assignments has
become very simple

Anyways, I would create a XML from the CSV file and
import that... but had to write the program to create the
XML

Regards.
>-----Original Message-----
>We did not add the CSV import functionality to FP1. You
can script that
>using COM CatalogManager object. Do you use CSV imports
and exports for
>your catalog system?
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use. © 2002 Microsoft
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>
>
>
>
>--------------------
>Content-Class: urn:content-classes:message
>From: "Ravi Shankar" <shankar.nospam@hp.com>
>Sender: "Ravi Shankar" <shankar.nospam@hp.com>
>References: <f97701c43e33$c3e27930$a001280a@phx.gbl>
><Grn6ZSqPEHA.3972@cpmsftngxa10.phx.gbl>
>Subject: RE: Catalog Migration
>Date: Fri, 21 May 2004 03:23:45 -0700
>Lines: 102
>Message-ID: <1027e01c43f1d$b28ca620$a501280a@phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcQ/HbKK0KHPVzNvSpyAwaJ/DyJsHQ==
>Newsgroups: microsoft.public.commerceserver.catalog
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.commerceserver.catalog:4616
>NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
>X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
>Thanks.
>The FP1 Catalog Manager is cool

>Only issue I see is that no more CSV Imports

or I'm
>missing something..
>Regards.
>catalog and then import
>something like
variantUID="Variantcode"[vbcol=seagreen]
>ReportingLanguage="en-US"
>listprice="0"
>ProductCode="Book"
in[vbcol=seagreen]
>a single
and[vbcol=seagreen]
>confers no rights.
>Corporation. All rights
>specified at
>http://www.microsoft.com/security. Please
>microsoft.public.commerceserver.catalog:4611
>product ?
and[vbcol=seagreen]
>confers no rights.
>Corporation. All rights
>specified at
>http://www.microsoft.com/security. Please
>
>
>Thanks
>Vinayak Tadas
>Microsoft
>http://blogs.msdn.com/vinayakt
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>You assume all risk for your use. © 2002 Microsoft
Corporation. All rights
>reserved.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>Get Secure! For more info visit
http://www.microsoft.com/security. Please
>reply to the newsgroups only. Thanks
>

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks