Retrieving information from database or google docs

mlapl1

Hello,

Sorry for what is probably very simple, but I cannot find a solution.

It is easy enough to save a form to google docs or a database. BUT... how does one retrieve information from a database or google docs?

Thanks for any help.

Andrew

ssneg

Reading almost as easy as writing. You will need a tiny bit of JavaScript to utilize Google Apps API: https://developers.google.com/google-apps/spreadsheets/. For some reason, Google does not publish a JS library for accessing API, so someone wrote one here (https://github.com/mikeymckay/google-spreadsheet-javascript). It might need a little updating but it is under 120 lines of code anyway, so not a big deal.

Please keep in mind that the spreadsheet has to be published. Accessing data with Google user authentication is much more cumbersome (and requires your learners to have Google apps accounts).

mlapl1

Thank you Sergey. Is there the equivalent for accessing a standard database, e.g. mysql?

Andrew

ssneg

Just as in case with Google Spreadsheets, Lectora provides interface for submitting data to a server-side script but not for writing. To access a database, you need three components:
- JS script in Lectora to call on a server-side script
- server-side script (in PHP, Perl, Ruby, ASP, server-side JS, etc) to read/write to database
- the database written in MySQL or any other kind

mlapl1

OK... thanks a lot Sergey.