External customer database

[ndhvu275]

Dear all,

Using External customer database

I configured to connect to external database already. That's very nice. But now I'm facing how to mapping one field (OTRS) to many fields (external DB)? Let see below is mycase:

In OTRS I have CustomerID field, then want to map with 3 field from ext DB (postcode + house number + ext house number). It means:
CustomerID = postcode + house number + ext house number

are there anyway to map field as above? or anyway same above idea? Please help me

Thanks a lot

Hoang Vu

[reneeb]

You could create a view on the external database and use this view as the external table. In that view you can do something like

Code: Select all

"CREATE VIEW otrscustomers AS SELECT CONCAT(postcode, house, ext_hous) AS customer_id ..."

[crythias]

If not ... you could, in theory, provide the concatenation method as the field.

[ndhvu275]

You could create a view on the external database and use this view as the external table. In that view you can do something like

Code: Select all

"CREATE VIEW otrscustomers AS SELECT CONCAT(postcode, house, ext_hous) AS customer_id ..."

Hi reneeb, this is really a good solution.

Thank you very much

Hoang Vu

[ndhvu275]

If not ... you could, in theory, provide the concatenation method as the field.

Hi crythias,

Please give an example for using concatenation method, I also need to know your solution insteed of my customers do not allow to create a view on their DB.
For example in Map field method in config.pm

Code: Select all

[ 'UserCustomerID', 'CustomerID', 'zip', 0, 1, 'var', '', 0 ],

How to write the coding to merge zip, house_no and house_ext_no

I also need to your help to explain more abt coding in another thread: viewtopic.php?f=62&t=7750

Thanks in adv

Hoang Vu

[crythias]

read reneeb's post for a concatenate method for MySQL.

[ndhvu275]

read reneeb's post for a concatenate method for MySQL.

Ah, I think your idea is use concatenate method in perl

Anyway thank

Hoang Vu

[crythias]

Code: Select all

[ 'UserCustomerID', 'CustomerID', 'CONCAT(postcode, house, ext_hous)', 0, 1, 'var', '', 0 ],

There's no inherent reason the read portion of the code can't do this.

[ndhvu275]

Code: Select all

[ 'UserCustomerID', 'CustomerID', 'CONCAT(postcode, house, ext_hous)', 0, 1, 'var', '', 0 ],

There's no inherent reason the read portion of the code can't do this.

Many thanks. It's very nice and flexible

Vu Nguyen