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
  • Email
  • 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.