MapInfo Pro

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hello Peter,

Is there a ticket number from support?
How can we track progress?

I'd like to get in touch with our local product manager about this. This has been going on for more than one year. We were told 2019 would fix it, then 2019.1 and now on 2019.3, the issue is still there.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Original Message:
Sent: 02-02-2021 06:05
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hi Alban,

Another workaround is to create an unique ID column in excel, then split the table across multiple excel files (MapInfo will complain the table is already open if you try to import a sheet from the same file). Make sure you keep the id column in both files, this will be how the table is re-joined in MapInfo.

Once in MapInfo, run a SQL query something like
Select *
From large_number_of_columns_table, large_number_of_columns_table2
where large_number_of_columns.id_column = large_number_of_columns2.id_column
Into Selection

Kind regards,

------------------------------
Lee Crosby
Campaspe Shire Council
Echuca VIC
------------------------------

Original Message:
Sent: 02-02-2021 17:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

Is there a ticket number from support?
How can we track progress?

I'd like to get in touch with our local product manager about this. This has been going on for more than one year. We were told 2019 would fix it, then 2019.1 and now on 2019.3, the issue is still there.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-02-2021 06:05
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hello Lee,

Yes, that's a good workaround.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Original Message:
Sent: 02-02-2021 20:32
From: Lee Crosby
Subject: import excel file >= 255 columns

Hi Alban,

Another workaround is to create an unique ID column in excel, then split the table across multiple excel files (MapInfo will complain the table is already open if you try to import a sheet from the same file). Make sure you keep the id column in both files, this will be how the table is re-joined in MapInfo.

Once in MapInfo, run a SQL query something like
Select *
From large_number_of_columns_table, large_number_of_columns_table2
where large_number_of_columns.id_column = large_number_of_columns2.id_column
Into Selection

Kind regards,

------------------------------
Lee Crosby
Campaspe Shire Council
Echuca VIC

Original Message:
Sent: 02-02-2021 17:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

Is there a ticket number from support?
How can we track progress?

I'd like to get in touch with our local product manager about this. This has been going on for more than one year. We were told 2019 would fix it, then 2019.1 and now on 2019.3, the issue is still there.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-02-2021 06:05
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hi Alban

Yeah, this is very unfortunate.
Our support case# is PRE-00214910.

We have engineering picking up this issue as we speak.
We are planning on another build of MapInfo Pro v2019.3 to be posted on our web site in February.
At the moment, I can't tell if we can get a fix for this into that release.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------

Original Message:
Sent: 02-02-2021 17:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

Is there a ticket number from support?
How can we track progress?

I'd like to get in touch with our local product manager about this. This has been going on for more than one year. We were told 2019 would fix it, then 2019.1 and now on 2019.3, the issue is still there.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-02-2021 06:05
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Hello Peter,

Thanks for the support.
Happy to test a patch once available.

Best regards
Alban

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------

Original Message:
Sent: 02-03-2021 02:28
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, this is very unfortunate.
Our support case# is PRE-00214910.

We have engineering picking up this issue as we speak.
We are planning on another build of MapInfo Pro v2019.3 to be posted on our web site in February.
At the moment, I can't tell if we can get a fix for this into that release.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 17:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

Is there a ticket number from support?
How can we track progress?

I'd like to get in touch with our local product manager about this. This has been going on for more than one year. We were told 2019 would fix it, then 2019.1 and now on 2019.3, the issue is still there.

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-02-2021 06:05
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

You are right. It doesn't work. Sorry that I didn't verify the workaround better before sharing it.
Let's see what support comes back with

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-02-2021 03:32
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello Peter,

We tried the workaround today without much luck:

Using your method, we enter the range manually. The output was:
- extra columns (>255)  were created but were empty
- extra columns (>255) name were blank

It didn't work.
Have you tried with a mix of character and integer columns for example?

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:30
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.

I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.

Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"
When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.

Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.

how to get a ticket raised?

thanks

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW

Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns

Hi Alban

According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.

Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.

------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data

Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns

Hello,

- Is there a way to import excel file having > 255 columns please?

- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?

Thanks.

------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------