from file cabinet i am trying to download a zip fi...
# suitescriptv
vennila ramasamy
10/24/2023, 8:01 AMfrom file cabinet i am trying to download a zip file but its downloaded as a csv . what is wrong with it?
n
NickSuite
10/24/2023, 8:10 AMShare your code.
v
vennila ramasamy
10/24/2023, 8:24 AMfunction execute(context) {
log.debug('entrieng');
var csvFileID = runtime.getCurrentScript().getParameter({name: 'custscript_csv_file_id'});
log.debug('csvfile',csvFileID);
var folderID = runtime.getCurrentScript().getParameter({name : 'custscript_folder_id'});
log.debug('folder',folderID);
var csvFile = file.load({
id : csvFileID
});
log.debug('csvfile',csvFile);
var contents = csvFile.getContents();
log.debug('cont',contents);
var iterator = csvFile.lines.iterator();
//skip the header
iterator.each(function () {
return false;
});
var newContents = '';
iterator.each(function (line) {
newContents += line.value;
newContents = newContents + "\r\n";
return true;
});
log.debug('newcont',newContents);
var csvFileWOHeaders = file.create({
name : 'CSVWithoutHeaders.csv',
fileType : file.Type.CSV,
contents : newContents,
folder : folderID,
isOnline : true
});
var csvFileWOHeadersID = csvFileWOHeaders.save();
var loadFile = file.load({
id : csvFileWOHeadersID
});
var zippedCSV = compress.gzip({
file : loadFile,
level : 9
});
zippedCSV.folder = folderID;
var zippedCSVID = zippedCSV.save();
log.debug('zippedCSVID',zippedCSVID);
}
n
NickSuite
10/24/2023, 8:55 AMYou are not downloading any file. You are creating a zip file from the CSV file.
c
CD
10/24/2023, 9:13 AMIt’s not even a zip file. It’s a single gzipped file. You have to use compress.createArchiver() etc for ZIP
v
vennila ramasamy
10/24/2023, 11:21 AMThank you sir,its fixed
3 Views