Community
Select to view content in your preferred language

Using MakeParcelFabricTableView to get the JobObjects table?

791
1
02-03-2011 05:40 AM
DanNarsavage
by
Frequent Contributor
‎02-03-2011 05:40 AM
I'm writing a Python script and I need to find all of the parcels that were edited in a particular job (in case it makes any difference, the job will always have been committed before I perform this task).  I'd planned on using the "MakeParcelFabricTableView_fabric()" GP tool, but it doesn't appear that that tool will get me to the JobObjects table.  Am I going to have to open a separate ODBC connection to our database just to get this table, or is there a way to get there using the GP tools that I've missed?  Alternatively, is there another place that I can get a list of parcels in a job?

Your pal,
Dan
0 Kudos
1 Reply
DanNarsavage
by
Frequent Contributor
‎02-03-2011 06:50 AM
For that matter, has anyone successfully run the "MakeParcelFabricTableView" tool in Python at all?  I just created & successfully ran a model using that tool, but exported that model to a python script and got an error.

Python code exported from successful model:
# ---------------------------------------------------------------------------
# fug.py
# Created on: 2011-02-03 08:28:07.00000
#   (generated by ArcGIS/ModelBuilder)
# Description: 
# ---------------------------------------------------------------------------

# Import arcpy module
import arcpy


# Local variables:
Basemap_DBO_Fabric = "Database Connections\\DefaultOnBasemap.sde\\Basemap.DBO.ParcelFabric\\Basemap.DBO.Fabric"
FabricTable_View = "FabricTable_View"
jobs = "C:\\Dan\\TurdPolishing.gdb\\jobs2"

# Process: Make Parcel Fabric Table View
arcpy.MakeParcelFabricTableView_fabric(Basemap_DBO_Fabric, "Jobs", FabricTable_View)

# Process: Copy Rows
arcpy.CopyRows_management(FabricTable_View, jobs, "")


Error message received when the above code was run:
Traceback (most recent call last):
  File "R:\DanN\b4after\fug.py", line 18, in <module>
    arcpy.MakeParcelFabricTableView_fabric(Basemap_DBO_Fabric, "Jobs", FabricTable_View)
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\fabric.py", line 250, in MakeParcelFabricTableView
    raise e
arcgisscripting.ExecuteError: ERROR 999999: Error executing function.
Failed to execute (MakeParcelFabricTableView).
0 Kudos