<div dir="ltr">Thanks,<br>Arnost, I guess I just updated it wrong. I made the change in the filter you say now.<div><br><div><a href="https://gist.github.com/mrvcyln/9c61803aa83a587ad38c8b0b27de81cc">https://gist.github.com/mrvcyln/9c61803aa83a587ad38c8b0b27de81cc</a><br></div><div><br>This time I got the following error. What is the wrong part?<br><div><br></div><div><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">Couldn't evaluate expression ExpressionType(variable=[],evaluator=script:com.evolveum.midpoint.xml.ns._public.common.common_3.ScriptExpressionEvaluatorType@63dc4f7[language=<null>,returnType=<null>,code=parent_id,description=<null>,trace=<null>,relativityMode=<null>,includeNullInputs=<null>,allowEmptyValues=<null>]): The URI (700036) does not contain slash character in (new) expression in mapping 'Add Organization' in template mapping 'Add Organization' in objectTemplate:c0c010c0-d34d-b33f-f00d-777333333333(User Template)(</span><br></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Petr Gašparík - AMI Praha a.s. <<a href="mailto:petr.gasparik@ami.cz">petr.gasparik@ami.cz</a>>, 13 May 2020 Çar, 16:15 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"><a href="https://gist.github.com/PetrGasparik/92f413ad8e23c7f36c5f601538649a1a" target="_blank">PS: even better to store as file.xml</a> <br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><span style="font-family:Arial,sans-serif;font-size:10pt">--</span></p><p><span style="font-family:Arial,sans-serif;font-size:10pt">s pozdravem</span></p><div style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:13px"><p><strong>Petr Gašparík</strong><br><span style="font-size:11px;color:rgb(128,128,128)">konzultant IT bezpečnosti</span></p></div><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">gsm: [+420] 603 523 860<br>e‑mail: <a href="mailto:petr.gasparik@ami.cz" target="_blank">petr.gasparik@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></div></div></div></div></div></div></div></div></div></div><br></div><div id="gmail-m_-769752199588538615DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid rgb(211,212,222)">
        <tbody><tr>
      <td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:17px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Bez virů. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a>               </td>
        </tr>
</tbody></table>
<a href="#m_-769752199588538615_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">st 13. 5. 2020 v 15:13 odesílatel Petr Gašparík - AMI Praha a.s. <<a href="mailto:petr.gasparik@ami.cz" target="_blank">petr.gasparik@ami.cz</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">Merve, it is better to use gist for code snippets, like this (your mapping) <a href="https://gist.githubusercontent.com/PetrGasparik/dac261891f0f22de425dc6112de1251b/raw/07de83e5392e4caf2d0781f5061dc39599b70430/gistfile1.txt" target="_blank">https://gist.githubusercontent.com/PetrGasparik/dac261891f0f22de425dc6112de1251b/raw/07de83e5392e4caf2d0781f5061dc39599b70430/gistfile1.txt</a>  <br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><span style="font-family:Arial,sans-serif;font-size:10pt">--</span></p><p><span style="font-family:Arial,sans-serif;font-size:10pt">s pozdravem</span></p><div style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:13px"><p><strong>Petr Gašparík</strong><br><span style="font-size:11px;color:rgb(128,128,128)">konzultant IT bezpečnosti</span></p></div><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">gsm: [+420] 603 523 860<br>e‑mail: <a href="mailto:petr.gasparik@ami.cz" target="_blank">petr.gasparik@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></div></div></div></div></div></div></div></div></div></div><br></div><div id="gmail-m_-769752199588538615gmail-m_7905686014798021229DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid rgb(211,212,222)">
        <tbody><tr>
      <td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:17px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Bez virů. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a>               </td>
        </tr>
