Generate and output a CSV file based on the template file and record data.
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.
You need to 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 the Customine customization, create a customization that retrieves records that can save the templates to apply and records that will output data.
Finally, set up “Output CSV” within the customization and set the template and output records as parameters.
The generated CSV file will be in an uploaded state to Kintone. You can set the result of “Output CSV” as “$1” in the field mapping for “Add Record” in the attachment field.
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, Data Record, Template Record, Template Field, Charset, andFile Name.
Specify the API key for gusuku.
Please note that this is not about the API token of the Kintone app.
Select the record that will be the output data.
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. This parameter does not accept fields that are inside tables.
If no files are attached in that Attachment field, it will result in an error 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.
Enter the file name to attach to the Attachment field.
Content not expressed in the CSV file, such as figures, images, and cell formatting, will be lost during output.
If the output process does not finish within 10 minutes, it will result in an error.