Excel (XLS) Export for User Management Page

Third party modules, patches, bugfixes
Post Reply
User avatar
murat
FormaLms Expert
Posts: 104
Joined: Fri Oct 12, 2012 6:28 pm
Version: forma.lms 1.4

Excel (XLS) Export for User Management Page

Post by murat » Fri Mar 22, 2013 8:01 pm

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 32 times

Online
User avatar
max
FormaLms Guru
Posts: 1783
Joined: Thu Mar 01, 2012 10:41 am

Re: Excel (XLS) Export for User Management Page

Post by max » Sat Mar 23, 2013 11:09 am

Hi Murat,

great! Thank you for this new feature 8-)
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
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 » Fri Oct 04, 2013 4:43 am

I also want to import User,Question from Excel

Online
User avatar
max
FormaLms Guru
Posts: 1783
Joined: Thu Mar 01, 2012 10:41 am

Re: Excel (XLS) Export for User Management Page

Post by max » Fri Oct 04, 2013 7:47 am

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
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
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 » Fri Oct 11, 2013 4:01 am

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

Online
User avatar
max
FormaLms Guru
Posts: 1783
Joined: Thu Mar 01, 2012 10:41 am

Re: Excel (XLS) Export for User Management Page

Post by max » Fri Oct 11, 2013 7:44 am

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
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
Skype: m_ferrari_it

Online
User avatar
max
FormaLms Guru
Posts: 1783
Joined: Thu Mar 01, 2012 10:41 am

Re: Excel (XLS) Export for User Management Page

Post by max » Fri Oct 11, 2013 8:00 am

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
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
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 » Fri Oct 11, 2013 9:48 am

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?

Online
User avatar
max
FormaLms Guru
Posts: 1783
Joined: Thu Mar 01, 2012 10:41 am

Re: Excel (XLS) Export for User Management Page

Post by max » Fri Oct 11, 2013 12:51 pm

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
http://www.elearnit.net
http://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
http://elearnit.wordpress.com
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 » Sat Oct 12, 2013 2:21 am

Thank you! I have done.

Post Reply