Import - String to Select - Get an error

1

Hello,

My config:

Node: **v22.13.0**
Arch: **x64**
Platform: **linux**
Docker: **true**
RootDB: **pg**
PackageVersion: **0.260.2**

I try to import an excel file to a table and i get an error.
After multiple tests, i understand the error:

In a file, i get a column with string.
I try to map the column to a Single Select ( or Multi select).
I get the error:
Cannot read properties of undefined (reading 'msg')

I understand the error occur when there are options in the column that doesn’t exist in the field configuration yet… A better way could be that the new option would have been automatically added with the import (as in coda, etc.).

It’s not the case in nocodb.

Any idea for a work-around?
Thank you in advance for the help.
Jean-baptiste

2

Are you converting Single Line Text to Single Select after import? If so, ideally it should have worked. Please share the file (with data redacted may be) to help reproduce this issue. Or if you have any error logs, please share. We will investigate it further.

3

Thank you @dstala for your answer.

Yes, it’s possible to convert Single Line Text to Single Select after import.
It’s not a perfect solution because i would be able to import a file regularly.

Here is a a file to test :

I can’t check the log now but i will add as soon as possible.

4

What version of the NocoDB are you in? Please share your base-info

5

Hello,

Node: v22.14.0
Arch: x64
Platform: linux
Docker: true
RootDB: pg
PackageVersion: 0.262.0

I update to the last version.
It doesn’t change anything.

6

An issue related to upload is fixed and should be available in our next release (likely today). Will keep you posted