How can I open the pdf template in the browser usi...
# suitescripta
AB
03/04/2020, 8:23 AMHow can I open the pdf template in the browser using suitescript 2.0?
d
D17339
03/04/2020, 8:26 AM Copy code
var renderer = render.create();
renderer.addRecord('saleorder', record.load({
type: record.Type.SALES_ORDER,
id: context.request.parameters.custom_id
}));
renderer.setTemplateByScriptId("CUSTTMPL_128_3768700_732");
context.response.writeFile(renderer.renderAsPdf())D17339
03/04/2020, 8:26 AMThis i using suitelet
D17339
03/04/2020, 9:14 AMTemplateRenderer.renderPdfToResponse()
a
AB
03/04/2020, 9:17 AM@D17339 Whenever I am using renderer.renderAsPdf(), will get an error message
{"type":"error.SuiteScriptError","name":"USER_ERROR","message":"Error Parsing XML: The reference to entity \"c\" must end with the ';' delimiter.","stack":["createError(N/error)","onRequest(/zSuiteScripts/OpenPDF.js:33)"],"cause":{"type":"internal error","code":"USER_ERROR","details":"Error Parsing XML: The reference to entity \"c\" must end with the ';' delimiter.","userEvent":null,"stackTrace":["createError(N/error)","onRequest(/zSuiteScripts/OpenPDF.js:33)"],"notifyOff":false},"id":"","notifyOff":false,"userFacing":false}
b
battk
03/04/2020, 9:35 AMyour template has an unescaped url in it
a
AB
03/04/2020, 9:44 AM@battk I can open the template then there is no issue. I think the template is correct.
b
battk
03/04/2020, 9:44 AMwhat is the template
a
AB
03/04/2020, 9:46 AM@battk that is advanced pdf template
b
battk
03/04/2020, 9:46 AMtemplate content?
a
AB
03/04/2020, 9:47 AM@battk below is the content
<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-<//big.faceless.org//report>" "report-1.1.dtd">
<pdf>
<head>
<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
<#if .locale == "zh_CN">
<link name="NotoSansCJKsc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKsc_Regular}" src-bold="${nsfont.NotoSansCJKsc_Bold}" bytes="2" />
<#elseif .locale == "zh_TW">
<link name="NotoSansCJKtc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKtc_Regular}" src-bold="${nsfont.NotoSansCJKtc_Bold}" bytes="2" />
<#elseif .locale == "ja_JP">
<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />
<#elseif .locale == "ko_KR">
<link name="NotoSansCJKkr" type="font" subtype="opentype" src="${nsfont.NotoSansCJKkr_Regular}" src-bold="${nsfont.NotoSansCJKkr_Bold}" bytes="2" />
<#elseif .locale == "th_TH">
<link name="NotoSansThai" type="font" subtype="opentype" src="${nsfont.NotoSansThai_Regular}" src-bold="${nsfont.NotoSansThai_Bold}" bytes="2" />
</#if>
<macrolist>
<macro id="nlheader">
<table class="header" style="width: 100%;"><tr>
<td rowspan="3"><#if companyInformation.logoUrl?length != 0><img src="${companyInformation.logoUrl}" style="float: left; margin: 7px" /> </#if> <span class="nameandaddress">${companyInformation.companyName}</span><br /><span class="nameandaddress">${companyInformation.addressText}</span></td>
<td align="right"><span class="title">${record@title}</span></td>
</tr>
<tr>
<td align="right"><span class="number">#${record.tranid}</span></td>
</tr>
<tr>
<td align="right">${record.trandate}</td>
</tr></table>
</macro>
<macro id="nlfooter">
<table class="footer" style="width: 100%;"><tr>
<td><barcode codetype="code128" showtext="true" value="${record.tranid}"/></td>
<td align="right"><pagenumber/> of <totalpages/></td>
</tr></table>
</macro>
</macrolist>
<style type="text/css">* {
<#if .locale == "zh_CN">
font-family: NotoSans, NotoSansCJKsc, sans-serif;
<#elseif .locale == "zh_TW">
font-family: NotoSans, NotoSansCJKtc, sans-serif;
<#elseif .locale == "ja_JP">
font-family: NotoSans, NotoSansCJKjp, sans-serif;
<#elseif .locale == "ko_KR">
font-family: NotoSans, NotoSansCJKkr, sans-serif;
<#elseif .locale == "th_TH">
font-family: NotoSans, NotoSansThai, sans-serif;
#else
font-family: NotoSans, sans-serif;
</#if>
}
table {
font-size: 9pt;
table-layout: fixed;
}
th {
font-weight: bold;
font-size: 8pt;
vertical-align: middle;
padding: 5px 6px 3px;
background-color: #E3E3E3;
color: #333333;
}
td {
padding: 4px 6px;
}
td p { align:left }
b {
font-weight: bold;
color: #333333;
}
table.header td {
padding: 0px;
font-size: 10pt;
}
table.footer td {
padding: 0px;
font-size: 8pt;
}
table.itemtable th {
padding-bottom: 10px;
padding-top: 10px;
}
table.body td {
padding-top: 2px;
}
table.total {
page-break-inside: avoid;
}
tr.totalrow {
background-color: #E3E3E3;
line-height: 200%;
}
td.totalboxtop {
font-size: 12pt;
background-color: #E3E3E3;
}
td.addressheader {
font-size: 8pt;
padding-top: 6px;
padding-bottom: 2px;
}
td.address {
padding-top: 0px;
}
td.totalboxmid {
font-size: 28pt;
padding-top: 20px;
background-color: #E3E3E3;
}
td.totalboxbot {
background-color: #E3E3E3;
font-weight: bold;
}
span.title {
font-size: 28pt;
}
span.number {
font-size: 16pt;
}
span.itemname {
font-weight: bold;
line-height: 150%;
}
hr {
width: 100%;
color: #D3D3D3;
background-color: #D3D3D3;
height: 1px;
}
</style>
</head>
<body header="nlheader" header-height="10%" footer="nlfooter" footer-height="20pt" padding="0.5in 0.5in 0.5in 0.5in" size="Letter">
<table style="width: 100%; margin-top: 10px;"><tr>
<td class="addressheader" colspan="3"><b>${record.billaddress@label}</b></td>
<td class="addressheader" colspan="3"><b>${record.shipaddress@label}</b></td>
<td class="totalboxtop" colspan="5"><b>${record.total@label?upper_case}</b></td>
</tr>
<tr>
<td class="address" colspan="3" rowspan="2">${record.billaddress}</td>
<td class="address" colspan="3" rowspan="2">${record.shipaddress}</td>
<td align="right" class="totalboxmid" colspan="5">${record.total}</td>
</tr>
<tr>
<td align="right" class="totalboxbot" colspan="5"><b>${record.duedate@label}:</b> ${record.duedate}</td>
</tr></table>
<table class="body" style="width: 100%; margin-top: 10px;"><tr>
<th>${record.terms@label}</th>
<th>${record.duedate@label}</th>
<th>${record.otherrefnum@label}</th>
<th>${record.salesrep@label}</th>
<th>${record.shipmethod@label}</th>
<th>${record.partner@label}</th>
</tr>
<tr>
<td>${record.terms}</td>
<td>${record.duedate}</td>
<td>${record.otherrefnum}</td>
<td>${record.salesrep}</td>
<td>${record.shipmethod}</td>
<td>${record.partner}</td>
</tr></table>
<#if record.item?has_content>
<table class="itemtable" style="width: 100%; margin-top: 10px;"><!-- start items --><#list record.item as item><#if item_index==0>
<thead>
<tr>
<th align="center" colspan="3">${item.quantity@label}</th>
<th colspan="12">${item.item@label}</th>
<th colspan="3">${item.options@label}</th>
<th align="right" colspan="4">${item.rate@label}</th>
<th align="right" colspan="4">${item.amount@label}</th>
</tr>
</thead>
</#if><tr>
<td align="center" colspan="3" line-height="150%">${item.quantity}</td>
<td colspan="12"><span class="itemname">${item.item}</span><br />${item.description}</td>
<td colspan="3">${item.options}</td>
<td align="right" colspan="4">${item.rate}</td>
<td align="right" colspan="4">${item.amount}</td>
</tr>
</#list><!-- end items --></table>
<hr /></#if>
<table class="total" style="width: 100%; margin-top: 10px;"><tr>
<td colspan="4"> </td>
<td align="right"><b>${record.subtotal@label}</b></td>
<td align="right">${record.subtotal}</td>
</tr>
<tr>
<td colspan="4"> </td>
<td align="right"><b>${record.taxtotal@label} (${record.taxrate}%)</b></td>
<td align="right">${record.taxtotal}</td>
</tr>
<tr class="totalrow">
<td background-color="#FFFFFF" colspan="4"> </td>
<td align="right"><b>${record.total@label}</b></td>
<td align="right">${record.total}</td>
</tr></table>
</body>
</pdf>
AB
03/04/2020, 9:48 AM@battk If I want to open any template then always gets an error message.
b
battk
03/04/2020, 10:40 AMi actually dont see any obvious unescaped urls in there
a
AB
03/04/2020, 10:43 AMSo @battk how can I fix this? Is there any way to print the PDF?
b
battk
03/04/2020, 10:47 AMwhat code are you using to render
a
AB
03/04/2020, 10:56 AMdefine(['N/render', 'N/record', 'N/xml'],
function(render, record, xml)
{
function onRequest(context) {
try {
var pdfFileName = "Standard Invoice PDF/HTML Template";
var renderer = render.create();
renderer.addRecord('record',record.load({
type: record.Type.INVOICE,
id: 486911
})
);
renderer.setTemplateByScriptId("STDTMPLCUSTINVC");
context.response.addHeader({
name: 'Content-Type:',
value: 'application/pdf'
});
context.response.addHeader({
name: 'content-disposition',
value: 'inline; filename="'+pdfFileName+'"'
});
log.debug('PDF : ', renderer.renderAsString());
// renderer.renderPdfToResponse(context.response);
context.response.write(renderer.renderAsPdf());
} catch(e) {
log.debug('Exception : ',e.toString());
}
}
return {
onRequest: onRequest
};
})
b
battk
03/04/2020, 11:07 AMaside from the weird multiple logging of the response, that looks reasonable
battk
03/04/2020, 11:07 AMnothing that should affect the output
battk
03/04/2020, 11:08 AMthe only thing in your template that looks like a url is
Copy code
${companyInformation.logoUrl}battk
03/04/2020, 11:08 AMyou can try explicitly escaping it via
Copy code
${companyInformation.logoUrl?xml}a
AB
03/04/2020, 11:57 AMHey, @battk now I can view my template in the browser. I removed the logo URL but I want to view the template with logo. When I add the logo URL, the error occurs again. Is there any way to view the template with logo in the browser?
Thanks!
b
battk
03/04/2020, 11:58 AMescape the url
battk
03/04/2020, 11:59 AM?xml
a
AB
03/04/2020, 12:02 PMI removed the below code
<td rowspan="3" width="10%"><#if companyInformation.logoUrl?length != 0><img src="${companyInformation.logoUrl}" style="float: left; height: 65%; width: 65%;" /> </#if></td>
AB
03/04/2020, 12:03 PMAnd I want my logo back, so how can I get the logo?
AB
03/04/2020, 12:03 PMI am not using any URL.
b
battk
03/04/2020, 12:03 PM${companyInformation.logoUrl} is a url
battk
03/04/2020, 12:03 PMits not escaped correctly
battk
03/04/2020, 12:03 PMuse an escape mechanism
a
AB
03/04/2020, 12:07 PMHey @battk, can you please explore this?
b
battk
03/04/2020, 12:08 PMresponses from an hour ago
battk
03/04/2020, 12:10 PMor you can start reading the documentation on it
battk
03/04/2020, 12:10 PM10 Views