When exporting a structure to a project, you may encounter errors referencing the “mandatory” attribute in multiple tables and fields, see the example below:
{
"messages": [
{
"message": "No more supported 'mandatory' attribute in project found on field 'UUID' of table 'Table_1'. Please use instead 'Reject NULL value input' (or 'Map NULL values to blank values')",
"severity": "error"
},
{
"message": "No more supported 'mandatory' attribute in project found on field 'Name' of table 'Table_1'. Please use instead 'Reject NULL value input' (or 'Map NULL values to blank values')",
"severity": "error"
}
],
"success": false
}
These messages indicate that the ‘mandatory’ attribute is no longer supported in your project. Here's a quick fix:
- Identify the problematic fields:
In the example above ‘UUID’ and ‘Name’ fields in the ‘Table_1’ table - Adjust field settings from the field inspector:
- Uncheck the "Mandatory" Option: Disable the mandatory setting for the affected fields.
- Enable NULL Value Handling: Check one of these options to manage NULL values:
- "Refuse NULL Values"
- "Translate NULLs to Empty Strings"
- Re-export your structure:
After applying these changes, try exporting your structure again. The process should now complete without error.