- How to Export Records?
- Requirements When Exporting a File for Bulk Updating
- Canceling the Data Export Process
- Which Character Encoding Should I Choose?
Users can export records from an app to a CSV (Comma Separated Values) file. The exported file can be used to update records in bulk or migrate data between apps. For details on how to create or update records in bulk with a file, see What is Bulk Updating?.
- Export to file permission for the app containing the export data is required.
- For more details on permission settings in an app, see Setting Permissions in an App.
- Certain data, like Attachments or Comments, cannot be exported. For a list of data sets that can be exported, see Data Types that can be Imported/Exported.
- The export fails if the size of a file exceeds 100 MB. Reduce the number of fields or records to be exported when this happens.
- Select the view you wish to export from the drop-down on the left.
- Click the Ellipses icon on the right.
- Select Export to File.
- On the export page that opens, select whether to include the header row via the checkbox.
- Select the character encoding.
- Select the delimiter to separate each field in a record.
- By default, all fields in the view are displayed on the right as fields that will be included in the export. Drag additional fields from the left, over to the right. To remove a field click the Field Options and select Delete.
- When all desired fields are on the right, click Export.
- Fields with values that will be updated.
- Field used as the Key to Bulk Update.
What is Key to Bulk Update?Key to Bulk Update is used to update existing records in apps with data from a CSV or Excel file. Data from the spreadsheet is compared to a Key Identifier field. Key to Bulk Update should have unique values such that values are unique across multiple records.
- Use the Record Number field as your Key to Bulk Update. Record numbers are assigned to each record with unique values generated by default.
- If the Record Numbers match, the record is updated.
- If the Record Number column is empty, the record is added as a new record and assigned a Record Number.
- If a Record Number does not match an existing record, an error occurs.
- If the Key matches any of the values in a column, the record is updated with the data of the row.
- If no value is matched, the data of the row is added as a new record.
- Record number*
- Date and time**
You can cancel the record data export during the export process.
- Only the user who initiated the export process can cancel it.
- Once the export process is complete, you cannot cancel it.
- It can take a few seconds to a few minutes to cancel the export process.
How to Cancel the Data Export Process:
- When data export starts, you are automatically moved to the Exported Files screen.
- You can also go to Exported Files by clicking on the upper right side of the screen and selecting Exported Files.
- From the Exported Files screen, click Cancel from the row in a file you want the export process to stop.
- Cancel is only displayed during the export process.
- When the export process is canceled, a "You have canceled the export." message will appear.
When you export data to a file, you may be required to specify the character encoding. The appropriate character encoding varies depending on the language used for the data registered in an app.
- Shift JIS
- English and Japanese characters can be exported to a file.
- Characters in other languages or symbols like '©' and '®' may be garbled.
- ISO 8859-1 (Latin-1)
- Western European language characters such as English, French, and Germany can be exported to a file.
- English and Simplified Chinese characters can be exported.
- Major language characters can be exported to a file. When you choose Unicode, specify one of the following encodings:
- Unicode (UTF-8 with BOM)
- When you specify "Unicode (UTF-8 with BOM)", you can load the exported file in Excel with no garbled characters.
- However, when trying to use software other than Excel, the exported file may not open properly depending on which software you use.