Limitations when using the application.
Template File Limitations
Template Layout
Not all layouts and output patterns are supported. Complex layouts are not supported. Check with your templates and output contents in the Sandbox.
Template File Size
Template file size should not exceed 1 MB. The Office file consists of multiple XML files, compressed in a ZIP file, and the file size limit before compression is 4 MB.
Application for Creating Templates
- Template files should be created in the Microsoft Office desktop version.
- Templates created in other applications such as online version, Google Spreadsheet, Google Docs, etc. are not supported.
Office Features
Office features are not supported. Some Office features are available, but not all templates are supported. Complex patterns are not supported.
Available Office Features
File Type | Details |
Excel | Excel Formulas, Data Validation, Conditional Formatting, Table, and Shapes are available. |
Word | Table, Text Box, Watermark, Shapes and Field Codes are available. |
PowerPoint | Table, Text Box and Shapes are available. |
Table is available.
*Text Box, Watermark, Shapes and Field Codes are not available. |
*Tables are for layout only, excluding aggregate functions.
Notes on available Office features
- Not all templates are supported. Complex patterns are not supported.
- When opening the file, if the message "We found a problem with some content in 'XXX.xlsx'. Do you want us to try to recover as much as we can?" or other error messages, remove the Office features in the template.
- Office features are outside the scope of support. Check with your templates and output contents in the Sandbox.
Salesforce Governor Limits
The following are the main limitations that may conflict with Salesforce limitations when using the application
Major Limitations
Type | Limit | Value |
Apex Governor Limits | Total heap size | 6 MB |
Maximum CPU time on the Salesforce servers | 10,000 milliseconds(10 seconds) | |
Visualforce Limits | Maximum size of HTML response before rendering, when Visualforce page is rendered as PDF | Less than 15 MB |
Maximum PDF file size for a Visualforce page rendered as a PDF | 60 MB | |
Maximum total size of all images included in a Visualforce page rendered as a PDF | 30 MB |
Examples of Violation of Limitations
- Template file size exceeds 1 MB.
- Template contains high quality images.
- Template or record value contains a large number of characters (the number of characters includes the XML tags that consist the file).
Reference
Salesforce Subquery Limitations (Ver.1 only)
In Ver.1, if the child records contain Long text Area/Rich Text Area merge fields, the subquery limitation of Salesforce is applied.
- If the template contains Long Text Area/Rich Text Area merge fields of the child object, the maximum number of child records is approximately 50-200 records.
- The maximum number of records depends on the length of the fields and the number of fields.
- The limit is applied when Long Text Area/Rich Text Area fields are included, regardless of the number of characters in the record value.
- If the upper limit is exceeded, the output process is aborted, and an error message "Aggregate query has too many rows for direct assignment" is displayed.
Salesforce Help
Aggregate query has too many rows for direct assignment but less than 200 rows
*The application cannot be avoided by using For Loop as described in the Salesforce Help due to the various processes.
Workaround
- Use Ver.2. In Ver.2, when a subquery restriction error occurs, only the child record where the error occurred is acquired by another method and there are no subquery limitations.
- Set output conditions for child records and output them multiple times.
Reference
Filter Output Conditions for Child Records
Object/Field/Record Number Limitations
Limitations on file output. Output is possible within Salesforce limits, such as governor limits.
Type | Limitations |
Number of Merge fields | There is no limit on the number of merge fields in the application. |
Number of child objects
(Related object) |
There is no limit on the number of objects in the application. |
Number of child records | There is no limit on the number of records in the application.
*If the child records contain Long text Area/Rich Text Area merge fields, the subquery limitation of Salesforce is applied. |
Number of Bulk Output Files | There is no limit to the number of batch file outputs in the application. There is no governor limit based on the number of outputs since transactions are split per file. |
Image Record Limitations
(OFC Pro) |
|
Approximate maximum number of child records
The approximate maximum number of child records verified in the sample template output is 480 records. The maximum number of child records varies depending on the template, record values, and number of fields, so check with your template and output content in the Sandbox.
Maximum number of child records (Sample template: Word)
Number of Child Record | Results |
480 records | Success |
490 records | Heap size governor limit errors occurred. |