Generate and output a CSV file based on the template file and the query for records.
You can process more records compared to “Output CSV”. Instead, there will be many Restrictions.
Some preparations are necessary in advance.
You will need the API key for gusuku. This API key is different from the API token of the Kintone app. The API key for gusuku can be issued and obtained from gusuku Admin.
Prepare a template file. For information on how to create a template file, see Excel/PDF Output Template Reference Manual.
In addition, a Kintone app is also needed to save the template. Add an Attachment field in the app you created, and prepare records so there is one record per template in this field.
In Customine customization, you retrieve records that have saved the templates to be applied, and set parameters such as queries to obtain templates and output records with “Output CSV by Query.”
The output will take time, so a dialog will be displayed during the output processing. The action will be completed when the output is finished.
If multiple sheets are in the template, only the active sheet (the sheet that was open when saving the Excel file) will be output.
Set Gusuku API Key, App, Search Condition, Template Record, Template Field, Charset, Output Destination, and File Name.
Specify the API key for gusuku.
Please note that this is not about the API token of the Kintone app.
Select which app to retrieve the data you want to output from.
Enter the search criteria (query) to obtain the data you want to output.
It is also possible to set the condition to “All records.”
You can choose the order, but processing may be quicker if you do not specify it. If not specified, it will be in ascending order of record ID.
Select the record containing the template file.
If there are no selected records at runtime, it will result in an error.
Select the Attachment field in the “Template Record” that contains the template file.
Only Attachment field can be selected. Fields in tables cannot be selected.
If no files are attached in the Attachment field, an error will occur at runtime.
The file extension of the attached file must be .xlsx. If the file’s extension is other than that, an error will occur at runtime.
Select the character encoding for the output CSV file.
If you select UTF-8, it will be in the without BOM format. This format will cause garbled characters when you open the output file in Excel by double-clicking. To open the file in this format with Excel, you must first launch it with a new file and import it using Excel’s “Import External Data” feature.
Select a method to output the generated CSV file.
Enter a file name.
Enter the default file name for saving files.
Communication with gusuku’s server will occur, but IP address restrictions are not applied during this connection.
Data record retrieval is performed by the user set up in the Kintone connection settings on Customine or Deploit, not by the user executing customizations in the Kintone app. Please pay special attention to the differences in record viewing permissions. Records that are prohibited from viewing for users running the app may be obtained.
Content not expressed in the CSV file, such as figures, images, and cell formatting, will be lost during output.
If the output destination contains “Download”, the download will be performed in a separate browser tab. Therefore, if the pop-up blocker is enabled in the user’s browser settings, the operation to open tabs from customization will be blocked, and downloads cannot be performed. In that situation, pop-ups should be permitted in the browser settings.
If the output process does not finish within 10 minutes, it will result in an error.
“Output CSV by Query” has the following limitations: “Output CSV” doesn’t have.
$FOREACH(0..9).)