MapInfo Pro

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
------------------------------

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
------------------------------

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
------------------------------

Original Message:
Sent: 01-24-2023 02:28
From: Uffe Kousgaard
Subject: Multi Append Tool?

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
------------------------------

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
------------------------------

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
------------------------------