Bulk Updates to Existing Users

Question

Afternoon, 
 Do you know of a way that we can bulk update a number of existing eB users to change their status from &lsquo; Active &rsquo; to &lsquo; Not Active &rsquo;? 
 We do not have any provisioning spreadsheets that we believe are capable of doing so. 
 Kind Regards, 
 Lewis C

Carma De Villiers · Accepted Answer

Hi Lewis, 
 
Has this issue been resolved? If so, could you please close the issue by selecting "This helped me" and "Verify Answer". If not, please let me know so I can follow up on this issue. 
 
Thanks 
 
Carma

eric.rajala · Answer

You can write a sql cursor that uses the epb_chg_person stored procedure. This will produce object changed entries in the audit log. Setting input parameters as below will change nothing but the status. 
 -- your query to select the @li_person_id s that you want to deactivate 
 -- include person_id > 1 AND template = 'N' in your WHERE clause 
 -- . . . 
 ebp_chg_person 
 @pi_person_id = @li_person_id 
 ,@ps_new_code = '%' 
 ,@ps_new_surname = '%' 
 ,@ps_new_initials = '%' 
 ,@ps_new_title = '%' 
 ,@ps_new_full_names = '%' 
 ,@ps_new_first_name = '%' 
 ,@pi_new_class_id = -1 
 ,@ps_new_national_id = '%' 
 ,@ps_new_additional_code = '%' 
 ,@ps_new_security_ref_no = '%' 
 ,@pdt_new_security_exp_date = NULL 
 ,@ps_new_status = 'N' 
 ,@ps_new_remarks = '%' 
 ,@pi_called_by = @li_session_id -- to capture the user performing the action or use 1 for ADMIN 
 @li_person_id and @li_session_id are integer parameters.

Manav · Answer

Hi, 
 Code is all correct, but need to call the .Retrieve to retrieve the information before you can manipulate / retrieve the data like below: 
 Session sess = new Session(); 
 sess.Connect(eB.Data.Session.SessionTypes.Both, "myServer"); 
 sess.Logon(Session.SessionTypes.Both, "eB_Development", "TESTUSER", "TESTPASSWORD"); 
 System.IO.StreamReader file = new System.IO.StreamReader("c:\userPersonIds.csv"); 
 string line; 
 while ((line = file.ReadLine()) != null) 
 { 
 try 
 { 
 Person pers = new Person(sess, int.Parse(line)); 
 pers.Retrieve(&ldquo;Header&rdquo;); 
 Console.WriteLine(pers.FullName); 
 } 
 catch (Exception ex) 
 { 
 Console.WriteLine("No such user " + ex.Message); 
 } 
 } 
 file.Close(); 
 sess.LogoffAndDisconnect(); 
 Do let me know if you still not able to retrieve the data!

Manav · Answer

Hi, 
 I checked that we have Retrieve("Header;Attributes;Files;Tags;Copies").