Hello all. Does anyone know the proper configuration needed to automatically attach a imported user (through Import Users function) to an Organization Chart tree node?

In the Configuration > Login/registration options tab I have set:
Insert user inside a tree through a code => Subscription code chosen from dropdown menu
Choose field associated to tree nodes for user tree association => The name of one of my Additional fields

But this does not seem to work on import. Any tricks? What steps am I missing? What configs am I missing?
I have almost 20,000 users and 94 tree nodes, so this is kind of an essential need.

We are on version 3.6.0.4

Thanks for the help!!

Hello,
Are you using the XML connector?
Claudio 

no. is the xml connector a requirement for this functionality?

Is the only way to understand where node is placed i think
Claudio
 

Thanks for the reply Claudio. Any idea where the node to user association is made in the database? Which table contains this info?

Hello,
please see here.

bye,
Giovanni. 

Ok. I am getting a bit desparate now. May someone please walk me through the steps for how to associate a user to an organzation chart node upon a mass upload. I don't care the method (I/O task, direct import, backend database update, whatever). I have to upload around 100-200 users each week and I have created my sql to download from our central HR database the data and fields that are requires in the upload format that is required. This is the easy part.

The problem is that these users belong to one of 94 org tree nodes. We set up these nodes to assign proper admin rights to the selected user population (over 23,000 in the LMS). The upload is easy, but the association to the correct node is driving me absolutely crazy! After the upload I am manually going to each of the 94 nodes, searching for the users based on the additional field that is set-up that identifies which node they should be in, then selecting all and clicking Go. Nuts to do this up to 94 times each week.

I know this automatic association to the org tree node cannot be that difficult but I am too much of an idiot to figure it out. At this point I am will to pay someone for their guidance. Let me know. Many thanks.

This is a backend database update method that I am using for version 4.04. I am updating from a MSSQL table with employee information. First, create a 'linked server' in MSSQL to the DoceboDB through an ODBC MySQL driver from my desired database. Then set an 'Additional Field' in Docebo for the Org Chart Name. I have all of the Org Chart names that are to be updated set to the Department in the 'YOURDATABASE' database that has been linked to Docebo. The tables are joined through the 'YOUREMPLOYEE_FIELD'  which I have set equal to the userid inside of Docebo. The only catch is, the userid in Docebo must always match the 'YOUREMPLOYEE_FIELD', so you will have to come up with a method of not allowing Admins to change the userid's. Hope this helps.

--Delete the old custom field
DELETE FROM OPENQUERY(DOCEBO, 'SELECT * FROM docebodev.core_field_userentry;')
WHERE id_common = '1' and id_user IN (SELECT idst FROM OPENQUERY(DOCEBO, 'SELECT idst, userid FROM docebodev.core_user') core_userref
    inner join [YOURSERVER].[YOURDATABASE].[dbo].[YOURTABLE]
    ON userid = ('/' + LTRIM(RTRIM(CAST([YOUREMPLOYEE_FIELD]as varchar(30)))))  )
   
--Place the new custom field equal to the OrgChart name
insert into openquery(docebo, 'select id_common_son, id_common, id_user, user_entry from docebodev.core_field_userentry')
select '0', '1', idst, LTRIM(RTRIM([YOURORGCHART_NAME])) as statuss FROM OPENQUERY(DOCEBO, 'SELECT idst, userid FROM docebodev.core_user')
    inner join [YOURSERVER].[YOURDATABASE].[dbo].[YOURTABLE]
    ON userid = ('/' + LTRIM(RTRIM(CAST([YOUREMPLOYEE_FIELD]as varchar(30)))))

--Delete the old OrgChart Associations
DELETE FROM OPENQUERY(DOCEBO, 'SELECT * FROM docebodev.core_group_members WHERE idst not in (1,2,3,4,5,6) and core_group_members.idst in (select idst from docebodev.core_group where groupid like "/oc%");')
WHERE idstMember IN (SELECT idst FROM OPENQUERY(DOCEBO, 'SELECT idst, userid FROM docebodev.core_user') core_userref
    inner join [YOURSERVER].[YOURDATABASE].[dbo].[YOURTABLE]
    ON userid = ('/' + LTRIM(RTRIM(CAST([YOUREMPLOYEE_FIELD]as varchar(30))))) )
   
--Insert the New OrgChart Associations
insert into openquery(docebo, 'select idst, idstMember from docebodev.core_group_members;')
SELECT qidst, qidstMember from openquery(docebo, 'select idst as qidst, id_user as qidstMember from docebodev.core_field_userentry
    inner join (select * from docebodev.core_org_chart
    inner join docebodev.core_group
    on core_group.groupid = CONCAT("/oc_", core_org_chart.id_dir) ||
        core_group.groupid = CONCAT("/ocd_", core_org_chart.id_dir)) as org_chart
    on user_entry=translation;')