cli-kintone is a command line utility for exporting and importing kintone App data.
⚠️ ⚠️ This package has been deprecated. Please use @kintone/cli-kintone instead. ⚠️ ⚠️
0.14.1
These binaries are available for download.
- Windows
- Linux
- Mac OS X
https://github.com/kintone-labs/cli-kintone/releases
Usage:
cli-kintone [OPTIONS]
Application Options:
--import Import data from stdin. If "-f" is also specified, data is imported from the file instead
--export Export kintone data to stdout
-d= Domain name (specify the FQDN)
-a= App ID (default: 0)
-u= User's log in name
-p= User's password
-t= API token
-g= Guest Space ID (default: 0)
-o= Output format. Specify either 'json' or 'csv' (default: csv)
-e= Character encoding (default: utf-8).
Only support the encoding below both field code and data itself:
'utf-8', 'utf-16', 'utf-16be-with-signature', 'utf-16le-with-signature', 'sjis' or'euc-jp', 'gbk' or 'big5'
-U= Basic authentication user name
-P= Basic authentication password
-q= Query string
-c= Fields to export (comma separated). Specify the field code name
-f= Input file path
-b= Attachment file directory
-D Delete records before insert. You can specify the deleting record condition by option "-q"
-l= Position index of data in the input file (default: 1)
-v, --version Version of cli-kintone
Help Options:
-h, --help Show this help message
Note:
- If you use Windows device, please specify cli-kintone.exe
- Please set the PATH to cli-kintone to match your local environment beforehand.
cli-kintone --export -a <APP_ID> -d <FQDN> -t <API_TOKEN>
cli-kintone --export -a <APP_ID> -d <FQDN> -e sjis -c "$id, name1, name2" -t <API_TOKEN> > <OUTPUT_FILE>
cli-kintone --import -a <APP_ID> -d <FQDN> -e sjis -t <API_TOKEN> -f <INPUT_FILE>
Records are updated and/or added if the import file contains either an $id column (that represents the Record Number field), or a column representing a key field (denoted with a * symbol before the field code name, such as "*mykeyfield").
If the value in the $id (or key field) column matches a record number value, that record will be updated. If the value in the $id (or key field) column is empty, a new record will be added. If the value in the $id (or key field) column does not match with any record number values, the import process will stop, and an error will occur. If an $id (or key field) column does not exist in the file, new records will be added, and no records will be updated.
cli-kintone --export -a <APP_ID> -d <FQDN> -t <API_TOKEN> -b mydownloads
⚠️ WARNING
If the flag "-b" has NOT been specified, even though value of attachment fields in csv is empty or not, attachment fields will be skipped and not updated to kintone.
If the flag "-b" has been specified and value of attachment fields in csv is empty (empty is mean leave blank or ""), the data of attachment fields after importing to kintone will be removed.
- The conditions to remove all of attachment files
- The flag "-b" has been specified with directory path is required.
- Attachment columns are required for csv file but directory path is empty in csv.
- Attachment files are optional.
- The conditions to remove part of attachment files and update part of them
- The flag "-b" has been specified with directory path is required.
- Attachment columns are required for csv file.
- Attachment files are required if there's only part of them will be updated.
Ex: CSV file to removed files in attachment fields
"$id","Name","Department","File" "1","Adam Clark","Planning","" "2","Sarah Jones","HR",""
cli-kintone --import -a <APP_ID> -d <FQDN> -t <API_TOKEN> -b myuploads -f <INPUT_FILE>
⚠️ WARNINGThe error message
The "$id" field and update key fields cannot be specified together in CSV import file.
will be displayed when both "$id" and key fields are specified in CSV import file.
The key to bulk update must be specified within the INPUT_FILE by placing an * in front of the field code name, e.g. “update_date",“*id",“status".
cli-kintone --import -a <APP_ID> -d <FQDN> -e sjis -t <API_TOKEN> -f <INPUT_FILE>
cli-kintone --import -a <APP_ID> -d <FQDN> -t <API_TOKEN> -f <INPUT_FILE> -l 25
printf "name,age\nJohn,37\nJane,29" | cli-kintone --import -a <APP_ID> -d <FQDN> -t <API_TOKEN>
- The limit of each file size for uploading to attachments field is 10MB.
- Client certificates cannot be used with cli-kintone.
- The following record data cannot be retrieved: Field group, Blank space, Label, Border, Related records, Status, Assignee, Category
-
Windows command prompt may not display characters correctly like "譁�蟄怜喧縺�". This is due to compatibility issues between Chinese & Japanese characters and the Windows command prompt.
- Chinese (Traditional/Simplified): Display wrong even if exporting with gbk or big5 encoding.
- Japanese: Display wrong even if exporting with sjis or euc-jp encoding.
In this case, display the data by specifying utf-8 encoding like below:
cli-kintone --export -a <APP_ID> -d <FQDN> -e utf-8
*This issue only occurs when displaying data on Windows command prompt. Data import/export with other means work fine with gbk, big5, sjis and euc-jp encoding.
- English: https://kintone.dev/en/tutorials/tool-guides/features-of-the-command-line-tool/
- Japanese: https://developer.cybozu.io/hc/ja/articles/202957070
Requirement
- Go 1.15.15
- Git and Mercurial to be able to clone the packages
GPL v2
Copyright(c) Cybozu, Inc.