<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hello Martin,<br>
<br>
looking at DatabaseTableConnector source code it seems that the
Name attribute has always the same value as the Uid property. This
value is take from the column specified by the KeyColumn
configuration parameter.<br>
<br>
So unless you hack the connector source, it is not possible to
have Uid bound to ID column, and Name to other column.<br>
<br>
As for the <ra:displayNameAttribute>, I suspect it is not
currently used in midPoint (maybe someone on this list would
correct me).<br>
And I'm afraid that currently there is no way how to see names in
the list of accounts, unless you use UserName as the KeyColumn.<br>
<br>
Best regards,<br>
Pavol<br>
<br>
<br>
On 26. 3. 2015 19:48, Martin Lízner - AMI Praha a.s. wrote:<br>
</div>
<blockquote
cite="mid:CALOh8eN9uua3Ht1qPfTi1sDKH5T-1Cn8RhEd6rBhQ6gLqbsp2g@mail.gmail.com"
type="cite">
<div dir="ltr">Hi, Im using midPoint 3.1
with org.identityconnectors.databasetable.DatabaseTableConnector 1.4.0.49
connector. I have simple table with:
<div>- immutable <b>ID column</b> (int) - which i set as Key
column and</div>
<div>- <b>UserName</b> column as username (Varchar).</div>
<div><br>
</div>
<div>The ID column is implicitly mapped to <b>icfs:uid</b>,
which is fine. But same ID has also been populated to <b>icfs:name</b>
attribute.</div>
<div><br>
</div>
<div>- I would like to set icfs:name with UserName column value,
any idea how to do that?</div>
<div>- My goal is to display db table accounts under their
usernames rather than int IDs. I tried setting
the <ra:displayNameAttribute> in resource XML but not to
much benefit...</div>
<div><br>
</div>
<div><img src="cid:part1.07060801.04080307@evolveum.com"
alt="Vložený obrázek 1" height="73" width="545"><br>
</div>
<div><br>
</div>
<div>Thank You, Martin</div>
<div><br>
</div>
<div>
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>
<table
style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important">
<tbody>
<tr style="padding:0px;margin:0px;border:0px solid
gray!important">
<td colspan="2"
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px
solid gray!important">
<p><span
style="font-size:14px;font-weight:bold">Martin
Lízner</span><br>
solution architect<br>
<br>
gsm: [+420] 737 745 571<br>
e-mail: <a moz-do-not-send="true"
href="mailto:jmeno.prijmeni@ami.cz"
target="_blank">martin.lizner@ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px
solid gray!important">
<p>AMI Praha a.s.<br>
Pláničkova 11<br>
162 00 Praha 6<br>
tel.: [+420] 274 783 239<br>
web: <a moz-do-not-send="true"
href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p>
</td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"> </td>
<td
style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;margin:8px;border:0px
solid gray!important">
<p><img moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/ami_logo.gif"
alt="" style="border: 0px;"></p>
</td>
</tr>
<tr style="padding:0px;margin:0px;border:0px solid
gray!important">
<td colspan="8"
style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px
solid gray!important"><br>
<a moz-do-not-send="true"
href="http://www.ami.cz/reseni-a-sluzby/bezpecnost-dat/audit-roli-a-opravneni-sap"
target="_blank"><img moz-do-not-send="true"
src="http://www.ami.cz/images/podpis/AMI-podpis-AuditSAP_1.png" alt=""
style="border: 0px; width: 480px; height:
82px;"></a></td>
</tr>
<tr style="padding:0px;margin:0px;border:0px solid
gray!important">
<td colspan="8"
style="color:rgb(128,128,128);font-family:Arial,sans-serif;font-size:11px;padding:0px;border:0px
solid gray!important"><br>
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.</td>
</tr>
</tbody>
</table>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
</body>
</html>