<div dir="ltr">Hi,<div><br></div><div>I have ScriptedSQL Connector. I am getting organization structure from database these attrbutes: name, displayName and parentOrgRef</div><div>I tried import and reconciliation type tasks, Shadows are creating successfully but Organizations are not creating. </div><div>I tried both <kind>account</kind> and <kind>generic</kind> on SchemaHandling. Nothing changes. </div><div>How can I import or reconcile organizations and build organization structure  from database? My datas are as follows:</div><div><br></div><div><div>id<span class="gmail-Apple-tab-span" style="white-space:pre">                            </span>name<span class="gmail-Apple-tab-span" style="white-space:pre">                                              </span>parent_id</div><div>0101<span class="gmail-Apple-tab-span" style="white-space:pre">                    </span>XXX.A.Ş.<span class="gmail-Apple-tab-span" style="white-space:pre">                                                       </span>0000</div><div>0102<span class="gmail-Apple-tab-span" style="white-space:pre">                     YYY</span> A.Ş.<span class="gmail-Apple-tab-span" style="white-space:pre">                                                      </span>0000</div><div>0103<span class="gmail-Apple-tab-span" style="white-space:pre">                     ZZZ</span> A.Ş.<span class="gmail-Apple-tab-span" style="white-space:pre">                                                      </span>0000</div><div>0200<span class="gmail-Apple-tab-span" style="white-space:pre">                     CCCCC</span> AŞ<span class="gmail-Apple-tab-span" style="white-space:pre">                                              </span>0000</div><div>0201<span class="gmail-Apple-tab-span" style="white-space:pre">                       </span>SSSSSS<span class="gmail-Apple-tab-span" style="white-space:pre">                                                </span>0000</div><div>50001365<span class="gmail-Apple-tab-span" style="white-space:pre">         </span>MANAGEMENT<span class="gmail-Apple-tab-span" style="white-space:pre">                                      </span>0101</div><div>50001366<span class="gmail-Apple-tab-span" style="white-space:pre">         </span>ASİSTANCE<span class="gmail-Apple-tab-span" style="white-space:pre">                                              </span>0101</div><div>50001367<span class="gmail-Apple-tab-span" style="white-space:pre">         </span><span class="gmail-Apple-tab-span">DRIVERS </span><span class="gmail-Apple-tab-span" style="white-space:pre">                                               </span>0101</div><div>50002780<span class="gmail-Apple-tab-span" style="white-space:pre">         </span>COMMUNICATION<span class="gmail-Apple-tab-span" style="white-space:pre">                                   </span>0102</div><div>50004775<span class="gmail-Apple-tab-span" style="white-space:pre">         </span>MANAGEMENT<span class="gmail-Apple-tab-span" style="white-space:pre">                   </span><span class="gmail-Apple-tab-span" style="white-space:pre">                 </span>0102</div><div>50006930<span class="gmail-Apple-tab-span" style="white-space:pre">         </span>MANAGEMENT<span class="gmail-Apple-tab-span" style="white-space:pre">                   </span><span class="gmail-Apple-tab-span" style="white-space:pre">                 </span>0103</div></div><div><br></div><div><div>   <xsd:complexType name="CustomOrganizationObjectClass"></div><div>               <xsd:annotation></div><div>                  <xsd:appinfo></div><div>                     <ra:resourceObject/></div><div>                     <ra:identifier>icfs:uid</ra:identifier></div><div>                     <ra:secondaryIdentifier>icfs:name</ra:secondaryIdentifier></div><div>                     <ra:displayNameAttribute>icfs:name</ra:displayNameAttribute></div><div>                     <ra:namingAttribute>icfs:name</ra:namingAttribute></div><div>                     <ra:nativeObjectClass>Organization</ra:nativeObjectClass></div><div>                  </xsd:appinfo></div><div>               </xsd:annotation></div><div>               <xsd:sequence></div><div>                  <xsd:element minOccurs="0" name="displayName" type="xsd:string"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayOrder>120</a:displayOrder></div><div>                           <ra:frameworkAttributeName>displayName</ra:frameworkAttributeName></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>                  <xsd:element minOccurs="0" name="parentOrg" type="xsd:string"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayOrder>130</a:displayOrder></div><div>                           <ra:frameworkAttributeName>parentOrg</ra:frameworkAttributeName></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>                  <xsd:element minOccurs="0" name="description" type="xsd:string"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayOrder>140</a:displayOrder></div><div>                           <ra:frameworkAttributeName>description</ra:frameworkAttributeName></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>                  <xsd:element ref="icfs:name"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayName>ConnId Name</a:displayName></div><div>                           <a:displayOrder>110</a:displayOrder></div><div>                           <ra:frameworkAttributeName>__NAME__</ra:frameworkAttributeName></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>                  <xsd:element minOccurs="0" name="name" type="xsd:string"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayOrder>150</a:displayOrder></div><div>                           <ra:frameworkAttributeName>name</ra:frameworkAttributeName></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>                  <xsd:element minOccurs="0" ref="icfs:uid"></div><div>                     <xsd:annotation></div><div>                        <xsd:appinfo></div><div>                           <a:displayName>ConnId UID</a:displayName></div><div>                           <a:displayOrder>100</a:displayOrder></div><div>                           <a:access>read</a:access></div><div>                        </xsd:appinfo></div><div>                     </xsd:annotation></div><div>                  </xsd:element></div><div>               </xsd:sequence></div><div>            </xsd:complexType></div></div><div><br></div><div><br></div><div><div>  <schemaHandling></div><div>      <objectType></div><div>         <kind>account</kind></div><div>         <displayName>OrgType</displayName></div><div>         <default>true</default></div><div>         <objectClass>ri:CustomOrganizationObjectClass</objectClass></div><div>         <attribute></div><div>            <c:ref>icfs:uid</c:ref></div><div>            <displayName>Entry UUID</displayName></div><div>            <limitations></div><div>               <access></div><div>                  <read>true</read></div><div>               </access></div><div>            </limitations></div><div>         </attribute></div><div>         <attribute></div><div>            <c:ref>icfs:name</c:ref></div><div>            <displayName>Organization Id</displayName></div><div>            <limitations></div><div>               <minOccurs>0</minOccurs></div><div>               <access></div><div>                  <read>true</read></div><div>                  <add>true</add></div><div>                  <modify>true</modify></div><div>               </access></div><div>            </limitations></div><div>            <tolerant>false</tolerant></div><div>            <exclusiveStrong>false</exclusiveStrong></div><div>            <outbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <source></div><div>                  <c:path>$focus/name</c:path></div><div>               </source></div><div>            </outbound></div><div>            <inbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <target></div><div>                  <c:path>$focus/name</c:path></div><div>               </target></div><div>            </inbound></div><div>         </attribute></div><div>         <attribute></div><div>            <c:ref>ri:name</c:ref></div><div>            <displayName>Organization Name</displayName></div><div>            <tolerant>false</tolerant></div><div>            <exclusiveStrong>false</exclusiveStrong></div><div>            <outbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <source></div><div>                  <c:path>$focus/displayName</c:path></div><div>               </source></div><div>            </outbound></div><div>            <inbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <target></div><div>                  <c:path>$focus/displayName</c:path></div><div>               </target></div><div>            </inbound></div><div>         </attribute></div><div>         <attribute></div><div>            <c:ref>ri:parentOrg</c:ref></div><div>            <displayName>Parent Org Id</displayName></div><div>            <tolerant>false</tolerant></div><div>            <exclusiveStrong>false</exclusiveStrong></div><div>            <outbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <source></div><div>                  <c:path>$focus/costCenter</c:path></div><div>               </source></div><div>            </outbound></div><div>            <inbound></div><div>               <authoritative>true</authoritative></div><div>               <exclusive>false</exclusive></div><div>               <strength>normal</strength></div><div>               <target></div><div>                  <c:path>$focus/costCenter</c:path></div><div>               </target></div><div>            </inbound></div><div>         </attribute></div><div>      </objectType></div><div>   </schemaHandling></div><div>   <capabilities></div><div>      <cachingMetadata></div><div>         <retrievalTimestamp>2017-01-18T14:32:39.006+02:00</retrievalTimestamp></div><div>         <serialNumber>31a0960a98ab18d-4afc49b08ce181c6</serialNumber></div><div>      </cachingMetadata></div><div>      <native xmlns:cap="<a href="http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3">http://midpoint.evolveum.com/xml/ns/public/resource/capabilities-3</a>"></div><div>         <cap:addRemoveAttributeValues/></div><div>         <cap:activation></div><div>            <cap:status/></div><div>            <cap:lockoutStatus/></div><div>         </cap:activation></div><div>         <cap:credentials></div><div>            <cap:password></div><div>               <cap:returnedByDefault>false</cap:returnedByDefault></div><div>            </cap:password></div><div>         </cap:credentials></div><div>         <cap:liveSync/></div><div>         <cap:testConnection/></div><div>         <cap:create/></div><div>         <cap:read/></div><div>         <cap:update/></div><div>         <cap:delete/></div><div>         <cap:script></div><div>            <cap:host></div><div>               <cap:type>connector</cap:type></div><div>            </cap:host></div><div>         </cap:script></div><div>      </native></div><div>   </capabilities></div><div>   <synchronization></div><div>      <objectSynchronization></div><div>         <name>Org Unit</name></div><div>         <objectClass>ri:CustomOrganizationObjectClass</objectClass></div><div>         <kind>account</kind></div><div>         <intent>default</intent></div><div>         <focusType>c:OrgType</focusType></div><div>         <enabled>true</enabled></div><div>         <correlation></div><div>            <q:description>Correlation expression.</q:description></div><div>            <q:equal></div><div>               <q:path>c:name</q:path></div><div>               <expression></div><div>                  <c:path>declare namespace icfs='<a href="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/resource-schema-3">http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/resource-schema-3</a>'; $shadow/attributes/icfs:name</c:path></div><div>               </expression></div><div>            </q:equal></div><div>         </correlation></div><div>         <reconcile>false</reconcile></div><div>         <reaction></div><div>            <name>Linked</name></div><div>            <situation>linked</situation></div><div>            <synchronize>true</synchronize></div><div>            <reconcile>false</reconcile></div><div>         </reaction></div><div>         <reaction></div><div>            <name>Deleted</name></div><div>            <situation>deleted</situation></div><div>            <synchronize>true</synchronize></div><div>            <reconcile>false</reconcile></div><div>            <action></div><div>               <name>Unlink</name></div><div>               <handlerUri></div><div><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink">http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink</a></div><div></handlerUri></div><div>            </action></div><div>         </reaction></div><div>         <reaction></div><div>            <name>Unlinked</name></div><div>            <situation>unlinked</situation></div><div>            <synchronize>true</synchronize></div><div>            <reconcile>false</reconcile></div><div>            <action></div><div>               <name>Link</name></div><div>               <handlerUri></div><div><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#link">http://midpoint.evolveum.com/xml/ns/public/model/action-3#link</a></div><div></handlerUri></div><div>            </action></div><div>         </reaction></div><div>         <reaction></div><div>            <name>Unmatched</name></div><div>            <situation>unmatched</situation></div><div>            <synchronize>true</synchronize></div><div>            <reconcile>false</reconcile></div><div>            <objectTemplateRef oid="c0c010c0-d34d-b33f-f00d-777222555111" type="c:ObjectTemplateType"/></div><div>            <action></div><div>               <name>Add focus</name></div><div>               <handlerUri></div><div><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#addFocus">http://midpoint.evolveum.com/xml/ns/public/model/action-3#addFocus</a></div><div></handlerUri></div><div>            </action></div><div>         </reaction></div><div>      </objectSynchronization></div></div><div><br></div><div><br></div><div><br></div><div><br></div></div>