Thread "Organizational Unit - XML User Assignment"

Grettings from Canada!

I was wondering if anyone had a sample of the xml for the XML User Assignment in hte Organisational Unit section?

I've been able to successfully use the Simple XML Import to load an organisational structure; but I cannot figure out the structure for the user assignment.

Thanks in advance.

Tom.

Hi Tom,
I'm Gabriel from Italy.
I found your post today.
Can you tell me if you were able to manage massive user assignments to organizational units?
currently I need to assign three hundred users to different organizational units. Do you have any suggestions?

Thanks in advance

Gabriel

Hi,
someone can tell me which tables have to populate to assign the staff to the Organization Unit?
I need to import to many users to different org. units, and I can't use the ILIAS Interface because requires too may time.

Thank you in advance

Gabriel

HI Gabriel, il_orgu_ua and il_orgu_ua_seq for an incrementing id are the table you have to populate / update.

il_orgu_ua
id - The id+1 from il_orgu_ua_seq (don't forget to update that table)
user_id - user id you're assiging to (from usr_data or object_data)
position_id - you can get this from il_orgu_positions, but it's generally 1 for Employees and 2 for Superiors
orgu_id - the object REF_ID (not obj_id).

you can get the list of orgu_id's in your system using the following.

SELECT obr.ref_id AS 'orgu_id', od.title FROM object_data od
INNER JOIN object_reference obr ON obr.obj_id = od.obj_id
WHERE od.type = 'orgu' AND title != '__OrgUnitAdministration'
AND obr.deleted IS NULL

Hi Evan,
Thank you so much for your answer.
I developed a stored procedure to do it, but I needed confirmation that only these two tables were involved.

Thank you again for your support.

Gabriel

Hi all,

Does anyone know if the XML User Assignment (import) actually works and what structure the file should have? (Is there a DTD around maybe?) I'm looking for a more user friendly way to bulk-assign or change users to Organisational Units. With the XMl import I can just send the XML file to the ILIAS administrator. 

Regards,

Robert

Hi all,

Does anyone know if the XML User Assignment (import) works and what the file structure looks like?
It would be really helpful for our ILIAS Administrators to just use this XML Import function with the XML file to assign users a position and an organizational unit. Can anyone help us out there? The XML file structure would us help out a lot. 

Best regards,

Matthias

Hi there,

thanks for your quick response. Sadly this did not satifisy my request cause I am not talking about bringing user into the Ilias System itself. 
We are using LDAP Auth and Sync to bring our user into the System. 
So we are still facing the same issue we created some organisational units and want to add users under the Staff tab with an XML File. If we go to the Content tab we can select importing user with an XML File sadly I dont know how this XML must be structed to work within the Ilias due to time issues I dont have the time to try it out myself. Maybe somebody knows how it looks like and can help us out with it. Maybe there is a way to set it up within the Active Directory Structure so we can apply it during the synchronisation? I did not found how you can assign it beside manually adding him by typing the name.
Attached I have some Screenshots where you see everything I meant earlier.

Best regards,

Matthias

Realized my mistake and deleted my response. I revisited the files in the import gui and determined that you can import with the following structure

<Assignments>
    <Assignment action='add'>
        <User id_type='ilias_login'>root</User>
        <OrgUnit id_type='reference_id'>116</OrgUnit>
        <Role>superior</Role>
    </Assignment>
</Assignments>

action can either be add or remove

User's id_type can either be email ilias_login or external_id
Orgunit's id_type can either be reference_id (the ref_id) or external_id (import_id in object_data)
Role can either be superior or employee

Hope this helps, I was successfully able to  enroll 'root' into a orgunit with a ref_id of 116 with that xml. using the XML User Assignment button.

EJ

Hi there,

Thank you it worked like a charm.

One last thing: I can only assign the role "employee" or "superior" if I define a test position for example "TESTROLE" and I call the role in the XML file I recieve an error that the role is not valid. Screenshot and XML File is attached.

How can I fix these because we need more than just two positions in our organisational unit?

Best regards,

Matthias

https://github.com/ILIAS-eLearning/ILIAS/blob/release_6/Modules/OrgUnit/classes/SimpleUserImport/class.ilOrgUnitSimpleUserImport.php#L65-L73

looks like the custom positions aren't implemented unfortunately.

https://github.com/ILIAS-eLearning/ILIAS/pull/3113 I proposed a change to Ilias to allow custom roles, you can use that at your own risk but i'm sure the repo owners will comment if it isn't the proper way to do it.

Hi Evan,
Can you tell me where can I find the button,"XML User Assignment"?

TK

Sure, if you go to Administration -> Organisational Units it should be the subtab Import



Keep in mind i'm in ilias 5.4 so things might change.

Evan

You are Great Evan !

If you want to know, in ILAS 6 the button is in the same place.

Also, I have verified that in ILIAS 6 it is possible to filter course members by organizational unit, which in ILIAS 5.4 does not work. right?

Thanks for your advices

Gabriel