Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Overview

In order to provide clients with hard copy signature form to uniquely meet their needs, Windsor has implemented a feature that allows system users to:

  1. Establish Hard Copy Signature Document Template(s), including:

    1. Assigning a standard Hard Copy Signature Document Template for use as the hard copy signature form for all Forms in the system, by default.

    2. Customizing the default Hard Copy Signature Document Template with a Form specific/customized template.

  2. Access submission data for display within the document generated from the Hard Copy Signature Document Template.

Document Templates are formatted/designed in MS Word, using LINQ coding syntax to access Submission data, Aspose.Words for .NET to compile and generate the document, Aspose.PDF to PDF the document.

Hard Copy Signature Forms are based on a Document Template and are made available to submitters during the signature process (i.e., when enabled) to remit signature(s) to the agency via paper process (e.g., providing a wet ink signature and sending the form back to the agency).

Document generation supports a highly configurable, dynamic, feature set and as such, requires advanced skills and detailed testing/verification. Customers who elect to define advanced configurations in document templates should consult with Windsor to ensure appropriate conventions and techniques are utilized to ensure a successful implementation.

Introduction

The nFORM tool supports the ability to define documents that can be generated from the system. This includes a hard copy (i.e., physical) signature form submitters can download in support of the submission certification and signature process.

A hard copy signature form can be designed for the system as a whole as well as for specific forms. The content in the hard copy signature form can be static or dynamically driven based on data provided in the submission. This capability allows agencies and form designers to provide a highly formatted hard copy signature form to online submitters.

This document provides some technical guidance on how to design the hard copy signature form template(s).

Please note that this is an advanced topic and is only to be utilized by advanced technical staff which knowledge of software coding practices.

Hard Copy Signature Form Design

Hard Copy Signature Form Formatting/Layout

Hard Copy Signature Forms are formatted and designed using MS Word (version 2007 or higher). The MS Word document can be highly formatted and include advanced features such as headers, footers, paging, tables, etc.

Be sure to test out the layout and functionality of the template using the publishing and testing instructions in this document.

Referencing Submission Data

The Hard Copy Signature Document Template has the ability to access data from the submission for reference on the form. In order to access this data, the system uses Aspose.Words and an Aspose-specific variation of the LINQ coding syntax. Here are some helpful resources on the template syntax:

**Disclaimer**

This is an advanced topic and is only to be utilized by advanced technical staff which knowledge of software coding practices.

Staff should know that if errors are encountered while running these documents it is often due to issues with coding and data being presented not fitting into the assumed structure presented in this document. Most commonly, data referenced may not be present or may be returned in a different format than expected (e.g., text value returned in what was believed to be a numeric field). These situations must be handled/pre-empted to prevent errors during document generation. Professional services may be advisable/required from Windsor to assist in the creation of these documents.

Static Data Attributes

When accessing static submission data (e.g., Submission Date, Parent Organization, Submission Number, etc.), the Submission attributes can be access directly.

See the available static references available in the Appendix under the topic, Standard Submission Attribute References.

Submission Number Example

The following example returns a formatted Submission #.

<<[submission.formattedNumber]>> revision #: <<[submissionVersion.Number]>>

Form Name

The following returns the form name for the Form.

<<[formVersion.name]>>

Site Address Example

The following returns the Site Address assigned to the Form.

<<[siteAddress.fullAddress.Replace(“\n”,”<br/>”)]:upper:”format” –html>>

Note: The Replace(“\n”,”<br/>”) reference replaces all newline characters with a line break. The “:upper” reference is used to make all text uppercase. The “format” –html reference used to ensure the displayed text honors the HTML formatting tags.

Dynamic Data Attributes

When accessing dynamically data in the submission (e.g., custom data points defined in form sections by a form designer), there are a few steps that should to be followed, such as:

  1. Define variables for the data to be accessed at the top of the template.

  2. Perform any needed concatenation and appropriate error handling at the top of the template.

  3. Reference the data point using the defined variable within the core of the template.

