How to enable customer's phone field?

Moderator: crythias

Post Reply
firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

How to enable customer's phone field?

Post by firebolt »

Good time of day.

I am searching for manual about enabling phone number field in the Customer's information.
I added these strings in Config.pm but the phone is still not displayed.

Code: Select all

    Map => [
      [ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
      [ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
      [ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ],
      [ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
      [ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var' ],
      [ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ],
    ],
I tried this manual and got next error

Code: Select all

mysql> ALTER TABLE customer_user ADD Phone VARCHAR(255);
ERROR 1060 (42S21): Duplicate column name 'Phone'
What else I need to do?
OTRS 6.0.20, Debian GNU/Linux 9 stretch

BrianYin
OTRS newbie
Posts: 76
Joined: 29 Aug 2012, 10:12
OTRS Version?: 3.1.12

Re: How to enable customer's phone field?

Post by BrianYin »

Does the attribuate name (telephonenumber) as same as your DB?
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

BrianYin wrote:Does the attribuate name (telephonenumber) as same as your DB?
What do you mean? Do you mean the LDAP DB? Yes, I have MS Active Directory 2003. I tried the "phone" attribute too.
OTRS 6.0.20, Debian GNU/Linux 9 stretch

BrianYin
OTRS newbie
Posts: 76
Joined: 29 Aug 2012, 10:12
OTRS Version?: 3.1.12

Re: How to enable customer's phone field?

Post by BrianYin »

firebolt wrote:
BrianYin wrote:Does the attribuate name (telephonenumber) as same as your DB?
What do you mean? Do you mean the LDAP DB? Yes, I have MS Active Directory 2003. I tried the "phone" attribute too.
o you don't excelly know what's the phone attribute's name in your Active Directory? would it be telephone?
OTRS Version: 3.1.9
OS: windows 2003
ITSM 3.1.6
MySQL 5.xxx

choenig
OTRS newbie
Posts: 36
Joined: 28 Sep 2012, 11:26
OTRS Version?: 3.1.10
Location: 49° 54′ N, 10° 54′ O

Re: How to enable customer's phone field?

Post by choenig »

Hi,

try to find out the correct name of the attribute which contains the phone number.
E.g. you can use LDAP Administrator to look up, in our W2k8 domain the attribute name is homePhone...
homephone.jpg
You do not have the required permissions to view the files attached to this post.
OTRS 3.2.8 - KIX4OTRS - ConfigureCallHome - ZnunyCustomerMap - running on CentOS 6.4 and MySQL
anyone who finds clerical errors can keep it...

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

Hey! I know the name of attribute! It is telephonenumber. This config is works, I found user's phone number in Customer information section in ticket creating dialog. But it still doesn't listed in "Customers" menu item.
OTRS 6.0.20, Debian GNU/Linux 9 stretch

jojo
Moderator
Posts: 14859
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: How to enable customer's phone field?

Post by jojo »

it won't be listed in the overview
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

jojo wrote:it won't be listed in the overview
It is open source system. It can list me all what I tell it to list. As I understood I need to change some *.dtl.
OTRS 6.0.20, Debian GNU/Linux 9 stretch

jojo
Moderator
Posts: 14859
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: How to enable customer's phone field?

Post by jojo »

and the modules
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

And what the *.dtl and modules?
OTRS 6.0.20, Debian GNU/Linux 9 stretch

crythias
Moderator
Posts: 10129
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: How to enable customer's phone field?

Post by crythias »

@firebolt show the entire Config.pm CustomerUser entry, please.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

jojo
Moderator
Posts: 14859
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: How to enable customer's phone field?

Post by jojo »

please read the developer doku for this.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

crythias wrote:@firebolt show the entire Config.pm CustomerUser entry, please.

Code: Select all

 $Self->{CustomerUser1} = {
     Name => 'Company',
     Module => 'Kernel::System::CustomerUser::LDAP',
     Params => {
      Host => 'svrmain.company.local',
      BaseDN => 'OU=Company Users,DC=company,DC=local',
      SSCOPE => 'sub',
      UserDN => 'cn=linadmin,ou=Administrators,dc=company,dc=local',
      UserPw => '*****',
      SourceCharset => 'utf-8',
      DestCharset => 'utf-8',
      AlwaysFilter => '(&(objectCategory=User)(!(userAccountControl:1.2.840.113556.1.4.803:=2$
 #     Params => {
                port => 389,
                timeout => 120,
                async => 0,
                version => 3
#               },
    },
    CustomerKey => 'sAMAccountName',
    CustomerID => 'mail',
    CustomerUserSearchListLimit => 900,
    CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'],
    CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],
    CustomerUserPostMasterSearchFields => ['mail'],
    CustomerUserNameFields => ['givenname', 'sn'],
    Map => [
      [ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var', '', 0 ],
      [ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var', '', 0 ],
      [ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var', '', 0 ],
      [ 'UserEmail', 'Email', 'mail', 1, 1, 'var', '', 0 ],
      [ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var', '', 0 ],
      [ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var', '', 0 ],
      [ 'UserTitle', 'Должность', 'title', 1, 0, 'var' ],
      [ 'UserDepartment', 'Департамент', 'department', 1, 0, 'var' ],
    ],

OTRS 6.0.20, Debian GNU/Linux 9 stretch

crythias
Moderator
Posts: 10129
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: How to enable customer's phone field?

Post by crythias »

firebolt wrote:This config is works, I found user's phone number in Customer information section in ticket creating dialog. But it still doesn't listed in "Customers" menu item.
There's no reason that it shouldn't show up unless the "shown" is invalid.
Do you have a screenshot?

The Module that applies is Kernel/Module/AdminCustomerUser.pm and the code is not very specific to say, "This won't show" unless there's a field that says it won't show.
In theory, your Phone should list under the CustomerID (which is hidden (?)) so it should show under mail.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

firebolt
OTRS newbie
Posts: 47
Joined: 21 Sep 2012, 07:55
OTRS Version?: 5.0.10
Real Name: Игорь (Igor)

Re: How to enable customer's phone field?

Post by firebolt »

Here is a screenshot

There is an email in CUSTOMERID section.
You do not have the required permissions to view the files attached to this post.
OTRS 6.0.20, Debian GNU/Linux 9 stretch

yuri0001
OTRS superhero
Posts: 631
Joined: 17 Mar 2011, 14:40
OTRS Version?: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: How to enable customer's phone field?

Post by yuri0001 »

I finally understood you. Your wishlist only can be made by hardcoding in source code.
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)

Post Reply