Forum LAMS for Tech-Heads - General Forum: Bulk Insert into lams_user_organisation

You may request notification for Bulk Insert into lams_user_organisation.

1: Bulk Insert into lams_user_organisation
03/08/11 06:48 PM
[ Reply | Forward ]
I'm trying to link all my users to my groups. I'm trying to use this command within the workbench:

LOAD DATA INFILE 'C:/TEMP/userorganisation.csv'
INTO TABLE lams_user_organisation;

The csv file contains 3 columns:
user_organisation_id, organisation_id and user_id

When I try to load the file I get the following error:

Error Code: 11366 Incorrect integer value: 'user_organisation_id,organisation_id,user_id' for column 'user_organisation_id' at row 1

I was unsure what to use for the user_organisation_id so I set this to the relevant user_id.

Will appreciate any help on this error. I'm a SQL DBA who is only just finding his way around MYSQL.


Posted by Mike Partridge

2: Re: Bulk Insert into lams_user_organisation
In response to 1 03/08/11 06:58 PM
[ Reply | Forward ]

I'm not an expert in MySQL but I found something that might be useful here.

However, LAMS stores course information in cache (to speed things up) so if you import things directly into the database, you will need to tell LAMS to flush the cache and get it all back again (which you will need to do from the sysadmin menu).

Given that you need to do this from the sysadmin menu, I guess you are better of just using the excel spreadsheets for importing courses and users directly. See:

Posted by Ernie Ghiglione

3: Re: Re: Bulk Insert into lams_user_organisation
In response to 2 03/08/11 07:34 PM
[ Reply | Forward ]
We imported all our users into LAMS by using LDAP (synced it with Active Directory).

I have already imported all of our groups (around 500 of them) and now need to link all the users to their respective groups (or classes). Using the LAMS imports will not do this.

We don't want to do this manually (there are around 900 users, each of which will be linked to 5 or more groups or classes).

Thanks for the link you gave me, I'll check that out.

Do you know of an easier way to link users to classes form within LAMS?


Posted by Mike Partridge

4: Re: Re: Re: Bulk Insert into lams_user_organisation
In response to 3 03/09/11 08:08 AM
[ Reply | Forward ]

If you using LDAP to do authentication, you can also configure it so every time a user logs in, it check which courses she's in LDAP and update LAMS automatically. That way you don't have to worry about keeping the users in sync. (See the LDAPUpdateOnLogin config setting).

Although if you want to keep the users in Sync, there's also an option (sysadmin menu) to sync up all the users from LDAP at once.

Check out the LDAP page on the wiki:

Also make sure you update to LAMS 2.3.5 in case you haven't yet as there were a few issues with LDAP sync in previous versions.



Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum