Excel (XLS) Export for User Management Page

[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.

[max]

Hi Murat,

great! Thank you for this new feature

[tuanmaster]

I also want to import User,Question from Excel

[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".

[tuanmaster]

Ok. Can you give me sample.csv to Import User? and I want import user following Organazion Chart, can you help me?

[max]

your .csv has to be like this

username,password,firstname,lastname,email
max,12345,max,ferrari,[email protected]

[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,[email protected],folder1
tuan,12345,tuan,master,[email protected],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.

[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?

[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.

[tuanmaster]

Thank you! I have done.