<div dir="ltr">Ok thanks, I was just wondering if I was doing something wrong. I am trying to keep the same schema for it but I keep finding new things to add since I can basically push any of that info into other systems now.<div><br></div><div>JASON</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 10, 2015 at 10:52 AM, Ivan Noris <span dir="ltr"><<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Jason,<br>
<span class=""><br>
On 03/10/2015 04:09 PM, Jason Everling wrote:<br>
</span><div><div class="h5">> I have been doing this quite often (testing and since I can basically<br>
> put any data/attribute into midPoint I keep finding new things to add)<br>
> but in an ugly way. If I were to add new attributes or in CSV terms<br>
> "columns" to my CSV file and edit the resource then the task errors<br>
> out. It takes a little bit of doing but eventually I get it going again.<br>
><br>
> Is there a way or steps I should take when doing this that would go as<br>
> smoothly as possible?<br>
><br>
> JASON<br>
<br>
</div></div>I was trying to find a better way, but so far only this has come out:<br>
<br>
1. if the resource is used for LiveSync, stop the task after all changes<br>
are processed<br>
- this means you will not be able to sync from that resource now<br>
2. modify the .csv file (add new columns) header<br>
3. modify the .csv file (add new columns) content - add empty values<br>
- empty values to avoid running reconciliation or import from resource;<br>
instead of empty values you may want to add the real values and use<br>
import from resource or reconciliation to avoid step 10<br>
4. remove old files used for synchronization (filename.csv.*)<br>
- the old diff files have different number of columns<br>
5. edit task in midPoint - Repository objects - Task and remove<br>
"<extension> .. </extension>" containing the last token (file timestamp)<br>
used for sync<br>
- this means the sync will start right after starting the LiveSync task<br>
and when first change is detected<br>
6. update resource - schema handling (if necessary)<br>
- otherwise you cannot use any of the new attributes from the resource<br>
to fill any midPoint attributes<br>
7a. edit the resource in midPoint and delete <schema> .. </schema><br>
contents OR<br>
7b. reimport the resource definition if there is no schema defined in<br>
resource on disk<br>
8. test connection for the CSV resource. It will create<br>
<schema>..</schema> in resource<br>
9. resume LiveSync task<br>
- LiveSync will start now - as no previous diff file exists, it will<br>
create one and start to poll for changes<br>
10. modify the .csv file - add real values for new columns<br>
- this will cause LiveSync to actually process the new values. To avoid<br>
this, in step 3 you can use import from file/reconciliation instead of<br>
the LiveSync and only after that start the LiveSync task<br>
<br>
It's ... well, ugly. But CSV connector has its limitations.<br>
<br>
For target resource, all you need to do is to alter the schema handling<br>
in the resource, drop the <schema>..</schema>, edit the .csv columns and<br>
add at least empty values for all lines to correspond with the header.<br>
<br>
Regards,<br>
Ivan<br>
<div class="HOEnZb"><div class="h5"><br>
--<br>
Ing. Ivan Noris<br>
Senior Identity Management Engineer & IDM Architect<br>
<a href="http://evolveum.com" target="_blank">evolveum.com</a> <a href="http://evolveum.com/blog/" target="_blank">evolveum.com/blog/</a><br>
___________________________________________________<br>
"Semper Id(e)M Vix."<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</div></div></blockquote></div><br></div>
<br>
<font size="2"><br><br>CONFIDENTIALITY NOTICE:<br>This e-mail together with any attachments is proprietary and confidential; intended for only the recipient(s) named above and may contain information that is privileged. You should not retain, copy or use this e-mail or any attachments for any purpose, or disclose all or any part of the contents to any person. Any views or opinions expressed in this e-mail are those of the author and do not represent those of the Baptist School of Health Professions. If you have received this e-mail in error, or are not the named recipient(s), you are hereby notified that any review, dissemination, distribution or copying of this communication is prohibited by the sender and to do so might constitute a violation of the Electronic Communications Privacy Act, 18 U.S.C. section 2510-2521. Please immediately notify the sender and delete this e-mail and any attachments from your computer. </font><br>