Hi guys, anyone here ever written a script to merg...
# suitescriptb
badazzke
03/26/2019, 7:27 AMHi guys, anyone here ever written a script to merge two pdf documents into one? I'm looking to do this on a User Event script 🤔
n
Nik
03/26/2019, 7:34 AMfunction mergePDFs(get_file) {
try {
if (get_file) {
var xml = "<?xml version=\"1.0\"?>\n<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n";
xml += "<pdfset>";
for (var s = 0; s < get_file.length; s++) {
try {
var fileURL = nlapiLoadFile(get_file[s]).getURL();
xml += "<pdf src='" + nlapiEscapeXML(fileURL) + "'/>";
} catch (er) {
nlapiLogExecution('Debug', 'Error in getting individual files', er.message);
}
}
xml += "</pdfset>";
var file = nlapiXMLToPDF(xml);
return file;
} else {
nlapiLogExecution('Debug', 'No files to be merged.');
return false;
}
} catch (er) {
nlapiLogExecution('Debug', 'Error in mergePDF function', er.message);
return false;
}
}
💯 1
1000 1
Nik
03/26/2019, 7:35 AMThis is SS-1.0. Had it's 2.0 equivalent as well but unable to find rn. You'll need to change a few API calls rest should work like magic I think.
Nik
03/26/2019, 7:36 AMGet File Parameter is an array of internal id(s) of files
b
badazzke
03/26/2019, 1:25 PM@Nik The code keeps failing at
nlapiXMLToPDF( myxml )badazzke
03/26/2019, 1:25 PMThe error i get is
Error Parsing XML: //system.eu2.netsuite.com/core/media/media.nl?id=5175759&c=3398896&h=b8264df6cdd72b6f2419&_xt=.pdfn
Nik
03/26/2019, 1:31 PMYou are using SS-1.0?
Nik
03/26/2019, 1:32 PMShare your code, and try to access the file you are trying to convert in here
b
badazzke
03/26/2019, 1:37 PM@Nik Yes am using SS1.0, perhaps i should switch it to SS2.0??
badazzke
03/26/2019, 1:38 PMfunction mergePDFs(get_file)
{
try
{
if (get_file)
{
var xml = "<?xml version=\"1.0\"?>\n<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n";
xml += "<pdfset>";
for (var s = 0; s < get_file.length; s++)
{
try
{
var fileURL = nlapiLoadFile(get_file[s]).getURL();
xml += "<pdf src='" + nlapiEscapeXML(fileURL) + "'/>";
} catch (er)
{
nlapiLogExecution('Debug', 'Error in getting individual files', er.message);
}
}
xml += "</pdfset>";
var file = nlapiXMLToPDF(xml);
return file;
} else
{
nlapiLogExecution('Debug', 'No files to be merged.');
return false;
}
} catch (er)
{
nlapiLogExecution('Debug', 'Error in mergePDF function', er.message);
return false;
}
}
var pdf_files = [5500134, 5477803]
var myfile = mergePDFs(pdf_files);
n
Nik
03/28/2019, 6:29 AMHave you tried logging the generated file URL and if the role you are trying to do this with have access to those files. laos, the file size of the generated consolidated PDF is in the correct range?
Nik
03/28/2019, 6:30 AMCan you share the screenshot of the error. This very function when I ran with a couple of valid Files, ran perfectly for me.
b
badazzke
03/28/2019, 11:26 AM@Nik You my friend, are a GENIUS!!!!!!!!!!!! Converted the script to 2.0 and it works!!! Wow! Lemme post my 2.0 version
🤓 1
n
Nik
03/28/2019, 12:16 PMThanks! But I inherited this script and only modified based on my use. 😜
Go ahead. Post your 2.0 version. Want to know what resolved the error you received in first place. 🤔
b
badazzke
03/28/2019, 2:00 PMfunction mergePDFs(get_file)
{
try
{
if (get_file)
{
var xmlDocument = "<?xml version=\"1.0\"?>\n"+
"<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n"+
"<pdfset>";
for (var s = 0; s < get_file.length; s++)
{
try
{
var fileObj = file.load({'id': get_file[s] });
var fileURL = fileObj.url;
var xmlEscapedDocument = xml.escape({ xmlText : fileURL });
xmlDocument += "<pdf src='" +xmlEscapedDocument+ "'/>";
} catch (er)
{
log.debug('Error in getting individual files');
}
}
xmlDocument += "</pdfset>";
var pdfFile = render.xmlToPdf({ xmlString: xmlDocument });
return pdfFile;
} else
{
log.debug('No files to be merged');
return false;
}
} catch (er)
{
log.debug('Error in mergePDF function');
return false;
}
}
🔥 1
af 1
badazzke
03/31/2019, 7:33 AM@Eric B The code above should work fine
badazzke
03/31/2019, 7:41 AMfunction generateDocusignReadyFile(currentRecord, transaction_id, folder_id)
{
var supplierquote_id = currentRecord.getValue("custbody_external_order_attach");
var printTemplate_FileObj = render.transaction({ entityId: transaction_id, printMode: render.PrintMode.PDF });
printTemplate_FileObj.folder = folder_id;
var final_filename = printTemplate_FileObj.name;
printTemplate_FileObj.name = '_delete_'+printTemplate_FileObj.name
var printTemplate_fileId = printTemplate_FileObj.save();
if(supplierquote_id && printTemplate_fileId && final_filename)
{
var supplierquote_FileObj = file.load({'id': supplierquote_id });
var post_printTemplate_FileObj = file.load({'id': printTemplate_fileId });
if(supplierquote_FileObj.fileType == 'PDF')
{
var xmlDocument = "<?xml version=\"1.0\"?>\n"+
"<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n"+
"<pdfset>";
var supplierquote_fileURL = supplierquote_FileObj.url;
var printTemplate_fileURL = post_printTemplate_FileObj.url;
var xmlEscapedsupplierQuoteDocument = xml.escape({ xmlText : supplierquote_fileURL });
var xmlEscapedprintTemplateDocument = xml.escape({ xmlText : printTemplate_fileURL });
xmlDocument += "<pdf src='" +xmlEscapedprintTemplateDocument+ "'/>";
xmlDocument += "<pdf src='" +xmlEscapedsupplierQuoteDocument+ "'/>";
xmlDocument += "</pdfset>";
var pdfFile = render.xmlToPdf({ xmlString: xmlDocument });
pdfFile.folder = folder_id;
pdfFile.name = final_filename;
var merged_fileId = pdfFile.save();
if(merged_fileId){
file.delete({ id: printTemplate_fileId });
attachTemplateToRecord(merged_fileId, transaction_id);
}
} else {
log.debug('Document merging did not happen coz supplier quote format is not of type PDF');
}
}
return pdfFile
}
badazzke
03/31/2019, 7:45 AM@Eric B The above is another implementation of the same, where i generate a pdf file for merging without using the available without login
e
Eric B
03/31/2019, 4:11 PM@badazzke thanks!
b
badazzke
04/08/2019, 12:02 PMHi @Nik does this implementation have an exception? I've noticed some PDF documents get merged while some do not 🤔
n
Nik
04/09/2019, 3:52 AMWell, no one has ever reported any so far to me. And my logs are mostly clean. Can you share the exception message? Could be something due to some special symbols being used in PDF, in which case you may want to use some sort of cleaner/encoder function to parse the string to its Unicode equivalent. Something that will replace your '&' with '&' and '<' with '<' and all. I think you got the idea.
Share the exception message and we'll see how to go about it.
b
badazzke
04/14/2019, 8:17 AM@Nik
Copy code
{
"type": "error.SuiteScriptError",
"name": "UNEXPECTED_ERROR",
"message": null,
"stack": [
"renderXmlToPdf(N/render)",
"generateDocusignReadyFile(/SuiteScripts/WIOCC/Purchases/purchase_order_user_event.js:91)",
"afterSubmit(/SuiteScripts/WIOCC/Purchases/purchase_order_user_event.js:166)"
],
"cause": {
"type": "internal error",
"code": "UNEXPECTED_ERROR",
"details": null,
"userEvent": "aftersubmit",
"stackTrace": [
"renderXmlToPdf(N/render)",
"generateDocusignReadyFile(/SuiteScripts/WIOCC/Purchases/purchase_order_user_event.js:91)",
"afterSubmit(/SuiteScripts/WIOCC/Purchases/purchase_order_user_event.js:166)"
],
"notifyOff": false
},
"id": "03f30caf-867d-4cd4-bfb2-89f5e82bec6d-2d323031392e30342e3134",
"notifyOff": false,
"userFacing": false
}badazzke
04/14/2019, 8:22 AM@Nik The function is as below
function generateDocusignReadyFile(currentRecord, transaction_id, folder_id)
{
var subsidiary = currentRecord.getValue("subsidiary");
var supplierquote_id = currentRecord.getValue("custbody_external_order_attach");
if((subsidiary == 13) || (!supplierquote_id))
{
supplierquote_id = currentRecord.getValue("custbody_quote_attachment");
}
var printTemplate_FileObj = render.transaction({ entityId: transaction_id, printMode: render.PrintMode.PDF });
printTemplate_FileObj.folder = folder_id;
var final_filename = printTemplate_FileObj.name;
printTemplate_FileObj.name = '_delete_'+printTemplate_FileObj.name
var printTemplate_fileId = printTemplate_FileObj.save();
if(supplierquote_id && printTemplate_fileId && final_filename)
{
var supplierquote_FileObj = file.load({'id': supplierquote_id });
if(!supplierquote_FileObj.isOnline) supplierquote_FileObj.isOnline = true;
supplierquote_FileObj.save();
var post_printTemplate_FileObj = file.load({'id': printTemplate_fileId });
if(supplierquote_FileObj.fileType == 'PDF')
{
var xmlDocument = "<?xml version=\"1.0\"?>\n"+
"<!DOCTYPE pdf PUBLIC \"-//big.faceless.org//report\" \"report-1.1.dtd\">\n"+
"<pdfset>";
var printTemplate_fileURL = post_printTemplate_FileObj.url;
var supplierquote_fileURL = supplierquote_FileObj.url;
var xmlEscapedprintTemplateDocument = xml.escape({ xmlText : printTemplate_fileURL });
var xmlEscapedsupplierQuoteDocument = xml.escape({ xmlText : supplierquote_fileURL });
xmlDocument += "<pdf src='" +xmlEscapedprintTemplateDocument+ "'/>";//
xmlDocument += "<pdf src='" +xmlEscapedsupplierQuoteDocument+ "'/>";
xmlDocument += "</pdfset>";
var pdfFile = render.xmlToPdf({ xmlString: xmlDocument });
pdfFile.folder = folder_id;
pdfFile.name = final_filename;
var merged_fileId = pdfFile.save();
if(merged_fileId){
file.delete({ id: printTemplate_fileId });
attachTemplateToRecord(merged_fileId, transaction_id);
}
} else {
log.debug('Document merging did not happen coz supplier quote format is not of type PDF');
}
}
return pdfFile
}
badazzke
04/14/2019, 8:31 AM@Nik I have also sent you a copy of the file via direct message. Another thing I noticed is that the file has an adobe digital signature.. could that be the issue?
2 Views