topic Re: arcpy.ParseTableName returning null in Python Questions

arcpy.ParseTableName returning null

deleted-user-tmoWMkOb1VrD — Wed, 03 Sep 2014 11:11:26 GMT

I have this very simpel script

import arcpy, os

from arcpy import env

adr =r"\\gisbatch\servere\GIS-DB\GISEDIT\ADRESSE@GISEDIT.sde\GISDIST.ADRESSE.ENHED_ADR_BBR"

env.workspace = os.path.dirname(adr)

print arcpy.ParseTableName(os.path.basename(adr))

I had expected this reply "GISDIST, ADRESSE, ENHED_ADR_BBR"

But I get this "(null), (null), GISDIST.ADRESSE.ENHED_ADR_BBR"

What do I do wrong or if then, what is the purpose with the tool.

Thanks

Sebastian

Re: arcpy.ParseTableName returning null

DanPatterson_Retired — Wed, 03 Sep 2014 12:28:52 GMT

don't you just want to use the os stuff instead?

>>> import os
>>> adr =r"\\gisbatch\servere\GIS-DB\GISEDIT\ADRESSE@GISEDIT.sde\GISDIST.ADRESSE.ENHED_ADR_BBR"
>>> adr
'\\\\gisbatch\\servere\\GIS-DB\\GISEDIT\\ADRESSE@GISEDIT.sde\\GISDIST.ADRESSE.ENHED_ADR_BBR'
>>> x = os.path.basename(adr)
>>> x
'GISDIST.ADRESSE.ENHED_ADR_BBR'
>>> y = os.path.dirname(adr)
>>> y
'\\\\gisbatch\\servere\\GIS-DB\\GISEDIT\\ADRESSE@GISEDIT.sde'
>>>

Re: arcpy.ParseTableName returning null

NaimeCelik — Wed, 03 Sep 2014 13:03:09 GMT

I think problem is related to your "adr" path , I tried one of my sde connection and it works. Try to copy your path location from catalog location after browsing your path.