MapInfo Pro

 View Only
  • 1.  Multi Append Tool?

    Posted 01-23-2023 12:55
    Is there an updated version of a Multi-Append tool mbx out there somewhere?  I have an old multiappend.mbx file that I registered but cannot get to open or work with the latest version of MapInfo, and I did not see any mbx tool like this in the MapInfo Marketplace.  

    A colleague of mine showed me how to do it in Q-GIS which came standard in that program, made me wonder why something like this is not standard in this day and age in MapInfo.  Seems like a pretty easy and common thing to have in an advance GIS software program like MapInfo, but it's not.  

    I have to append about 25 files, and there's not way I want to do the manual 1 at a time way which is the only option available that I can see.  

    Thanks
    Ryan

    ------------------------------
    Ryan Richter
    COX COMMUNICATIONS
    Roanoke GA
    ------------------------------


  • 2.  RE: Multi Append Tool?

    Posted 01-24-2023 02:29
    If you don't manage to find such an existing and working append application, this is how it should look, if you care to do it on your own:

    Import "table1.MIF"
    set table table1 fastedit on

    Import "table2.MIF"
    Insert Into table1 Select * From table2
    drop table table2

    Import "table3.MIF"
    Insert Into table1 Select * From table3
    drop table table3

    etc.


    ------------------------------
    Uffe Kousgaard
    ROUTEWARE
    Roskilde
    ------------------------------



  • 3.  RE: Multi Append Tool?

    Posted 01-24-2023 04:06
    Somehow I read it as it was multiple MIF files you wanted to append. But if it is TAB files, it is even easier. It is the kind of stuff, where it is faster to write the code, than looking for someone else, who has already done it. And then it doesn't do exactly what you need.

    ------------------------------
    Uffe Kousgaard
    ROUTEWARE
    Roskilde
    ------------------------------



  • 4.  RE: Multi Append Tool?

    Employee
    Posted 01-24-2023 02:46
    Hi Ryan

    Yeah, that would be easy to do. But there are always those tiny tweaks where a table has a different column structure or order of the columns...

    But you are right. We should have such a tool.

    For now, you can use this elementary method:

    1. Open the tables you want to merge
    2. Paste the two lines of code into the SQL Window and execute them until you get an error

    Insert Into TableInfo(1, TAB_INFO_NAME) Select * From TableInfo(2, TAB_INFO_NAME) DropIndex Auto
    Close Table TableInfo(2, TAB_INFO_NAME)

    This will insert the second table into the first table and then close the table. Continue doing this until you only have one table open.

    You can also use the MapBasic Window. Paste the two lines into the MapBasic Window, select both lines, and hit Enter until you get the error.

    The error occurs when you only have one table open.

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



  • 5.  RE: Multi Append Tool?

    Posted 01-24-2023 05:05
    Ryan,

    I have an .mbx called combine layer from 1994 that still works - although I had to recompile the .mb in mapbasic v21 first.  It will basically create a new table of all the layers in a map window.  I have no idea where I got it from but pretty sure its freeware.  would you like a copy?

    Nick

    ------------------------------
    Nick Hall
    Mapchester LTD
    Manchester
    ------------------------------