i heve below code to convert csv to ZIP. the CSV f...
# suitescriptv
vennila ramasamy
10/23/2023, 12:22 PMi heve below code to convert csv to ZIP. the CSV file have 800 lines and its zipped perfectly. but when we unzip the file, it returns all the 800 lines into 1 single long line.
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();
What should i do to achieve the result? pleasehlp
c
CD
10/23/2023, 12:24 PMShare the code that creates
newContentsv
vennila ramasamy
10/23/2023, 12:27 PMvar 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;
return true;
});
log.debug('newcont',newContents);
c
CD
10/23/2023, 12:34 PMOk, so where do you think you should look to see if there are newlines/carriage returns?
v
vennila ramasamy
10/23/2023, 12:37 PMiterator.each(function (line) {
newContents += line.value;
return true;
});
Here
vennila ramasamy
10/23/2023, 12:37 PMam i right?
c
CD
10/23/2023, 12:41 PMThis is not something I'd expect you to know, so I'll tell you. To add a cr/nl to a string use:
str = str + "\r\n";v
vennila ramasamy
10/23/2023, 12:44 PMwhere should i use this?
vennila ramasamy
10/23/2023, 12:45 PMiterator.each(function (line) {
newContents += line.value;
newContents = newContens + "\r\n"
return true;
});
vennila ramasamy
10/23/2023, 12:46 PMis this how to do?
c
CD
10/23/2023, 12:48 PMUse your initiative and try instead of asking?
v
vennila ramasamy
10/24/2023, 11:22 AMThank you , i tried it works fine