File Output

   

The File Output command outputs the result data of the data editing flow to an Excel and CSV file in the cloud storage.

The data editing flow should always be ended with the output app command, but the file output command is treated in the same way. So, there is no problem if there is one or more file output commands in the data editing flow, even when the output app command does not exist.

Steps for Setting Command
For cloud services like Google Drive, you must set them up on Google in advance. For details, see Using Google Drive.

In order to set the File Output command, follow these steps. These settings are set on the Settings tab of the File Output command.

  1. Register account information of the cloud service
    Create an External Service Information App that saves the account information of the cloud service used when setting commands and executing the data editing flow, and register the account information. You can refer the registered account information on the External Service Setting List.
  2. Configure output file
    Set the file to be output by the command and the output method such as the output field and record output order.

1. Register Account Information of Cloud Service

In order to set the command, you must register and sign into the linked cloud service.

(1) Create kintone app (External Service Information App) that saves account information

This step is only required when you are using the File Input or File Output commands for the first time in Plug-in setting page. Note: you do not need to perform this step if the app name appears instead of the Select APP button in the External Service Information App.

a. Click the Select APP button of External Service Information App.

b. Create an external service information app by clicking Create service setting management app in the app selection dialog, entering the name in the APP Name field, and clicking the OK button.

c. Click the OK button after selecting the external service information application created in the application selection dialog.

(2) Sign into the cloud Service and allow krewData to access the files.

a. Click the Sign in button of Account Name.

b. Sign into cloud service's account / password on the sign-in screen.

  • Sign-in dialogs vary depending on the cloud service you are connecting to.
  • You will be asked to grant krewData access to the stored information when you make the first connection to the service. Select "Yes" when you open the first connection to the service.

2. Configure Output File

Set the output file name, output method and filtering conditions. In the Settings section, you will find more information about setting options.

Settings

1. Set the file information to be saved in the target service when the data editing flow runs.

Settings Description
File Type Select the file type to output.
  • CSV
  • Excel
Character Encoding Select the character encoding of the CSV file.
  • Japanese (Shift-JIS)
  • English (Latin 1)
  • Chinese (GBK)
  • Unicode (UTF-8)
  • Unicode (UTF-8 with BOM)
Delimiter Select the delimiter of the CSV file.
  • Comma
  • Semicolon
  • Tab
  • Space
Output Folder Click the Browse button and select the cloud storage folder where you want to save the file.
Output File Name Specify the file name to save in the output folder.
  • Enter file name: Enter the file name normally.
  • Specify file name using formula: Specify the file name by using formula.

The following characters cannot be included in the output file name.

  • \ / ? % * : | " < >
Output method Select the output method.
  • Output to new file
    • Overwrite if the file with the same name exists
      • Enable: If a file with the same name exists, the existing file will be overwritten with the result data of the data editing flow.
      • Disable: If a file with the same name exists, the result data of the data editing flow will not output. In this case, the execution result of the flow will be "Fail".
  • Add to existing file (works with CSV file type only)
    If a file with the same name exists, additional output will be added to the existing file. If the file with the same name does not exist, it will output to a new file.

2. Select fields of data editing flow to output and set output order.

Settings Description
Fields of data editing flow to output Select the field of result data of the data editing flow to output to the file.
Record Output Order Specify the order of records output to the file by using sort conditions.
Table record Output Order Specify the order of table records output to the file by using sort conditions
Auto Number

For more information about the auto number, refer to Auto Number.

Number of files to output, file size

There is a limit to the number of files to output and the size of the file when the data editing flow is executed. For more information, refer to Upper Limits.

See Also