Batch Generate Schema Report

[ReeceVydrzal1]

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.

[Robert_LeClair]

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.  

[LauraleeGann25]

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

[Robert_LeClair]

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]

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

[LauraleeGann25]

@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🌏🌎🌍

[Robert_LeClair]

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

[AyanPalit]

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

[AyanPalit]

@ReeceVydrzal1 Curious if you tried a FGDB as input dataset and tool failed or errored? If so, post the error. If you found a solution, please post for Esri Community users.