The Elearning Community • Excel (XLS) Export for User Management Page
Page 1 of 1

Excel (XLS) Export for User Management Page

Posted: Fri Mar 22, 2013 8:01 pm
by murat
Hi,
User management page export only csv.
But not anymore now isn't only csv.
Because I wrote new export code for user management page.
You can download addition.
After,
You can Copy-Paste for your lms site.

Re: Excel (XLS) Export for User Management Page

Posted: Sat Mar 23, 2013 11:09 am
by max
Hi Murat,

great! Thank you for this new feature 8-)

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 04, 2013 4:43 am
by tuanmaster
I also want to import User,Question from Excel

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 04, 2013 7:47 am
by max
Hi Tuanmaster,
sorry but your question is not very clear. If you want to import users into the LMS, you just need to have a simple .csv file and go to Administration>users>users management, then click on "import users".

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 11, 2013 4:01 am
by tuanmaster
Ok. Can you give me sample.csv to Import User? and I want import user following Organazion Chart, can you help me?

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 11, 2013 7:44 am
by max
your .csv has to be like this

username,password,firstname,lastname,email
max,12345,max,ferrari,max@max.com

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 11, 2013 8:00 am
by max
If you want your users to go into different folders, for example folder1 or folder2, this is what you have to do:

username,password,firstname,lastname,email,folder
max,12345,max,ferrari,max@max.com,folder1
tuan,12345,tuan,master,tuan@tuan.com,folder2

Upon import, associate each field from your .csv with the appropriate field. Folder has to be associated with the item "folder" in the dropdown menu.

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 11, 2013 9:48 am
by tuanmaster
Thank you very much. If users have exists. I want change Information all users from CSV, How must I do?

Today, I upload file SCORM 2004, It is error: Error on RenderStartItem query = SELECT idscorm_resource FROM learning_scorm_resources WHERE idscorm_package = 4 AND idsco = 'RES-D8776DC7070F3D23F86C60148865E38A' record not found. How need I do?

Re: Excel (XLS) Export for User Management Page

Posted: Fri Oct 11, 2013 12:51 pm
by max
Hi,
so you want to update information about existing users? It works in the same way as creating new users (provided that the username is the same). When you import the .csv, just flag "update" and it should update users.
Be careful, you better try with some sample users before...

The error you get, to me, seems to mean that your scorm package is malformed, or at least zipped with a folder too much. The lms looks for a file, and it doesn't find it. Sorry, but without knowing what you use to publish and how you publish I cannot help you more than this.

Re: Excel (XLS) Export for User Management Page

Posted: Sat Oct 12, 2013 2:21 am
by tuanmaster
Thank you! I have done.

This site uses cookies.

Some of the cookies we use are essential for parts of the site to operate and have already been set. We also use Google Analytics scripts, which all use cookies.
You may delete or block all cookies from this site in your browser options.