Map customerID to a part of an LDAP attribute

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Map customerID to a part of an LDAP attribute

Post by aph »

So far, I can map attributes in LDAP with the attributes in OTRS. For example, I have mapped CustomerID with userPrincipalName.

Code: Select all

   # customer unique id
         CustomerKey => 'userPrincipalName',
# # #        # customer #
         CustomerID => 'userPrincipalName',
#more code here
.
.
.
[ 'UserCustomerID', 'CustomerID', 'userPrincipalName',            0, 1, 'var', '', 0 ]
What I would like to do is:

Code: Select all

If distinguishedName contains the string 'ou=XYZ' then set CustomerID = 'some string' 
How can this be achieved? Which dtl needs to be edited?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Map customerID to a part of an LDAP attribute

Post by aph »

Maybe an alternative. Is it possible to map customer ID to a non-LDAP value? There is not field customer ID in our LDAP or any other field that can identify the customer ID from LDAP attributes of a customer user
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Map customerID to a part of an LDAP attribute

Post by crythias »

1) mass update a field (select everyone in ADUC, properties, assign a CustomerID value to a field) (use at own risk)
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Map customerID to a part of an LDAP attribute

Post by aph »

Hmmmm!

Well is it then possible to 'convert' the CustomerID field into a drop down field retaining the functionality that by clicking on the customer ID hyperlinklink, I can see the tickets belonging to that customer ID. I have a limited number of customers and I could mainatain a drop down list.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Map customerID to a part of an LDAP attribute

Post by crythias »

sure. change the dtl for CustomerID to a dropdown list. Why not?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Map customerID to a part of an LDAP attribute

Post by aph »

you mean the dtl in which I want the customer ID field to appear as a drop down list or is there a dtl for the field so it will appear as drop down list everywhere?
Btw how do I make the field into a drop down list?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Map customerID to a part of an LDAP attribute

Post by crythias »

dtl of the page for which you wish the CustomerID field to appear as a drop down list.
aph wrote:how do I make the field into a drop down list?
http://www.w3schools.com/tags/tag_select.asp
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked