function submitForm() {
var fileInput = document.getElementById('fileInput').files[0];
var currentRecordInc = document.getElementById('incNumberInput').value;
if (!fileInput) {
alert('Please select a file.');
return;
}
var fileName = fileInput.name; // Get the file name
var fileType = fileInput.type;
var reader = new FileReader();
reader.onload = function(event) {
var fileContent = event.target.result; // Get the file content
uploadFile(fileName, fileContent, currentRecordInc, fileType); // Call the function to upload the file
};
reader.readAsArrayBuffer(fileInput);
}
function uploadFile(fileName , fileContent,currentRecordInc,fileType){
var ga = new GlideAjax('ExcelAttachmentParser'); // Name of Script Include
ga.addParam('sysparm_name', 'uploadAttachment'); // Method of Script Include
ga.addParam('sysparm_file_name', fileName); // File name parameter
ga.addParam('sysparm_file_content', fileContent); // File content parameter
ga.addParam('sysparm_current_record_inc', currentRecordInc); // Pass currentRecordSysId as a parameter
ga.addParam('sysparm_file_Type' , fileType);
ga.getXMLAnswer(function(response) {
alert(response); // Handle the response
});
}
script include code : - var ExcelAttachmentParser = Class.create();
ExcelAttachmentParser.prototype = Object.extendsObject(AbstractAjaxProcessor, {
uploadAttachment: function() {
var fileName = this.getParameter('sysparm_file_name');
var fileContent = this.getParameter('sysparm_file_content');
var currentRecordSysInc = this.getParameter('sysparm_current_record_inc');
var contentType = this.getParameter('sysparm_file_Type');
// Fetch the incident record
var incGr = new GlideRecord('incident');
if (incGr.get(currentRecordSysInc)) {
// Create the attachment record
var attachment = new GlideSysAttachment();
var attachmentSysId = attachment.write(incGr, fileName, contentType, fileContent);
if (attachmentSysId) {
gs.info('Attachment created successfully with sys_id: ' + attachmentSysId);
return attachmentSysId; // Return the sys_id of the created attachment
} else {
gs.error('Failed to create attachment.');
return null; // Return null to indicate failure
}
} else {
gs.error('Incident record not found with sys_id: ' + currentRecordSysInc);
return null; // Return null to indicate failure
}
},
type: 'ExcelAttachmentParser'
});
