CustomerCompany as a Dropdown list not working

[sirbunnz]

ISSUE :
Unable to get CustomerID to display as a dropdown list populated from customer_company table, on New Customer User form.


VERSIONS:

Code: Select all

cat /etc/redhat-release
CentOS Linux release 7.1.1503 (Core)

cat /opt/otrs/RELEASE
PRODUCT = OTRS
VERSION = 4.0.13
BUILDDATE = Wed Sep 23 21:13:34 CEST 2015
BUILDHOST = otrsbuild.otrs.com

DEPLOYMENT:
Using unixODBC backend for everything, talking to an MS SQL database. Which is ‘totally unsupported’, I get it, but it is working fine. 


TROUBLESHOOTING:
Trawled the web and the forums here, most references are to older OTRS versions but from 3.x onwards, they all point to enable CustomerCompanySupport in the CustomerUser configuration section of /Kernel/Config.pm.
Not getting any errors. From what I can read, enabling CustomerCompanySupport and defining the customer user and customer company tables should deliver dropdown functionality to the input fields for CustomerID, but it doesn’t work.

Have stopped/started httpd.
Have cleared caches.
Have rebuilt configurations.


CONFIG FILE:
/Kernel/Config.pm

Code: Select all

# Activate Customer User Mode
$Self->{CustomerUser} = {
        Name   => 'Database Backend',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            Table => 'customer_user',
  [snip for brevity, all details for this section included from Config/Default.pm]
        CustomerCompanySupport => 1,
    };
};

# Activate Customer Company Mode
$Self->{CustomerCompany} = {
        Name   => 'Database Backend',
        Module => 'Kernel::System::CustomerCompany::DB',
        Params => {
            Table => 'customer_company',
  [snip for brevity, all details for this section included from Config/Default.pm]
    };
};

Any advice would be great, as I'm now at a bit of a loss.

[crythias]

Customer Company appears as DDL when SysConfig option for CustomerCompanySupport is enabled.

[sirbunnz]

Unable to find any sysconfig setting for CustomerCompanySupport, but per the details online and the Kernel/Config/Defaults.pm file, the line for CustomerCompanySupport = 1 is present in my config.pm file. Is there something within the GUI that I need to toggle as well?

One thing that occurred to me last night which I'll test today, do I need to change the DB type and provide the details for an ODBC link to the config.pm section detailing the customer user and customer company tables? I can use the GUI fine to add/remove/edit this data, so OTRS can obviously find them from the 'master' definition of the database, but maybe these sections require details as well?

[crythias]

Let me revise this.

Customer Company (if company is separate) isn't going to be a drop down list, but customer ID *will* be.

May we see a screenshot?

[sirbunnz]

Eh?

CustomerCompany and CustomerID I'm almost using interchangably? I mean, CustomerID is only a way to link to the CustomerCompany right? Or do I have that incorrect? I thought that was the purpose of the customer_id field in the customer_user table is to link to customer_id field in the customer_company table and tie multiple entries in customer_users to a single entry in customer_company, for eventual reporting/permissions/acls etc.

The dropdown list functionality I'm after (at the moment), is when entering a new CustomerUser, the CustomerID field is free-text. I haven't got far enough in the project to identify any other places that may need fixing, as I have hit a brick wall with this first instance I've found.