Retrieving information from database or google docs

mlapl1
Community Member Posts: 350 ♪ Opening Act ♪
Comments
-
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). -
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
Categories
- 35.9K All Categories
- 109 ✫ Announcements
- 33.1K Lectora®
- 31.1K Lectora Discussions
- 28.9K Lectora Desktop
- 2K Lectora Online
- 2K Lectora Feature Requests
- 71 Lectora User Groups
- 36 Lectora Accessibility User Group (LAUG)
- 22 ELB Learning Content
- 22 ELB Learning Content Discussions
- 324 CenarioVR®
- 191 CenarioVR Discussions
- 133 CenarioVR Feature Requests
- 41 Rockstar Learning Platform®
- 38 Rockstar Learning Platform Discussions
- 108 CourseMill®
- 108 CourseMill Discussions
- 47 ReviewLink®
- 47 ReviewLink Discussions
- 7 The Training Arcade®
- 7 The Training Arcade Discussions
- 934 All Things eLearning
- 36 eLearning Development
- 546 Learning Management System (LMS) Integration
- 332 Web Accessibility
- 1.2K ♪ The Green Room
- 9 Additional Learning Products