PDF Generation in Geneva

syed_faheem
ServiceNow Employee
ServiceNow Employee

This document will cover details on PDF Generator Plugin provided in Geneva as well as Enhancement that I have made to this solution.

1. PDF Generator Plugin

PDF generation feature has been added in Geneva as plugin, which provides the ability to generate PDF documents as per your own layout and data.

PDF Generator

New in Geneva application

com.snc.pdf_generator

Provides a tool to generate PDF documents.

This plugin has been used in Human Resources application to generate 'Employee Verification Letters' which is covered in Configure the employment verification letter and Complete an employment verification request articles in Geneva documentation.

However documentation lacks the details on use of this plugin for any other custom application or OOTB tables i.e. Incidents etc.

If you have been familiar with walter.brame's (fantastic) PDF Generator, this plugin is based on the same scripts. Basically this plugin provides you the ability to generate PDF of any document i.e. Letter which an end user can draft & design in ServiceNow with the data coming form record it is related to.

In order to utilize this for your application, you will need to create a script include similar to 'GeneralHRForm' and a document template table similar to 'hr_document_template' (both introduced with HR application in Geneva).

In Script Include you would be able to configure various aspects of this solution including variables which need to be replaced while PDF generation and document template table keeps all the customized templates which you could format as per your need using HTML editor.

Figure 1 - HR Document Template Record

Pasted_Image_4_21_16__11_38_AM.png

Figure 2 - PDF Letter Generated

Pasted_Image_4_21_16__11_42_AM.png

This solution has some limitations around variables you could use in templates as well as some other aspects. While working on it for a customer I have come up with some enhancements, which I would like to share with you in next section.

2. Enhancements

If you are looking to implement PDF letter generation functionality using solution provided for 'Employee Verification Letter' in HR Application, you would find few limitations and I have developed following enhancements to it.

a)       Dynamic Variables Parsing

Problem

When you are configuring document template you would notice that variables are being entered as {{Name]}} or {{Position}}. These variables are parsed by following method in 'GeneralHRForm' script include.

Figure 3 - OOTB Script Include Method

