Property description

The excel_import_settings property configures the settings for importing objects from an Excel file.

Minimal JSON

{
    "key": "excel_import_settings"
}
{
    "setting": {
        "key": "excel_import_settings",
        "value": {
            "allowCrossSpaceAppImport": true,
            "allowedImportModes": ["FULL_RELOAD", "INSERT", "UPDATE", "DELETE"],
            "dateFormat": "MM-dd-yy",
            "fullReloadDeletionMode": "SOFT",
            "minimalRightsLevel": "space_admin",
            "multiAppsImportEnabled": false
        }
    }
}

This example JSON is applicable for the settings asset. The settings in the applications asset are configured differently.

Nested properties

PropertyDescriptionValueMandatory
keyexcel_import_settingsstringYes
valueSpecifies settings values. See supported value keys.stringNo

Supported value keys

NameIs Single OnlyDescription
allowCrossSpaceAppImportYesEnables objects to be imported across different spaces and applications.
allowedImportModesNoAllowed import modes. See supported allowedImportModes values.
dateFormatNoDate format used in the import Excel file. The list of supported values can be found here. Default value is d.m.yyyy (e.g., 1.1.202x).
enableExtendedLoggingNoEnables extended logging. The default value is false.
fullReloadDeletionModeNoThe deletion mode during a full reload process. The default value is SOFT.
minimalRightsLevelNoSets the minimum required role (permission level) needed to import objects. See supported minimalRightsLevel values.
multiAppsImportEnabledNoEnables object import into multiple applications. The default value is false.

Supported allowedImportModes values

ValueDescription
DELETEAllows deleting objects specified in the import.
FULL_RELOADAllows the full reload of the objects.
INSERTAllows inserting new objects specified in the import.
UPDATEAllows updating objects specified in the import.

Supported minimalRightsLevel values

ValueDescription
adminOnly administrators can import objects.
contributorAny contributor with write permissions for the space and higher can import objects. Default value.
space_adminOnly space admins and higher can import objects.