Hi Guys, Can any one help me? I am trying to prepa...
# suitescriptp
Praveen Peddinti
10/09/2019, 8:43 PMHi Guys, Can any one help me? I am trying to prepare a CSV data in the script and creating a file to it. But i am getting "UNEXPECTED_ERROR", but if i do it after some time i'm able to create a CSV file.
b
battk
10/09/2019, 8:49 PMWhat does the code look like
p
Praveen Peddinti
10/09/2019, 8:58 PMHi battk, here is the custom function
function prepare_csvfile(csvData){
var result, ctr, keys, columnDelimiter, lineDelimiter, data;
data = csvData || null;
if (data == null || !data.length) {
return null;
}
columnDelimiter = csvData.columnDelimiter || ',';
lineDelimiter = csvData.lineDelimiter || '\n';
keys = Object.keys(csvData[0]);
result = '';
result += keys
.map(x =>
"${x}"Praveen Peddinti
10/09/2019, 8:59 PMI am calling this custom function from Map/Reduce script summary stage
Praveen Peddinti
10/09/2019, 9:00 PMcsvfileinfo = prepare_csvfile(failed_Array);
var fileObj_1 = file.create({name:'test.csv',fileTypefile.Type.CSV,contentscsvfileinfo});
fileObj_1.encoding = file.Encoding.UTF_8;
fileObj_1.folder = 1381273;
var file_Id = fileObj_1.save();
b
battk
10/09/2019, 9:02 PMunless you plan on working closer with support, stop using suitescript 2.1 and use suitescript 2.0
p
Praveen Peddinti
10/09/2019, 9:04 PMI also tried with doing in 2.0 but still i am facing the issue
Praveen Peddinti
10/09/2019, 9:04 PMand this is not happening all the time
b
battk
10/09/2019, 9:06 PMif its the same data, that weird
p
Praveen Peddinti
10/09/2019, 9:06 PMif it is failed to create CSV file first time & if i try it doing again surprisingly it will work.
b
battk
10/09/2019, 9:07 PMif its different data, then you probably need to share what your inputs are
p
Praveen Peddinti
10/09/2019, 9:07 PMIt is same data
b
battk
10/09/2019, 9:07 PMmy advice here would be to hardcode your inputs
battk
10/09/2019, 9:08 PMand if it still is inconsistent, share it with support
p
Praveen Peddinti
10/09/2019, 9:08 PMOk
Praveen Peddinti
10/09/2019, 9:08 PMBut can you tell me that how should be the final CSV string
Praveen Peddinti
10/09/2019, 9:09 PMI am trying to prepare like this
Praveen Peddinti
10/09/2019, 9:09 PM"externalid","entity","memo","class","custbody_del_psp","department","location","custbody_coi_tv_auto_assgin_gui","trandate","sublist_item_item","sublist_item_amount","sublist_item_tax1amt","Error" "consumer_adm_254706117","consumer_adm_13233001","254706117","4","cashier","1296","385","True","07/10/2019","3128","9.00","1","Invalid entity reference key consumer_adm_13233001." "consumer_adm_254706117","consumer_adm_13233001","254706117","4","cashier","1296","385","True","07/10/2019","3129","100.00","5","Invalid entity reference key consumer_adm_13233001."
Praveen Peddinti
10/09/2019, 9:09 PMevery thing in double quotes
b
battk
10/09/2019, 9:11 PMi think thats your output
battk
10/09/2019, 9:11 PMits the inputs you want to hardcode
p
Praveen Peddinti
10/09/2019, 9:13 PMYes, i am trying this now by hardcode.
Praveen Peddinti
10/09/2019, 9:14 PMlet me check if any issue in file preparing.