Added column_mappings object to the import complete webhook and the callback function. The column_mappings object contains the user-defined mappings between the columns of the sheet (template) and columns in the uploaded CSV file.
Added the Import ID column in the table on the Imports page of the CSVbox dashboard.
The dynamic columns now support multiple date validation.
01 July 2022
Added an Export button that downloads the validation errors and row data in an Excel sheet. More info here.
Updated importer UI to show the truncated row count.
30 June 2022
Added Max Rows option to the importer dashboard. It limits the number of rows per import.
Minor UI changes to the import modal. Changes include:
The importer modal is now full screen across all devices.
The column mapping table & validation error text are center-aligned for better visibility.
27 June 2022
New styling options added - upload logo and custom fonts.
24 June 2022
Added the Arabic language (ltr) support for the importer frontend.
23 June 2022
Added option to allow displaying the import fail error messages to the end-user.
22 June 2022
Added Primary Color custom theme option. You can stylize the importer with the primary color of your brand. More styling options coming soon.
10 June 2022
The importer will attach the custom user attributes as query parameters to the Dynamic List API request. csvbox_ prefix will be added to the custom user attribute query parameters. This will help you identify the users/environment and return back a relevant list of values.
30 May 2022
Added Upsert operation to MySQL, PostgreSQL and MS SQL data destinations. Instead of directly inserting the file data to the databases, the importer will first check if the record exists. If the record exists, then the row will be updated. Only if the record does not exist then a new row will be added.
23 May 2022
Added Dynamic List column type to accept valid list values via API, real-time.
20 May 2022
New display options for the 'Select Header Row' page of the importer.
Skip this step? - Hide/Show the 'Select header row' page to the users.
Show encoding - Hide/Show the character set selection list to the users.
Switch Row/Columns - Hide/Show the option to switch rows and columns to the users.
These settings help to remove the non-essential options from the importer and make the user experience cleaner.
19 May 2022
Added the option (DELETE button on Accounts page) to delete and close down the CSVbox account permanently.
12 May 2022
Added 'Multiple' option to Date Type columns. With this, you can provide multiple date formats that are allowed for the incoming data.
11 May 2022
Added the option to receive the CSV data in JSON format in the callback function. More info here.
The display order of the columns in the importer can now be changed by simply drag-dropping in the dashboard.
Ability to add rows directly in the importer.
Added Column Info Hints. Info Hints are help tooltips that will get displayed when the users hover the mouse over the Column Name (or click it) in the importer. They are useful to convey additional information about the Column.
The settings now allow skipping of the CSV data to be stored in csvbox s3 storage.
15 September 2021
Multiple Encoding support. The users can now select/change the Character Set when they upload a CSV.
Select Character Set
Display options for adding customizable title, help text and downloadable sample CSV on the importer.
09 September 2021
Increased the size of the file drop area on the importer.
Required columns will now have a * mark on the column mapping page of the importer.
Intermitted failed imports problem. It was related to the Cloudflare CDN issue.
31 August 2021
'Remove All' button to delete the invalid rows all at once.
Remove All button
Big-endian validation for date type columns.
30 August 2021
It was been a busy month for the csvbox team as we reworked the entire architecture and introduced some new features.
A new Plus plan with an increased limit of 500,000 rows per import
Intelligent Column Mapping - Based on the historical columns mapped by the users, the importer will now automatically map the columns for new imports so that the users don't have to.
Matching Keywords - You can provide a set of keywords as alternative matching options to help users match column names automatically. For example, let's say you have a column name 'First Name'. If you think a lot of your users might have sheets with columns as 'F_Name' or simply 'First', then you can add two matching keywords 'F_Name' and 'First'. The importer will then automatically match columns to the specified keywords to speed up column mapping.
In addition to the Column Name, you can now add Display Label for any sheet column. Display Labels will replace the Column Names in the header row that the user will see while doing an import.
Fixed Date validation bug.
20 July 2021
13 July 2021
07 July 2021
A new Data variable is returned via the callback function of the integration code. This variable contains the details of the completed import. More information here. This change is backward compatible with the old integration code.
30 June 2021
Fixed UI bugs.
Optimized importer for faster speed.
11 June 2021
New column type 'List'. You can now specify a list of allowed values for a column. The importer will validate the column data with the list of values configured.
Min, Max values validation for Number type columns.
Min, Max character length validation option for Text type columns.
A sheet copy button to quickly make duplicate sheets.
24 May 2021
A new optional method setUser() to the sheet integration code. With the setUser() method you can reference the user by providing the value to the user_id option. This helps you identify and match imports to their respective users from within your system.
Updated pricing plans.
New Pricing Plans
21 May 2021
Support for adding custom headers for all webhooks.
18 May 2021
Fixed a few edge case data input scenarios for CSV files.
Improved the speed of import.
29 April 2021
Boolean, Regex, IP, URL, Credit Card type validations for sheet columns.
csvbox.io branding for paid plans.
20 April 2021
Amazon S3 destination type. You can now push the user uploaded files directly to your S3 bucket
12 April 2021
Encryption for the user-uploaded files.
Validation check for restricting files more than 15MB in size.
Enhancements for faster uploads
19 Mar 2021
Settings page under the top right menu
Delete Files Policy to provide an option to get all the user files deleted as soon as the upload is complete.
File Delete Policy
Filter UI on the Import Page
03 Mar 2021
Date type validation for the sheet columns
UI bugs on the importer widget
18 Feb 2021
You can now subscribe to a webhook that will be triggered each time an import event is completed.
CDN file caching problem.
10 Feb 2021
Added a callback function to the sheet integration code. This function will be invoked client side each time an import event is completed.
20 Dec 2020
UI errors on the Imports page.
Location of the plans page. Moved it under the User menu.