Import option will be found in project level context menu(click the right button) in the archive tree(asta7 side).
This import will only work for starbas project.
The sheet name needs to be the name of the entity. (eg. Bestillingsenhed, medie).
This import will work for non-root entities. For example, arkiv cannot be imported by this Excel import.
There will be two mandatory columns (Owner, Owner Legacy Id) in the input Excel file(look at the attached sample).
Owner Legacy ID will refer to the field having a serial data type of the owner entity. (If there are more than one field having serial data type, this import will not work properly)
In Excel import, an imported row will have (at most) one owner. Although there can be multiple possible owners.
Empty cells will be considered null.
Serial data type fields will be auto-generated if no value is found in the cell, otherwise, the value in the Excel will be imported.
Sample Excel File