SAP Knowledge Base Article - Public

2087495 - Data Imports & Exports: How to Transfer Data from Old UserID to a New UserID Guide - Platform

Symptom

  • Can I transfer forms to a new user?
     
     
  • How do I move all the information to a new user account?

Environment

  • BizX Platform

Resolution

Purpose

  • In the SuccessFactors system USERID is the primary key for the master table that defines each user. As in most employee databases, changing this primary key is not possible without risking disruption of functionality throughout the system.

      The following guide describes how you can manually transfer data for one user from the old USERID to their new USERID.

 

Factors to be Aware of When Transferring User Data

     The following limitations have been identified.

  • SuccessFactors in general does not recommend a USERID Conversion. It is preferred to simply import new USERID's, and disable old IDs. This document provides information on how to facilitate that move for just ONE user at a time.
     
  • We offer no automated data validation.
     
  • • We do not provide an undo feature so the client must backup any data exports before re-importing data, which may overwrite existing data.
     
  • • In general forms and data are never deleted, although it may appear lost if it becomes disconnected from the correct user ID due to a failed transfer, or you use the delete documents of inactive users option on user imports.
     
  • • Custom reporting and system permissions set for users in the system cannot be copied. The client administrator will need to manually establish permissions for the new USERID's.
     
  • • The client may need to communicate any new password for new user ID. [or have user reestablish their own]
     
  • • All work should be completed by the client. SuccessFactors support staff will not be responsible for the exporting and re-importing of client data.

 

How to Transfer Data from UserOLD to UserNEW

  • Note: The following steps should only be used as a guideline, and should be adapted depending on your specific needs.
  1. Create backup files of all available exports
  1. Export user directory via Admin Tools and save to desktop [EXPORT_ORIGINAL.csv]
     
  2. Export Goal Data from Reports > Goal Search
     
  3. Export Detailed Document Search report for all users and forms that you later want to launch new forms for [USERDOCS.csv]
     
  4. Export Live Profile data via Admin Tools

i. Personal Information [PersonalInfoData_xxx.csv]

ii. Background Information [BackgroundData_xxx.csv]

iii. Trend data [TrendData_xxx.csv]

 

  • Note: It is recommended that you do not create the above backup files until the day before, or as close to the day, that the change will be executed so that data integrity is kept. Immediately after generating your export files you may want to remove the affected employees (or everyone) from the systems "default user group" [in admin tools]. This effectively locks these users out and prevents them from logging in. This will prevent users from entering new data that has not been captured in your exports and reports.
     
  1. Make copy of EXPORT_ORIGINAL.csv for OLD ID and save as [IMPORT_OLD.csv]
     
    1. Identify current user to change in IMPORT_OLD.csv. This may include users where their personal userid is NOT changing, but maybe their manager's id is.
       
    2. Modify 'USERNAME' field by appending '_OLD' to user account record.

i. For example, UserName "JDoe" becomes "JDoe_OLD", or 000123 becomes 000123_OLD

ii. Doing this allows you to later reimport the new USERID, with the original username, otherwise you will get an error the username already exists since it is still associated with the original ID.

iii. If your usernames are also changing, then this step is not required.

 

  1. Make another copy of EXPORT_ORIGINAL.csv for NEW ID and save as [IMPORT_NEW.csv]
     
    1. In this new file have the NEW USERID and the ORIGINAL [old] username.
       
    2. Also in this file change MANAGER & HR id columns making sure all users reflect any new USERID that will apply to them.

 

  1. Set Up PROXY Rights to Allow Copying of Data by Users
     
    1. Setup proxies as needed if you will be proxying as both old and new users.

 

  1. Make a copy of PersonalInfoData_xxx.csv and rename it PersonalInfoData_NEW.csv
     
    1. In this new copy change all USERID's to the new user ID
       
    2. This file by default will replace ALL existing data, so be aware you need to import a full file. Any data not in your import file is effectively deleted.

 

  1. Do the same for both trendInfoData and background info files.
     
    1. Unlike the personal Info file, you can either ADD to existing data, or Overwrite Existing Data
       
    2. Consider if you want to delete data for old ID > import file with just new ID, selecting Overwrite Existing Data.
       
    3. To keep historical data import just a partial file with New ID and don't Overwrite Existing Data, or import a full file with both old and new user ID while choosing Overwrite Existing Data.

 

  1. Goal Imports
     
    1. Determine whether goals will be transferred to the new accounts.
       
    2. Administrators can transfer goals one employee at a time using the goal transfer wizard. As a means of lightening the load, managers or distributed administrators could be given administrative Goal Transfer permission.

