function execute() {
var sqlQueryParam...
# suitescriptv
vennila ramasamy
12/05/2023, 2:37 PMfunction execute() {
var sqlQueryParameter = runtime.getCurrentScript().getParameter({name: 'custscript_sql_query_in_file_cabinet'});
var format = runtime.getCurrentScript().getParameter({name : 'custscript_format_txt_or_csv'});
var folderToSave = runtime.getCurrentScript().getParameter({name: 'custscript_folder_to_save_the_results'});
if(format === 'CSV'){
var fileCreated = file.create({
name : 'task_data_export' + new Date() + '.csv',
fileType : file.Type.CSV,
//contents : content,
folder : folderToSave
});
var fileID = fileCreated.save();
log.debug('File Created', fileID);
}else if(format === 'TEXT'){
var fileCreated = file.create({
name : 'task_data_export' + new Date() + '.txt',
fileType : file.Type.PLAINTEXT,
//contents : content,
folder : folderToSave
});
var fileID = fileCreated.save();
log.debug('File Created', fileID);
}
if(sqlQueryParameter){
var sqlQuery = file.load({id : sqlQueryParameter}).getContents();
log.debug('format',format);
log.debug('sql',sqlQuery);
var results = query.runSuiteQL({
query : sqlQuery,
params : []
}).asMappedResults();
var fieldNames = Object.keys(results[0]);
log.debug('fieldnames',fieldNames);
var header = fieldNames.join(',');
log.debug('header',header);
var rows = results.map(function (task) {
return fieldNames.map(function (fieldName) {
return task[fieldName];
}).join(',');
});
log.debug('rows',rows);
var content = rows.join('\n');
log.debug('content',content);
var loadedFile = file.load({id : fileID});
loadedFile.contents = content;
var loadedFileID = loadedFile.save();
log.debug('filecreated with content',loadedFileID);
}
This is my script. it creates a file but with no contents. What is wrong with it?
e
erictgrubaugh
12/05/2023, 2:38 PM Copy code
//contents: contentv
vennila ramasamy
12/05/2023, 2:47 PMagain i load the file to set the content
n
NElliott
12/05/2023, 2:55 PMnot sure but why not save the file with the contents the once rather than save --> load --> save?
e
erictgrubaugh
12/05/2023, 3:05 PMI don't believe the
contentserictgrubaugh
12/05/2023, 3:05 PMI was trying a similar thing recently and did not see a way to update the contents of a file; I had to create the file with the contents I wanted
👍🏻 1
a
alien4u
12/05/2023, 3:06 PM@erictgrubaugh I think you are right, even to use the searchTask to export to CSV you need to create an empty file first.
v
vennila ramasamy
12/05/2023, 3:08 PMThe reason first i create a file is to let the customer choose either text or csv.
e
erictgrubaugh
12/05/2023, 3:10 PMThe
file.Filecontentsv
vennila ramasamy
12/05/2023, 3:15 PMvennila ramasamy
12/05/2023, 3:16 PMactully before the same code worked, all of a sudden it is stopped working
e
erictgrubaugh
12/05/2023, 3:17 PMThat picture is of the options parameter for
file.createfile.FileloadedFilev
vennila ramasamy
12/05/2023, 3:29 PMwhat could i do then?
I am damn sure it worked well before.
n
NElliott
12/05/2023, 3:32 PMOnly create your file at the point you know the type, including the contents....
v
vennila ramasamy
12/05/2023, 3:59 PMI think you are right, even to use the searchTask to export to CSV you need to create an empty file first.
To achieve this, what could i do then?
vennila ramasamy
12/05/2023, 4:04 PMfunction execute() {
var sqlQueryParameter = runtime.getCurrentScript().getParameter({name: 'custscript_sql_query_in_file_cabinet'});
var savedSearch = runtime.getCurrentScript().getParameter({name : 'custscript_saved_search'});
var format = runtime.getCurrentScript().getParameter({name : 'custscript_format_txt_or_csv'});
var folderToSave = runtime.getCurrentScript().getParameter({name: 'custscript_folder_to_save_the_results'});
if(format === 'CSV'){
var fileCreated = file.create({
name : 'task_data_export' + new Date() + '.csv',
fileType : file.Type.CSV,
//contents : content,
folder : folderToSave
});
var fileID = fileCreated.save();
log.debug('File Created', fileID);
}else if(format === 'TEXT'){
var fileCreated = file.create({
name : 'task_data_export' + new Date() + '.txt',
fileType : file.Type.PLAINTEXT,
//contents : content,
folder : folderToSave
});
var fileID = fileCreated.save();
log.debug('File Created', fileID);
}
if(sqlQueryParameter){
var sqlQuery = file.load({id : sqlQueryParameter}).getContents();
log.debug('format',format);
log.debug('sql',sqlQuery);
var results = query.runSuiteQL({
query : sqlQuery,
params : []
}).asMappedResults();
var fieldNames = Object.keys(results[0]);
log.debug('fieldnames',fieldNames);
var header = fieldNames.join(',');
log.debug('header',header);
var rows = results.map(function (task) {
return fieldNames.map(function (fieldName) {
return task[fieldName];
}).join(',');
});
log.debug('rows',rows);
var content = rows.join('\n');
log.debug('content',content);
var loadedFile = file.load({id : fileID});
loadedFile.contents = content;
var loadedFileID = loadedFile.save();
log.debug('filecreated with content',loadedFileID);
}else if(savedSearch){
var searchTask = task.create({
taskType : task.TaskType.SEARCH
});
searchTask.savedSearchId = savedSearch;
searchTask.fileId = fileID;
log.debug('searchtask',searchTask);
var searchTaskId = searchTask.submit();
}
vennila ramasamy
12/05/2023, 4:07 PMthis is my actual code . it has two deployments one for sql results, one for saved search results.
3 Views