the condition is when a user attaches the attachment in catalog item if the excell headers didnt matched with {number,name,assigned to ,assignment group) the attachment should not attach to the catalog item
by using Glide Ajax in catalog item i trie this
if the attachment headers matched the below condition
if it matches then only the attachment should be created in sc_req_item
1 ACCEPTED SOLUTION
Hi,
Please find the scripts below
I just tested with 1 excel file containing the name header and other which didn't contain the name header
You can enhance it as per your need
function onSubmit(){
var cat_id = g_form.getValue('sysparm_item_guid');
var ga = new GlideAjax('validateheaders');
ga.addParam('sysparm_name', 'validate');
ga.addParam('sysparm_item_guid', cat_id);
ga.getXMLWait();
var answer = ga.getAnswer();
if(answer == 'false'){
g_form.addErrorMessage('not valid headers');
return false;
}
}Script Include:
var validateheaders = Class.create();
validateheaders.prototype = Object.extendsObject(AbstractAjaxProcessor, {
validate: function() {
var attachID;
var test = this.getParameter('sysparm_item_guid');
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', test);
gr.addQuery('table_name','ZZ_YYsc_cart_item');
gr.query();
if (gr.next()) {
attachID = gr.getUniqueValue();
}
var stream = new GlideSysAttachment().getContentStream(attachID);
var parser = new sn_impex.GlideExcelParser();
parser.parse(stream);
var headers = parser.getColumnHeaders();
var arr = headers.toString().split(',');
if(arr.indexOf('Name') == -1)
return false;
/*if ((arr.indexOf('Name') == -1) || (arr.indexOf('Number') == -1) || (arr.indexOf('assigned to') == -1) || (arr.indexOf('assignment group') == -1) || (arr.indexOf('short description') == -1)) {
return 'false';
}
*/
return 'true';
},
type: 'validateheaders'
});Output:
Regards
Ankur
