The Elearning Community

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

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.

HI Max

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

Thanks
Tonygil

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

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

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.

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

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

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.

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