Export Data to Excel Spread sheet
Feb 21, 2016
Hello everyone,
I have been assigned to design a course in Articulate Storyline 2 that will export the data in to excel spread sheet. Google drive is prohibited because of security concerns and my client is against of putting confidential information on cloud.
I understand that the same question has been asked by other e-learning experts but not sure that if they are restricted to export values in Excel only. If they did, I would love to hear their experience.
9 Replies
You may be able to save to a CSV file on the desktop of the users machine but this can be affected by security policies. A Google sheet is the easiest way to capture the data, otherwise you want to look at saving into a database.
Hi Mohammad,
As you mentioned, it's a common request and most people recommend Google. I did find this thread where another user mentioned Excel and using Javasciprt so perhaps that helps.
Since it's not something we can offer support for, hopefully others in the community can assist.
Thanks for your reply Phil. I understand, but this is one of their policy and I can't debate with them on that. However, they have implemented internal webserver to send and receive data within the company. They also have SharePoint that generates the link and accessible to any machine.
I am interested to hear out what you have in mind regarding Saving to a CSV. I am just thinking out loud and help me if you think this will work.
If I upload the package with the excel file on webserver, on the same location. Will that work?
I strongly believe that if data can be exported to google sheets that there must be a way to export the same data on excel sheet with the help of webserver.
Hi Ashley,
I completely understand that this is very specific and unusual scenario that's why I shout out to all e-learning experts and want to see if they have gone with something similar.
There are two options that I can think of either save the content to a database and then export from database as CSV which can be read in excel. Or save as a text file on the users machine (which will only give that users data).
You may be able to achieve what you want using Excel web services, sorry never used these so cannot help.
Thanks Phil. I will see if there is any possibility to save the content to a database and then export data.
Best bet might be Sharepoint Web Services. It's complicated but you should be able to setup a web services endpoint and route that to a spreadsheet or database within Sharepoint's environment.
If you want to take it a step closer, there's a way to infuse Sharepoint web parts to create an xAPI endpoint, if I read this project correctly.
Grr... Nope. Misread that project. They are using a SCORMCloud LRS to make that Sharepoint bit work. Should still be able to pull something together using web parts and Sharepoint web services. Would just be starting from scratch:)
Thanks for your help Steve.
This discussion is closed. You can start a new discussion or contact Articulate Support.