• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

Is there a way to generate an SQL schema automatically from a given Google Form?

 
Ranch Hand
Posts: 60
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So I got this project that i need to start working on where they need better control and filtering of their answers on Google Forms, so I want all of the submissions to be saved in a DB. My initial worry from the start is that the database is gonna be really hard to set up. There are like 25 pages of it with 4-5 answers on each page. It's about documenting cases of violence. Any ideas would be much appreciated.

Long time no see guys I passed my OCA btw <3
 
Saloon Keeper
Posts: 22784
153
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good question. Google Forms data can definitely be posted into a database, but I'm not sure what tools are available off-the-shelf for constructing a SQL schema for them.

Traditionally, I'd scrape the form page HTML with a Perl or Python script and generate my own SQL if nothing else was available. The downside of this with HTML4 is that HTML doesn't allow much knowledge about what the best column type to define would be so I'd be assuming that almost everything was text and have to manually tweak it. HTML5 is a little more fine-grained, so that might help. Cases where the data types are defined via JavaScript field validation would be a problem, regardless.
 
Darko Jakimovski
Ranch Hand
Posts: 60
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Either way there is a lot of manual labor involved I guess... In each case I'll have to manually map the values with types or get them as Strings and parse them when getting them back which would slow down the process. Sigh...
 
The airline is called "Virgin"? Don't you want a plane to go all the way? This tiny ad will go all the way:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic