<div dir="ltr"><div>Hi Gustav, Thanks for your answer</div><div><br></div>It did not improve when I imported twice. I didn't understand that. There are users in the database table and there is also identifier and parent information in their information. Users are sorted, for example, by employeeNumber. But unfortunately, the organization name, identifier and parent_id in their columns are not sequential. What do I have to do in this situation?<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Pálos Gustáv <<a href="mailto:gustav.palos@gmail.com">gustav.palos@gmail.com</a>>, 12 May 2020 Sal, 16:57 tarihinde şunu yazdı:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">Hi  mceylan,</div><div dir="ltr"><br></div><div>You need organizations in right order (from bottom to top), and I prefer not using <span style="color:rgb(0,0,0);font-family:"Courier New",Courier,monospace,arial,sans-serif;font-size:14px;white-space:pre-wrap">createOnDemand</span>, just create orgs with linked shadows & 

strong

assignmentTargetSearch.</div><div>If you have in wrong order, you need to import "twice", first just create orgs and assign what you already have, and on second round create assignments to missing parents from first run.</div><div><br></div><div>best regards,</div><div><br></div><div>Gustav</div><div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">ut 12. 5. 2020 o 15:15 mceylan <<a href="mailto:mrveceylan@gmail.com" target="_blank">mrveceylan@gmail.com</a>> napísal(a):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I made it as the attached source. I added the user template in the file. This way the organizational tree is created, but parent_id and identifier get mixed. So some don't occur under child parent. It occurs as a side tab. I couldn't figure it out.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Ivan Noris <<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>>, 12 May 2020 Sal, 15:57 tarihinde şunu yazdı:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <p>Hi,</p>
    <p>nothing special. Just use them as AccountObjectClass from the
      connector and link them to corresponding objects in midPoint (e.g.
      Organizations).</p>
    <p>Ivan<br>
    </p>
    <div>On 12. 5. 2020 14:55, mceylan wrote:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">Thanks for the answer, Ivan. So what should I do to
        pull the organizational units from DB Table resource and create
        and synchronize the organization tree in midpoint according to
        parent id and identifier?<br>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">Ivan Noris <<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>>,
          12 May 2020 Sal, 14:30 tarihinde şunu yazdı:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
          <div>
            <p>Hi,</p>
            <p>I think DB Table connector supports only
              AccountObjectClass.</p>
            <p>Ivan</p>
            <p><br>
            </p>
            <div>On 12. 5. 2020 13:06, mceylan wrote:<br>
            </div>
            <blockquote type="cite">
              <div dir="ltr">
                <div>I get the following error when I set
                  CustomorganizationalUnitObjectClass as database
                  resorce object class. What would be the reason?<br>
                </div>
                <div>
                  <div><br>
                  </div>
                  <div>
                    <div><span>Error:No objectclass specified and no
                        default can be determined</span></div>
                  </div>
                  <div><span><br>
                    </span></div>
                  <div><default>true</default><br>
                    When I do, I get the following error.<br>
                  </div>
                  <div><br>
                  </div>
                  <div><span>Internal error: Got unexpected exception:
                      java.lang.IllegalArgumentException: Operation
                      requires an Account ObjectClass.</span><br>
                  </div>
                  <div><span><br>
                    </span></div>
                  <div><span><br>
                    </span></div>
                  <div><br>
                  </div>
                  <div><schemaHandling><br>
                          <objectType id="1"><br>
                             <kind>generic</kind><br>
                             <default>false</default><br>
                           
 <objectClass>ri:CustomorganizationalUnitObjectClass</objectClass><br>
                             <attribute id="2"><br>
                                <c:ref>icfs:uid</c:ref><br>
                                <displayName>Entry
                    UUID</displayName><br>
                                <limitations><br>
                                   <access><br>
                                      <read>true</read><br>
                                   </access><br>
                                </limitations><br>
                             </attribute><br>
                             <attribute id="3"><br>
                                <c:ref>icfs:name</c:ref><br>
                               
                    <displayName>Name</displayName><br>
                                <limitations><br>
                                   <minOccurs>0</minOccurs><br>
                                   <access><br>
                                      <read>true</read><br>
                                      <add>true</add><br>
                                      <modify>true</modify><br>
                                   </access><br>
                                </limitations><br>
                                <inbound id="24"><br>
                                   <target><br>
                                     
                    <c:path>$user/employeeNumber</c:path><br>
                                   </target><br>
                                </inbound><br>
                                <inbound id="43"><br>
                                   <target><br>
                                     
                    <c:path>$user/name</c:path><br>
                                   </target><br>
                                </inbound><br>
                             </attribute><br>
                             <attribute id="15"><br>
                                <c:ref>ri:parent_id</c:ref><br>
                                <inbound id="16"><br>
                                   <target><br>
                                     
                    <c:path>$user/extension/parent_id</c:path><br>
                                   </target><br>
                                </inbound><br>
                             </attribute><br>
                             <attribute id="37"><br>
                                <c:ref>ri:identifier</c:ref><br>
                                <inbound id="39"><br>
                                   <target><br>
                                     
                    <c:path>$user/extension/identifier</c:path><br>
                                   </target><br>
                                </inbound><br>
                             </attribute><br>
                             <attribute id="32"><br>
                               
                    <c:ref>ri:organization_name</c:ref><br>
                                <inbound id="33"><br>
                                   <target><br>
                                     
                    <c:path>$user/extension/organizationname</c:path><br>
                                   </target><br>
                                </inbound><br>
                             </attribute><br>
                             <activation><br>
                                <administrativeStatus><br>
                                   <outbound id="5"/><br>
                                   <inbound id="6"><br>
                                     
                    <strength>weak</strength><br>
                                   </inbound><br>
                                </administrativeStatus><br>
                             </activation><br>
                          </objectType><br>
                       </schemaHandling><br>
                  </div>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                </div>
              </div>
              <br>
              <fieldset></fieldset>
              <pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
            </blockquote>
            <pre cols="72">-- 
Ivan Noris
Senior Identity Engineer
<a href="http://evolveum.com" target="_blank">evolveum.com</a>
</pre>
          </div>
          _______________________________________________<br>
          midPoint mailing list<br>
          <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
          <a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
        </blockquote>
      </div>
      <br clear="all">
      <div><br>
      </div>
      -- <br>
      <div dir="ltr">
        <div dir="ltr">Merve CEYLAN</div>
      </div>
      <br>
      <fieldset></fieldset>
      <pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
    </blockquote>
    <pre cols="72">-- 
Ivan Noris
Senior Identity Engineer
<a href="http://evolveum.com" target="_blank">evolveum.com</a>
</pre>
  </div>

_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr">Merve CEYLAN</div></div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr">s pozdravom<div><br></div><div>Gustáv Pálos</div></div></div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr">Merve CEYLAN</div></div>