Departments with & symbol not syncing

[Lightsource]

We use AD sync to bring across the department into hornbill customers. if its got an & symble it wont bring it across and we need to do this manually in hornbill

[Steve G]

Hi @Lightsource,

When you say you're using AD sync to add the department in to Hornbill customers, what mechanism are you using to get those in to Hornbill? Are you using one of our import tools to perform this, or an external script? At what point is this actually failing?

Thanks,

Steve

[Lightsource]

13 minutes ago, Steve G said:

Hi @Lightsource,

When you say you're using AD sync to add the department in to Hornbill customers, what mechanism are you using to get those in to Hornbill? Are you using one of our import tools to perform this, or an external script? At what point is this actually failing?

Thanks,

Steve

We are using the hornbill LDAP import tool. 

The tool its self doesn't fail and the users and their details appear to come across, except in the case of those who have the "&" symbol in there department. it will bring across everything except their department. 

[Steve G]

@Lightsource Ah ok, I'll have a look at replicating this in the tool now, and will let you know how I get on.

Thanks,

Steve

[Steve G]

@Lightsource I've just attempted to replicate this issue, and have been unable to  I have a user in my test domain, who has a department of Research & Development, and have a Research & Development department group in Hornbill. When I import this user, the department is applied as expected. This also works for user updates as well as user creation. What version of the LDAP Import Tool are you running?

Is there any information in the log regarding this user, that could give us a better idea as to what is happening? The information in the log is collated per user, so it should be pretty easy to spot any errors... For example,  this is from my log for the user I've just successfuly imported:

And the resulting user:

Cheers,

Steve

  

[Lightsource]

@Steve G thanks for your assistance with this.

you cant use "&" symbol in the organisation ID on hornbill so we put Operations_and_maintenance then matched the name Operations and Maintenance. Leaving the organisation ID as is and changing the name to Operation & Maintenance solved our issue.