Hi everyone, I want to create a Esri Personal Geodatabase whose structure is specified in an Excel table. Is that possible? How can I achieve that?
Solved
How to create a Esri Personal Geodatabase whose structure is specified in an Excel table? ?
+1- Contributor
Best answer by nielsgerrits
This is not a standard functionality, but it is possible to build something like this.
I also have seen something like this on the FME Hub.
https://hub.safe.com/?page=1&page_size=10&order=relevance&query=gdb%20excel
The default solution would be to use an XML workspace document to use as input.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+62- Best Answer
This is not a standard functionality, but it is possible to build something like this.
I also have seen something like this on the FME Hub.
https://hub.safe.com/?page=1&page_size=10&order=relevance&query=gdb%20excel
The default solution would be to use an XML workspace document to use as input.
Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
If you already have an ArcGIS product installed, a solution could be to parse the Excel information into a single feature and send it off to a PythonCaller that uses ArcPy methods to create the database, using e.g.
- https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-file-gdb.htm
- https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-feature-class.htm
An alternative could be to create an FME schema feature from the Excel and send it to a regular writer together with your data. You can find some information about his here: https://support.safe.com/hc/en-us/articles/25407525774221-Dynamic-Workflows-Advanced-Example-Modifying-the-Schema-Feature
+23- Influencer
I do this.As
There are certain things I use FME for, and others I use ArcPy (but all built into one workspace).
I create gdb and add domains with arcpy, and then create the featureclasses with FME (featureclasses and fields/alias/type), and back to arcpy to associate domains and create indexes.
You can do most of it in FME, but I also wanted to be able to add fields, domains, indexes etc over time due to the ever changing nature of what we built this process for, and all the surrounding processes that support and build upon this. So I used arcpy to meet those needs.
Here is an example of one of the many sheets contains alias, field name, domain association, type and indexes:
+1- Contributor
This is not a standard functionality, but it is possible to build something like this.
I also have seen something like this on the FME Hub.
https://hub.safe.com/?page=1&page_size=10&order=relevance&query=gdb%20excel
The default solution would be to use an XML workspace document to use as input.
Thank you so much for your advice, the custom workspace mentioned above seem to be exactly what I want and for sure it will take some time to check for that.