Xanadu upgrade : 'sys_choice' table data loss if Label was empty

[gc00775491]

Mandatory fields on 'sys_choice' table

below are the mandatory fields on form level,

'Label' was not a mandatory field when we created a record in the List view hence we were able to create the choices with empty Lable or without Lable.

Now, when we upgrade to the Xanadu release - If we have choices with 'empty' Label will be lost after the upgrade. We need to recreate all the entries where earlier 'Label' was empty.

Is there any way we can save our choice list data without needing to recreate post-upgrade.

[Sumanth16]

Hi @gc00775491 ,

Description

Importing into sys_choice table using easy import option, the data uploads but the 'Table' column label is empty.

Steps to Reproduce: 

1. Open the Choice List Records
2. Click on List Control (hamburger menu) icon, and click on Import
3. Select Create Template and export it.
4. Fill the data inside the excel spreadsheet
5. Import the excel data sheet

>> Choice will add inside the sys_choice table but table field will displayed empty.

Cause

Issue has been reported on known PRB1315898.
This is caused by system property 'glide.import_template.field_types_to_ignore'
This defines a set of filed types to ignore in easy import. The Table column is in table_name type which is a ignore field by default.

Resolution

Removing table_name from the list on Value field from system property 'glide.import_template.field_types_to_ignore'

Plz mark my solution as Accept, If you find it helpful.

Thanks & Regards,

Sumanth meda

[Community Alums]

This looks like, 

In the list view or via import servicenow allowed or allowing to create the choices record in 'sys_choice' table without Label. 

When we upgrade to Xanadu, since Label ia mandatory fields and if we create with empty Label with value '-- None --' then system consider this as empty or dummy entry amd diacard that choice from the list. This is the observation when we created choice with value '-- None --' and kept Label empty.