i. Once goals are transferred they will not exist in the old account.

  1. If you want to keep goals with the old USERID, Goals can be downloaded using the Goal Search and then used to create a goal import file. For information see the Goal Import Guide.
     

i. For the Goal Search export file, create a new copy and save as [GoalImports.csv].

ii. Format the file into the format that is required for an import. This is a function the client performs from admin tools. SuccessFactors can provide support to validate file FORMAT, but we cannot validate actual data as we do not necessarily know what the data should be.

iii. Save a copy of this complete file to perform a small test. GoalImportsTEST.csv

iv. Delete all but a few records you will later verify have correctly imported

 

 

Day of the Data Transfer

 

1. First import our user-import file IMPORT_OLD.csv

a. This file has "username_old" value. This will change usernames for all users that we are changing ID for, and allows us to later import the USERID file that has NEW IDs.

b. Import via Admin tools > Employee import

c. We recommend you use the validate data tool first. If you see invalid manager IDs, you should first correct these errors.

d. Once completed you now have all original users with changed usernames. All users are still active.
 

2. Import main file IMPORT_NEW.csv

a. This file contains New USERID in Userid, Manager, and HR columns, and has original usernames in username column

b. At this point we now have active in our system, both Old user IDs and new user IDs.

c. The old USERID's have usernames_old, and the records with new USERID's have the original usernames.

 

3. Import your new extended data files that have new USERID's for

a. personal information

b. background info. Since this is a full file choose "override existing data"

c. trend data. Since this is a full file choose "override existing data"

 

4. Goal Imports

a. Import your test file [GoalImportsTEST.csv] that contains a subset of the main goal import file.

i. Proxy in as the person under their new USERID that the goals were for.

ii. Confirm they show up as expected in the correct goal plan

b. If successful you will then import the main goal file that contains original usernames (Remember, goal import usually uses usernames, not USERID's)

 

5. Other Actions to Perform

a. You will need to manually reset any custom user permissions for managers, users, and administrators that had been previously granted. Only permissions set in "Default User Permissions" will apply by default.

 

6. Users & Managers May Copy Data

a. Users may now access the system to manually "Send Copies" of old completed forms from their old USERID to their new USERID.

b. Users will navigate to the proxy account using the Options link.

c. Users can send completed documents from the old account to the new account by navigating to the Completed folder and using the Send option.

d. Users can also transfer existing goals if you are employing this option.

e. Launch new forms for new userid as needed.

 

7. Disable Old User Accounts

a. After you have completed all the actions above, including users transferring forms from old IDs to new IDs you can then disable the old user's so that you do not exceed your seat license per your contract

b. Using the IMPORT_OLD.csv file that contains all the old user IDs, change the status to INACTIVE for user.

c. Import via employee import to inactivate the old user account.

 

APPENDIX: How to use Send Copy

1. Log into your instance

2. Once you logged into your instance click My Forms Tab

3. Open your In Progress folder or Completed folder. (located on the left of the screen)

4. Click on the form that you want to send a copy of

5. If enabled, the Send Copy button will show at the top of the form

6. When you click on send copy button you can select the employees that you want to send the form to

7. Select all employees that you want to send the form to and hit the select and continue button

8. You as the sender can add comments in the comment box and send the form. Note, the comments will only show in the audit trail of the person your comment is for.
 

DISABLING/ENABLING SEND COPIES

1. To disable the Send Copy button for forms

Go to Admin Tools -> Form Template Administration ->

Keywords

KBA , sf bizx performance management , LOD-SF-PLT , Foundational Capabilities & Tools , How To

Product

SAP SuccessFactors HCM Core all versions