<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div dir="auto">You could sync the attributes to a user schema extension then assign object template to add/remove assignments based on those. </div>
<div dir="auto">
<div id="br-id-d2aee89b-5e45-4a7d-94d6-79000091bee1" dir="auto"><br>
</div>
</div>
<div dir="auto" style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255);">
<br>
</div>
<div dir="auto" style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255);">
Also on another note, I was thinking about this today, we utilize quite a few scripted sql connectors and it's basically just groovy scripts returning results. It looks to be quite easy to use scripted sql as a scripted rest type resource or any other resource
for that matter as long as the scripts ypu write return what midpoint is expecting. Anybody ever try to do that or is there something preventing that to happen?</div>
<div dir="auto" style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255);">
<br>
</div>
<div dir="auto" style="color: rgb(33, 33, 33); background-color: rgb(255, 255, 255);">
Jason</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> midPoint <midpoint-bounces@lists.evolveum.com> on behalf of Marvel Krafts via midPoint <midpoint@lists.evolveum.com><br>
<b>Sent:</b> Thursday, September 29, 2022 9:49:17 AM<br>
<b>To:</b> Fabian Noll-Dukiewicz <fabian.noll-dukiewicz@fndit.de><br>
<b>Cc:</b> Marvel Krafts <marvel.krafts@gmail.com>; MidPoint Mailing List <midpoint@lists.evolveum.com><br>
<b>Subject:</b> Re: [midPoint] CSV Entitlements</font>
<div> </div>
</div>
<div>
<div dir="ltr">Thanks. Is there an example I can refer to? I am not sure how to go about doing this. Apparently the CSV connector does not have "association" functionality as well. Basically, I want to import the user and their entitlements (it's one-to-one,
that is each account will have one entitlement only).
<div><br>
</div>
<div>Example:</div>
<div><br>
</div>
<div>user1, admin</div>
<div>user2, developer</div>
<div>user3, analyst</div>
<div>user4, admin</div>
<div>user5, tester</div>
<div><br>
</div>
<div>-Thanks</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Wed, Sep 28, 2022 at 7:10 AM Fabian Noll-Dukiewicz <<a href="mailto:fabian.noll-dukiewicz@fndit.de">fabian.noll-dukiewicz@fndit.de</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="x_msg1488663451556341102">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi Marvel,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I think csv resource is just for account object class. but you can try to use schema handling and synchronization sections to import user and import entitlements (as role type).</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
The other way is that you create two resources using the same file. The first handles user objects and the second one handles the entitlements.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Good luck!</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Kind regards</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Fabian</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
--</div>
<div id="x_m_-3553542354393074073Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<b><span style="font-size:10pt; font-family:Verdana,sans-serif; margin:0px; color:black">Fabian Noll-Dukiewicz</span></b><b><span style="font-family:Verdana,sans-serif; margin:0px; color:black"></span></b></p>
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<i><span style="font-size:10pt; font-family:Verdana,sans-serif; margin:0px; color:black">Spezialist Identity & Access Management | Geschäftsführer</span></i></p>
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span lang="en-US" style="font-size:10pt; font-family:Verdana,sans-serif; margin:0px; color:black">Tel.: +49 152 244 63 211</span></p>
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span lang="en-US" style="font-size:10pt; font-family:Verdana,sans-serif; margin:0px; color:black">Email:<span style="margin:0px"> </span><a href="mailto:fabian.noll-dukiewicz@fndit.de" rel="noopener noreferrer" target="_blank" style="margin:0px">fabian.noll-dukiewicz@fndit.de</a></span></p>
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-size:10pt; font-family:Verdana,sans-serif; margin:0px; color:black">Web:<span style="margin:0px"> </span><a href="https://www.fndit.de/" rel="noopener noreferrer" target="_blank" style="margin:0px">https://www.fndit.de</a></span></p>
</div>
</div>
</div>
</div>
<div>
<div id="x_m_-3553542354393074073signature_bookmark"></div>
<div id="x_m_-3553542354393074073appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr style="display:inline-block; width:98%">
<div id="x_m_-3553542354393074073divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>Von:</b> Marvel Krafts <<a href="mailto:marvel.krafts@gmail.com" target="_blank">marvel.krafts@gmail.com</a>><br>
<b>Gesendet:</b> Dienstag, 27. September 2022 20:42<br>
<b>An:</b> midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
<b>Betreff:</b> [midPoint] CSV Entitlements</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hello,
<div><br>
</div>
<div>I have a CSV with 2 columns username and entitlement. How do I import entitlements from CSV for each account in the resource? I could import the accounts into the resource but not sure how to go about importing the entitlements. Appreciate any help.</div>
<div><br>
</div>
<div>Thanks</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</body>
</html>