Customer with Multiple IDs

Moderator: crythias

kloos
OTRS newbie
Posts: 11
Joined: 05 Jul 2017, 21:17
OTRS Version?: 5.0.20
Real Name: Kristoffel Loos
Company: Telecom IT

Customer with Multiple IDs

Postby kloos » 17 Nov 2017, 15:37

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

Return to “Help”

Who is online

Users browsing this forum: No registered users and 10 guests

cron