Table field ignored when importing to a choice list

[andrewbailey]

Hi I am a beginner so slowly learning.

I have an issue when importing a xls file into a choice list. The steps I followed below

Create an xls file as per below and saving

Right click and show choices and right click on bar to import

Insert - select the file and click "Import"

It shows success with 8 and none missed

When I preview I get an error that table field is ignored as it does not exist in destination table

As per screenshot the Table field is (empty)

I can manually edit the Table values to the correct table (hr_case) and all is fine, however I have some choice lists (example created sub category) which have over 100 rows (with different dependent values to category) and I don't want to manually edit 100+ every time.

This is happening in my personal Developers instance and I know it should work as I can successfully perform the import in our work dev instance and the Table field is not ignored and is populated - work instance is also Fuji.

Other steps I have tried are doing an update as opposed to an insert by creating an excel template -

When I open the Template the Table column is not there.

Any ideas or assistance would be appreciated

Thanks

Andrew

[Ajai S Nair]

Hi Andew,

The table which you are loading is already present in choice table or not?

search with the table name in choice table and confirm that.

May be the table name is different or not present in sys_choice table

[andrewbailey]

Thanks Ajai

Some further information

This is using the HR Case management module Plugin which was activated

The hr_case table is the OOTB default table for Category

I have retried in our work test environment which is OOTB with no issues.

[Ajai S Nair]

Have you tried importing through transform map ?

[andrewbailey]

Thanks Ajai

The transform completed successfully

I will have to use the process in the future instead of the Import way.

I wiped and refreshed my personal instance and attempted the import route described in my original question above using the Incident module and still have the same issue with using this route - the Template I created described above still excludes the "Table"

I still would like a solution using the import route from the choice lists if anyone could assist as mentioned it does work on our Work instances. The only difference I can see between my personal instance and my work ones is that the work instances are upgrades to Fuji (Calgary to Dublin, Dublin to Eureka and now Eureka to Fuji)

Thanks Andrew