How to fix that? I am not able to export excel file successfully in vendor risk assessment

[ak49]

How to fix that I am not able to download the excel after clicking on export.

[Ankur Bawiskar]

Hi,

So what is configured in that list banner button?

please share the script

was it working fine earlier?

Regards
Ankur

[ak49]

I don't know but there are some other VRA numbers and I can export successfully but some of VRA I can. If I go through the view response options then I am getting error like sheet name cannot contain :/?*{}

[Ankur Bawiskar]

what's the script inside that?

[ak49]

function exportAllPopup() {
var tblName = g_list.getTableName();
var parentSysId = g_form.getUniqueValue();
var listID = g_list.listID;

var cBoxes = document.getElementsByName('check_' + listID);
for (var i = 0; i < cBoxes.length; i++) {
cBoxes[i].checked = true;
}

var incQuery = 'vendor_risk_assessment=' + parentSysId + '^questionnaire_instance.state=complete^ORresubmit_counter!=0';
var excludeQuery = 'vendor_risk_assessment=' + parentSysId + '^questionnaire_instance.state!=complete^resubmit_counter=0';

var dialogClass = window.GlideModal ? GlideModal : GlideDialogWindow;
var dialog = new dialogClass('sn_vdr_risk_asmt_export_excel', false);
dialog.setSize(500, 500);
dialog.setTitle(getMessage('Export all questionnaires'));
dialog.setPreference('sysparam_name', tblName);
dialog.setPreference('sysparam_incQuery', incQuery);
dialog.setPreference('sysparam_exclQuery', excludeQuery);
dialog.render();
}