Skip to main content
Question

How to check if the data is arcfm or Esri objects From database ?


gogopotter90
Contributor
Forum|alt.badge.img+13

hello ,

i would like to know if all my data are Esri objects or not

How could I do that ?

i am using oracle developer , and FME 2021

8 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

Not sure what you are asking. How to distinguish one from the other?


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • July 8, 2023
nielsgerrits wrote:

Not sure what you are asking. How to distinguish one from the other?

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use


nielsgerrits
VIP
Forum|alt.badge.img+54
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

I'm sorry but I'm really lost what you are trying to ask. You have to elaborate a more what you have and what you are trying to achieve.

 

What kind of database are you talking about. Is this Esri SDE?


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • July 10, 2023
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

Thanks for reply .

we have migrated the data from arcfm to Esri object .

i would like to ask,if all data successfully converted to Esri object or we have missed sth.

or May be something called class extenstion still relates to arcfm.

i want to check my data ,

i am using oracle sql developer ,i have read that I can know the type of object by getting GUID .so I got it already ,but I am not sure how to continue .

the database is oracle and there is Arcsde esri .

i need to discover which class extension still arcfm

if u have any idea let me know ?

 

i hope , it is more clear nw and thanks for help


nielsgerrits
VIP
Forum|alt.badge.img+54
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

If you have GUID's in both ArcFM and Esri Object ( I don't know what this is) you can load both sources in FME and see if the GUID from ArcFm exist in Esri Object. This can be done using various transformers, but the ChangeDetector is one of them.


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • July 10, 2023
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

https://myarcfm.schneider-electric.com/myarcfm/s/article/How-To-ArcFM-How-to-Get-Object-Type-GUIDs-in-10-x-Geodatabases

could u check this link ?

i got GUID id ,but I need to know the matching table for each id to know if it is arcfm or Esri object ,

at this link ,they write some GUID id but it is not the same that I have


nielsgerrits
VIP
Forum|alt.badge.img+54
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

If the GUID's you get using the scripts differ from the GUID's they described, I think you should ask the people at ArcFM, not at Safe, what is wrong?

 

What are the GUID's you are getting?


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • July 11, 2023
gogopotter90 wrote:

I mean , i have found UUID in sql developer for different feature classes and tables .

each uuid has value looks like this {———}

is there a table to tell me ,if the id value as … so it is Esri object or sth else .

is there any matching table that I could use

Thanks ,I will ask them


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings