2 emails for 1 customer

Moderator: crythias

Post Reply
Arry
Znuny newbie
Posts: 11
Joined: 20 Jun 2011, 12:41
Znuny Version: 3.0.7

2 emails for 1 customer

Post by Arry »

Good Day,

I am trying to solve the problem with 1 customer user having 2 e-mail addresses in different domains.

My goal is to show them both in the AutoComplete box when you create a new e-mail ticket.

I have setup the solution below coming from Torsten Thau, however, there is a problem with it -
when you create a new e-mail ticket the AutoComplete function doesn't lookup e-mails in the email_ext00

I have a feeling that somewhere in the AgentBook.pm the lookup should be extended to search also in the alternative email fields.

Anyone able to point me in the right direction?

best regards
Arry
(1) create additional table columns (e.g. via SQL-Box in Admin area):
ALTER TABLE customer_user ADD COLUMN email_ext00 varchar(300);
ALTER TABLE customer_user ADD COLUMN email_ext01 varchar(300);

(2) add new columns to customer backend configuration in Config.pm:

(2a) Edit the customer backend definition related to the data source for
table "customer_data". Just add following rows to the Map-array (e.g.
directly below the definition for the default email-field):
[ 'UserEmail0', 'Further Email', 'email_ext00', 1, 0, 'var', '', 0 ],
[ 'UserEmail1', 'Further Email', 'email_ext01', 1, 0, 'var', '', 0 ],

(2b) add new table columns as postmaster-search columns
CustomerUserPostMasterSearchFields => ['email', 'email_ext00',
'email_ext01'],

(3) If applicable, extend customeruser-import-export mappings in the
ImportExport backend.
Post Reply