This guide helps you understand common mistakes in Excel and PDF files and provides straightforward solutions.
Like “Output Excel,” there will be respective error messages for PDF/CSV outputs.
This error occurs when authentication for Excel/PDF output fails.
Most of the causes of this error are due to setting an incorrect gusuku API key. For example, this error will occur if you accidentally enter the API key name or creator incorrectly.
Please check and modify the “gusuku API key” parameter for the action set with “Output Excel,” “Output PDF,” and “Output CSV” in Customine customization. Then, “Add it to the Kintone app” or “Generate the job” again.
Set the 30-digit “API key” to the “gusuku API key”.
This error occurs when Customine cannot retrieve the template file from the Kintone app.
The primary reason for not retrieving the template file is a permission error.
The details of the error reported from Kintone will be displayed following this message. If there is an access permission error, a message like the following will be added.
[Kintone Error]
HTTP Status: 403
id: xxxxxxxxxxxxxxxxxxxxx
code: CB_NO02
message: No privilege to proceed.
Please check the access permissions for the attachment field in the Kintone app where the template file is saved.
This error occurs when the template file extension is not .xlsx.
Please ensure that the template file extension attached to the Attachment field in the Kintone app is .xlsx.
.xls and .xlsm formats are not supported.
This error occurs when the template file is not in Excel workbook format.
The following cases will be the cause:
Please ensure that the template file extension attached to the Attachment field in the Kintone app is .xlsx and can be opened in Excel.
This occurs when the size of the template file is too large.
The template file must be smaller than 5MB in size.
Please remove any unnecessary sheets or rows from the template file.
A typical example is using an old Excel file output from the past as a template. In this case, there may be past output data remaining in the Excel file that has become very large in size. To reduce the size, please delete sheets or rows or copy only the necessary parts to a new Excel file.
Like “Output Excel,” there will be respective error messages for PDF/CSV outputs.
This error occurs when a record containing a large amount of data is passed to the “data record” during customization of the Kintone app. When the data exceeds approximately 50MB, this error occurs.
Please reduce the size of the record passed to the “data record”.
Reducing the number of records is the most effective.
If you cannot reduce the number of records, consider the app’s configuration to reduce the number of fields. Table data tends to become large, but you can reduce its size by using related records fields instead.
Like “Output Excel,” there will be respective error messages for PDF/CSV outputs.
This error occurs when the number of characters in the field value set in the cell exceeds the Excel limit of 32,767. It is hard to determine the data size at which this occurs definitively, as other customizations also impact it. However, it will likely happen when the size exceeds approximately 80 to 90 MB.
Please reduce the size of the record passed to the “data record”.
Reducing the number of records is the most effective.
If you cannot reduce the number of records, consider the app’s configuration to reduce the number of fields. Table data tends to become large, but you can reduce its size by using related records fields instead.
This error occurs when the total number of rows across all sheets in the template exceeds 10,000. Please note that this error will occur if the total exceeds, even if it is not exceeded in one sheet.
Please edit the template to remove any unnecessary lines.
In particular, templates with thousands to tens of thousands of empty lines are wasteful, so please remove them. $ FOREACH to $END automatically increases the number of rows according to the amount of data, so there is no need to prepare empty lines in advance in the template.
Please note that even if a cell appears empty in Excel, the data may not have been deleted.
This error occurs when the row number exceeds the maximum value in Excel (1048575) after applying the template.
Even if the number of lines in the template itself is small, it can occur when the number of lines expanded by $FOREACH to $END is enormous.
Please reduce the number of rows in the “data record”.
If there are two or more lines between $FOREACH and $END, please reduce the number of lines. If there are five lines between $FOREACH and $END, they will be expanded to five lines for each data record. If you reduce the lines between $FOREACH and $END to just one line, the lines per data record will also be reduced to one line, totalling one-fifth of the original amount.
This error occurs when the number of cells in the original sheet exceeds 10,000 in cases where the template sheet name starts with “#”.
If a sheet name begins with “#”, the corresponding sheet will be copied for each Kintone record. Such limitations are set at this time because the load becomes too heavy when the number of source cells is enormous.
Please edit the template to remove any unnecessary lines.
In particular, templates with thousands to tens of thousands of empty lines are wasteful, so please remove them. $ FOREACH to $END automatically increases the number of rows according to the amount of data, so there is no need to prepare empty lines in advance in the template.
Please note that even if a cell appears empty in Excel, the data may not have been deleted.
Like “Output Excel,” there will be respective error messages for PDF/CSV outputs.
This error occurs when the server runs out of memory during the Excel generation process on the gusuku server.
It happens when there is too much data to process. There are various factors that could cause the issue, but the most likely one is the attached file. It is more likely to occur when trying to load a large number of attachments or attachments of a considerable size.
If you are trying to display the attached file image with $IMG, consider reducing the size of the images attached to the Kintone record. Especially, if you attach photos taken with a high-resolution camera as they are, they may be very large in size.
This error occurs when the template’s sheet name is configured to be named based on the field value, such as “$(field code),” but the field value is either empty or does not exist.
If there is a possibility that the field value may be empty, it is advisable to place a fixed string before or after it. The example below will use the fixed string “Assignee_” combined with the value of the Assignee field as the sheet name. If the person in Assignee’s name is empty, it will be output with the sheet name “Assignee_”.
$("Assignee_")$(Assignees_name)
This error occurs when Excel functions not supported by Customine are used in the Excel template.
After replacing the cells in the template with the record data, a recalculation of all sheets is performed to reflect that data in the calculation formula cells. Not all Excel functions are supported in recalculation, and only some functions are supported. This error occurs when using functions that are not supported.
The function name will be displayed in the [XXXX] part of the error message. Please modify the template not to use this function.
You can check the functions supported by Customine here.
This error occurs when the template sheet’s name starts with “#” and a formula from another sheet references the original sheet that contains the “#”.
If a sheet name starts with ‘#’, that sheet will be output for each record. Then, the original sheet with the “#” will be deleted. ** Furthermore, after the data replacement of the template is completed, recalculation of all sheets will be performed. If there are calculation cells that refer to sheets with a “#” during this recalculation, this error occurs because the referenced sheet has already been deleted.
Modify the template so the sheet with ‘#’ is not referenced from another sheet.
It occurs if there is a sheet with “【】” in the template sheet name and a formula that references that sheet from another sheet. It can also happen with characters like ① other than “【】”.
In Customine’s Excel/PDF output, some full-width characters such as “【】” cannot be correctly recognized in formulas that reference other sheets.
Modify the template to ensure that the sheet name does not include characters that cause errors, such as “【】”.
This error occurs when a corresponding $END for $FOREACH is not found.
Please place the $END corresponding to $FOREACH on the same line as $FOREACH.
This error occurs when there are no data rows between $FOREACH and $END.
Please modify the template to ensure that there is at least one data line between $FOREACH and $END.
This error occurs when the template contains vertical cell merges that span the range between $FOREACH and $END.
Please modify the template to ensure the cell merge is between $FOREACH and $END.
This error occurs when using Excel’s table feature. It occurs when there are no data rows in the Excel table due to the $FOREACH to $END expansion.
In Excel’s table feature, a header row and at least one data row are required. On the other hand, if there is no target data in $FOREACH to $END, the lines of $FOREACH to $END will be deleted, which may result in a table with no data rows.
If there is a possibility that there are no data to expand with $FOREACH, please create a template as a regular table without using Excel’s table feature. Alternatively, it is also a good idea to include dummy rows in the template to ensure that at least one data row is created.
There are unclosed parentheses in the template’s $(field code) notation.
After the error message, the sheet name and cell will be displayed, so please correct the relevant part of the template to ensure that the parentheses are closed correctly.
This error occurs when an unrecognized command is used in the template’s $command (field code) notation.
For example, it can happen when you mistype $NUM(xxx) as $NUN(xxx).
After the error message, the sheet name and cell will be displayed, so please check and correct the relevant part of the template. Please be careful of typos.
This error occurs when there is an error in the syntax of the $IF command in the template.
Please refer to the specifications of $IF described in the reference manual and correct it to the proper notation. Please note that there are several types of $IF notation, so please consider which notation you would like to use.
This error occurs when the number of characters in the field value set in the cell exceeds the Excel limit of 32,767.
Fields that may contain such large text data are recommended to be excluded from Excel output.
If you absolutely must output that field, please reduce the size of the text set in the cell by limiting the number of lines output using slicing.