Commerce Server Catalog - Virtual Catalogs, 2 questions

Author

Virtual Catalogs, 2 questions

Sandra Castellanos

2004-05-11, 8:20 pm

Hi everybody

I am using a virtual catalog with only one base catalog included in it. I
want to know 2 things:

1. Since it's not adviced to rebuild the catalogs in a production server, I
would like to have this catalog non-materialized instead of materialized.
The documentation sais this is the default, but it just created the tables
from the moment I created it on the BizDesk, and I don't know how to make
it non-materialized
2. This is what is causing me the biggest trouble: It changes the productid
and the category code and adds the name of the base catalog to it. How can I
avoid this behavior? it completely screws up everything else.

Thanks in advance for your help

SC

Vinayak Tadas[MSFT]

2004-05-11, 8:20 pm

1. You dont need to do anything. By default the virtual catalog will be non
materialized.
2. What are the exact issues you are facing? One thing you can do is use the
DisplayName property instead of categoryname or productid if you want it to
display it on site. The DisplayName value will come from the base catalog
display names.

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

"Sandra Castellanos" <sandrac@washuway.com> wrote in message
news:evVIc73NEHA.2876@TK2MSFTNGP09.phx.gbl...
> Hi everybody
>
> I am using a virtual catalog with only one base catalog included in it. I
> want to know 2 things:
>
> 1. Since it's not adviced to rebuild the catalogs in a production server,
I
> would like to have this catalog non-materialized instead of materialized.
> The documentation sais this is the default, but it just created the tables
> from the moment I created it on the BizDesk, and I don't know how to make
> it non-materialized
> 2. This is what is causing me the biggest trouble: It changes the
productid
> and the category code and adds the name of the base catalog to it. How can
I
> avoid this behavior? it completely screws up everything else.
>
> Thanks in advance for your help
>
> SC
>
>

Sandra Castellanos

2004-05-11, 10:41 pm

It doesn't look like it's non-materialized by default. It is creating physical tables for the virtual catalog, and everytime I change something in the base catalog, I have to rebuild the virtual one. That, as far as I've read, is the behavior for the mate
rialized virtual catalog.

I tried with the .vbs script that comes in the /support folder, and it sais the operation completed successfuly, but its still doing the same thing.

The issue I am having is that it is changing the ProductID field, it is adding the catalog name at the end, and I need that field, I am using it for several things, my problem is not with the display. The same thing goes for the categories.

The question I am asking is not how to work around my solution accepting that I can't get those fields clean. What I want to know is if I can do anything so that it leaves them intact.

Austin Skyles [MSFT]

2004-05-20, 8:37 pm

Both materialized and non-materialized virtual catalogs will have several
SQL tables created for them, however, non-materialized VCs will have
smaller tables, and will use the base catalog tables, while materialized
VCs will not use the base catalog tables except when rebuilding.

The category name without the appended catalog name is available in the
column OrigCategoryName, and the same for product ID is available in the
column OrigProductID.

Austin Skyles
Commerce Server
Microsoft Corporation

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

--------------------
Thread-Topic: Virtual Catalogs, 2 questions
thread-index: AcQ3xmCpDQ8ERIs9QIi9ASxSqNt4+w==
X-WN-Post: microsoft.public.commerceserver.catalog
From: =?Utf-8?B?U2FuZHJhIENhc3RlbGxhbm9z?=
<anonymous@discussions.microsoft.com>
References: <evVIc73NEHA.2876@TK2MSFTNGP09.phx.gbl>
<eTN1jK7NEHA.1340@TK2MSFTNGP12.phx.gbl>
Subject: Re: Virtual Catalogs, 2 questions
Date: Tue, 11 May 2004 19:11:03 -0700
Lines: 7
Message-ID: <DFB22B8C-B8A6-4C09-A720-FB7C41D26B8F@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.catalog
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.catalog:4600
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.catalog

It doesn't look like it's non-materialized by default. It is creating
physical tables for the virtual catalog, and everytime I change something
in the base catalog, I have to rebuild the virtual one. That, as far as
I've read, is the behavior for the materialized virtual catalog.

I tried with the .vbs script that comes in the /support folder, and it sais
the operation completed successfuly, but its still doing the same thing.

The issue I am having is that it is changing the ProductID field, it is
adding the catalog name at the end, and I need that field, I am using it
for several things, my problem is not with the display. The same thing goes
for the categories.

The question I am asking is not how to work around my solution accepting
that I can't get those fields clean. What I want to know is if I can do
anything so that it leaves them intact.