Merging multiple data tables into one table

[Anonymous]

I'm trying to merge 98+ different tables that have information on my water authorities valves in their distribution territory. The way I'm going about doing this is to attach a drawing with just the valve, query it based on one of the object data tables, have it draw the geometry, and then saving that drawing once the geometry is inserted. My question now is do I have to do this for all 98+ data tables? And, if that's the case, then what's next?

I'm basing this procedure on a screencast that our CAD consultant did for us, but his screencast goofed and what he's saying does not match what he's doing on screen. 

[Anonymous]

HI,

you could just export all valves into one SHP or SDF file. All attributes will be merged.

Then re-import. If you have blocks for your valves then importing the file back into Map allows to assign blocks again.

But whether that is a suitable approach in your situation I don't know.

Why do you want to merge? Whats the purpose?

Rob

[Anonymous]

Already tried exporting the valves to a SHP and SDF files. The attributes transferred over with the SDF but we already have info that was entered for the valves that was not transferred over. And with the SHP neither the data or the points were transferred over. The SHP file was created but nothing was on it.

The purpose is to ultimately join these tables together into a cohesive table and push them out to an Access Database, so that anyone can edit the tables without having to go into Autocad.

[Anonymous · Accepted solution]

Hi,

so I assume you have map object data tables attached to the valves and I also assume valves are just points or blocks? It that the case?

You wrote: "The attributes transferred over with the SDF but we already have info that was entered for the valves that was not transferred over"

So - which bits were not transferred over? If some bits were not transfered over than chances are high that with any other method that data will not travel accross either.

You wrote: "And with the SHP neither the data or the points were transferred over. The SHP file was created but nothing was on it." - Either the epxort settings were not right or there is something else going on. I think it is a good idea to try figuring out why the export was not successfull. Especially as ther eis already another issue when you try to export to SDF.

A sample drawing wher ethe export fails or is not complete might be helpful.

Rob