User import to clear manager field

[JJack]

Hi,
We have an update user import, using a csv file and goDb2HUserImport.
This includes setting the user's manager to a value based on the csv file.
The setting of the manager field involves a look up. If the input manager value is blank, the Hornbill account would stay as it is, ie become out of date.
I'm not aware of any change I can make to get it to set it to a value based on the input file unless that's blank, in which case clear the existing value.
"ProfileMapping":{
"Manager":"{{.MGREMPNUM}}",
…
"Manager":{
        "Action": "Both"
        , "Value": "{{.MGREMPNUM}}"    
        , "Options": {
            "GetStringFromValue": {
                "Regex" : ""
                , "Reverse": false
            }
            , "MatchAgainstDistinguishedName": false
            , "Search": {
                "Enable": true
                , "SearchField": "h_user_id"
            }
Suggestions gratefully received. I'm trying to avoid a special separate extra run prior to our standard run just to clear values.

[Steve Giller]

Have you tried using the "__clear__" value to empty the field?

[JJack]

Hi @Steve Giller, Yes. I have tried putting this in the profilemapping section and the manager section but it has no effect that I can see - so even a separate run just to clear the values before a second run populated them again wouldn't work. Should this work?

I have a similar requirement to clear organisational levels.

If use of __clear__ is something brought in in a recent executables updates, we may not be on the latest version and so would have to wait until we bring ourselves up to date.

Thanks, Jill.

 

[Steve Giller]

Hi @JJack

If you're on version 4.x this should auto-update (until v.5.x is released, anyway!)

If you're on version 3.x this is deprecated, may well stop working at any time, and we would strongly recommend updating as soon as possible.