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 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 iddata type, this import will not work properly)
In excel Excel import, an imported row will have (at most) one owner. Although there can be multiple possible owners.
Empty cells or missing column will be considered null and if there is any default value in the template for that field then the default value will be imported instead of null.
Serial data type fields will be auto-generated if no value is found in the cell, otherwise, the value in the excel Excel will be imported.
The sheet name needs to be name of the entity. (eg. Bestillingsenhed, medie).
Import option will be found for only project level.
This import will only work for starbas project.
Sample Excel File
| View file | ||
|---|---|---|
|
...