Select to view content in your preferred language

Batch Generate Schema Report

739
7
06-14-2024 02:36 PM
Labels (1)
ReeceVydrzal1
New Contributor

Hey, 

I have a very large arcgis online webmap that has been developed and refined over the course of the last couple of years. I am wanting to get the schema for these various different features into an excel sheet. 

 

The 'Generate Schema Report' tool when used on a single feature is able to output exactly what I am looking for in an appropriate format when cleaned up a little bit. 

 

Is there a way that I can use this on more than one feature at a time and to have it output a single excel sheet summarizing the entirety of my project. In a vein attempt to make this work I tried doing a batch version of the tool, but it was only able to output a table for a single feature.

Tags (1)
0 Kudos
7 Replies
Robert_LeClair
Esri Esteemed Contributor

So even though the Generate Schema Report GP tool parameter says - Input Dataset - it will take an entire geodatabase and generate the report for EVERYTHING in that GDB.  I tested this where I selected Demo.gdb as the input dataset and generated a pdf with the full report.  

0 Kudos
LauraleeGann25
Emerging Contributor

Good morning Robert,

Are there any means to get a Schema Report from an UNregistered, non-eGDB, just a plain FGDB--I see in the notes that it has to be registered and that has changed recently, as a few months ago, it would work on unregistered FGDB, just looking for a means out side a  registed eGDB

0 Kudos
Robert_LeClair
Esri Esteemed Contributor

Good afternoon Lauralee!  So I examined the help documentation back to ArcGIS Pro 3.2 and the pages say that the datasets must be registered with the geodatabase.  So I don't think there's been a change recently in the code.

There's a great blog article here that discusses the Generate Schema Report GP tool.  I see that you found the Esri Community Data Management page that discusses this as well and asked Jonathan for the information referenced in your response here.  I'd be curious to hear what Jonathan says.

AyanPalit
Esri Regular Contributor

@LauraleeGann25 Generate Schema Report GP tool  supports a file geodatabase (FGDB) input in addition to enterprise geodatabase (EGDB). I am unsure what you mean by registered vs. unregistered.

Ayan Palit | Principal Consultant Esri
0 Kudos
LauraleeGann25
Emerging Contributor

Capture.PNG

@AyanPalit  @Robert_LeClair Thank you both and I do look forward to someone figuring out why it can only be run on basically an eGDB, when just a few weeks ago you could run the tool on any data, so it's odd that this would be required or need to be registered, Everyone needs a report like this it is only sensible, so I look forward to when the developers "Release" the tool for the GREATER GOOD🌏🌎🌍

0 Kudos
Robert_LeClair
Esri Esteemed Contributor

@LauraleeGann25 - so I can confirm that the Generate Schema Report does work on a fGDB as I just ran it without any issues.  See images below.  The item "datasets must be registered with the geodatabase" only applies to eGDB's and not fGDB's.  In eGDB's, when a dataset is registered with the geodatabase, this stores information about the items in the repository system tables.  My guess is that help documentation for this item could be improved.  Question - are you not able to run the GP tool on your fGDB?  If it does not run, then maybe you need to upgrade the fGDB to the current release.

SchemaReport.JPGSchemaReport2.JPG

0 Kudos
AyanPalit
Esri Regular Contributor

@LauraleeGann25 Thanks for referencing the Generate Schema Report documentation. Note the following:

  • This tool can be run on a workspace (file, mobile, and enterprise), feature class, feature dataset, feature layer, and feature service.

Have you tried a FGDB as input dataset and tool failed or errored? If so, post the error. As posted by @Robert_LeClair  and myself, we have run the tool on FGDB with a schema report output.

Ayan Palit | Principal Consultant Esri
0 Kudos