different customer DB depending on TO address

Moderator: crythias

Locked
AlexKS
Znuny newbie
Posts: 2
Joined: 08 Aug 2014, 12:21
Znuny Version: 3.3.5
Real Name: Alex
Company: KS

different customer DB depending on TO address

Post by AlexKS »

Hi folks,

I tried using the search function but was not able to find anything addressing my question - so here we go:

We are trying to access two client databases depending on the OTRS recipient (TO field of the email):

For example:
If a client sends an email to support@compA the client data should be taken from DB-A.
In case the same client would be sending an email to support@compB the client data should be taken from DB-B.

I know that there is the possibility to define different customer databases but the mapping to the recipient (TO) address of the email is important to me and I can't find any way to do so.
Any hint/help/assistance would be highly appreciated!

Thanks a lot!
Best,
Alex
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: different customer DB depending on TO address

Post by crythias »

OTRS will parse all backends until it finds a match. Make sure you read the docs on multiple backends.
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
AlexKS
Znuny newbie
Posts: 2
Joined: 08 Aug 2014, 12:21
Znuny Version: 3.3.5
Real Name: Alex
Company: KS

Re: different customer DB depending on TO address

Post by AlexKS »

Thanks for replying crythias!

My problem is that the user IDs are duplicated and the only obvious way to differentiate which DB should be used is the recipient (to field) of the email.
I can't find any way in defining this in the CustomerUser section of OTRS.
Something that would help is :

$Self->{CustomerUser1} = {
Name => 'db name A'
Recipient => 'support@companyA'

...

$Self->{CustomerUser2} = {
Name => 'db name B'
Recipient => 'support@companyB'
wurzel
Znuny guru
Posts: 3274
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: different customer DB depending on TO address

Post by wurzel »

Hi,

I think OTRS takes the first match.

The E-Mailadress/username must be unique.

Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Locked