<div dir="ltr">Hi Arnost,<div><br></div><div>Hi, do I have to define all parent ones in filter one by one? What will be added later? and how can I do this?<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Arnošt Starosta - AMI Praha a.s. <<a href="mailto:arnost.starosta@ami.cz">arnost.starosta@ami.cz</a>>, 12 May 2020 Sal, 20:03 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">Hi Merve,<div><br></div><div>you may load the parent org id to each organization in midpoint with ordinary resource inbound mapping to an extension attribute. Then create the assignment from organization to it's parent org in org template by using the parent id in the filter, like this</div><div><br></div><div><a href="https://wiki.evolveum.com/display/midPoint/Automatic+Role+Assignment+HOWTO" target="_blank">https://wiki.evolveum.com/display/midPoint/Automatic+Role+Assignment+HOWTO</a><br></div><div><br></div><div>Do the same for users and their parent orgs.</div><div><br></div><div>During the first organization import the parent org may not exist yet (it may be processed and created after the child org), thats why you need to recompute the orgs second time to get all parent assignments working.</div><div><br></div><div>good luck</div><div><br></div><div>arnost</div><div><br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">út 12. 5. 2020 v 16:33 odesílatel mceylan <<a href="mailto:mrveceylan@gmail.com" target="_blank">mrveceylan@gmail.com</a>> napsal:<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>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" target="_blank">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"><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"><div dir="ltr"><div><div dir="ltr"><div style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:13px"><p><strong>Arnošt Starosta</strong><br><span style="font-size:11px;color:rgb(128,128,128)">solution architect</span></p></div><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">gsm: [+420] 603 794 932<br>e‑mail: <a href="mailto:arnost.starosta@ami.cz" target="_blank">arnost.starosta@ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px"><strong>AMI Praha a.s.</strong><br>Pláničkova 11, 162 00 Praha 6</p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">tel.: [+420] 274 783 239 | web: <a href="https://www.ami.cz" target="_blank">www.ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;margin-top:20px"><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="AMI Praha a.s." style="border: 0px;"></p><p style="font-family:Arial,sans-serif;font-size:11px;color:rgb(170,170,170)">Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br><span style="font-size:6px"> </span><br>Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat důvěrné nebo osobní<br>informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv zveřejňování, zprostředkování<br>nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně, informujte o tom prosím<br>odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně všech jeho příloh. Nakládáním<br>s neoprávněně získanými informacemi se vystavujete riziku právního postihu.</p></div></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>