| Nihit Kaul [MSFT] 2005-08-12, 8:48 pm |
| HI,
Don't know of any admin scripts, but you can delete the user profile data
independenly of whether they have Baskets/Orders etc. or not. The downside
would be that you would have orphaned Baskets that will probably never be
loaded since the correponding user profile would have been deleted.
So ideally you would want to clean up together, but it is not necessary
(i.e. you shouldn't see any errors because of this).
Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: Clean older basket
thread-index: AcWfLbEVmjX0WHPBRcmcTvqB+p9PVQ==
X-WBNR-Posting-Host: 213.201.74.174
From: "=?Utf-8?B?TWFyY2Vsbw==?=" <Marcelo@discussions.microsoft.com>
Subject: Clean older basket
Date: Fri, 12 Aug 2005 04:05:04 -0700
Lines: 5
Message-ID: <6221A0B6-427A-41C6-B8A5-498FF5C816E9@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.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3183
X-Tomcat-NG: microsoft.public.commerceserver.general
Are there any administrative scripts or SQL to clean up the older Basket
group
and User Object table? If not is it advisable to delete all those
unregistered user profiles based on whether there is any item on the basket
associated with the user account. Please advise.
|