parseBody : function(docBody, instance){

                                  var parsedBody = docBody;

                                  var gr = new GlideRecord(this.tableName);

                                  gr.get(this.tableId);

                                 

                                  var date = gs.now();

                        parsedBody = parsedBody.replace(/\{\{Date\}\}/gi, date);

                        parsedBody = parsedBody.replace(/\{\{Name\}\}/gi, gr.hr_profile.name);

                        parsedBody = parsedBody.replace(/\{\{Position\}\}/gi, gr.hr_profile.position.position);

                        parsedBody = parsedBody.replace(/\{\{Time type\}\}/gi, gr.hr_profile.time_type.getDisplayValue());

                        parsedBody = parsedBody.replace(/\{\{Employment start date\}\}/gi, gr.hr_profile.employment_start_date);                                                    

                                 

                                  parsedBody = parsedBody.replace(/\{\{Work email\}\}/gi, gr.hr_profile.work_email);

                                  parsedBody = parsedBody.replace(/\{\{Work phone\}\}/gi, gr.hr_profile.work_phone);

                                  parsedBody = parsedBody.replace(/\{\{Prefix\}\}/gi, gr.hr_profile.introduction);

                                  parsedBody = parsedBody.replace(/\{\{Nationality\}\}/gi, gr.hr_profile.nationality);

                                  parsedBody = parsedBody.replace(/\{\{Manager\}\}/gi, gr.hr_profile.manager.name);

                                  parsedBody = parsedBody.replace(/\{\{Department\}\}/gi, gr.hr_profile.department.name);

                                  parsedBody = parsedBody.replace(/\{\{Employee number\}\}/gi, gr.hr_profile.employee_number);

                                  parsedBody = parsedBody.replace(/\{\{Employment status\}\}/gi, gr.hr_profile.employment_status);

                                  parsedBody = parsedBody.replace(/\{\{Employment type\}\}/gi, gr.hr_profile.employment_type);

                                  parsedBody = parsedBody.replace(/\{\{Gender\}\}/gi, gr.hr_profile.gender);

                                 

                                  // convert to the right image path

                                  parsedBody = parsedBody.replace(/\/sys_attachment.do\?sys_id=(\w{32})/gi, '/$1.iix');

                                  parsedBody = parsedBody.replace(/\/sys_attachment.do\?sys_id=(\w{32})/gi, '/$1.iix');

                                  parsedBody = parsedBody.replace(/src="\//gi, 'src="' + instance);

                                  return parsedBody;

                },                            

You would notice that variable parsing is hard-coded in the method, which poses a limitation that user can only use variables that have parsing code available in script include method 'parseBody'. Any new variable would require code change and may result in recurring code maintenance job for System Administrators.

Solution

For this solution lets consider we are developing Letter generation solution for an Incident record and have already created following script include and document template table.

Script Include: GeneralIncidentForm

Document template table: x_snc_letters_letter_template

Now we need to follow below steps:

Step 1: Add a new field called 'Table' to the document template form as below:

Figure 4 - Adding table field

Table___ServiceNow_Service_Management.png          

Step 2: Changed field type for 'Body' field from 'HTML Translated' to 'HTML Script'.

Figure 5 - Body field type change

Pasted_Image_4_21_16__11_57_AM.png

Step 3: Set 'Use dependent field' to checked and 'Dependent field' to 'Table' (i.e. new field you created)

Figure 6 - Setting dependent field

Body___ServiceNow_Service_Management.png

This will change your form to look like below:

Figure 7 - Enhanced document template form

Incident_Notification_Letter___ServiceNow_Service_Management.png

This form would now provide the similar functionality as we have for creating email templates i.e.

  • You can select table from the table dropdown, i.e. in this case 'Incident'
  • 'Select variable' section on right of 'Body' field populates all the fields from Incident table (which was selected in table field above).
  • You can select any field from variable list, which would be added to template body.
  • You can drill down / dot-walk to a lower level of field and add it to the body.
  • Notice that variables are now enclosed in ${}.

Step 4: Now we need to modify script include to parse these variables dynamically. Replace the parseBody method with code given below:

Figure 8 - Enhanced Script Include Method

parseBody : function(docBody, instance){

                                  var parsedBody = docBody;

                                  var gr = new GlideRecord(this.tableName);

                                  gr.get(this.tableId);

                                 

                                  var date = gs.now();

                                  parsedBody = parsedBody.replace(/\$\{date\}/gi, date);

                                  parsedBody = parsedBody.replace(/\$\{letterid\}/gi, this.letterid);

                                 

                                  // parsing of variables dynamically

                                  var sampleString=docBody.toString();

                                  var reg = new SNC.Regex('/\\$\\{(.*?)\\}/i');

                                  var match = reg.match(sampleString);

                                  var count =0;

                                  var variables = [];

                                  var values = [];

                                  var tmpValue;

                                  while (match != null) {

                                                    variables.push(match.toString().substring(match.toString().indexOf(',')+1));

                                                    match = reg.match();

                                                   

                                                    values.push(variables[count]);

                                                    if(gr.getDisplayValue(values[count])==null || JSUtil.nil(gr.getDisplayValue(values[count]))){

                                                                      tmpValue='';

                                                    }

                                                    else

                                                                      {

                                                                      tmpValue=gr.getDisplayValue(values[count]);

                                                                     

                                                    }

                                                    parsedBody = parsedBody.replace('${'+variables[count]+'}', tmpValue);

                                                    count++;

                                  }

                                 

                                  // convert to the right image path

                                  parsedBody = parsedBody.replace(/\/sys_attachment.do\?sys_id=(\w{32})/gi, '/$1.iix');

                                  parsedBody = parsedBody.replace(/\/sys_attachment.do\?sys_id=(\w{32})/gi, '/$1.iix');

                                  parsedBody = parsedBody.replace(/src="\//gi, 'src="' + instance);

                                 

                                  return parsedBody;

                },                              

And when you generate PDF, solution would be able to parse any variable you have included in the document template.

Here is the out put.

Figure 9 - Final generated letter

final.png

b)       Miscellaneous enhancements

Following minor enhancements were also made and are included in attached script include code.

        i) Removal of hard coded references for template table and source table form script include and passing them as parameter.

        ii) Setting file name in script include as you like.

        iii) and couple of more.

Apart from this I have also developed a solution of 'Letters & Correspondence Management' which covers:

  • Creating draft letter, approval and then generation of PDF
  • Having ability to select from multiple pre-drafted letter templates
  • Ability to generate latter / template with data coming from any ServiceNow table.
  • and more.

This solution will be available on Share portal soon.

Please share your feedback on this solution and how could this be improved.

Message was edited by: Syed Faheem

116 REPLIES 116

syed_faheem
ServiceNow Employee
ServiceNow Employee

Hi Ajit,


* What version are you on ?


* Do you have PDF Generatator plugin installed ?


* Can you share logs / errors ?



Cheers


Syed


Hi Syed, I do not why but this is not creating tables with border while printing pdf. Text are printing clear but not the tables with border and background color. Any idea why?


Hi Vijendra,


Did you set table border to 1 in table properties ?


See this image.


border.jpg


Hey Syed, I have resolved issue of border, I had manually added Border="1" in html, however background color and height of table is not set according to inline css properties. Is there is something different with this script which accept css differently? Many other CSS properties are also ignored while printing pdf.



Does there is any way by which we can pass style sheet to iTextPDF? I have came across a function setStyleSheet() (this.document.setStyleSheet()) but I do not know how I can pass style sheet.


Hi Vijendra


With reference to my discussion with developer of PDF Generator plugins, it does not cater for backgrounds and some other stuff. I have not tried setStyleSheet() yet. May be give it a try and share how you go with it.



Cheers


Syed.