4/18/14 ... I have updated my question because I misphrased it. I created an Import Set and Transform Map trying to import new rows from an excel spreadsheet to a Security Access Table. My goal is to only import new rows and not do any updates to existing rows. I can get rows to insert, but I am having problems with my onBefore script trying to check and skip/ignore duplicate rows. If I find a match to the Target table records for u_name & u_func_access_display, I want to skip the record and not insert.
This is my onBefore script:
//CHECK TO SEE IF RECORD ALREADY EXISTS IN THE LLB SECURITY ACCESS TABLE
//COMPARE WITH NAME AND FUNC ACCESS DISPLAY FIELDS
var ast = new GlideRecord('u_llb_security_access');
ast.addQuery('u_name',source.u_name);
ast.addQuery('u_func_access_display',source.u_func_access_display);
ast.query();
//IF RECORD ALREADY EXISTS SKIP THE RECORD AND GO TO THE NEXT
if(ast.next()){
ignore = true;
}
My onBefore script does not skip/ignore any duplicate records. Any ideas on what I am doing wrong?
Thanks,
Andy
I will check my excel file for spaces. There are no date/time fields in my input excel file.
Nope, I scripted for those in my onBefore script:
/**
* For variables go to: http://wiki.service-now.com/index.php?title=Import_Sets
**/
//SCRIPTS TO SKIP RECORDS WITH NULL OR EMPTY FIELDS
//NAME FIELD CHECK FOR NULL OR EMPTY
if (source.u_name.nil()){
ignore = true;
}
//FUNC_ACCESS_DISPLAY FIELD CHECK FOR NULL OR EMPTY
if (source.u_func_access_display.nil()){
ignore = true;
}
//FUNC_ACCESS_TECH FIELD CHECK FOR NULL OR EMPTY
if (source.u_func_access_tech.nil()){
ignore = true;
}
//FUNC_ACCESS_DISPLAY DESC CHECK FOR NULL OR EMPTY
if (source.u_func_access_desc.nil()){
ignore = true;
}
//APPROVER_GROUP FIELD CHECK FOR NULL OR EMPTY
if (source.u_approver_group.nil()){
ignore = true;
}
//ACCESS_TYPE FIELD CHECK FOR NULL OR EMPTY
if (source.u_access_type.nil()){
ignore = true;
}
//CHECK TO SEE IF RECORD ALREADY EXISTS IN THE LLB SECURITY ACCESS TABLE
//COMPARE WITH NAME AND FUNC ACCESS DISPLAY FIELDS
//SET COALESCE for U_NAME & U_FUNC_ACCESS_DISPLAY TO TRUE
if(action != "insert"){
ignore= true;
}
The rows with empty fields get ignored, the 2 duplicate rows already in the table get ignored, and the 1 row with the wrong name gets ignored, but the 8 rows new rows I imported before get inserted again?
