Originally Posted by jhc811
I am wondering if new site will have big improvement with PDGA course database? PDGA course database really need to support multiple layouts for each course download. For example, in my local course, it has two tee pads and three basket pins which is 6 different layouts so I would love to be able to download that course which will include 6 diff layouts (which translate into 6 different "courses" in eye of PDGA app view in this current setup).
Right now I had to create 6 diff layouts with pars and feet via "Create Locally' feature which is pain in the butt.
I was wondering if anyone did create some tools that automatically import scorecard data via email into say excel or/and SQL database?
Once PDGA app can download a course data with multiple layouts and some tools that allows automatic importing of scorecard data into excel/database then it would be great for paper-less league (as well tournament) rounds where at the end of round, the players can simply email the scorecard data and the league director would be able to view all scorecard data in excel/database at glance and can easily sort them and hand out the prizes on spot and have those results ready for view on WWW/Facebook etc.
That would help encourage the growth of actual PDGA leagues which is win-win for everybody involved.
We have the implementation of course layouts in our feature list, and it has been, for the website, for years (literally). It's a big project though, because in additional to significant changes to the database model (tables and fields), we need to have governance around data quality. Course layouts change regularly, and if we don't have a simple way to submit changes and report discrepancies, it will be easy to have the layout data be out of sync with the actual layouts.
Our ideal vision is to have the mobile app be able to collect the information via location services (i.e., GPS) and upload it directly. However, there needs to be some way to validate the data, so that it doesn't get corrupted through accidental OR malicious updates.