Excel (XLS) Export for User Management Page

Third party plugins, patches, bugfixes
Post Reply
User avatar
murat
FormaLms User
Posts: 114
Joined: Fri Oct 12, 2012 6:28 pm
Version: forma.lms 2.0

Excel (XLS) Export for User Management Page

Post 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.
Attachments
Docebo User XLS -EXCEL-Export.zip
Docebo Excel Export - User Management
(25.12 KiB) Downloaded 290 times
Hello,I'm Murat. If you need me, you can contact my mail
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Excel (XLS) Export for User Management Page

Post by max »

Hi Murat,

great! Thank you for this new feature 8-)
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Excel (XLS) Export for User Management Page

Post by tuanmaster »

I also want to import User,Question from Excel
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Excel (XLS) Export for User Management Page

Post 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".
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Excel (XLS) Export for User Management Page

Post by tuanmaster »

Ok. Can you give me sample.csv to Import User? and I want import user following Organazion Chart, can you help me?
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Excel (XLS) Export for User Management Page

Post by max »

your .csv has to be like this

username,password,firstname,lastname,email
max,12345,max,ferrari,max@max.com
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Excel (XLS) Export for User Management Page

Post 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.
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Excel (XLS) Export for User Management Page

Post 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?
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Excel (XLS) Export for User Management Page

Post 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.
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Excel (XLS) Export for User Management Page

Post by tuanmaster »

Thank you! I have done.
Post Reply