Using MakeParcelFabricTableView to get the JobObjects table?

DanNarsavage — Thu, 03 Feb 2011 13:40:10 GMT

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

Re: Using MakeParcelFabricTableView to get the JobObjects table?

DanNarsavage — Sat, 11 Dec 2021 20:34:29 GMT

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).

topic Re: Using MakeParcelFabricTableView to get the JobObjects table? in Geoprocessing Questions

Using MakeParcelFabricTableView to get the JobObjects table?

Re: Using MakeParcelFabricTableView to get the JobObjects table?