I/O Task import Org Chart into formalms

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
tonygil
Newbie
Posts: 5
Joined: Tue Mar 11, 2014 2:34 pm

I/O Task import Org Chart into formalms

Post by tonygil »

Hi Guys

I trying to use the i/o tasks to import Organization chart into formalms.
I have been trying to use it but have no success.
Can someone help me with exactly what i have to do step by step ?.
Also need to know the format of the source file.

Thanks
Tony Gilpin
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: I/O Task import Org Chart into formalms

Post by max »

Hi Tony, welcome onboard!

i/o tasks are normally used to connect, for instance, the Org Chart in your company's HR Software with Forma's Org Chart so that they stay synchronized.
They can also be used to connect users-courses subscriptions, to connect reports etc. etc.
The needed file format is normally .csv. You also need to set up a task in your server, so that it communicates with the Lms.

If all you want to do is import the org chart one time, a simple .csv import in the users management section is enough.
---------------------
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
tonygil
Newbie
Posts: 5
Joined: Tue Mar 11, 2014 2:34 pm

Re: I/O Task import Org Chart into formalms

Post by tonygil »

HI Max

What should the structure be for one time .csv org chart import ?

Thanks
Tonygil
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: I/O Task import Org Chart into formalms

Post by max »

Well, the structure (one-time or for synchronized connection) has to replicate the same structure you have in the org chart...
The typical fields are
username;first_name;last_name;email;password
You can check out this post
http://elearnit.wordpress.com/2014/06/1 ... #more-2686
It's in Italian, but I guess that having Google translate it automatically should be more than enough
---------------------
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
tonygil
Newbie
Posts: 5
Joined: Tue Mar 11, 2014 2:34 pm

Re: I/O Task import Org Chart into formalms

Post by tonygil »

Hi Max

I have 6500 branches to input, can I do this via a script directly to the database tables ?
What tables are used for the orgchart and what data do i need for the fields ?

Thanks
Tonygil
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: I/O Task import Org Chart into formalms

Post by max »

Hi Tony,

yes, it's definitely possible. We already did something similar just a few weeks ago. Do you only need to import branches and related users, or are you migrating from a previous LMS to a new one? Because that's also something we did, we also imported user skills and user status in courses.

It's not so simple, though: if you need assistance, you can PM me or e-mail me so we can discuss further.
---------------------
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
tonygil
Newbie
Posts: 5
Joined: Tue Mar 11, 2014 2:34 pm

Re: I/O Task import Org Chart into formalms

Post by tonygil »

We have a very old bespoke LMS. I want to do a one off import of 6500 branches and 28000 users. Now only about 250 users are active each month. but we have to keep the all users on the database
I have a test formalms system setup. I can produce a csv files from the old system.
I am testing this import , plus wanting to test the SSO and API
On the API we need to add new users from our support desk system in the background.
So how do i start ?
Thanks
tonygil
tonygil
Newbie
Posts: 5
Joined: Tue Mar 11, 2014 2:34 pm

Re: I/O Task import Org Chart into formalms

Post by tonygil »

Hi I ready to start to import a org chart and connect users to it.

Do you have a script yet that will do that as a one off ?

Thanks
Tony
User avatar
max
FormaLms Guru
Posts: 2735
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: I/O Task import Org Chart into formalms

Post by max »

Hi Tony,

if you want to do it as a one off, it's pretty simple (just build the additional fields as you wish and use the import feature inside the org chart).

I/O tasks are used to synch the LMS' org chart with a third party application, i.e. an HR management tool. Rather than a script, what you need to do is to create so called "connectors" and create some cron jobs on your server, from the 3rd party to the LMS and viceversa (if you want two-way synching).

But from what I read, it seems you are actually migrating from an old LMS to Forma, so you probably don't need any synching.
---------------------
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
alberto
FormaLms Guru
Posts: 1134
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: I/O Task import Org Chart into formalms

Post by alberto »

Hi Tony, HERE is some basic documentation on the API functionalities, should answer your needs on SSO.
Post Reply