nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy.Describe(relationshipclass) doesn't include key fields.

MichaelAdornetto

I'm attempting to write a script to read the relationship classes from one geodatabase to another. These tables have identical feature and object classes.

I should be able to select the relationshipclass in the source, use arcpy.Describe on them and get the parameter I'll need to perform an arcpy.createRelationshipClass_management. Except the describe does not give me any access Primary / Foreign key information according to the documentation. Is there away to get these field names because without it I can't recreate the relationship class.

Vind meer berichten getagd met

Accepted answers

All comments

ChrisDiMeo

Hi -

Bumping this thread with a related question.

I'm trying to automate creating relationship classes in python (ArcGIS 10.2.1). I am able to get most of the information I need via the Describe call as shown in previous posts. I'd like to get the properties of existing RC's and automate recreating them using the original properties (copy/paste of data not an option).

My issue is that I'm not able to return the Relationship Rules (eg. desc.relationshipRules) as decribed here:

RelationshipClass properties—Help | ArcGIS for Desktop

The documentation is at 10.3 and I am working at 10.2

You can see below that I'm able to return all the properties available for this particular rel class except the Relationship Rules, which, I know exist (also see below).

Has anyone tried to return these relationship rules? Tried to recreate via python? Any success?

Thanks,

Chris

JillianPenney

At 10.2.1 release, it will be possible to obtain the origin and destination class keys via python using the Describe function.

You can use:

arcpy.Describe(<relationshipclass>).OriginClassKeys  or
arcpy.Describe(<relationshipclass>).DestinationClassKeys

The result returned will look something like this:

[(u'OBJECTID', u'OriginPrimary', u''), (u'ParcelID', u'OriginForeign', u'')]
[(u'id', u'DestinationPrimary', u''), (u'RenterID', u'DestinationForeign', u'')]

Hope this helps!

JamesCrandall

I know this is an old thread, but can anyone provide an updated status on this "enhancement"? NIM048192

I'm trying to write a python script that copies feature classes and relationships across from one GDB to another. But without access to the KEY fields on the relationship, I can't recreate the relates...

Have you reviewed any of these?

http://forums.arcgis.com/threads/64318-Detect-Relationship-in-Feature-Class-or-Table
http://gis.stackexchange.com/questions/50846/copy-two-datasets-that-particpate-in-the-same-relationship-class
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000015s000000

JeffButurff

GSCUser85, thanks for the response. However, if you look closely at the docs, you'll notice the most important piece of a relationship class is missing: the key fields. We need the key fields for both primary and foreign keys.

NeilAyres

Doesn't this give you the functionality you are looking for...
arcpy describe relationshipclass properties
http://resources.arcgis.com/en/help/main/10.2/#/RelationshipClass_properties/018v0000002n000000/
Cheers,
N

JeffButurff

Nope, never found a solution. As far as I know, it's still an "enhancement request".

Haven't tested at 10.2, so I don't know if it's been fixed there.

brettangel

Did anybody ever find a solution to this?

JeffButurff

I know this is an old thread, but can anyone provide an updated status on this "enhancement"? NIM048192

I'm trying to write a python script that copies feature classes and relationships across from one GDB to another. But without access to the KEY fields on the relationship, I can't recreate the relates...

JohnGravois

Currently Python does not have access to the following relationship class properties

OriginPrimaryKey
OriginForeignKey
DestinationPrimaryKey
DestinationForeignKey

The tracking number of this enhancement is [NIM048192 access to relationship class key properties in Python]. The status of the enhancement is currently "deferred", which means our development team will reconsider implementing it in our next major release. Please contact Esri Technical Support for more information or to add your name to the list of customers requesting this functionality.

HenryColomb

Hello Michael
I am working on the same thing and encountered the same problem. If you figure it out please post your solution as will I. This is not the first time Ive started out with python for a task and had to go back to ArcObjects.
Henry

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.