I'm getting some help on this on the side with this, but just wondering if anyone has done this and can provide me with some full code examples that I could then modify for my use. I'm a javascript noob so can't write all my own code at this point, but can probably modify some.
Can you IM me about this? I know how to push data out of Storyline, but I've been trying to do the reverse for ages and was sure it's not possible. Let me know, thanks!
* I should say - the only way I've found to pull data IN to Storyline is via LMS, using the LMS API library.
I'm including tabletop.js (https://github.com/jsoma/tabletop) into my project and using the following code to pull in data from a sheet which has been published for public access. Please let me know how you make out with this.
var public_spreadsheet_url = 'FullUrlToGoogleSheet';
So I am not the only one waiting on the 'nerd out' results :) This wasn't that long ago, but there is a Contact Me option on Michael's user profile as well if needed Mike.
Hey Mike. I did indeed - I replied in another thread, thought I did so here as well. I've been using your tabletop.js approach, and it works beautifully -- as long as your arrays are clean and you're using column titles, the sky's the limit!
Hi Gustavo, a while back I put together a "user guide" on how to do this, along with other JS functions, for my own projects. It's not super professional, but I hope it's useful. Let me know if you have any questions on using Tabletop.js.
Kicking this thread to see if there is still life......
I have made this work pulling a variable from a sheet. I have worked out that the Data[0] is the row from which to pull data [0] being the first row.
Does anybody know how to find a particular part of the table? I.e. if you had a list of names and ID numbers, how can you pull a name from a particular ID number.
I want to pull a name when I enter an ID number
Any ideas?
Gustavo, if you are still there...
"CourseID" is the variable in storyline that you want to populate
Data[0] is the row in the sheet you want the data to come from [0] is the first row
.CourseID is the header of the column of the sheet you want the data to come from.
If you don't hear from Gustavo or others they may no longer be subscribed here, so you can reach out to them by using the "contact me" button on their profile to see if they can offer any additional insight.
25 Replies
Hi Mike! Hopefully someone in the community will be able to assist you here. Good luck with your project.
I've got this working now with some help from the Storyline Guru. :)
Awesome! Love it!
Hey Mike - another Mike B here :)
Can you IM me about this? I know how to push data out of Storyline, but I've been trying to do the reverse for ages and was sure it's not possible. Let me know, thanks!
* I should say - the only way I've found to pull data IN to Storyline is via LMS, using the LMS API library.
Hi Michael! If you do not here back from Mike soon, as I'm not sure if he's subscribed, be sure to utilize the contact me option on the user profile.
Michael,
I'm including tabletop.js (https://github.com/jsoma/tabletop) into my project and using the following code to pull in data from a sheet which has been published for public access. Please let me know how you make out with this.
var public_spreadsheet_url = 'FullUrlToGoogleSheet';
Tabletop.init( { key: public_spreadsheet_url,
callback: showInfo,
simpleSheet: true } );
function showInfo(data) {
var player = GetPlayer();
player.SetVar("CourseID",data[0].CourseID);
}
Thanks,
Mike
Thanks for popping in to assist Mike :)
Mike.... You don't know how excited I am about this. Can't wait to nerd out on this later. Thank you for sharing!
I was able to accomplish this by following this article
http://josephfitzsimmons.com/getting-json-data-from-google-spreadsheets-and-using-it-in-google-maps/
Copied a spreadsheet of Michael's
https://docs.google.com/spreadsheets/d/1lJLFfR70VMXewEv637bRppMX_bGk-Pc_uHneLZRm8SM/edit?usp=sharing
imported it into Storyline
http://nextgen.wvnet.edu/Courses/ActiveAcademics/test4/story_html5.html
I pulled 5 random entries
Thanks for popping in to share as well Mark :)
Michael,
Did you get this figured out?
Thanks,
Mike
So I am not the only one waiting on the 'nerd out' results :) This wasn't that long ago, but there is a Contact Me option on Michael's user profile as well if needed Mike.
Feel free to contact him if you like. ;) I have this working for myself, I just wanted to see if he needed any more help.
I'll maintain my subscription to the thread, but I just like when users get excited about new findings/opportunities with the software for sure.
Hey Mike. I did indeed - I replied in another thread, thought I did so here as well. I've been using your tabletop.js approach, and it works beautifully -- as long as your arrays are clean and you're using column titles, the sky's the limit!
Glad to hear it! I'm sorry I wasn't more responsive last week, I was VERY sick.
Hi.
I'm looking for this solution. I'm able to export variables into a Google Spreadsheet but now i want to do the inverse.
Help will be appreciated.
Nice weekend
Hi Gustavo, a while back I put together a "user guide" on how to do this, along with other JS functions, for my own projects. It's not super professional, but I hope it's useful. Let me know if you have any questions on using Tabletop.js.
Thanks for popping in to share that with Gustavo and the community Michael :)
Thanks Mike.
Very nice job. Now I can create my own "tracking" system to control users' progress.
And so on...
Have a great week
Glad this will be able to assist you Gustavo :) Thanks for popping in to share.
Happy new year everybody.
I work in this solution but I don't achieve to make it work.
I did include tabletop.js into my project folder and using the following code
var public_spreadsheet_url = 'FullUrlToGoogleSheet';
Tabletop.init( { key: public_spreadsheet_url,
callback: showInfo,
simpleSheet: true } );
function showInfo(data) {
var player = GetPlayer();
player.SetVar("CourseID",data[0].CourseID);
}
any ideas? Can anybody explain me about "CourseID" ?
Kicking this thread to see if there is still life......
I have made this work pulling a variable from a sheet. I have worked out that the Data[0] is the row from which to pull data [0] being the first row.
Does anybody know how to find a particular part of the table? I.e. if you had a list of names and ID numbers, how can you pull a name from a particular ID number.
I want to pull a name when I enter an ID number
Any ideas?
Gustavo, if you are still there...
"CourseID" is the variable in storyline that you want to populate
Data[0] is the row in the sheet you want the data to come from [0] is the first row
.CourseID is the header of the column of the sheet you want the data to come from.
Hi David,
If you don't hear from Gustavo or others they may no longer be subscribed here, so you can reach out to them by using the "contact me" button on their profile to see if they can offer any additional insight.
Hi David and all.
Thanks. I worked HARD with this. Now, I'm able to push in or pull out data from a Google Sheet. I created a user's DB.
I would like to do a tutorial for that, but I've really not time now.
So, i used Tabletop feauture (https://github.com/jsoma/tabletop).
Good luck !
This discussion is closed. You can start a new discussion or contact Articulate Support.