topic Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables in Geoprocessing Questions

TableToTable_conversion 10.3.1 no longer outputs INFO tables

HarlanMarshall — Wed, 25 Jan 2017 16:35:41 GMT

I'm moving a python script running in ArcGIS 10.0 to ArcGIS 10.3.1 environment. In that script we are converting a file geodatabase table to an INFO table. This no longer works the same in 10.3.1 as it produces a DBF table rather than an INFO table even though the output table name "taxmaster" does not have the .dbf extension.

arcpy.TableToTable_conversion("C:/Test//TaxMaster2.gdb/taxInfoSort", "//stgisgdb1/testdata//taxmastr", "taxmaster", ...)

Apparently output to INFO table is no longer supported in TableToTable_conversion 10.3.1.

Is this the case and , if so, is there any way to convert from table to INFO table?

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

DuncanHornby — Sun, 29 Jan 2017 17:33:21 GMT

I can confirm that this behaviour even exists in ArcGIS 10.5. It does seem odd that it won't export to that format and insist on dBase, especially as Microsoft are trying to kill of dBase in all their office applications... With the new ArcGIS Pro not supporting mdb's this is only going to get more painful for the rest of us...

What ESRI are good at is creating an excellent help file and with little effort I worked out how to create an INFO version of your table.

Run the Create Table tool and create your blank empty INFO table, probably using another table as the template for its fields.
Run the Append tool appending into your INFO table.

So what was one step is now two. You could easily wrap this up in model builder and create your own tool.

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

DanPatterson_Retired — Sun, 29 Jan 2017 23:25:13 GMT

The outputs are quite specific (no INFO), but the inputs can be many

Table To Table—Help | ArcGIS Desktop

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

JoshuaBixby — Mon, 30 Jan 2017 02:14:38 GMT

Copy Rows still supports INFO output, at least when I run it from ArcPy. It is even explicitly mentioned in the documentation.

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

DuncanHornby — Mon, 30 Jan 2017 10:17:01 GMT

HI Joshua,

Unless I have missed something I cannot see where it states that INFO is a supported output? I then tried exporting a file geodatabase table to a folder (without a .dbf extension) using the copy rows tool and it throws an error.

This throws an error.

So from my limited testing I would disagree that copy rows supports INFO as an output.

Duncan

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

JoshuaBixby — Mon, 30 Jan 2017 13:32:39 GMT

My mistake, I didn't look close enough at the documentation. I thought the support input format was the support output format.

That said, it still works for me using both the GUI and ArcPy. I am running ArcGIS 10.5, build 6491. From the Geoprocessing Results:

Executing: CopyRows D:\geodata\Default.gdb\Factors D:\geodata\factors #

Start Time: Mon Jan 30 07:27:58 2017

Succeeded at Mon Jan 30 07:27:58 2017 (Elapsed Time: 0.27 seconds)

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

DuncanHornby — Mon, 30 Jan 2017 14:15:46 GMT

That is weird, you are correct, run as a tool through ArcToolbox it throws an error, but from command line is works a treat! I tried the Table to Table too out of interest, but no such luck, that still spews out a dBase file. So Harlan has at least two options to create his info table.

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

HarlanMarshall — Mon, 30 Jan 2017 14:58:42 GMT

Thank you all for looking into this. Somewhere between 10.0 and 10.3.1, TableToTable dropped INFO output.

You have given me another option to try which is exactly what I needed.

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

JoshuaBixby — Mon, 30 Jan 2017 15:56:50 GMT

If you look at the various online documentations, the references to supporting INFO tables as output dropped between 10.2.x and 10.3.x.

Re: TableToTable_conversion 10.3.1 no longer outputs INFO tables

HarlanMarshall — Mon, 30 Jan 2017 16:01:59 GMT

I looked but didn’t find anything. That’s why I asked about it.

Thanks Joshua.

Harlan Marshall

GIS Analyst – Senior

Pima County

(520) 724-6757