[midPoint] Using CSV resource for accounts import and management of them inside midPoint

[Konstantin Tikhonov]

Atdhe.

It’s a magic! 😊

I added a synchronization object via GUI and it’s configured exactly the same:

    <synchronization>
        <objectSynchronization>
            <objectClass>AccountObjectClass</objectClass>
            <kind>account</kind>
            <intent>Default</intent>
            <focusType>c:UserType</focusType>
            <enabled>true</enabled>
            <reconcile>false</reconcile>
        </objectSynchronization>
    </synchronization>

but was added after Capabilities section. Then I did Schema refresh and delete old shadows. And after that everything got worked!
Now I see all accounts in the CSV resource with Default intent and I’m able to assign it to users.

Thank you very much for your assistance!

--
Best Regards,

Konstantin Tikhonov

From: Konstantin Tikhonov
Sent: Friday, June 19, 2020 4:56 PM
To: midPoint General Discussion
Subject: RE: Using CSV resource for accounts import and management of them inside midPoint

Hello Atdhe.

Thank you very much for your help.

I tried to add your synchronization section to my CSV resource and when tried to save it got the error:

Attempt to store multiple values in single-valued property {http://midpoint.evolveum.com/xml/ns/public/common/common-3}synchronization

I attached XML of the current CSV resource to the email. What am I doing wrong?

Thank you in advance.

--
Best Regards,

Konstantin Tikhonov

From: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> On Behalf Of Musliu Atdhe
Sent: Friday, June 19, 2020 4:48 PM
To: 'midPoint General Discussion'
Subject: Re: [midPoint] Using CSV resource for accounts import and management of them inside midPoint

Hello Konstantin,
I added the Synchronization part on the CSV Connector, and then it worked.

<synchronization>
        <objectSynchronization>
            <name>Default</name>
            <objectClass>AccountObjectClass</objectClass>
            <kind>account</kind>
            <focusType>c:UserType</focusType>
            <enabled>true</enabled>
            <reconcile>false</reconcile>
        </objectSynchronization>
    </synchronization>

I don’t know if it should be like this or not.

Best Regards
Atdhe

—
—
Zürcher Hochschule der Künste
Zurich University of the Arts
—
Atdhe Musliu
Mitarbeiter Informationstechnologie-Zentrum
—
—
www.zhdk.ch<http://www.zhdk.ch>
http://www.zhdk.ch/?itz

Von: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> Im Auftrag von Musliu Atdhe
Gesendet: Friday, 19 June 2020 15:25
An: 'midPoint General Discussion' <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Betreff: Re: [midPoint] Using CSV resource for accounts import and management of them inside midPoint

Hello Konstantin,
Can you try and set  default to «true» in the SchemaHandling section, and then test it again.

Best Regards
Atdhe


—
—
Zürcher Hochschule der Künste
Zurich University of the Arts
—
Atdhe Musliu
Mitarbeiter Informationstechnologie-Zentrum
——
www.zhdk.ch<http://www.zhdk.ch>
http://www.zhdk.ch/?itz

Von: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> Im Auftrag von Konstantin Tikhonov
Gesendet: Wednesday, 17 June 2020 20:07
An: midPoint General Discussion <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Betreff: Re: [midPoint] Using CSV resource for accounts import and management of them inside midPoint

Hello Colleagues.

Thank you very much for your feedback. XML config of the resource is attached to the e-mail.

SchemaHandling part is configured but I didn’t configured Synchronization part because as far as I understood it’s related to automatic assigning to a user but we need to assign accounts to users manually on this step.

--
Best Regards,

Konstantin Tikhonov

From: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> On Behalf Of Musliu Atdhe
Sent: Saturday, June 13, 2020 9:48 PM
To: 'midPoint General Discussion'
Subject: Re: [midPoint] Using CSV resource for accounts import and management of them inside midPoint

Hello Konstantin,
Could you send your Resource XML File?
Maybe the Synchronization part is missing or even the SchemaHandling part.

https://wiki.evolveum.com/display/midPoint/Synchronization+Configuration
https://wiki.evolveum.com/display/midPoint/Resource+Schema+Handling

Best Regards
Atdhe
—
—
Zürcher Hochschule der Künste
Zurich University of the Arts
—
Atdhe Musliu
Mitarbeiter Informationstechnologie-Zentrum
——
www.zhdk.ch<http://www.zhdk.ch>
http://www.zhdk.ch/?itz

Von: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> Im Auftrag von Konstantin Tikhonov
Gesendet: Sunday, 7 June 2020 23:30
An: midPoint General Discussion <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Betreff: [midPoint] Using CSV resource for accounts import and management of them inside midPoint

Hello Colleagues.

We have the following task: a system exports a list of its accounts to a CSV file, then midPoint imports the list and after that an administrator assigns the accounts to users in midPoint or assignment can be done in some automatic way. I could find mention of similar functionality in Semi-Manual resource description<https://wiki.evolveum.com/display/midPoint/Manual+Resource+and+ITSM+Integration> only. But the document doesn’t describe how this should be configured in midPoint.

I tried to find it out myself. I created a CSV resource and saw accounts from CSV file but the accounts appeared only in the Resource section of the CSV resource (screenshot attached), no any mention of them in the Repository section. And when I tried to Change Owner for any of the accounts I got the error “No projection definition for kind=UNKNOWN intent=unknown in resource:3b21495d-cc1d-47a8-8f7a-e1f1a02d2c24(Test CSV System 1)”.

Could you please let me know what I do wrong? And what are the main steps in midPoint to solve this task?

Thanks a lot in advance.

--
Best Regards,

Konstantin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20200619/7d2af33a/attachment.htm>