Select rows in a collection to move them to another collection, or copy them while keeping the originals. Before you run the action, decide which source properties should become destination properties. A move requires a destination mapping for every editable source property; a copy can use only the properties you need.
Create a collection with the same data structure
To avoid losing data in a move, Datablist requires every editable source property to be mapped to a destination property. Each destination property can be mapped only once. If you want to copy selected fields instead, choose the option to keep the source items in the mapping step.
An easy way to have a compatible data structure for your source and destination collection is to create your destination collection using the source.
To do so, clone your collection and uncheck "Clone data".
With this "Clone data" unchecked, your new collection will have the same data structure.
Move items between collections
The "Move items" tool is available with one or more items selected. In the available actions, click on "Move items to another collection".
Then, select the destination collection.
Finally, map your current collection properties (on the left side) with your destination properties (on the right side). Leave Don't remove items from current collection unchecked to move the selected rows. Check it to copy rows and keep the originals; you then only need to map at least one property. Review the mappings before continuing, especially when two properties have similar names.
Notes: Datablist will try to auto-map your properties using their names.
Click Move items once the mappings are ready. A notification shows progress. The destination items are created before the source items are deleted when you move them. When you copy, the source items remain in place.
FAQ
How does the moving algorithm work?
Under the hood, Datablist follows this process:
- If your destination collection has a unique property, ensure no conflict exists. See FAQ question.
- Split your items into chunks.
- For each chunk, create the mapped items in your destination collection.
- Once all chunks have been processed, remove the items from your current collection only if you did not select Don't remove items from current collection.
What happens if my destination collection has a property with unique values?
The Unique values option lets you add a data constraint to your data. This prevents having items with duplicate values on a property.
When you move items into a collection with at least one property a "unique values" constraint, the algorithm checks that it passes the constraint.
If items from your current collection have duplicate values with the destination collection, an error will be shown. And the process will be stopped.
Can I continue to use Datablist during the moving process?
For big collections with hundreds of thousands of items, the moving process can take some time. In the meanwhile, you can browse your other collections.
But wait until the process is finished before editing data on your source or destination collections.