Background The QBO Attachment Template class is used to orchestrate mail merges to create new documents. QBO contains various plug-ins that enable mail merging (see below). An Attachment Template defines the type of document being mail merged, where to get the merge data, what plug-in to use, the name and type of the file being created, as well as document retention guidance. FieldsTemplate: This is the template name. Applies To: This is the Parent Object Repeatable:
Plugin: This is the name of a mail merge plug-in to use when generating new Attachments based on a template.
Mime Type: This is used by the plugin to determine the file format of the document produced. For example, the Aspose plugins can produce Word, PDF, or RTF documents. The Crystal Reports plugin can produce Word, Excel, and PDF documents. Note that not all plugins support all mime types. Note that the list of mime type is maintained from Design > Configuration > Modules > Attachment Template, on the Mime Types panel. Transform: The "template" file used by a plugin to mail merge. Examples:
File Name Format: This field controls the path and name of the file on disk. By default, /{Object}/{ObjectID}/{FileName} will be used. The curly braces represent data that can be substituted as the path and file name is generated. Examples include:
The values that may be used in the curly braces include:
Method: The statement that is used to generate input data for the attachment. Type: This is a power-used defined enumeration of Attachment Template types. This can be maintained from Design > Configuration > Modules > Attachment Templates. Status: This is a power-used defined enumeration of Attachment Template statuses. This can be maintained from Design > Configuration > Modules > Attachment Templates. Initial Storage: Where file resides once created and saved. Leaving this value blank will default to the 'standard' location (recommended). However, one can instead target client or vendor FTP sites, imaging systems, or any other IFileObject configuration on the system. Expiration: Defines when to expire attachments of matching this template. Expiring a document means deleting the file on disk, while retaining the Attachment record in the database. This is useful for document retention compliance, and for managing disk storage space costs. This value is used by standard Attachment expiration jobs that may be configured in the system. Archive: Defined when a document is to be move for 'expensive' storage to 'cheap' archival storage. This value is used by standard Attachment archival jobs that may be configured in the system. Archive Storage: Where to store the file once it is archived. Outbound Service: What is used to handle mailing, only currently used for: USPSCertified Generating an Attachment based on a TemplateOnce an Attachment Template has been configured, one may generate a mail-merged attachment as follows:
There is an issue with Aspose and the PMingLiu font when generating Korean characters during Microsoft Word merges. If PMingLiu is used, Unicode blank squares are generated instead of Korean words. The solution, according to Aspose's documentation, is to change the font to Arial Unicode MS. |
Quandis Business Objects 3 > qbo.Attachment >