</tbody></table>
<a href="#m_-769752199588538615_m_7905686014798021229_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">st 13. 5. 2020 v 14:29 odesílatel Arnošt Starosta - AMI Praha a.s. <<a href="mailto:arnost.starosta@ami.cz" target="_blank">arnost.starosta@ami.cz</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">Hi,<div><br></div><div>without looking into the details you are still trying to filter the SAME organization as the assignment target, or not? </div><div><br></div><div>The assignmentTargetSearch filter is the same as three emails above - trying to 'find assignment target organizations that have my org_id as identifier' instead of trying to link the target organization id to my parent_id.</div><div><br></div><div>Also not sure about the name declarations in your 'source' elements. It may work, don't know, but i use sources directly in code expressions without naming them - in your case it would be 'parent_id' and 'identifier' - or i declare and name them as 'variable' elements in the expression itself.</div><div><br></div><div>arnost</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">st 13. 5. 2020 v 14:08 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">Hi Arnost,<div><br></div><div>I changed the object template as you said. As I understand it as below.</div><div><mapping id="11"><br>      <name>Add Organization</name><br>      <source><br>         <name>org_id</name><br>         <c:path>$focus/extension/identifier</c:path><br>      </source><br>      <source><br>         <name>parent_id</name><br>         <c:path>$focus/extension/parent_id</c:path><br>      </source><br>      <source><br>         <name>orgName</name><br>         <c:path>$focus/extension/organizationname</c:path><br>      </source><br>      <expression><br>         <assignmentTargetSearch xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"<br>                                 xsi:type="c:SearchObjectRefExpressionEvaluatorType"><br>            <targetType>c:OrgType</targetType><br>            <filter><br>               <q:equal><br>                  <q:path>c:identifier</q:path><br>                  <expression><br>                     <script><br>                        <code>org_id</code><br>                     </script><br>                  </expression><br>               </q:equal><br>            </filter><br>            <createOnDemand>true</createOnDemand><br>            <populateObject><br>               <populateItem><br>                  <expression><br>                     <script xsi:type="c:ScriptExpressionEvaluatorType"><br>                        <code>org_id</code><br>                     </script><br>                  </expression><br>                  <target><br>                     <c:path>c:identifier</c:path><br>                  </target><br>               </populateItem><br>               <populateItem><br>                  <expression><br>                     <script xsi:type="c:ScriptExpressionEvaluatorType"><br>                        <code>orgName</code><br>                     </script><br>                  </expression><br>                  <target><br>                     <c:path>name</c:path><br>                  </target><br>               </populateItem><br>               <populateItem><br>                  <expression><br>                     <script xsi:type="c:ScriptExpressionEvaluatorType"><br>                        <code>orgName</code><br>                     </script><br>                  </expression><br>                  <target><br>                     <c:path>name</c:path><br>                  </target><br>               </populateItem><br>               <populateItem><br>                  <expression><br>                     <assignmentTargetSearch xsi:type="c:SearchObjectRefExpressionEvaluatorType"><br>                        <targetType>c:OrgType</targetType><br>                        <filter><br>                           <q:equal><br>                              <q:path>org_id</q:path><br>                              <expression><br>                                 <script><br>                                    <code>parent_id</code><br>                                 </script><br>                              </expression><br>                           </q:equal><br>                        </filter><br>                     </assignmentTargetSearch><br>                  </expression><br>                  <target><br>                     <c:path>$focus/assignment</c:path><br>                  </target><br>               </populateItem><br>            </populateObject><br>         </assignmentTargetSearch><br>      </expression><br>      <target><br>         <c:path>$focus/assignment</c:path><br>      </target><br>   </mapping><br></div><div><br></div><div><br></div><div>No organization came when I ran import task in this way. Task also made a mistake<br></div><div><br></div><div><br></div><div><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">Failures (13):</span><br style="box-sizing:border-box;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)"><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">13: java.lang.RuntimeException: Couldn't find a proper data item to query, given base entity Ent:ROrg (jaxb=OrgType) and this filter: EQUAL:</span><br style="box-sizing:border-box;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)"><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">PATH: org_id</span><br style="box-sizing:border-box;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)"><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">DEF: null</span><br style="box-sizing:border-box;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)"><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">VALUE:</span><br style="box-sizing:border-box;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)"><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px;background-color:rgb(249,249,249)">700036 in (new) expression in assignment expression in expression in mapping 'Add Organization' in template mapping 'Add Organization' in objectTemplate:c0c010c0-d34d-b33f-f00d-777333333333(User Template)(orgName=YÖNETİM MÜDÜRLÜĞÜ; org_id=700043; parent_id=700036; ) in expression in mapping 'Add Organization' in template mapping 'Add Organization' in objectTemplate:c0c010c0-d34d-b33f-f00d-777333333333(User Template)</span><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" target="_blank">arnost.starosta@ami.cz</a>>, 13 May 2020 Çar, 11:02 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>your organizations may have more than one parent? i guess no, that would make a very unusual organization structure.</div><div><br></div><div>Suppose each midpoint organization has an id in extension/org_id and knows it's one and only parent id in extension/parent_id. Then a mapping like</div><div><br></div><div>    <mapping><br>        <source><br>            <path>$focus/<b>extension/parent_id</b></path><br>        </source><br>        <expression><br>            <assignmentTargetSearch><br>                <targetType>c:OrgType</targetType><br>                <filter><br>                    <q:equal><br>                        <q:path><b>extension/org_id</b></q:path><br>                        <expression></div><div>                            <script><code><b>parent_id</b></code></script><br>                        </expression><br>                    </q:equal><br>                </filter><br>            </assignmentTargetSearch><br>        </expression><br>        <<b>target</b>><br>            <path>$focus/<b>assignment</b></path><br>        </target><br>    </mapping><br></div><div><br></div><div>in organization template assigns the organization as a member in <b>existing</b> parent organization. When you reconcile your organizations in a random order and not in parent-first-child-next order (as you do), the parent organization may not be created yet, the mapping can't find the parent and child organizations keep dangling in the air (visible as many fake 'root' orgs in gui). That's why you need to recompute all the orgs one more time when all parent orgs are guaranteed they exist - after reconciling them first.</div><div><br></div><div>I checked briefly your org template and you seem to mix parent and child ids sometimes, e.g. the 'Add Organization' mapping tries to assign parents (i guess) by this filter</div><br><filter><br>               <q:equal><br>                  <q:path>c:identifier</q:path><br>                  <expression><br>                     <script><br>                        <code><b>org_id</b></code><br>                     </script><br>                  </expression><br>               </q:equal><br>            </filter><div><br></div><div>where org_id is extension/identifier. Shouldn't you be comparing <b>parent_id</b> instead? You seem to be on the right path in the end .)</div><div><br></div><div>arnost</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">út 12. 5. 2020 v 21:26 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">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" target="_blank">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"><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"><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><div id="gmail-m_-769752199588538615gmail-m_7905686014798021229DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid rgb(211,212,222)">
        <tbody><tr>
      <td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
                <td style="width:470px;padding-top:17px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Bez virů. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a>               </td>
        </tr>
</tbody></table>
<a href="#m_-769752199588538615_m_7905686014798021229_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>
</blockquote></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>