I am being asked to come up with a solution that allows a user to set queries on a feature class and related tables from an app or widget and then export the results to an excel sheet. They want the records to be joined so they appear as one line item based on their common ID instead of separate tables. I can come up with the python to join and filter the tables, as well as export the results. The issue is, the users want to run this themselves and aren't familiar with python. My question is, does anyone have a suggestion for the user interface? Is it possible to pass their selections to the python script from an html page?
Solved! Go to Solution.
If not, Flask is probably what you want.
Create a simple HTML Page/Form and use your Python as the SUBMIT handler --
Here is one of many hits from a simple google search to get you started --
https://www.tutorialspoint.com/How-to-process-a-simple-form-data-using-Python-CGI-script
Thank you, I think this will work for me. I'm going to give it a shot.
Do the users have ArcGIS Pro installed?
I think my main user has it installed but doesn't use it.
You could create a script tool or Python toolbox that runs inside ArcGIS Pro. Both give you a simple user interface and custom messaging.
I actually proposed that idea to my boss, but it was turned down. I may try to push it again because I do think it is an easier option and the end user can be trained on it.
If not, Flask is probably what you want.
Sorry, I don't understand your question as it pertains to this thread.
I'm working on a Flask app now to test on dummy data, and it seems to do what I need. This will be the solution once I get it working on real data.