exporting variables to be read in a Google docs spreadsheet

Hi all -

First of all - thanks for the discussion! Like many others, I'm not a coder so it is inspiring to see how many people are working together to build a solution to this problem.

I've had a lot of help from Tracy - her tutorial is amazing! - but am still having trouble implementing a solution.... I'd really appreciate any advice that could be given for my 1 variable, test Articulate course...

Thanks again!

Jane James

Link to hosted articulate course

https://googledrive.com/host/0B82TWSb7pI3wQ2dkWlMyT2lBSGs

Link to survey form

- https://docs.google.com/forms/d/1c9OZMa1hFuM39FqwU7dz-1GzSXrcdbjCD59Ldnbcx4o/viewform?usp=send_form

Link to articulate course

https://drive.google.com/open?id=0B82TWSb7pI3wSkZTVEhpcTlLR2M

Text of the javascript program

var player = GetPlayer();

$.ajax({

url: “https://docs.google.com/forms/d/1c9OZMa1hFuM39FqwU7dz-1GzSXrcdbjCD59Ldnbcx4o/formResponse”,

type: “POST”,

dataType: “jsonp”,

data: {“entry.1796023489” :player.GetVar(“Hi“)},

success: function(data)

{

alert(data);

}

});

return false;

Hooray, Jane! Thanks so much for sharing an update, and what you discovered to be the issue! :)

Many thanks, Jane!  Your tip on checking the quotations saved my day.  The issue for me was when I copied dataType: "jsonp", directly from a post in this thread. While this line of code is helpful, the formatting of the text needed to be changed before pasting into Storyline.

Hi Jane,

Just an FYI when responding via email it includes your signature here, and you're welcome to edit the post and remove it if needed. 

Quote Patrick "As a result, you must manually include it in the head of your outputted HTML file (e.g. "")."

Does that mean manually include it in the head of the articulate html file?  If so how is this done - presumably by editing the file when it has been generated?

Hi Toby,

I'm not certain if Patrick is still subscribed, but you may want to message him directly using the "contact me" button on his profile to see if he's able to share additional information with you. I suspect that is what he meant - but I can't say for certain as modifications to the published output is not something we support, and therefore something I've never done. :) 

Why is this such a fiddly and confusing thing to achieve.  Sorry AS staff, the lack of simple non LMS functionality to track learner data is pathetic.  It feels more like a tactic to force users to consider Articulate Online.  This is really starting to alter my opinion of the software and company and making me very reluctant to confidently recommend to other professionals in the industry.

Very dissapointed customer ):

Hi Daniel,

This thread is a bit older and references folks who were looking to report to something outside of an LMS such as a web site or spreadsheet for tracking. The LMS reporting capabilities if publishing with SCORM or Tin Can API are what you would want to look into further for your LMS. Have you run into a particular issue with reporting data to your LMS? What publish options are you using? What LMS are you hosting within? Have you reviewed this troubleshooting article on testing content at SCORM cloud? 

Hi -

I wanted to update on a wierd quirk I found in the system. I setup the variable reporting to send very long strings of information to google forms (I have been grouping multiple variables into a single string, and then separating them in excel). While variables were being reported to Google forms appropriately, it stopped sending at variable 17. I was concerned that it was a problem in terms of coding, or even google forms, but it turned out to be a problem with the volume and length of variables being reported. When I broke it up so that storyline was separately sending out half the variables at a time (as supposed to all the variables at once) it worked. Hope this helps someone...

Thanks again for all the support - I wouldn't have been able to get my project past our IRB if it wasn't for this selective reporting of variables...

I appreciate you popping in to share Jane. True community spirit in getting some assistance and then paying if forward.