Following these steps will allow the template to minimize code within the core of the template and help preserve the integrity of the template.

Speaking to bullets #1 and #2 above, the designer should define the variables to be referenced and perform any needed concatenation and error handling at the top of the document. Here are some examples of how to perform this task.

See the Dynamic Submission Attribute References section of the Appendix for details on available attributes available for each control.

Please contact Windsor for assistance with any advanced data access needs.

Short Text/Paragraph Example

In this example, the Template is attempting to access text from a Short Text or Paragraph Control, the “Site Name,” that the user entered in the submission. The Short Text or Paragraph (e.g., Site Name) Control in the submission has a Tag value of “SITE_NAME”. The first step is to define the siteName variable. Assuming Site Name control will always be available on the Submissions, use the following syntax to define the siteName control:

<<var [siteName = SectionControls.FirstOrDefault(sc=>sc.tag ==”SITE_NAME”).values.controlValue] >>

One defined, siteName can be referenced from anywhere in the form using the following syntax:

Site Name: <<[siteName] :upper>>

Note: The “:upper” reference is used to make all text uppercase.

Address Example

In this example, the Template is attempting to access text from an Address Control, the “Site Address”, that the user entered in the submission. The “Address” (e.g., “Site Address”) Control in the submission has a Tag value of “SITE_ADDR”. The code below performs the following tasks:

  • Defines the siteAddressCtrl variable so simplify the many references to this control.

  • Performs error handling to handle the situation where the site address is null.

  • The siteAddress variable is established by concatenating all the constituent parts of the address control (e.g., street address, secondary address, city, state, zip, etc.) and to improve formatting, HTML break tags are added where needed.

See example below:

<<var [siteAddressCtrl=SectionControls.FirstOrDefault(sc=>sc.tag ==”ADDRS”)]>>

<<var [siteAddress = siteAddressCtrl == null ? “”:”<br />”+ siteAddressCtrl.values.street + “<br />” + siteAddressCtrl.values.street2 + (siteAddressCtrl.values.street2 != null?“<br />”:””) + siteAddressCtrl.values.locality +”,” + siteAddressCtrl.values.areaCode + “ “ + siteAddressCtrl.values.postalCode] >>

Note: Each individual address component could be referenced separately (versus one address block, if desired).

One defined, the siteAddress can be referenced from anywhere in the form using the following syntax:

Site Address: <<[siteAddress]:upper:”format” –html >>

Note: The “:upper” reference is used to make all text uppercase. The “format” –html reference used to ensure the displayed text honors the HTML formatting tags.

Contact Control Example

In this example, the template is attempting to access a Contact Control, the “Submitter” information that the user entered in the submission. The Contact (e.g.,. Submitter) Control in the submission has a Tag value of “CNTCT”. The code below performs the following tasks:

  • Defines the submitterCtrl variable so simplify the many references to this control.

  • Performs error handling to handle the situation where the company name is null.

  • The submitterInfo variable is established by concatenating all the constituent parts of the Submitter control (e.g., name, street address, secondary address, city, state, zip, etc.) and to improve formatting, HTML break tags are added where needed.

See example below:

<<var [submitterCtrl=SectionControls.FirstOrDefault(sc=>sc.tag ==”CNTCT”)]>>

<<var [submitterInfo = submitterCtrl == null ? “”:”<br/>”+ submitterCtrl.values.companyNameContact+”<br/>”+ submitterCtrl.values.streetContact + “<br/>” + submitterCtrl.values.street2Contact + (submitterCtrl.values.street2Contact !=null?”<br />”:””) + submitterCtrl.values.localityContact +”,” + submitterCtrl.values.areaCodeContact + “ “ + submitterCtrl.values.postalCodeContact] >>

