Question

MapInfo to ArcSDE - Options

  • 23 September 2013
  • 5 replies
  • 1 view
S
Hi all,

 

 

Im just curious to know what might be the best way to deal with multiple MapInfo TAB files output to an ArcSDE geodatabase.

 

 

Is it the most efficient way to bring all features into the workspace and have them directed to the writer, or is there a way of looping through the location folder, processing each one until completion? (sounds tricky - is it doable?)

 

 

Ive typically dragged all feature classes into one or many workspaces and processed accordingly.

 

 

Appreciate your response(s) in advance.

 

 

Sean

5 replies

davideagle
Rank
Badge +10
Add your reader and use the 'Open Advanced Browser' button on the dialog. Then Add a Directory with a file filter set to *.TAB, you can also iterate through sub folders too:

 

 

 

 

Once done, click the properties of the reader feature type and apply a merge, then all the tab file names will become irrelevant and enter the workspace through one input feature type. Just connect that up to your target SDE table and you'll load all TAB files into the one table:

 

 

 

 

S
Thanks Dave,

 

 

I understand the above would merge many into one?

 

 

What i was after was to retain a one to one translation,

 

but try and channel the MapInfo files into one ArcSDE Writer (instead of multiple writers) whilst ending up with multiple tables created.

 

 

I managed to achieve the multiple tables in SDE by using a dynamic workspace, but couldnt control the output attributes - all attributes from each schema ended up in the destination feature classes.

 

 

Maybe ive not got the point of the dynamic workspace?

 

 

Can one achieve an outcome by using only one Writer nd still honour the output attributes?

 

 

Thanks in advance.

 

Sean

 

 

davideagle
Rank
Badge +10
Ok so, to do that you need to just add your reader and writer together and choose the option on the dialog 'Single Merged Feature Type'. This will automatically set the merge filter on the Reader but importantly set the 'Dynamic Properties' on the writer for you. In that fully dynamic mode any Tab file read in will end up in its own table with it's own attribute structure. The table name will then be controlled by the Tab file name and the schema will be applied per file:

 

 

 

davideagle
Rank
Badge +10
Ok so, to do that you need to just add your reader and writer together and choose the option on the dialog 'Single Merged Feature Type'. This will automatically set the merge filter on the Reader but importantly set the 'Dynamic Properties' on the writer for you. In that fully dynamic mode any Tab file read in will end up in its own table with it's own attribute structure. The table name will then be controlled by the Tab file name and the schema will be applied per file:

 

 

 

S
Perfect - that did the trick.  Thanks Dave - appreciate your expertise.

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.