Hi @Souvick A ,
What field you have in excel to identify the user? Is it email, user_name or something else?
You can use Load data module with transform maps to import this data.
1. Load data: Navigate to System Import Sets -> Load data
2. Sample Data
3. Fill in the details as shown below and select your excel file then click submit.
4. You will get the following page, then select create transform map.
5. You will get the following page, fill in the data as shown then save (not submit).
6. Once the form is saved, in the related links section click on Mapping Assist and in the page opened map the fields from excel to fields in user table as shown below and save.
7. Then open the email mapping record from the Field Map related list and in the page opened, enable the Coalsce check box to true and click on update.
8. In the Transform map page set the Run Script check box to true and use the code below in the Script field and save.
(function transformRow(source, target, map, log, isUpdate) {
if(!isUpdate){
ignore = true;
}
if (target.phone == '') {
ignore = true;
}
})(source, target, map, log, action === "update");
9. Now from the transform map related links page click on transform and in the page opened select the import set (that you loaded in the first two steps) and select the transform which we created now (auto selected) and click on Transform.
10. Now check your user records after the transform is completed.
Please mark my answer helpful and accept as solution if it helped you 👍✔️
