ESP Image Converter Tool failed

[grahambird80]

Hello All,

I have configured LDAP import from Active Directory to Hornbill and we want to import the Photo's that we store in AD to Hornbill, however I am getting this error message;

[DEBUG] User Proflile Image Set: username
[DEBUG] DAV Upload URL: https://mdh-p01-api.hornbill.com/instance/dav/session/username.png
[DEBUG] Profile Set Image URL: /session/username.png
[DEBUG] Profile Image Set XML <params><objectRef>urn:sys:user:edevos</objectRef><sourceImage>/session/username.png</sourceImage></params>
[ERROR] Unable to Update User Image: edevos Error: ESP Image Converter Tool failed

This is the same if I select JPG or PNG

Anyone got this working from Active Directory?

Cheers,

Graham

[Steve G]

Hi @grahambird80,

This was caused by a bug in the tool, which I've fixed this morning. You can pull the latest version of the tool (v3.1.4) from here:

https://github.com/hornbill/goLDAPUserImport/releases/tag/3.1.4

No changes are required to the config, so just replace the executable with your specific platform variant and it should just work

Let me know how you get on with it.

Cheers,
Steve

[grahambird80]

Hello Steve,

I have downloaded the latest version of the LDAP tool however i am still getting the same error :-(

To confirm I have configured the LDAP as per the Wiki - https://wiki.hornbill.com/index.php/LDAP_User_Import and I am using the thumbnailPhoto attribute

I have tried with JPG and PNG set but still get the same error.

2018/11/12 11:40:31 [DEBUG] User Proflile Image Set: smakop
2018/11/12 11:40:31 [DEBUG] DAV Upload URL: https://mdh-p01-api.hornbill.com/spiritenergy/dav/session/smakop.jpg
2018/11/12 11:40:31 [DEBUG] Profile Set Image URL: /session/smakop.jpg
2018/11/12 11:40:31 [DEBUG] Profile Image Set XML <params><objectRef>urn:sys:user:smakop</objectRef><sourceImage>/session/smakop.jpg</sourceImage></params>
2018/11/12 11:40:31 [ERROR] Unable to Update User Image: smakop Error: ESP Image Converter Tool failed
 

 

[Steve G]

Hi @grahambird80,

That error is being returned as the data being written to the image files in the session cannot be converted by the platform, so I wonder what data is being written into them... Can you please send me a copy of your config JSON from within the Debug tab of the data import config, and I'll make sure everything is as it should be with that.

Kind regards,
Steve

[grahambird80]

Hi @Steve Goldthorpe

Here is the JSON for the LDAP Import;

{
  "version": 4,
  "User": {
    "AccountMapping": {
      "UserId": "[sAMAccountName]",
      "UserType": "basic",
      "Name": "[cn]",
      "Password": "",
      "FirstName": "[givenName]",
      "LastName": "[sn]",
      "JobTitle": "[title]",
      "Site": "[extensionAttribute12]",
      "Phone": "[telephoneNumber]",
      "Email": "[extensionAttribute11]",
      "Mobile": "[mobile]",
      "AbsenceMessage": "",
      "TimeZone": "W. Europe Standard Time",
      "Language": "",
      "DateTimeFormat": "dd/MM/yy HH:mm",
      "DateFormat": "dd/MM/yy",
      "TimeFormat": "HH:mm",
      "CurrencySymbol": "€",
      "CountryCode": "[c]"
    },
    "UserDN": "[distinguishedName]",
    "Type": {
      "Action": "Create",
      "Value": "user"
    },
    "Status": {
      "Action": "None",
      "Value": "active"
    },
    "Role": {
      "Action": "Create",
      "Roles": [
        "Basic User Role",
        "Self Service User"
      ]
    },
    "ProfileMapping": {},
    "Manager": {
      "Action": "Both",
      "Value": "[manager]",
      "Options": {
        "GetStringFromValue": {
          "Reverse": false,
          "Regex": "CN=(.*?)(?:,[A-Z]+=|$)"
        },
        "MatchAgainstDistinguishedName": false,
        "Search": {
          "Enable": false
        }
      }
    },
    "Image": {
      "Action": "Both",
      "UploadType": "AD",
      "InsecureSkipVerify": false,
      "ImageType": "jpg",
      "Value": "[thumbnailPhoto]",
      "URI": "thumbnailPhoto"
    },
    "Site": {
      "Action": "Both",
      "Value": "[extensionAttribute12]"
    },
    "Org": [
      {
        "Action": "Both",
        "Value": "[co]",
        "MemberOf": "",
        "Options": {
          "Type": 4,
          "Membership": "member",
          "TasksView": true,
          "TasksAction": true,
          "OnlyOneGroupAssignment": false
        }
      }
    ]
  },
  "LDAP": {
    "Server": {
      "keySafeID": 1,
      "InsecureSkipVerify": false,
      "Debug": true,
      "ConnectionType": ""
    },
    "Query": {
      "Attributes": [
        "cn",
        "distinguishedName",
        "sn",
        "telephoneNumber",
        "mobile",
        "sAMAccountName",
        "userPrincipalName",
        "givenName",
        "description",
        "department",
        "manager",
        "thumbnailPhoto",
        "extensionAttribute11",
        "employeeID",
        "title",
        "c",
        "extensionAttribute12",
        "co",
        "jpegPhoto"
      ],
      "Scope": 2,
      "DerefAliases": 1,
      "TypesOnly": false,
      "SizeLimit": 0,
      "TimeLimit": 0,
      "Filter": "(&(objectClass=user)(division=Standard))",
      "DSN": "OU=NAME,DC=DOMAIN,DC=COM"
    }
  },
  "Advanced": {
    "LogLevel": 1,
    "LogRetention": 0,
    "PageSize": 500
  },
  "Actions": [
    {
      "Action": "None",
      "Value": "[department]",
      "Options": {
        "regexValue": ""
      },
      "Output": "department"
    }
  ]
}

 

[Steve G]

Hi @grahambird80,

The value of Image > URI is incorrect. It's currently set to thumbnailPhoto, but this needs wrapping with square brackets [thumbnailPhoto] otherwise no data mapping will take place and the tool will assume the string thumbnailPhoto is the image data  :

 

So in your config in the admin console should look like this:

 

So correcting that should fix your issue, as long as the image data stored in the thumbnailPhoto attribute is JPG.

Let me know how you get on.

Steve

[grahambird80]

Hi @Steve G

OK I wondered about this but the instructions on the Wiki said to leave the [] off 

https://wiki.hornbill.com/index.php/LDAP_User_Import

I have added the attribute again by selecting if from the picker and everyting is now working!

Cheers,

Graham

[Steve G]

Hi @grahambird80 ,

Glad to hear that's working now,  I'll go and  correct the documentation

Cheers,
Steve