exporting variables to be read in a Google docs spreadsheet

I would also like to try this...have you found a solution?

Myself and a (very) technical colleague are doing these sorts of things to help with this issue - exporting the values of variables so that you can work with them offline (in a spreadsheet if you wish), and also if you need to, filling Storyline variables with data from external sources.

Send a private message if you want to discuss it in more detail.

John.a.

Dorothy,

Did you ever get a solution to this? It would be great to see the solution listed on this page. Several colleagues and I are all trying to do what you described.

Thanks!

Ben

Sorry, Ben.  I stopped using Storyline last spring because I couldn't stop the "low memory" error, so I never pursued this question.  You might check with John Faulkes (above) and then post what you find out.  I'd still be interested in case I get back to SL.

Dorothy

Sending data from Storyline using variables to a Google spreadsheet can be done...and quite effectively, too. I just finished a project doing this very thing.

First is setting up a Google Script. In Storyline you'll need to write a Javascript that will read all the variables and fire the data off. In our project we had over 50 questions each with 3 possible choices. We wanted to see the result (choice1, choice2, or chioce3) for each of the questions. 

The neat thing is the Google Spreadsheet would update dynamically. We tested several outputs including a stand alone Storyline output on a web server, Storyline published as SCORM on an LMS, Storyline published for AO, and Storyline as a web object in a Studio '09 output in both SCORM and AO. Same project all sending data to the same spreadsheet while multiple users were accessing the various platforms and being able to literally watch the spreadsheet as it fills up. 

Hi Ben! It looks like Kevin is helping you out here, but I wanted to pop in and welcome you to E-Learning Heroes

I'm being asked to show a non-LMS method to gather gather data from Storyline courses on learner progress (something that gives us more data than Google Analytics, which would only look at the page where the SL "object" is contained).

I'd like to implement one of these "non-LMS" methods to capture some data. Right now I just need to show something to mgmt like a proof-of-concept. My thought is to just have a couple of variables for a small section of a course...."slide1complete" to "slideNcomplete" and then a "Section1complete"...all set as booleans and the triggers to mod them to Y once the timeline for that slide (or last slide) completed.

I understand the create vars in SL, probably some javascript in user.js, and the google spreadsheet that contains a script to get the vars and print them.

Does anyone have anything like this already minimally completed that I could repurpose? Or someplace where the entire process is documented cradle-to-grave (I've read the referenced blog posts in the forum posts here that discuss the process but in order to "beat the clock" I need something that I can mockup quickly).

thanks,

John 

Hi everyone,

My solutions for this is here.

Helpful link to do this solve in Storyline is here. You will find there solution to send date from html form to google spreadsheet.

To implemnt this in Storyline you will need this link.

I hope it's helpful.

Thanks for sharing your solution Andrzej!

Brilliant solution and thanks for sharing Andrzej.

Unfortunetly the second link is not working for me. Could you please try repost it?

I am desperately trying to accomplish the same solution whcih you have.

Thanks