topic Arcpy Table to Table Conversion of multiple tables in Python Questions

Arcpy Table to Table Conversion of multiple tables

ColeNelson — Mon, 21 Feb 2022 21:24:16 GMT

Hello everyone, I'm working on creating a tool that will allow me to select multiple tables from an Access Database and convert them to standalone tables in a Geodatabase:

I created a .odc database connection to the Access database the tables are being stored in hopes to make it easier to select the tables. Here is the script that I have so far:

import arcpy import os #Allow code to overwrite existing datasets arcpy.env.overwriteOutput = True #Set the variables workspace = r"C:\UpdateDevelopmentPython\ForDeveloping\isrb_business.odc" tables = arcpy.GetParameterAsText(0).split(";") outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb" outfile = os.path.join(workspace, "{}" .format(os.path.join(workspace) + str(["baseName"]))) #Create the standalone tables TblResponseID = arcpy.TableToTable_conversion(tables,outpath,outfile)

However whenever I run the the tool I keep getting this message.

import arcpy

import os

#Allow code to overwrite existing datasets

arcpy.env.overwriteOutput = True

#Set the variables

workspace = r"C:\UpdateDevelopmentPython\ForDeveloping\isrb_business.odc"

tables = arcpy.GetParameterAsText(0).split(";")

outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb"

outfile = os.path.join(workspace, "{}" .format(os.path.join(workspace) + str(["baseName"])))

#Create the standalone tables

TblResponseID = arcpy.TableToTable_conversion(tables,outpath,outfile)

I want the new standalone tables to keep the same name as the original Access tables, is there a way to do this? Thanks for the help!

Re: Arcpy Table to Table Conversion of multiple tables

DonMorrison1 — Mon, 21 Feb 2022 23:46:56 GMT

I actually don't see the error message - I do see the source code in red - is that what you are calling the error message?

Also:

Here are the file types supported by TabletoTable_conversion - I've never worked with Access files so maybe they work.:
1. Geodatabase
2. dBASE (.dbf)
3. Comma-separated values (.csv or .txt)
4. Microsoft Excel worksheets (.xls or .xlsx)
5. In-memory table views
I think you are going to have to copy one file at a time, it looks like you are trying to pass in a list
I would also print out (if running in a toolbox, use AddMessage) the variables along the way as you assign them just to verify they are what you expect - once you have it working you can remove those

Re: Arcpy Table to Table Conversion of multiple tables

Anonymous User — Tue, 22 Feb 2022 14:32:02 GMT

The parameters for the TableToTable are not right. It is expecting an input table, the output path, and just the output table name. You have a full path (and string of a list "baseName") going into the table name parameter.

Set your code up in a loop to iterate over the list of tables you get and you can grab the name of each table for the output. Like Don mentioned, add some print statements or set some breakpoints and debug so you can see what your variables look like.

tables = arcpy.GetParameterAsText(0).split(';') outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb" for tble in tables: baseName = os.path.basename(table) #Create the standalone tables TblResponseID = arcpy.TableToTable_conversion(tble, outpath, baseName)

Re: Arcpy Table to Table Conversion of multiple tables

ColeNelson — Tue, 22 Feb 2022 15:24:09 GMT

Hi Don I copied and pasted the wrong thing lol

Traceback (most recent call last):
File "C:\UpdateDevelopmentPython\DevelopmentScripts\PublishFireStationWithType.py", line 13, in <module>
Tbls = arcpy.TableToTable_conversion(tables,outpath,["baseName"])
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 3112, in TableToTable
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 3109, in TableToTable
retval = convertArcObjectToPythonObject(gp.TableToTable_conversion(*gp_fixargs((in_rows, out_path, out_name, where_clause, field_mapping, config_keyword), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
RuntimeError: Object: Error in executing tool

Re: Arcpy Table to Table Conversion of multiple tables

ColeNelson — Tue, 22 Feb 2022 15:30:49 GMT

Hi Jeff that worked great, thank yo so much!