External CustomerCompany database

[wiktor]

Hi,
I'm trying to integrate external customer/company database with OTRS. With customer db there has been no problem, but when I looked closer at customer_company table customer_id is varchar. I thought that simply changing storage-type like this

Code: Select all

[ 'CustomerID',             'CustomerID', 'id', 0, 1, 'int', '', 0 ],

would suffice, but it still tries to compare customerid like they were two varchars. Changing

Code: Select all

[ 'UserCustomerID', 'CustomerID', 'entity_id', 0, 1, 'int', '', 1 ],

in CustomerUser didn't help either. Is there any way to use integer as companyid ? There is no unique index on companyname column in database so I can't be sure there won't be two companies with identical names.

Wiktor