Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Commerce Server Userprofile management > direct bulk sql...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 255 of 267
Post > Topic >>

direct bulk sql script update to UserObject table

by =?Utf-8?B?Sm9obiBOLg==?= <kjgfkdjg@[EMAIL PROTECTED] > Jan 8, 2007 at 09:41 AM

hi,
is the above approach for CS2002 recomended by MS?

We need to run the bulk update to the user profiles (site is in production

)- flag all existing customers as a type of 'webcustomer' before the next 
release of the site. We are using one of the 5 custom properties
(u_pref1). 
This must be inside the Commerce profile to be able to target these users 
later.

I see the sql script provided in 
"update userobject
set userobject.g_org_id = organizationobject.u_Name 
from userobject, organizationobject
where userobject.g_org_id = organizationobject.g_org_id ".

Assumption is that we can safely run the update sql against this
USerObject.
is it correct?
-- 
John N.
 




 1 Posts in Topic:
direct bulk sql script update to UserObject table
=?Utf-8?B?Sm9obiBOLg==?=   2007-01-08 09:41:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 16:46:13 CST 2008.