Rooms: Casanova 502, Sands Level 1
Primary Instructor:
- James Divine - Primary Instructor
- Gavin Lowe - Secondary Instructor
- Jeanette Smith - Track Lead
- Fred Delbart - TA
- Kelli Hoeppner - TA
- Top Tanti - TA
something is wrong with that site at the moment.
B2C user question from earlier if you are already set up for users on the sys_user table.
For those like me who are already set up for Incident, Requests etc.. and have their users in the sys_user table and are wanting to add CSM to their system you notice the the issue that the CASE identifies the POC via the csm_consumer table, not the sys_user table. Well, this table has a field called User Login that is a reference to the csm_consumer_user table. This table is extended from the sys_user table.
So as a test, i moved my record row to the csm_consumer_user table and created a consumer profile. I was able to log in via Single SignOn with no issues. A fix script would be needed to move your data from sys_user to csm_consumer_user and keep the same sys_id so you don't loose any user history. Then update your user load transform to point to the new consumer_user table. I would keep any custom accounts like ones used for integration on the sys_user table and just move the accounts of users that you need to identify in CASE, Incident etc...
**SAFE HARBOR HERE IS MY THOUGHT HOW TODO IT - NOT FULL TESTED AND VETTED**
Sample Script to move the user but keep the same sys_id for history and create Consumer profile:
//Fix Script fun in background
var oldRecord = new GlideRecord('sys_user');
oldRecord.addQuery('user_name=sphelan');//testing on this one user
oldRecord.addQuery('sys_class_name=sys_user');
oldRecord.query();
while ( oldRecord.next() ) {
//Lets move to the new table
var newRecord = new GlideRecord('csm_consumer_user');
newRecord.initialize();
newRecord.name=oldRecord.name;
newRecord.email=oldRecord.email;
newRecord.employee_number=oldRecord.employee_number;
newRecord.first_name=oldRecord.first_name;
newRecord.last_login=oldRecord.last_login;
newRecord.last_login_device=oldRecord.last_login_device;
newRecord.last_login_time=oldRecord.last_login_time;
newRecord.last_name=oldRecord.last_name;
newRecord.vip=oldRecord.vip;
newRecord.building=oldRecord.building;
newRecord.company=oldRecord.company;
newRecord.department=oldRecord.department;
newRecord.location=oldRecord.location;
newRecord.manager=oldRecord.manager;
newRecord.user_name=oldRecord.user_name;
newRecord.sys_id=oldRecord.sys_id;
newRecord.sys_updated_by = oldRecord.sys_updated_by;
newRecord.sys_updated_on = oldRecord.sys_updated_on;
newRecord.sys_created_by = oldRecord.sys_created_by;
newRecord.sys_created_on = oldRecord.sys_created_on;
newRecord.autoSysFields(false); //disables updates to sys_updated_by, sys_updated_on, sys_mod_count, sys_created_by, and sys_created_on.
newRecord.insert();
//lets make the profile
var csmprofile = new GlideRecord('csm_consumer')
csmprofile.initialize();
csmprofile.first_name=oldRecord.first_name;
csmprofile.last_name=oldRecord.last_name;
csmprofile.email=oldRecord.email;
csmprofile.street=oldRecord.street;
csmprofile.city="College Park";
csmprofile.state="Maryland"
csmprofile.zip="20740";
csmprofile.user = oldRecord.sys_id;//link to profile for login
//add other fields here you want to display on the reference field pop-up on the case form
csmprofile.insert();
//lets remove this record form the sys_user table
oldRecord.deleteRecord();
}
