Merge LDAP fields into Customer ID?

[Mothra]

Is it possible, via Config.pm, to merge more than one field into the CustomerID?

This is for the Customer Interface in which the ability to view all tickets for the Company is inappropriate for large companies, or those where the various departments only want to see tickets raised by their immediate colleagues.

As our internal customers are added via Active Directory, I was wondering whether it's possible to merge both the "company" and "department" fields into the Customer ID, so that it would contain "Acme Ltd - Sales", "Acme Ltd - IT Support" etc.?

If not, I can just get our AD guy to add the department names to the company field in AD, but I would prefer that be a last resort.

[crythias]

You might be able to do it with concatenation in Map.

[Mothra]

You might be able to do it with concatenation in Map.

Of course! I've been treating it for so long as just a config file, I sometimes forget that it's also a Perl Module.

[mweisser]

Can you post how you configured your Mapping in Detail?
I've got the same problem and didn't get it working with perl concatenation. This would be very helpful

[ndhvu275]

You might be able to do it with concatenation in Map.

Hi can you explain for more detail, or writedown to how merge manyfields into only one field is CustomerID

Thanks in adv

Hoang Vu

[ndhvu275]

Hi

You can merge many fields into a CustomerID field in your file config like below

[ 'UserCustomerID', 'CustomerID', 'CONCAT_WS("",postcode, house_nr, house_ext_nr, room)', 0, 1, 'var', '', 0 ],

And don't forget enable property ReadyOnly => 1. Do not allow to add/update on your external customer DB, just view.

Hope it's helpful for someone

Vu Nguyen