Forum Discussion

BastiaanTimmer's avatar
BastiaanTimmer
Partner
10 years ago

Articulate Storyline: Export to Google Drive

PREVIEW  |  SOURCE On the Articulate user days in Utrecht (2015), we held a session about exporting Articulate Storyline variables to Google Drive (Spreadsheet). This export is achieved via...
storyline 360
BastiaanTimmer's avatar
BastiaanTimmer
Partner
8 years ago

Hi Alison,

Thanks for your reply. In this example the variables will be send to the spreadsheet when you fire the following JavaScript code:

//DELAY SO JQUERY LIBRARY IS LOADED
setTimeout(function (){
 
//Export to Google
$.ajax({
url: WEB_APP_URL,
type: "POST",
data : storyline,
success: function(data)
{
console.log(data);
},
error: function(err) {
console.log('Error:', err);
}
});
return false;
}, 1000);

Note: It will always create an extra spreadsheet row, with the information of the variables.

If you got multiple variables, and you would like to submit them separately, then you will get multiple rows for one particular user. It won't update the existing record.

So this solution won't be the best solution for you.

Maybe someone else knows another script to update an existing record. In this case, you can send multiple variables to the spreadsheet and it will update the existing record of this specific user. Otherwise you will have to make a filter within the spreadsheet to find all the details of one user.

  • AlisonGretchenS's avatar
    AlisonGretchenS
    Community Member
    8 years ago

    Thanks Bastiaan,

    I agree, and I understand everything you've mentioned.

    My scenario is this, we run our storyline workshops/"outputs" on a LMS (Blackboard), but sometimes our students get "kicked" out of Blackboard before they finish the workshop. Since the example code only appears at the end of a workshop, the code cannot execute and I do not know (cannot track) where they were within the workshop.

    So, basically I am looking for a way for the information to be sent to the spreadsheet within certain time intervals? So yes, I'm looking for some script to update an existing record every few minutes.

    Anyone??

Related Content