Yes, that's exactly the issue. Thank you for the workarounds, I will use them and contact support.
Original Message:
Sent: 05-03-2024 02:43
From: Peter Møller
Subject: Mapinfo sets field as float even when manually selecting character when importing xlsx
OK, it seems to work but then it doesn't.
We convert the column to Char as specified but the values are all numbers - all the characters seem to have been removed from the table once loaded into MapInfo Pro. The values starting with a character seem to have been changed into an empty string.
If I format the cells in the first row as Text, MapInfo Pro detects this and suggests using Char(20) as the column type.
You can also use OGR Vector Files to open Excel files. This also seems to detect the column as Char but for me, it picks a wide column of 254 characters.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
Original Message:
Sent: 05-02-2024 19:14
From: Paolo Banchig
Subject: Mapinfo sets field as float even when manually selecting character when importing xlsx
The table has over 18000 rows. I attach an example so you can check if this happens to you also
------------------------------
Paolo Banchig
Original Message:
Sent: 05-02-2024 01:32
From: Peter Møller
Subject: Mapinfo sets field as float even when manually selecting character when importing xlsx
Hi Paolo
That sounds like a bug but not something I have noticed earlier.
MapInfo Pro should, of course, honor the column type you select when opening an Excel file.
Do you get this misbehavior with a small file with just 6 records as you show above or only if you have thousands of records where the first many records are numerical?
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
Original Message:
Sent: 05-01-2024 17:00
From: Paolo Banchig
Subject: Mapinfo sets field as float even when manually selecting character when importing xlsx
Hello,
I have an excel table with many fields. One of them goes like:
Samples
1
2
3
4
GA12345
GA123456
...
When importing this table, mapinfo recognizes sample field as float automatically. But, since I don't want to lose the other records I select to treat the field as character. However, when creating a browser I can see that mapinfo still imported the field as float.
The solution I found is to move one record with a character sample (GA12345) to the beginning, and then it works fine.
Can anyone please confirm if this is a bug indeed or it just happens to me?
Thank you
------------------------------
Paolo Banchig
------------------------------