Hi everyone, I would like to merge any duplicate l...
# suitescriptk
KnotKnick
07/16/2019, 1:53 PMHi everyone, I would like to merge any duplicate leads coming from online form to the existing one and if anyone is manually typing in a new lead, setup a duplication check and make sure they can;t enter it, if the lead already exists. How would I be able to achieve this?
b
battk
07/16/2019, 2:38 PMyou can do a search using the duplicate filter (or use search.duplicates) to detect duplicates and then use the entity duplication task to merge them
k
KnotKnick
07/16/2019, 2:45 PMAll this would be done in a scheduled script or user event script?
b
battk
07/16/2019, 2:47 PMeither
k
KnotKnick
07/16/2019, 3:04 PMSo basically, do a search.duplicate based on my criteria, if it exists then merge using entity duplication task and save, if its a scheduled script, would be done beforeSubmit, right? How would I make sure that the lead is coming from an online source or manual input?
b
battk
07/16/2019, 3:11 PMthe deduple task doesn't trigger user events and is asynchronous
k
KnotKnick
07/16/2019, 3:12 PMI'm not sure what that means exactly
b
battk
07/16/2019, 3:13 PMhave you used the entity duplicate resolution mass update
k
KnotKnick
07/16/2019, 3:15 PMNot yet
b
battk
07/16/2019, 3:15 PMtry it out, its what drives the entity duplication task
battk
07/16/2019, 3:16 PMessentially you will be passing parameters to that mass update from script
k
KnotKnick
07/16/2019, 3:22 PMSorry I'm relatively new yo suitescript, does that mean using the script and search in it, pass the internal id of the dupes to task.EntityDeduplicationTask, and that will merge the dupe record to the original record?
b
battk
07/16/2019, 3:25 PMall of the task related modules work by sending the task to a queue
battk
07/16/2019, 3:25 PMwhich process the task at a later date
battk
07/16/2019, 3:37 PMBut otherwise yes. Make your script do a search to find duplicates. If there are duplicates submit an entity deduplication task
battk
07/16/2019, 3:37 PMyour choice of script depends on when you want to do your logic
battk
07/16/2019, 3:38 PMif you want it to run on a schedule and process many records at a time, choose a map-reduce script
battk
07/16/2019, 3:38 PMif you want it to run it after an individual record is submitted, choose user event
battk
07/16/2019, 3:39 PMif you want to run it in the ui before the user submits the record, choose a client script
k
KnotKnick
07/16/2019, 3:39 PMYes, I was working on the UE script
KnotKnick
07/16/2019, 3:39 PMUsing search.duplicates to get the duplicates and update it using entity deduplication task
KnotKnick
07/16/2019, 5:05 PMWould it be something like this?
KnotKnick
07/16/2019, 5:05 PMfunction beforeSubmit(){
log.debug('Started');
var newRecord = context.newRecord;
var newEmail = newRecord.getValue({
name: 'email'
});
var searchResult = search.duplicates({
type: search.Type.CONTACT,
fields:{
'email': newEmail
}
});
var recIds = [];
for (var i =0 ; i < searchResult.length; i++){
recIds.push(searchResult[i].id);
}
var dedupeTask = task.create({taskType task.TaskType.ENTITY_DEDUPLICATION});
dedupeTask.entityType = task.DedupeEntityType.CONTACT;
dedupeTask.masterSelectionMode = task.MasterSelectionMode.MOST_RECENT_ACTIVITY;
dedupeTask.RecordsIds = recIds;
var dedupeTaskId = dedupeTask.submit();
log.debug('Ended');
}
b
battk
07/16/2019, 7:50 PMi believe you would need this afterSubmit
battk
07/16/2019, 7:55 PMbeforeSubmit won't have an id on the current record so it would be excluded from duplicates
k
KnotKnick
07/17/2019, 7:57 PM@battk Currently I have the following code and it doesnt't detect any duplicates at all
KnotKnick
07/17/2019, 7:57 PMpractice.js
b
battk
07/17/2019, 7:59 PMis the record marked by netsuite as a duplicate
k
KnotKnick
07/17/2019, 8:04 PMYes it does
KnotKnick
07/17/2019, 8:04 PMRight after I save the second (duplicate) lead, it pops up an alert and now I am getting the following error
KnotKnick
07/17/2019, 8:05 PMmessage has been deleted
b
battk
07/17/2019, 8:16 PMi think your error message is saying that you have an invalid recordIds group
battk
07/17/2019, 8:17 PMprobably because you only had 1 element at the time
k
KnotKnick
07/17/2019, 8:52 PMI had one lead stored in NS and when I tried to add another lead with the same entityname and email, this is what I got.
b
battk
07/17/2019, 8:55 PMYour code doesn't add newRecord.id to recordIds
5 Views