Re: [otrs] (SOLVED) CustomerCompany on external database

22 Jan 2016

      Solved.
My external CustomerCompany database didn't provide a 
CustomerCompanyValid column, so I commented it out in the column mapping.
This was not a problem retrieving the customer company list in Customers 
section but was a problem populating the CustomerID when add or modify a 
customer in the Customer User section.

Antonio.

Il 15/01/2016 16:16, Antonio Reale ha scritto:
...
Hi Gerald,
CustomerCompanySupport is already enabled in Default.pm and I have no 
custom config in Config.pm for CustomerUser.
In Config.pm I have only custom config for CustomerCompany.
Thanks.
Regards.
Antonio
Il 15/01/2016 15:33, Gerald Young ha scritto:
...
...
I already changed the Config.pm and in the "Customer Management" 
section I correctly see all my companies retrieved from the external DB.
I gathered that after I posted, but was confused by the wording of 
your question.
...
The problem is that when I create a CustomerUser I don't have the 
dropdown menu to choose the CustomerID that is mandatory field, so I 
can't create the CustomerUser.
This is CustomerCompanySupport and is a parameter in CustomerUser, 
which is likely customized for you in Config.pm.
https://github.com/OTRS/otrs/blob/rel-5_0_5/Kernel/Config/Defaults.pm#L1456
On Fri, Jan 15, 2016 at 4:00 AM, Antonio Reale mailto:ant.reale@gmail.com> wrote:
Hi Gerald,
    thanks for the answer but as I wrote, I already changed the
    Config.pm and in the "Customer Management" section I correctly
    see all my companies retrieved from the external DB.
The problem is that when I create a CustomerUser I don't have the
    dropdown menu to choose the CustomerID that is mandatory field,
    so I can't create the CustomerUser.
Thanks.
    Regards.
Antonio
Il 14/01/2016 18:41, Gerald Young ha scritto:
...
I'd like to point out this thread:
    http://forums.otterhub.org/viewtopic.php?t=30755
And yes, it is possible to put CustomerCompany on a (single)
    different DB backend.
Copy the relevant section from Defaults.pm to Config.pm and
    modify appropriately.
    https://github.com/OTRS/otrs/blob/rel-5_0_5/Kernel/Config/Defaults.pm#L1561
On Thu, Jan 14, 2016 at 11:52 AM, Antonio Reale
     wrote:
Hi all,
        in 3.2 version during the customer user creation phase I had
        to populate the CustomerID field manually (no dropdown
        menu). There was no need to have the company created in the
        CustomerCompany backend.
        After upgradind to OTRS 5, when I create a new customer I
        can't insert a CustomerID if it is not present in
        CustomerCompany, so I decided to point OTRS to an external
        database where I have companies data.
        I changed the Config.pm, so now I have CustomerCompany data
        on the external database and CustomerUser on the local OTRS
        database.
        In Customer Management I correctly see all companies, but if
        I try to add a customer user the CustomerID field is disabled.
Is possible to have CustomerUser and CustomerCompany on
        different backends?
Thanks.
        Regards.
Antonio
        ---------------------------------------------------------------------
        OTRS mailing list: otrs - Webpage: http://otrs.org/
        Archive: http://lists.otrs.org/pipermail/otrs
        To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
    OTRS mailing list: otrs - Webpage:http://otrs.org/
    Archive:http://lists.otrs.org/pipermail/otrs
    To unsubscribe:http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
    OTRS mailing list: otrs - Webpage: http://otrs.org/
    Archive: http://lists.otrs.org/pipermail/otrs
    To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage:http://otrs.org/
Archive:http://lists.otrs.org/pipermail/otrs
To unsubscribe:http://lists.otrs.org/cgi-bin/listinfo/otrs