Is there any way can create a text file or CSV fil...
# suitescripts
SG
12/28/2020, 5:13 PMIs there any way can create a text file or CSV file in such a pattern by fetching data from a saved search?
c
Chris
12/28/2020, 5:37 PMWell, you might wanna look at the
N/fileChris
12/28/2020, 5:38 PMOnce it’s in the file cabinet you can email it to the user, attach it to a record, etc…
s
SG
12/28/2020, 5:49 PMDo you have some code for this?
SG
12/28/2020, 5:50 PMvar searchResultCount = getJBData.runPaged().count;
log.debug("getJBData result count", searchResultCount);
getJBData.run().each(function(result) {
sono = result.getValue(cols[0]);
scmcode = result.getValue(cols[1]);
Content = Content + sono + ''
+ sono ;
Content = Content + '\n';
});
var csv = file.create({
name: 'PSI cycle1extract.txt',
fileType: file.Type.CSV,
contents: Content
});
// log.debug('Excel csv created successfully', 'Id: ' + csv);
csv.folder = folderId;
var csvid = csv.save();
Unable to itrerate properly
c
Chris
12/28/2020, 6:48 PMlooks like your
.each()return true;e
ehcanadian
12/28/2020, 7:17 PMUse the
N/task💯 1
22 Views