MapInfo Pro

Expand all | Collapse all

import excel file >= 255 columns

  • 1.  import excel file >= 255 columns

    Posted 02-01-2021 00:43
    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
    ------------------------------


  • 2.  RE: import excel file >= 255 columns

    Posted 02-01-2021 04:07
    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
    ------------------------------



  • 3.  RE: import excel file >= 255 columns

    Posted 02-01-2021 04:22
    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
    ------------------------------



  • 4.  RE: import excel file >= 255 columns

    Posted 02-01-2021 04:31
    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
    ------------------------------



  • 5.  RE: import excel file >= 255 columns

    Posted 30 days ago
    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
    ------------------------------



  • 6.  RE: import excel file >= 255 columns

    Posted 30 days ago
    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
    ------------------------------



  • 7.  RE: import excel file >= 255 columns

    Posted 30 days ago
    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
    ------------------------------



  • 8.  RE: import excel file >= 255 columns

    Posted 30 days ago
    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
    ------------------------------



  • 9.  RE: import excel file >= 255 columns

    Posted 30 days ago
    Hello Lee,

    Yes, that's a good workaround.

    Thanks.

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



  • 10.  RE: import excel file >= 255 columns

    Posted 29 days ago
    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
    ------------------------------



  • 11.  RE: import excel file >= 255 columns

    Posted 29 days ago
    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
    ------------------------------