How to change properties by import using “find and replace” functionality with GALsync.

25 May

It is possible that you would like to change properties during an import with GALsync. You do this by going to the property settings and choosing a property you want to change and then to choose how you want to modify this property.

We will have a look at how to do this with the “find and replace” option in this blog entry. For example, the property “title” of your partner company from Germany can contain titles that are not common in the rest of the world and you wish to change these titles during an import.

The first possibility is to replace the exact value with another exact value. If you want to change the German title “Geschäftsführer” to “managing director” you can put “Geschäftsführer” in the find field and “managing director” in the replace field. This will cause GALsync to change all titles that exactly match “Geschäftsführer” to “managing director” during an import.

Paul 1.pdf

GALsync is case sensitive here. If you require that GALsync finds both “Geschäftsführer” and “geschäftsführer”, then you can use regular expressions und put (?i) in front of your matching criteria. In this example, it would look like this: “(?i)Geschäftsführer”

Paul 2

If you choose to let the “Replace” field empty, GALsync will “remove” the matching criteria from the result. For example, if you want to remove “director” from all titles like “sales director” and “business director”, then you need to put “ director” in to the find field and leave replace field empty.

Paul 3

The second possibility is to use the “end with” logic. In this example, we will merge all developer titles during the import, so “software developer” and “other developer” titles are imported both as “developer”.  Here we will also use regular expressions and put „.* developer$“ in to the find field and “developer” in to the replace field.

Paul 4

The third possibility is to use the “starts with” logic. In this example, we will merge all “software” titles during the import, so “software developer” and “software tester” titles are both imported as “IT”.  Here we will use regular expressions again and put “^software.*” in to the find field and “IT” in to the replace field.

Paul 5

There are many other possibilities. You can try it out with regular expressions checker if you want. For example, check this website https://myregextester.com/index.php

NOTE: Please make sure to choose properties which are valid for the object type you want to change. For example, groups don’t have the property “given name”.

For more information please have a look at the GALsync manual:   http://www.netsec.de/fileadmin/download/GALsync/GALsync_Manual_EN.pdf

Leave a Reply

Your email address will not be published. Required fields are marked *