Note: Each individual address component could be referenced separately (versus one address block, if desired.

One defined, the submitterInfo can be referenced, in uppercase, from anywhere in the form using the following syntax:

<<[submitterInfo]:upper:”format” –html>>

Note: The “:upper” reference is used to make all text uppercase. The “format” –html reference used to ensure the displayed text honors the HTML formatting tags.

Other Considerations

Below are some additional considerations when presenting dynamic data attributes:

  • When defining the variables for the data to be accessed at the top of the template:

    • Perform this work at the top of the page (prior to the data attribute being referenced).

    • Do NOT add carriage returns in or between these definitions as the template will include these carriage returns in the presented document.

  • Any Controls referenced in the Template must exist on Submission Form. If the control doesn’t exist, errors will be encountered and the Payment Voucher will not be generated, unless error handling code is added. To trap for potentially absent controls, the following format of code can be used.

<<var [companyNameCtrl = SectionControls.FirstOrDefault(sc=>sc.tag==”COMPANY_NAME”)]>><<var [companyName= (companyNameCtrl == null ?””: companyNameCtrl.values.controlValue)]>>

  • If a Control is empty (e.g., not entered), the value will be returned to the template will be a blank. In some cases, blank values are saved in controls as a “?” to help with URL encoding. In these cases, the “?” will need to be replaced with a blank value during display.

  • Case does matter when referencing variables so be sure that your casing is in sync.

  • Configuration values (in the Vars.config, VarsOverrides.config, etc.) can be exposed to the document generator. These can be exposed by referencing the existing configuration properties in the following format:

<add key="docgen.config.settings" value="
app.title,
app.name,
message.email.appBaseUrl,
esa.recipient.organization.name,
esa.recipient.mailing.address,
hcs.recipient.organization.name,
hcs.recipient.mailing.address
"/>

Any attributes referenced here can be accessed from within the document by referencing the configuration value without periods and capitalizing secondary words. So, the app.Title configuration setting will be referencing as:

<<[appTitle]>>

The esa.recipient.mailing.address configuration setting will be referencing as:

<<[esaRecipientMailingAddress]>>

Testing

It is recommended that the Electronic Signature Form Template be tested in a test environment, prior to publishing.

Hard Copy Signature Form

If a test environment is not available, another means for testing the Hard Copy Signature Form Template is to add the draft Hard Copy Signature Form Template to an unpublished form as a non-default Hard Copy Signature Form Template and Preview that form.

Once a draft Template is assigned to the system/form, the user can navigate to the Certification and Submission/Signing step of the Submission Wizard for a form and select the Hard Copy Signature option. From this form, click on the “Download Certification Form” button.

You can also force the download of the Hard Copy Signature Form by assembling a URL to generate and download the Hard Copy Signature document directly. To do this assemble the URL in the following format:

[root application URL]/DocumentGeneration/[SubmissionVersionID]?
template=HardcopySignatureTemplate&fileName=HardCopySignature.pdf

The template value references the name of the template to be utilized/tested (sans the .DOCX file type reference). The filename specifies the name that will be assigned to the generated document.

For example, in Windsor’s QA environment, for a specific submission, the URL would look like the following:

http://qaweb.windsor.com/nForm/DocumentGeneration/b96013ff-de07-4417-8f6c-0784e631778?http://qaweb.windsor.com/nForm/DocumentGeneration/b96013ff-de07-4417-8f6c-0784e631778?template=HardCopySignatureTemplate&fileName=HardCopySignature.pdf

If issues are encountered and the Hard Copy Signature Form returns a runtime error, further details about the nature of the error can be found in the application logs which can be found here, [root web application folder]\App_Data\logs where root web application folder is equal to the location of the web application.

Publishing

Hard Copy Signature Form

To publish an established template, perform the following:

  • If the template will be considered the default template:

    • Save the template with the name HardCopySignatureTemplate.docx.

    • Copy/Move the template to your agencies Override folder, [root web application folder]\DocumentTemplates\Word where root web application folder is equal to the location of the web application. Note: Any changes made to the Template should be backed up and provided to Windsor to ensure the master template is included in the client build, to ensure it is not overwritten with an old version during the next deployment process.

    • At this point, the template will be utilized during the submission, for Forms using the default template.

  • If the template is form specific:

    • Save the template.

    • Open the Form for which this Hard Copy Signature Form will be used, in design mode.

    • On the Certification tab, uncheck the “Use Default Signature Form Template?” checkbox, upload this template to the Form.

    • At this point, the template will be utilized during the next hard copy signature request for this specific form.

Please note that the base Template that is shared throughout the system must be named HardCopySignatureTemplatedocx.

Appendix

Standard Submission Attribute References

Below is a list of key standard submission attributes that are available for reference in the template.

Note: More properties may be available. Please see the nFORM Control Attributes Reference Guide for guidance if an attribute needed is not referenced.

You may use any of these standard data elements in your template, just copy and paste to the location you want, even in the header and footer.

FORM DATA

  • Form Header:

    • Form Name:

      • Form Name: <<[formVersion.name]>>

      • Form Short Description: <<[formVersion.title]>>

      • Reference Number: <<[formVersion.referenceNumber]>> (this will only be populated after a processor has provided this number, post submission)

    • Alternative Identifier:

      • Label: <<[formVersion.altIdentityLabel]>> (only the label is from the form version)

    • Reason for Submission: <<[formVersion.formType]>> (this will only be populated when the Reason for Submission attribute is enabled on the form design)

    • Online Payments Accepted: <<[formVersion.isOnlinePaymentAvailable]>>

    • Form Version:

      • Full Version Number: <<[formVersion.version]>>

      • Major Version Number: <<[formVersion.versionNumber]>>

      • Minor Version Number: <<[formVersion.minorVersion]>>

  • Fees:

    • Account Number: <<[formVersion.accountNumber]>> (must be populated on form design)

    • Flat Fees (static fee list): <<foreach [item in formVersion.fees]>><<[item.description]>>: $<<[item.amount] >><</foreach>>

    • Calculated Fee (will not have values if fee is not calculated)

      • Fee Description: <<[formVersion.fees[0].description]>>

      • Is Payment Calculated: <<[formVersion.paymentIsCalculated]>>

      • Minimum Threshold: <<[formVersion.fees[0].MinimumFee]>>

      • Maximum Threshold: <<[formVersion.fees[0].MaximumFee]>>

    • Fee Amount: <<[formVersion.processingFee]>> (not really relevant for FORM VERSION)

  • Addresses: <<foreach [item in formVersion.addresses]>><<[ item.addressTypeName]>>:<<[ item.fullAddress] >><</foreach>>

SUBMISSION DATA

  • Submission Header:

    • Submission Number: <<[submission.formattedNumber]>>

    • Revision Number: <<[submission.LastSubmittedSubmissionVersion]>> (not yet available)

    • Submission Locked Indicator: <<[submission.isLocked]>>

    • Is Test/Preview Submission: <<[submission.isTest]>>

    • Submitted Date: <<[submissionVersionSubmitted]>>

    • Submitted By: <<[SubmissionVersionSubmittedBy]>>

    • Responsible person information:

<<[responsiblePerson.LastName]>>

<<[responsiblePerson.FirstName]>>

<<[responsiblePerson.DisplayName]>>

<<[responsiblePerson.PrimaryEmail]>>

  • Fees:

    • Account Number: (entered by Form Designer)

    • Payment Remittance Address: (Not yet available)

    • Fee Description: <<[submission.fee.description]>>

    • Calculated Fee:

      • Is Payment Calculated: <<[formVersion.paymentIsCalculated]>>

      • Minimum Threshold: <<[submission.fee.min]>>

      • Maximum Threshold: <<[submission.fee.max]>>

    • Fee:

      • Amount: <<[submission.processingFee]>>

      • Formula: <<[submission.fee.formula]>>

    • Payments/Adjustments:

      • Manual Payments/Adjustments: <<[submission.adjustments]>>

      • Online Payments: <<[submission.onlinePaymentsTotal]>>

      • Total Payments/Adjustments: <<[submission.paymentsTotal]>>

    • Payment Status:

ORGANIZATION DATA

  • Organization Header:

    • Top-Level System Organization Name: <<[systemOrganizationName]>>

    • Organization Name: <<[organization.name]>>

    • Organization Code: <<[organization.organizationCode]>>

USER DATA

  • User Information:

    • Name:

      • Full Name: <<[loggedInUser.displayName]>>

      • Username: <<[loggedInUser.login]>>

      • Email: <<[loggedInUser.primaryEmail]>>

    • Company: <<[loggedInUser.company]>>

      • Address: <<[loggedInUser.addresses.FirstOrDefault(a => a.addressType.Name =="home")]>> This is not yet available.

Dynamic Submission Attribute References

Submission attributes that are custom to a form or dynamically generated, can also be referenced on a template. Control values can be referenced in a format such as below, here Tag Value is the Tag assigned to the control and Control Type is the control type of the attribute being accessed. Please see the Control Value Properties Appendix within the nFORM Integration Guide for available Control Types that can be referenced for a Control.

Note: More properties may be available. Please see the nFORM Control Attributes Reference Guide for guidance if an attribute needed is not referenced.

The following describe how you would normally reference each control. Your Variable name is set to what you want to name the variable, the tag should be set to the tag within the control you wish to access.

Simple

Short Text

Establish Variable Example

<<var [ShortText=SectionControls.FirstOrDefault(sc=>sc.tag ==”STC”).values.controlValue]>>

Reference Variable Example

Short Text: <<[ShortText]>>

Paragraph

Establish Variable Example

<<var [Paragraph = SectionControls.FirstOrDefault(sc=>sc.tag ==”PRGRPH”).values.controlValue] >>

Reference Variable Example

Paragraph: <<[Paragraph]>>

Instructions

No attributes are returned from this control.

Single Selection

Establish Variable Example

<<var [Single=SectionControls.FirstOrDefault(sc=>sc.tag ==”SSC”)]>>

Reference Variable Example

Selection: <<[Single.values.select]>>

Reason: <<[Single.values.otherReason]>>

Multi Selection

Establish Variable Example

<<var [Multi=SectionControls.FirstOrDefault(sc=>sc.tag ==”MSC”)]>>

Reference Variable Example

Selection: <<[Multi.values.select.Replace(",",", ")]>>

Reason: <<[Multi.values.otherReason]>>


Formatted

Number

Establish Variable Example

<<var [Number=SectionControls.FirstOrDefault(sc=>sc.tag ==”NMBR”).values.controlValue]>>

Reference Variable Example

Number: <<[Number]>>

Date

Establish Variable Example

<<var [Date=SectionControls.FirstOrDefault(sc=>sc.tag ==”DTE”).values.controlValue]>>

Email

Establish Variable Example

<<var [Email=SectionControls.FirstOrDefault(sc=>sc.tag ==”EML”).values.controlValue]>>

Reference Variable Example

Email: <<[Email]>>

URL

Establish Variable Example

<<var [URL=SectionControls.FirstOrDefault(sc=>sc.tag ==”URL”).values.controlValue]>>

Reference Variable Example

URL: <<[URL]>>

Phone

Establish Variable Example

<<var [Phone=SectionControls.FirstOrDefault(sc=>sc.tag ==”PHN”).values.controlValue]>>

Reference Variable Example

Phone: <<[Phone]>>

Advanced

Name

Establish Variable Example

<<var [Name=SectionControls.FirstOrDefault(sc=>sc.tag ==”NME”)]>>

Reference Variable Example

Full Name: <<[Name.values.fullNameValue]>>

Title: <<[Name.values.titleValue]>>

Location

Establish Variable Example

<<var [Location=SectionControls.FirstOrDefault(sc=>sc.tag ==”LCTN”)]>>

Reference Variable Example

Address: <<[Location.values.mapAddress]>>

Coordinates: <<[Location.values.mapCoord]>>

Address

Establish Variable Example

<<var [siteAddressCtrl=SectionControls.FirstOrDefault(sc=>sc.tag ==”ADDRS”)]>>

<<var [siteAddress = siteAddressCtrl == null ? “”:”<br />”+ siteAddressCtrl.values.street + “<br />” + siteAddressCtrl.values.street2 + (siteAddressCtrl.values.street2 != null?“<br />”:””) + siteAddressCtrl.values.locality +”,” + siteAddressCtrl.values.areaCode + “ “ + siteAddressCtrl.values.postalCode] >>

Reference Variable Example

Line by line Address: <<[siteAddress]>>

1st Line of Address: <<[siteAddressCtrl.values.street]>>

2nd Line of Address: <<[siteAddressCtrl.values.street2]>>

Location Description: <<[siteAddressCtrl.values.description]>>

City: <<[siteAddressCtrl.values.locality]>>

State: <<[siteAddressCtrl.values.areaCode]>>

Zip: <<[siteAddressCtrl.values.postalCode]>>

County: <<[siteAddressCtrl.values.county]>>

Country: <<[siteAddressCtrl.values.countryCode]>>

Attachment

Establish Variable Example

<<var [Attachment=SectionControls.FirstOrDefault(sc=>sc.tag ==”ATTCHMNT”)]>>

Reference Variable Example

Comment: <<[Attachment.values.attachmentComment]>>

Confidential: <<[Attachment.values.confidential]>>

Confidential Reason: <<[Attachment.values.confidentialReason]>>

File ID: <<[Attachment.values.fileId]>>

File Name: <<[Attachment.values.fileName]>>

Table

Establish Variable Example

<<var [Table=SectionControls.FirstOrDefault(sc=>sc.tag ==”TBLE”)]>>

Reference Variable Example

Contact

Establish Variable Example

<<var [submitterCtrl=SectionControls.FirstOrDefault(sc=>sc.tag ==”CNTCT”)]>>

<<var [submitterInfo = submitterCtrl == null ? “”:”<br/>”+ submitterCtrl.values.companyNameContact+”<br/>”+ submitterCtrl.values.streetContact + “<br/>” + submitterCtrl.values.street2Contact + (submitterCtrl.values.street2Contact !=null?”<br/>”:””) + submitterCtrl.values.localityContact +”,” + submitterCtrl.values.areaCodeContact + “ “ + submitterCtrl.values.postalCodeContact] >>

Reference Variable Example

Line by line Address: <<[submitterInfo]>>

Prefix: <<[submitterCtrl.values.prefixNames]>>

First Name: <<[submitterCtrl.values.firstNameContact]>>

Middle Name: <<[submitterCtrl.values.middleNameContact]>>

Last Name: <<[submitterCtrl.values.lastNameContact]>>

Title: <<[submitterCtrl.values.titleContact]>>

Company Name: <<[submitterCtrl.values.companyNameContact]>>

Phone: <<[submitterCtrl.values.phoneContact]>>

Email: <<[submitterCtrl.values.emailContact]>>

1st Line of Address: <<[submitterCtrl.values.streetContact]>>

2nd Line of Address: <<[submitterCtrl.values.street2Contact]>>

Location Description: <<[submitterCtrl.values.descriptionContact]>>

City: <<[submitterCtrl.values.localityContact]>>

State: <<[submitterCtrl.values.areaCodeContact]>>

Zip: <<[submitterCtrl.values.postalCodeContact]>>

County: <<[submitterCtrl.values.countyContact]>>

Country: <<[submitterCtrl.values.countryCodeContact]>>

Hidden Text

Establish Variable Example

<<var [Hidden=SectionControls.FirstOrDefault(sc=>sc.tag ==”HDDN”)]>>

Reference Variable Example

Hidden: <<[Hidden.values.controlValue]>>

Calculated

Establish Variable Example

<<var [Calculated=SectionControls.FirstOrDefault(sc=>sc.tag ==”CLCLTD”).values.controlValue]>>

Reference Variable Example

Calculated: <<[Calculated]>>

Repeaters

If references to data found within a form repeater is desired, consulting services will be required to perform advanced configuration of the document template.

Markup

If you are uploading a document that is in review, be sure and turn off track changes before you save it to upload. Markup will be considered part of the document and will impact rendering.

  • No labels