November 2021
New features
Automatic duplicates merging
Last month, we released Datablist Duplicates Finder to find and list collection items with duplicate values. Yet, processing those duplicates was a manual task.
Not anymore! In November, Duplicates Finder got an upgrade to automatically merge non-conflicting items.
What are non-conflicting items?
- Items with similar values for all their properties
- Items with complementary values
Merging Assistant
For items with conflicting values found with Datablist Duplicates Finder or to merge items directly from a collection, we introduce a Merging Assistant.
It shows two or more items, automatically select the item with the most information as Primary Item and allow merging data from other items into this Primary Item.
Import/Export Excel files
In addition to CSV, Microsoft Excel files have been added as import and export format.
To import a Microsoft Excel file, the data must be on the first worksheet and display a Table like structure.
Improvements
Properties data types
In November, built-in data types received improvements. Current built-in types are:
- Text
- Long Text
- Checkbox
- Url
- Datetime
- Date
- Number
During data import (CSV or Excel), Datablist scans the first 100 lines to automatically detect data types.
Collection search and sort actions are compatible with all those built-in data types.
In the detail drawer, data validation is performed to forbid non valid data inputs.
Empty cell en backspace/delete key press
Last month, bulk delete was added to empty several cells with the "Delete"/"Backspace" key. Now it also works on a single cell.
Fix freeze on big CSV file import
On very large files (more than 50mo), Datablist CSV Importer could freeze as browser memory became full.
Now, CSV files are read chunk by chunk to handle large files.
Currently, Datablist only import the first 10k lines but this is an important step toward higher volume of data.