topic Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why? in Python Snippets Questions

arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

GauriDeshmukh — Sun, 12 Dec 2021 10:13:24 GMT

Hello all,

My python script runs well and returns all tables from mdb with arcpy.ListTables() command when i run a script in IDLE(default IDE) or python window from arcmap. But when I try to run the same script from cmd arcpy.ListTables() returns blank list []. What could be the problem?And what is the solution? As I am calling this script in my C# desktop application.

import xlrd
import datetime
import os
import sys
#sys.path.append("C:\Program Files\ArcGIS\Desktop10.0\arcpy")
import arcpy


#arcpy.ResetEnvironments()
arcpy.env.workspace = r"D:/Final/gdb_workspace/New Personal Geodatabase.mdb"
#Get and print a list of tables
tables = arcpy.ListTables()
print tables
for table in tables:
    print table

This is my simple code to list tables.I want to insert data from excel file to a particular table from this personal gdb.

When I run this script using cmd(out of arcgis environment) its not returning tables.

Is this possible to achieve and how? Or do I need to use any geoprocessing service?Any other way to achieve this?

I am able to insert data into mdb if i run the script in IDLE or python window from arcmap.

Please tell me the right way to do this task.

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

DanPatterson_Retired — Mon, 22 Dec 2014 11:19:13 GMT

import arcpy

arcpy is know to exist from python within arcmap, but not outside of it. it needs to be imported in most languages (ie python running outside of arcmap, or separately from it)

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

GauriDeshmukh — Mon, 22 Dec 2014 12:24:27 GMT

Yes I have already included import arcpy.

Its not working in when i run script from command prompt.

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

JoshuaBixby — Mon, 22 Dec 2014 14:54:05 GMT

How are you setting the workspace environment? Can you post the functional part of the code that isn't working?

Do you have more than 1 Python install on the machine?

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

MichaelVolz — Mon, 22 Dec 2014 15:04:31 GMT

Gauri:

Are you running this script in a 64-bit environment?

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

GauriDeshmukh — Tue, 23 Dec 2014 05:33:12 GMT

I have posted the functional part which is not working. I have only 1 python installed on my machine. python 2.6 for arcgis 10.0

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

GauriDeshmukh — Tue, 23 Dec 2014 05:35:09 GMT

I am having 32 bit.

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

DanPatterson_Retired — Tue, 23 Dec 2014 06:47:43 GMT

probably has no effect but worth checking

r"D:/Final/gdb_workspace/New Personal Geodatabase.mdb" raw notation is used when paths have backslashes and not foreslashes

table@@ I am not farmiliar with @@ is that a substitute for printing its name?

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

GauriDeshmukh — Tue, 23 Dec 2014 09:49:58 GMT

sorry its variable table only.

I tried by all way.. i.e. with r without r. I tried giving path in different way.but not working in cmd.

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

JoshuaBixby — Tue, 06 Jan 2015 03:36:46 GMT

Are you sure the script is running at all when called from the command line by your other program? If you try printing 'hello world' from the script, does that even work from the command line?

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

RichelleSpry — Fri, 13 Mar 2015 07:05:45 GMT

This might not fix your problem since you are on version 10, but this was my resolution to the same issue.

I have ArcGIS 10.2.2 and Python 2.7, and in C:\Python27\ I have ArcGIS10.2 (32bit) and ArcGISx6410.2 (64bit). I believe they are both included in the standard install. I cannot say for 32bit machines, but the default idle in the start menu is set to C:\Python27\ArcGISx6410.2 .

I ran the code in 32bit cmd (C:\Python27\ArcGIS10.2\python.exe) and arcpy.ListTables() worked, but didn't in 32bit Idle (C:\Python27\ArcGIS10.2\Lib\idlelib\idle.pyw ). I had a look at the path browser in the 32bit Idle and it's referencing a lot of files from the ArcGISx6410.2 folder (C:\Python27\ArcGISx6410.2\).

You might want to try re-running the code directly from 32bit cmd (C:\Python27\ArcGIS10.2\python.exe) and see how you go.

I am working in Visual Studio, so once I changed my default environment from ArcGISx6410.2 to ArcGIS10.2, arcpy.ListTables() worked.

Again, this might not fix your issue, and this post is a few months old, but might give you an idea that might. Good luck!

*note replace 10.2 references for 10

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

JoshuaBixby — Fri, 13 Mar 2015 14:12:34 GMT

If you have the C:\Python27\ArcGISx6410.2 directory on your machine, then you installed 64-bit Background Geoprocessing (not part of the standard installation) or ArcGIS for Server. Assuming the latter isn't the case, the former is what put the extra Python interpreter installation on your machine.

With regard to the OP's situation, 64-bit Background Geooprocessing wasn't introduced until ArcGIS 10.1 SP1. That said, the information provided is useful for others that install 64-bit Background Geoprocessing and get confused over which Python interpreter they are using when.

Re: arcpy.ListTables() doesnt work in cmd but works in IDLE or arcmap python window,why?

RichelleSpry — Fri, 13 Mar 2015 21:32:56 GMT

To be honest I couldn't remember if it was apart of the standard install or the 64-bit Background Geoprocessing. I did check before my post with a team member who I thought didn't have it installed, but this proves she did. Thanks for clarifying this Joshua.