Hi,
I'm looking to how to enable multiple IDs for my customer users, I created the ne column in the customer_user table in the OTRS database as discribed in the user manual:
linux:~# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 124 to server version: 5.0.18-Debian_7-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use otrs;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER TABLE customer_user ADD customer_ids VARCHAR (250);
Query OK, 1 rows affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> quit
Bye
linux:~#
Now the new column has to be added to the MAP array in Kernel/Config.pm, as shown
in the script below:
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link,
readonly, http-link-target, link class(es)
[...]
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
I don't get what need to be done here now, this script needs to be run how?
--
Kristof
Customer with Multiple IDs
Moderator: crythias