Issues Reading a table from Geodatabase

abhimishra — Tue, 27 May 2014 21:44:16 GMT

Hi,

I have scripted a process to read a CSV file into a file geodatabase. Then, I want to read this imported file and work on it by adding new fields and calculating values. However, while using the arcpy.ListTables() on the geodatabase does not list the table.

I am just confused what is wrong.

Any help !!

Here is my script-------------------------

outLocation = dbLoc+'\\'+ out_name +'.gdb'
arcpy.env.workspace = where_tables_are # the folder where your tables are

# Make list of all tables in workspace
tables = arcpy.ListTables("GDB*")

print tables
try:

    for tb in tables:
    # Execute TableToGeodatabase
        print "Importing "+tb+ " to gdb: " + outLocation
        arcpy.TableToGeodatabase_conversion(tables, outLocation)

env.workspace = os.path.dirname(os.path.dirname(__file__))+'\\'+ out_name +'.gdb'
arcpy.RefreshCatalog(env.workspace)

inTables = arcpy.ListTables()

Re: Issues Reading a table from Geodatabase

JamesCrandall — Fri, 10 Dec 2021 23:07:27 GMT

Hi,

I have scripted a process to read a CSV file into a file geodatabase. Then, I want to read this imported file and work on it by adding new fields and calculating values. However, while using the arcpy.ListTables() on the geodatabase does not list the table.

I am just confused what is wrong.

Any help !!

Here is my script-------------------------
outLocation = dbLoc+'\\'+ out_name +'.gdb'
arcpy.env.workspace = where_tables_are # the folder where your tables are

# Make list of all tables in workspace
tables = arcpy.ListTables("GDB*")

print tables
try:

    for tb in tables:
    # Execute TableToGeodatabase
        print "Importing "+tb+ " to gdb: " + outLocation
        arcpy.TableToGeodatabase_conversion(tables, outLocation)

env.workspace = os.path.dirname(os.path.dirname(__file__))+'\\'+ out_name +'.gdb'
arcpy.RefreshCatalog(env.workspace)

inTables = arcpy.ListTables()

This should work:

import arcpy
import os

inWS = r'H:\Documents' #the directory that contains the .csv files
outGDB = r'H:\Documents\ArcGIS\Default.gdb' #the output Geodatabase

arcpy.env.workspace = inWS
csvlist = arcpy.ListFiles('*.csv')
print csvlist
for csvfile in csvlist:
   csvname = os.path.splitext(csvfile)[0] 
   print "converting " + str(csvname)
   arcpy.TableToTable_conversion(csvfile, outGDB, csvname + '_tab')

Edit: To list the imported tables you just need to set the correct workspace


arcpy.env.workspace = outGDB
tables = arcpy.ListTables("*_tab")
for table in tables:
    print table
    #do the rest of the work here

topic Issues Reading a table from Geodatabase in Python Questions

Issues Reading a table from Geodatabase

Re: Issues Reading a table from Geodatabase