Azure User Import - .businessPhones

[AndyHill]

I noticed in the latest version of the Azure Import Tool we have switched from the following values. 

"Phone": "{{.telephoneNumber}}",

"Mobile": "{{.mobile}}",

to the newer values of

"Phone": "{{.businessPhones}}",

"Mobile": "{{.mobilePhone}}",

These both import the values i would expect but because businessPhones is an array it imports with the [] around the entry. Is there anyway to remove these brackets as it looks untidy?

[Guest Mary]

Hi @AndyHill

Could you please confirm that the StringCollectionTweak is set to true as shown below and detailed in the change log of the new utility (https://github.com/hornbill/goAzure2HUserImport/releases/tag/v2.7.0)? 

 

[AndyHill]

@Mary Yup checked and definitely have that in the file.

[SamS]

Hi @AndyHill,

Are you saying that telephoneNumber doesn't work for you anymore?

I'm not entirely sure how Azure works behind the scenes (I think it has switched about a bit - telephoneNumber should return the primary number indicated in businessPhones and mobilePhone, the mobile number indicated in there, but I know telephoneNumber doesn't return anything if it is not expressly set), but I have noticed that telephoneNumber doesn't work for everyone - and for those where it doesn't work, the businessPhones route is now given as an alternative.

You might also want to add businessPhones to the list of UserProperties.

[AndyHill]

@SamS Hi Sam, yeah telephoneNumber is now no longer working. I switched it out for businessPhones which does work but because businessPhones is an array it puts the number inside [] which just looks a little untidy as where users haven't supplied a number they now just have [] showing.

[SamS]

@AndyHill,

The '''StringCollectionTweak''' in 2.7.0 should have automatically selected the first entry in the array - I will look into it - and fix it in v2.7.1 if I can replicate the issue.

[AndyHill]

@SamS just been looking in to this again after reading the below:-

• businessPhones is coming back as ["#phone#"] (a so-called "string collection"), so now stripping the phone number fields from any potential square bracket and double-quotes. Only "Phone" and "WorkPhone" (Profile) have been "treated" in this way. AzureConf.StringCollectionTweak needs to be set to true use.

I can confirm that when I use the WorkPhone setting under the ProfileMapping it does correctly remove the []. 

Problem here is I want the number mapping on to Phone under the AccountMapping section.

[SamS]

Hi @AndyHill,

Are you trying to have two functionalities? i.e. removal of [] on WorkPhone and NO removal for Phone?

If so, then the best thing would be to run the import twice - one with WorkPhone configured WITH the tweak set (NO mapping on Phone),  and the other (without the tweak) mapping to Phone (but NOT on WorkPhone)

[AndyHill]

@SamS only trying to import the Office phone from our AD 

to the Phone field in Service Manager but without the [] brackets

 

if I do this to Home Telephone in Service Manager it does remove the brackets (but thats no good to me).

 

[SamS]

Hi @AndyHill,

You might find the latest release better - https://github.com/hornbill/goAzure2HUserImport/releases/latest

Thanks for reporting the issue.

[AndyHill]

@SamS bad news it not only still doesn't work for the Phone field but the Home Telephone one is now back to showing the [] so its actually gotten worse