Skip to main content
Solved

How to get file geotabase includes subtypes


gogopotter90
Contributor
Forum|alt.badge.img+13

Hello ,

i have xml document schema ,that includes subtypes .I have exported it from arc catalog

 

in FME my input is arcsde ,i have used quick translator to convert it from arcsde to file geodatabase ,in configure parameters I have used the schema xml

I have read in article this is the way to get subtypes in file geodatabase to use schema xml .

But after checking the file geodatabase by ArcGis pro ,does not include any subtype .

 

How could I get file geodatabase include subtypes ?

FME 2021

Best answer by nielsgerrits

gogopotter90 wrote:

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?

Ok, I tried:

  • Exported an XML from SDE using ArcGIS Pro. Selected one FeatureClass I knew it had SubTypes configured. Choose for Schema Only. (No data.)
  • I checked the XML in Notepad++ and found the subtypes.
  • Created a new GDB using ArcGIS Pro.
  • Imported the XML in the GDB using ArcGIS Pro.
  • Checked the GDB using ArcGIS Pro. I now see the exported FeatureClass with the subtypes as it used to be in SDE.
  • Created a GDB using FME, under parameters "Import XML Workspace Document (Schema Only)" I selected the XML file.
  • Checked the GDB in ArcGIS Pro, I now see the dummy table I created from FME and the empty FeatureClass with subtypes from the XML.

 

For me this works, and it works as expected I think. Versions are FME Desktop 2021.2.6 and ArcGIS Pro 2.9.6.

View original
Did this help you find an answer to your question?

6 replies

nielsgerrits
VIP

I do not have the time to replicate it at this moment, but I believe this is the way it should work.


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

I do not have the time to replicate it at this moment, but I believe this is the way it should work.

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?


nielsgerrits
VIP
gogopotter90 wrote:

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?

What I would try:

  • Check if the XML document schema from SDE has the subtypes in it, using Notepad++. Just to be sure.
  • Export the FeatureClasses from SDE to a new GDB using ArcGIS Pro.
  • Check if the GDB has got the subtypes as well using ArcGIS Pro.
  • Export a XML document schema from the GDB using ArcGIS Pro.
  • Check if the XML document schema from the GDB has the subtypes in it, using Notepad++.
  • Use the XML document schema from the GDB to create a new GDB using FME.
  • As an alternative, if the exported GDB has the subtypes, empty the FeatureClass(es) and use that one as a template GDB in the writer.

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

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?

thanks for reply ,

i have checked xml schema and it contains subtypes .

to understand clearly ,

if the schema xml that i have exported from arc catalog for 100 feature classes and I have chosen from input arcsde parameter tables 70 feature class to read .

will be okey ? Or should I choose the same tables as in schema .

i am trying to understand ,why it did not write into file geodatabase with subtype ,to fix it .

 


nielsgerrits
VIP
gogopotter90 wrote:

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?

I think so. If you create a GDB from the XML it should just create an empty shell.

 

I would first try and create a new GDB from the XML using ArcGIS Pro. If it works in the native software, then try it using FME.


nielsgerrits
VIP
  • Best Answer
  • June 23, 2023
gogopotter90 wrote:

Do u have sample workspace ?

i have checked my output ,and i did not find any subtypes .

Do u have any idea else to do ?

Ok, I tried:

  • Exported an XML from SDE using ArcGIS Pro. Selected one FeatureClass I knew it had SubTypes configured. Choose for Schema Only. (No data.)
  • I checked the XML in Notepad++ and found the subtypes.
  • Created a new GDB using ArcGIS Pro.
  • Imported the XML in the GDB using ArcGIS Pro.
  • Checked the GDB using ArcGIS Pro. I now see the exported FeatureClass with the subtypes as it used to be in SDE.
  • Created a GDB using FME, under parameters "Import XML Workspace Document (Schema Only)" I selected the XML file.
  • Checked the GDB in ArcGIS Pro, I now see the dummy table I created from FME and the empty FeatureClass with subtypes from the XML.

 

For me this works, and it works as expected I think. Versions are FME Desktop 2021.2.6 and ArcGIS Pro 2.9.6.


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