New
In some cases you may have an unknown number of additional columns that users want to import. Now you can enable an option in your Importer admin to also import all unassigned columns, and receive this data in your callback or webhook.
Allow unassigned columns to be imported
Encoding switcher
New
When uploading files from legacy Excel versions the file encoding is often not UTF8. We now support users switching between all common encodings during the import process.
Local data callback option
New
If you want to receive imported data as a frontend JS callback (and disabled the webhook) there is a new onData callback option.
When you use this option, the webhook will be disabled and the imported data will not be sent to our servers (however basic metadata about the upload will still be saved).
Phone and date validation formats
New
Validation rules are now available for phone numbers and dates.
Increased maximum header and row size
Improvement
We've increased the maximum length of a column header and row cell to 64KB. This is above the Excel limit, and will allow even the largest files to be imported.
Custom regex validation rule
New
For cases where you want to do advanced data validation, we now support custom regex. This feature lets you configure a regular expression used to validate data in a specific column.
Vue.js Importer plugin released
New
It's now even easier to use UseCSV in your Vue.js project, with the new library we've just released. Checkout the docs.
Enable import data in preview mode
Improvement
To make integrating and end-to-end testing of your Importer, we now will send a live data import webhook when using the Preview Importer in the admin.
Trim spaces before/after each cell
Improvement
Excel files will often have tailing spaces in data. This becomes a problem when you are importing data like email addresses or names shouldn't contain unintended whitespace. We now trim whitespace at the start or end for all data being imported.
UseCSV is now in open beta
Big news today, UseCSV is now in open beta. The whole team at Layercode has been working hard to get here, and we're excited open up the product for everyone.
We're also starting a public changelog here so you're always up to date with all the updates, improvements and fixes that are made.