jmacdonald
09/25/2019, 12:30 PMjarens
09/25/2019, 2:54 PM/**
* @NApiVersion 2.0
* @NScriptType suitelet
* @NAmdConfig /SuiteScripts/configuration.json
* @Author Jack Arens | National Food Group
*/
define(['papaparse', 'N/file'],
function (papaparse, file) {
var exports = {onRequest: onRequest};
function onRequest(options) {
var request = options.request;
var response = options.response;
log.debug('Request', request.files.upfile);
var csv = request.files.upfile.getContents();
//This breaks when '\n' is in a cell
log.debug('Read CSV', readCSV(csv));
//This breaks when '\n' is in a cell
var iterator = request.files.upfile.lines.iterator();
iterator.each(function (line) {
log.debug('Line', line);
return true;
});
//Doesn't break when '\n' is in a cell
log.debug('Papa Parse', papaparse.parse(csv).data);
response.writePage({
output: 'File Received'
});
}
function readCSV(csv) {
return csv.split('\n');
}
return exports;
});
jarens
09/25/2019, 2:54 PMjmacdonald
09/25/2019, 3:26 PM