- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2020 04:34 AM
Hi,
Yes I think after adding the attachment kindly add wait for 5 seconds
updated script
function importQC(){
var answer = confirm('Have you attached spreadsheet');
if(answer==true)
{
gsftSubmit(null, g_form.getFormElement(), "fj_import_qc");
}
}
var gr2 = new GlideRecord("sys_attachment");
gr2.addQuery("table_sys_id", current.sys_id);
gr2.addQuery("table_name", "x_fdrbl_business_p_bpm_task");
gr2.query();
if (!gr2.next()) {
gs.addErrorMessage("You must attach a file to submit. Your import submission has been aborted.");
current.setAbortAction(true);
}
else{
GlideSysAttachment.copy(current.getTableName(), current.sys_id, 'sys_data_source', 'a5226c1e1b7f181069e7a9342a4bcbdf');
var ms = 5000; // 5 seconds
var endSleep = new GlideDuration().getNumericValue() + ms;
while ( new GlideDuration().getNumericValue() < endSleep) {
//wait
}
var exportGr = new GlideRecord("scheduled_import_set");
exportGr.addQuery("sys_id", "bd553cf2db7f9810b22061f74b9619ec"); // sys_id of the record which you will be creating for scheduled import in step
exportGr.query();
if (exportGr.next()) {
//gs.executeNow(exportGr); // this is for scoped app
SncTriggerSynchronizer.executeNow(schImp_GR); // this is for non scoped app
}
}
regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader