[midPoint] CSV Entitlements

[Jason Everling]

You could sync the attributes to a user schema extension then assign object template to add/remove assignments based on those.


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?

Jason
________________________________
From: midPoint <midpoint-bounces at lists.evolveum.com> on behalf of Marvel Krafts via midPoint <midpoint at lists.evolveum.com>
Sent: Thursday, September 29, 2022 9:49:17 AM
To: Fabian Noll-Dukiewicz <fabian.noll-dukiewicz at fndit.de>
Cc: Marvel Krafts <marvel.krafts at gmail.com>; MidPoint Mailing List <midpoint at lists.evolveum.com>
Subject: Re: [midPoint] CSV Entitlements

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).

Example:

user1, admin
user2, developer
user3, analyst
user4, admin
user5, tester

-Thanks

On Wed, Sep 28, 2022 at 7:10 AM Fabian Noll-Dukiewicz <fabian.noll-dukiewicz at fndit.de<mailto:fabian.noll-dukiewicz at fndit.de>> wrote:
Hi Marvel,

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).

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.

Good luck!

Kind regards
Fabian

--

Fabian Noll-Dukiewicz

Spezialist Identity & Access Management | Geschäftsführer

Tel.: +49 152 244 63 211

Email: fabian.noll-dukiewicz at fndit.de<mailto:fabian.noll-dukiewicz at fndit.de>

Web: https://www.fndit.de<https://www.fndit.de/>

________________________________
Von: Marvel Krafts <marvel.krafts at gmail.com<mailto:marvel.krafts at gmail.com>>
Gesendet: Dienstag, 27. September 2022 20:42
An: midPoint General Discussion <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Betreff: [midPoint] CSV Entitlements

Hello,

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.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220929/291626f3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 16644930938612009085933511184243.png
Type: image/png
Size: 9612 bytes
Desc: 16644930938612009085933511184243.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220929/291626f3/attachment.png>