Sheet Options
Description of select sheet configuration settings
Show Error Text
Display the import fail error messages back to the end-users.
To see the errors, the users will have to click the 'See Errors' button on the import complete screen.
Export Button
Export validation errors in Excel
With this option, you can enable/disable the Export button on the verify data screen. Your users can export data to Excel while keeping the error highlighting and error messages. This helps to resolve the errors in the Excel sheet and quickly re-upload the file in CSVbox.
Server & Data Location
Select the geographic location of the servers & database for the user data.
Data residency refers to where the data is stored in a geographical location. The location is important usually for regulatory or policy reasons.
You have the option to select the storage location of the data uploaded by your users.
Go to Edit Sheets > Options > Privacy & Security section > Select the location from the dropdown.
The US is the default location. The other option is Europe (Germany.)
The data uploaded by the users will then pass through servers and get stored in the database situated in the selected location only.
Note, that you also have the option to not store the data at all.
The long-lived data about the import and the user files is not covered under the selected location. It mainly consists of supplementary log data helpful for troubleshooting and analyzing the import processes. This data does not include any original data from inside the user files. The image below shows how the data will flow if you select Europe as the data residency location.
Domain Authorization
Run the importer on select domains only
You can provide a list of authorized domains/sub-domains for embedding the importer. The embedded importer will work on the whitelisted domains only.
Go to Edit Sheets > Options > Authorized Domains > Add the domain/subdomains
If you do not whitelist any domain, then the importer embed will work on all the domains. This is the default configuration.
You can use the "*" wildcard prefix to include any subdomain. A few examples:
Text Valid Invalid exampleco.com
exampleco.com
www.exampleco.com, app.exampleco.com
www.exampleco.com
www.exampleco.com
exampleco.com, app.exampleco.com
app.exampleco.com
app.exampleco.com
exampleco.com, www.exampleco.com
*.exampleco.com
all exampleco.com subdomains
Import Complete Messages
Show custom messages when the import is completed
The messages can be:
Static - Any fixed text as per your requirements.
Dynamic - Provide an API to fetch the message text in real-time. The importer will append metadata (
import_id,sheet_id) to the API as query parameters. This will help determine the context and return relevant messages.
Resubmit Button
1-click to resubmit the same CSV file again
With this option, you can show or hide the Resubmit button on the Import Success screen.
The Resubmit button triggers a new import pushing the same file with the same import configuration.
This is useful during testing and debugging. You don't have to upload the file, match columns and confirm data for importing the file. Simply click the Resubmit button and push the file to the same destination.
Importer Dialog Size
Control the size of the import dialog box for large screens
Based on your import data structure (# of columns) you can pick between two import dialog sizes:
Medium
Large
To change the size go to sheet settings > display > Importer Dialog Size
Note: The dialog size configuration will be applicable for large (desktop) screens only. For smaller screens the dialog will always occupy the entire screen.
Worksheet Selection
Allow users to select a worksheet for upload
There can be a case where the uploaded Excel file contains multiple worksheets. You can allow the users to select a worksheet for upload.
To activate worksheet selection go to sheet settings > display > File Upload > Select 'Yes' for Allow Worksheet Selection option.
If the Allow Worksheet Selection option is set to 'No' then the first worksheet will be picked up by default.
Last updated
