The below is the requirement
create a script wher...
# suitescriptv
vennila ramasamy
11/22/2023, 12:58 PMThe below is the requirement
create a script where we can export a SQL statement(select * from accounts) into a csv file in the file cabinet?
I dont know how to proceed this? could anyone please help me?
b
battk
11/22/2023, 2:06 PMbattk
11/22/2023, 2:08 PMif you want to run this on a schedule, then you will need either a Map/Reduce Script Type or a Scheduled Script Type
battk
11/22/2023, 2:11 PMif you also require a prettier interface, you will want a Suitelet Script Type
battk
11/22/2023, 2:19 PMits not mandatory for writing csvs, but in general papaparse is a good library for working with csvs
v
vennila ramasamy
11/22/2023, 2:51 PMok thank you
vennila ramasamy
11/22/2023, 2:58 PMthis is my code
var parsedResults = JSON.parse(context.values);
log.debug('parsedresults',parsedResults);
var csvData = Papa.unparse(parsedResults, { newline: '\n' });
log.debug('csvData',csvData);
But it does not create the csv. what iamdoing wrong?
b
battk
11/22/2023, 3:01 PMexpect to share enough code to reproduce the problem
battk
11/22/2023, 3:01 PMthe code you shared doesnt generate csvs
battk
11/22/2023, 3:01 PMbut if you were trying to start logging one, that code may or may not work depending on whats in context.values
v
vennila ramasamy
11/22/2023, 3:06 PMdefine(['N/search','N/record','N/task','N/query','SuiteScripts/lib/papaparse'],
function (search,record,task,query,Papa) {
function getInputData(){
log.debug('entering getinputdata')
var sql = `
SELECT *
FROM projecttask
`;
var results = query.runSuiteQL({
query : sql,
params : []
}).asMappedResults();
var resultsLength = results.length;
log.debug('resultsLength',resultsLength);
return results;
}
function reduce(context){
try{
var parsedResults = JSON.parse(context.values);
log.debug('parsedresults',parsedResults);
var csvData = Papa.unparse(parsedResults, { newline: '\n' });
log.debug('csvData',csvData);
}catch(e){log.debug('error',e);}
}
function summarize(summary){
}
return{
getInputData : getInputData,
reduce : reduce,
summarize : summarize
}
}
);
b
battk
11/22/2023, 3:16 PMpay closer attention to what you are parsing
battk
11/22/2023, 3:16 PMyou arent passing the correct value to unparse
v
vennila ramasamy
11/22/2023, 3:32 PMsorry i really dont get it .
vennila ramasamy
11/22/2023, 3:32 PMeven i tried papa.parse(context.values)
b
battk
11/22/2023, 3:33 PMwhat value are you passing to Papa.unparse
v
vennila ramasamy
11/22/2023, 3:33 PMparsedresults
b
battk
11/22/2023, 3:33 PMthats the variable
battk
11/22/2023, 3:33 PMbut what value is in the variable
v
vennila ramasamy
11/22/2023, 3:33 PMits an object
b
battk
11/22/2023, 3:34 PMgood enough for now
battk
11/22/2023, 3:34 PMand what type of inputs can go into Papa.unparse
v
vennila ramasamy
11/22/2023, 3:35 PMjson objects
b
battk
11/22/2023, 3:35 PMlook harder at the papaparse documentation
v
vennila ramasamy
11/22/2023, 3:35 PMi mean array of objects
b
battk
11/22/2023, 3:35 PMbetter, now you get to ask, is an object the correct value to pass
v
vennila ramasamy
11/22/2023, 3:36 PMno an array should be the one to pass
vennila ramasamy
11/22/2023, 3:36 PMusing for loop?
b
battk
11/22/2023, 3:37 PMi mean you could, but i dont think it will add much value
v
vennila ramasamy
11/22/2023, 3:38 PMi dont think any clue other than for loop
b
battk
11/22/2023, 3:38 PMfor loops are for iterating through an existing array
battk
11/22/2023, 3:38 PMyou want to create a new one
battk
11/22/2023, 3:39 PMif you dont know how to create an array, you really need to go through a javascript tutorial first
battk
11/22/2023, 3:39 PMits one of the basics
v
vennila ramasamy
11/22/2023, 3:40 PMok i got it
vennila ramasamy
11/22/2023, 4:30 PMi get this error
FileReaderSync is not definted
b
battk
11/22/2023, 4:34 PMpapaparse has options for working with files in a browser, which will not work in suitescript since it runs on the server
battk
11/22/2023, 4:35 PMyou need to change the options of whatever line is throwing the error
5 Views