[solved]Zusätzliche Kundenfelder

MikeDelta · Post by **MikeDelta** » 19 Mar 2015, 10:26

Hey,
ich habe aktuell OTRS 4.0.4 implementiert.
Nun würde ich gerne das Benutzerprofil um weitere Felder ergänzen.
Ich habe bereits recherchiert und bin auf diesen Eintrag gestoßen.
viewtopic.php?t=11508

Ist diese Anleitung noch gültig?
Gibt es zusätzlich etwas dass ich ebachten muss?

Herzlichen Dank.

reneeb · Post by **reneeb** » 20 Mar 2015, 09:16

Ja, das ist noch gültig. Nur eine Sache hat sich geändert: Wenn Du Links für die Felder einbaust, dann hat sich die Syntax für die Dynamischen Sachen geändert. Wenn als http-link unter OTRS <4 bspw: "http://test.example/test?userphone=$QData{"UserPhone"}" angegeben war, muss das unter OTRS >= 4 so aussehen: "http://test.example/test?userphone=[% Data.UserPhone | uri %]"

TamaraS · Post by **TamaraS** » 20 Mar 2015, 09:18

Ja, soweit noch gültig. Habe ich für uns auch damit umgesetzt.
Lese jetzt alle Felder aus dem AD aus, die interessant für uns sind und stelle die in der Customer Info dar.

Sascha79 · Post by **Sascha79** » 26 Mar 2015, 21:27

Wow, danke für den Tipp - das steht im v4 Admin-Handbuch noch falsch drin.

reneeb wrote:Ja, das ist noch gültig. Nur eine Sache hat sich geändert: Wenn Du Links für die Felder einbaust, dann hat sich die Syntax für die Dynamischen Sachen geändert. Wenn als http-link unter OTRS <4 bspw: "http://test.example/test?userphone=$QData{"UserPhone"}" angegeben war, muss das unter OTRS >= 4 so aussehen: "http://test.example/test?userphone=[% Data.UserPhone | uri %]"

MikeDelta · Post by **MikeDelta** » 11 May 2015, 17:33

Hey

ich habe nun Zeit gehabt es zu testen

so sieht meine config.pm aus

allerdings sehe ich keine neuen felder
Was läuft schief

Code: Select all

# --
# Kernel/Config.pm - Config file for OTRS kernel
# Copyright (C) 2001-2014 xxx, http://otrs.com/
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
#  Note:
#
#  -->> Most OTRS configuration should be done via the OTRS web interface
#       and the SysConfig. Only for some configuration, such as database
#       credentials and customer data source changes, you should edit this
#       file. For changes do customer data sources you can copy the definitions
#       from Kernel/Config/Defaults.pm and paste them in this file.
#       Config.pm will not be overwritten when updating OTRS.
# --

package Kernel::Config;

use strict;
use warnings;
use utf8;

sub Load {
    my $Self = shift;

    # ---------------------------------------------------- #
    # database settings                                    #
    # ---------------------------------------------------- #

    # The database host
    $Self->{DatabaseHost} = 'xxxx';

    # The database name
    $Self->{Database} = 'xxxx';

    # The database user
    $Self->{DatabaseUser} = 'xxxx';

    # The password of database user. You also can use bin/otrs.CryptPassword.pl
    # for crypted passwords
    $Self->{DatabasePw} = 'xxxx';

    # The database DSN for MySQL ==> more: "perldoc DBD::mysql"
    $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

    # The database DSN for PostgreSQL ==> more: "perldoc DBD::Pg"
    # if you want to use a local socket connection
#    $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
    # if you want to use a TCP/IP connection
#    $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";

    # The database DSN for Microsoft SQL Server - only supported if OTRS is
    # installed on Windows as well
#    $Self->{DatabaseDSN} = "DBI:ODBC:driver={SQL Server};Database=$Self->{Database};Server=$Self->{DatabaseHost},1433";

    # The database DSN for Oracle ==> more: "perldoc DBD::oracle"
#    $Self->{DatabaseDSN} = "DBI:Oracle://$Self->{DatabaseHost}:1521/$Self->{Database}";
#
#    $ENV{ORACLE_HOME}     = '/path/to/your/oracle';
#    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
#    $ENV{NLS_LANG}        = 'AMERICAN_AMERICA.AL32UTF8';

    # ---------------------------------------------------- #
    # fs root directory
    # ---------------------------------------------------- #
    $Self->{Home} = '/var/www/xxxx/html';

    # ---------------------------------------------------- #
    # insert your own config settings "here"               #
    # config settings taken from Kernel/Config/Defaults.pm #
    # ---------------------------------------------------- #
    # $Self->{SessionUseCookie} = 0;
    # $Self->{CheckMXRecord} = 0;

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #
    # data inserted by installer                           #
    # ---------------------------------------------------- #
    # $DIBI$

    # ---------------------------------------------------- #
    # ---------------------------------------------------- #
    #                                                      #
    # end of your own config options!!!                    #
    #                                                      #
    # ---------------------------------------------------- #
    # ---------------------------------------------------- #
}

# ---------------------------------------------------- #
# needed system stuff (don't edit this)                #
# ---------------------------------------------------- #

use base qw(Kernel::Config::Defaults);

# -----------------------------------------------------#

1;  
  $Self->{CustomerUser} = {
        Name   => 'Database Backend',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            Table => 'customer_user',
            # CaseSensitive will control if the SQL statements need LOWER()
            #   function calls to work case insensitively. Setting this to
            #   1 will improve performance dramatically on large databases.
            CaseSensitive => 0,
        },

        # customer uniq id
        CustomerKey => 'login',

        # customer #
        CustomerID             => 'customer_id',
        CustomerValid          => 'valid_id',
        CustomerUserListFields => [ 'first_name', 'last_name', 'email' ],
        CustomerUserSearchFields           => [ 'login', 'first_name', 'last_name', 'customer_id' ],
        CustomerUserSearchPrefix           => '*',
        CustomerUserSearchSuffix           => '*',
        CustomerUserSearchListLimit        => 250,
        CustomerUserPostMasterSearchFields => ['email'],
        CustomerUserNameFields     => [ 'title', 'first_name', 'last_name' ],
        CustomerUserEmailUniqCheck => 1,
        Map => [

            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target
            [ 'UserTitle',      'Title',      'title',      1, 0, 'var', '', 0 ],
            [ 'UserFirstname',  'Firstname',  'first_name', 1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'last_name',  1, 1, 'var', '', 0 ],
            [ 'UserLogin',      'Username',   'login',      1, 1, 'var', '', 0 ],
            [ 'UserPassword',   'Password',   'pw',         0, 0, 'var', '', 0 ],
            [ 'UserEmail',      'Email',      'email',      1, 1, 'var', '', 0 ],
            [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ],
            [ 'UserPhone',        'Phone',       'phone',        1, 0, 'var', '', 0 ],
            [ 'UserFax',          'Fax',         'fax',          1, 0, 'var', '', 0 ],
            [ 'UserMobile',       'Mobile',      'mobile',       1, 0, 'var', '', 0 ],
            [ 'UserStreet',       'Street',      'street',       1, 0, 'var', '', 0 ],
            [ 'UserZip',          'Zip',         'zip',          1, 0, 'var', '', 0 ],
            [ 'UserCity',         'City',        'city',         1, 0, 'var', '', 0 ],
            [ 'UserCountry',      'Country',     'country',      1, 0, 'var', '', 0 ],
            # --------------------ADDED DATA xxxxxx------ 
            [ 'version',         'Version',      'version',         1, 0, 'var', '', 0 ],
            [ 'addone',          'AddOnOne',     'addone',          1, 0, 'var', '', 0 ],
            [ 'addtwo',          'AddOnTwo',     'addtwo',          1, 0, 'var', '', 0 ],
            [ 'addthree',        'AddOnThree',   'addthree',        1, 0, 'var', '', 0 ],
            [ 'addfour',         'AddOnFour',    'addfour',         1, 0, 'var', '', 0 ],
            [ 'brokerone',       'BrokerOne',    'brokerone',       1, 0, 'var', '', 0 ],
            [ 'brokertwo',       'BrokerTwo',    'brokertwo',       1, 0, 'var', '', 0 ],
            [ 'brokerthree',     'BrokerThree',  'brokerthree',     1, 0, 'var', '', 0 ],
            [ 'brokerfour',      'BrokerFour',   'brokerfour',      1, 0, 'var', '', 0 ],
            [ 'feedone',         'FeedOne',      'feedone',         1, 0, 'var', '', 0 ],
            [ 'feedtwo',         'FeedTwo',      'feedtwo',         1, 0, 'var', '', 0 ],
            [ 'feedthree',       'FeedThree',    'feedthree',       1, 0, 'var', '', 0 ],
            [ 'feedfour',        'FeedFour',    'feedfour',         1, 0, 'var', '', 0 ],
            # --------------------FINAL xxxxxx------------------------------- 
            [ 'UserComment',      'Comment',     'comments',     1, 0, 'var', '', 0 ],
            [ 'ValidID',          'Valid',       'valid_id',     0, 1, 'int', '', 0 ],
        ],

        # default selections
        Selections => {

UserTitle => {
                'Mr.' => 'Mr.',
                'Mrs.' => 'Mrs.',
            },           
version => {
                'None' => 'None',
                'Demo' => 'Demo',
         
            },
addone => {
                'None' => 'None',
               'Demo' => 'Demo',

            },
addtwo => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
addthree => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
addfour => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
brokerone => {
                'None' => 'None',
               'Demo' => 'Demo',,
            },
brokertwo => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
brokerthree => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
brokerfour => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
feedone => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
feedtwo => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
feedthree => {
                'None' => 'None',
               'Demo' => 'Demo',
            },
feedfour => {
                'None' => 'None',
               'Demo' => 'Demo',
            }, 
        },

reneeb · Post by **reneeb** » 12 May 2015, 09:35

Alles was nach der

Code: Select all

1;

steht muss hinter

Code: Select all

   # ---------------------------------------------------- #
    # data inserted by installer                           #
    # ---------------------------------------------------- #
    # $DIBI$

stehen...

MikeDelta · Post by **MikeDelta** » 13 May 2015, 10:05

Danke .
Bin hier einen Schritt weiter.
Adde ich die zusätzlichen Felder in die DEFAULTS.pm werden diese angezeigt.
Adde ich die Felder in die CONFIG.pm werden diese NICHT angezeigt.

Ideen?

nd0 · Post by **nd0** » 13 May 2015, 11:13

NIEMALS den Inhalt der default.pm ändern!

Das Mapping gehört in die config.pm ... und das klappt auch:

config.pm wrote: # ---------------------------------------------------- #
# KUNDE XYZ #
# ---------------------------------------------------- #

$Self->{'Customer::AuthModule1'} = 'Kernel::System::CustomerAuth::LDAP';
$Self->{'Customer::AuthModule::LDAP::Host1'} = '*censored*';
$Self->{'Customer::AuthModule::LDAP::BaseDN1'} = '*censored*';
$Self->{'Customer::AuthModule::LDAP::UID1'} = 'mail';
$Self->{'Customer::AuthModule::LDAP::SearchUserDN1'} = '*censored*';
$Self->{'Customer::AuthModule::LDAP::SearchUserPw1'} = '*censored*';

#CustomerUser
#(customer user database backend and settings)
$Self->{CustomerUser1} = {
Name => 'LDAP - Kunde XYZ',
Module => 'Kernel::System::CustomerUser::LDAP',
Params => {
Host => '*censored*',
BaseDN => '*censored*',
SSCOPE => 'sub',
UserDN =>'*censored*',
UserPw => '*censored*',
SourceCharset => 'utf-8',
DestCharset => 'iso-8859-1',
AlwaysFilter => '(&(mail=*)(givenname=*)(sn=*)(company=*))',
},
# customer unique id
CustomerKey => 'mail',
# customer #
CustomerID => 'company',
CustomerUserListFields => ['cn', 'mail'],
CustomerUserSearchFields => ['cn', 'mail'],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['givenname', 'sn'],
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown, required, storage-type
#[ 'UserSalutation', 'Title', 'title', 1, 0, 'var' ],
[ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
[ 'UserLogin', 'Login', 'mail', 1, 1, 'var' ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
[ 'UserDomain', 'DomainUser', 'userPrincipalName', 1, 1, 'var' ],
[ 'UserCustomerID', 'CustomerID', 'company', 0, 1, 'var' ],
[ 'UserCompanyGroupID', 'CompanyGroupID', 'primaryGroupID', 0, 1, 'var' ],
[ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ],
#[ 'UserAddress', 'Address', 'postaladdress', 1, 0, 'var' ],
#[ 'UserComment', 'Comment', 'description', 1, 0, 'var' ],
],
};

# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# end of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #

Habe dir mal meine config.pm hier her kopiert und das Mapping blau hervorgoben... die Zeile die blau hervorgehoben ist habe ich selbst hinzugefügt. Den Sinn und Zweck der zusätzlich gemappten Felder brauche ich an dieser Stelle ja nicht zu erläutern ... Fakt ist ... sie erscheinen! (siehe Screenshot im Anhang)

MikeDelta · Post by **MikeDelta** » 13 May 2015, 14:11

Hey - ich hoffe ich stelle mich gerade nicht ausgesprochen dämlich an - aber irgendwie scheitere ich.

So schaut meine COnfig.pm aus diese liegt in /html/Kernel/Config

Code: Select all

 
# CustomerUser
    # (customer user database backend and settings)
    $Self->{CustomerUser} = {
        Name   => 'Database Backend',
        Module => 'Kernel::System::CustomerUser::DB',
        Params => {
            # if you want to use an external database, add the
            # required settings
#            DSN  => 'DBI:odbc:yourdsn',
#            Type => 'mssql', # only for ODBC connections
#            DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
#            User => '',
#            Password => '',
            Table => 'customer_user',
#            ForeignDB => 0,    # set this to 1 if your table does not have create_time, create_by, change_time and change_by fields

            # CaseSensitive will control if the SQL statements need LOWER()
            #   function calls to work case insensitively. Setting this to
            #   1 will improve performance dramatically on large databases.
            CaseSensitive => 0,
        },

        # customer unique id
        CustomerKey => 'login',

        # customer #
        CustomerID             => 'customer_id',
        CustomerValid          => 'valid_id',

        # The last field must always be the email address so that a valid
        #   email address like "John Doe" <john.doe@domain.com> can be constructed from the fields.
        CustomerUserListFields => [ 'first_name', 'last_name', 'email' ],

#        CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
        CustomerUserSearchFields           => [ 'login', 'first_name', 'last_name', 'customer_id' ],
        CustomerUserSearchPrefix           => '*',
        CustomerUserSearchSuffix           => '*',
        CustomerUserSearchListLimit        => 250,
        CustomerUserPostMasterSearchFields => ['email'],
        CustomerUserNameFields             => [ 'title', 'first_name', 'last_name' ],
        CustomerUserEmailUniqCheck         => 1,

#        # show now own tickets in customer panel, CompanyTickets
#        CustomerUserExcludePrimaryCustomerID => 0,
#        # generate auto logins
#        AutoLoginCreation => 0,
#        # generate auto login prefix
#        AutoLoginCreationPrefix => 'auto',
#        # admin can change customer preferences
#        AdminSetPreferences => 1,
#        # use customer company support (reference to company, See CustomerCompany settings)
#        CustomerCompanySupport => 1,
        # cache time to live in sec. - cache any database queries
        CacheTTL => 60 * 60 * 24,
#        # just a read only source
#        ReadOnly => 1,
        Map => [

            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target, link class(es)
            [ 'UserTitle',      'Title',      'title',      1, 0, 'var', '', 0 ],
            [ 'UserFirstname',  'Firstname',  'first_name', 1, 1, 'var', '', 0 ],
            [ 'UserLastname',   'Lastname',   'last_name',  1, 1, 'var', '', 0 ],
            [ 'UserLogin',      'Username',   'login',      1, 1, 'var', '', 0 ],
            [ 'UserPassword',   'Password',   'pw',         0, 0, 'var', '', 0 ],
            [ 'UserEmail',      'Email',      'email',      1, 1, 'var', '', 0 ],
#            [ 'UserEmail',      'Email', 'email',           1, 1, 'var', '[% Env("CGIHandle") %]?Action=AgentTicketCompose;ResponseID=1;TicketID=[% Data.TicketID | uri %];ArticleID=[% Data.ArticleID | uri %]', 0, '', 'AsPopup OTRSPopup_TicketAction' ],
            [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ],
#            [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
            [ 'UserPhone',        'Phone',       'phone',        1, 0, 'var', '', 0 ],
            [ 'UserFax',          'Fax',         'fax',          1, 0, 'var', '', 0 ],
            [ 'UserMobile',       'Mobile',      'mobile',       1, 0, 'var', '', 0 ],
            [ 'UserStreet',       'Street',      'street',       1, 0, 'var', '', 0 ],
            [ 'UserZip',          'Zip',         'zip',          1, 0, 'var', '', 0 ],
            [ 'UserCity',         'City',        'city',         1, 0, 'var', '', 0 ],
            [ 'UserCountry',      'Country',     'country',      1, 0, 'var', '', 0 ],
            [ 'version',         'Version',      'version',         1, 0, 'var', '', 0 ],
            [ 'addone',          'AddOnOne',     'addone',          1, 0, 'var', '', 0 ],
            [ 'addtwo',          'AddOnTwo',     'addtwo',          1, 0, 'var', '', 0 ],
            [ 'addthree',        'AddOnThree',   'addthree',        1, 0, 'var', '', 0 ],
            [ 'addfour',         'AddOnFour',    'addfour',         1, 0, 'var', '', 0 ],
            [ 'brokerone',       'BrokerOne',    'brokerone',       1, 0, 'var', '', 0 ],
            [ 'brokertwo',       'BrokerTwo',    'brokertwo',       1, 0, 'var', '', 0 ],
            [ 'brokerthree',     'BrokerThree',  'brokerthree',     1, 0, 'var', '', 0 ],
            [ 'brokerfour',      'BrokerFour',   'brokerfour',      1, 0, 'var', '', 0 ],
            [ 'feedone',         'FeedOne',      'feedone',         1, 0, 'var', '', 0 ],
            [ 'feedtwo',         'FeedTwo',      'feedtwo',         1, 0, 'var', '', 0 ],
            [ 'feedthree',       'FeedThree',    'feedthree',       1, 0, 'var', '', 0 ],
            [ 'feedfour',        'FeedFour',    'feedfour',         1, 0, 'var', '', 0 ],
            [ 'UserComment',      'Comment',     'comments',     1, 0, 'var', '', 0 ],
            [ 'ValidID',          'Valid',       'valid_id',     0, 1, 'int', '', 0 ],
            
        ],

        # default selections
        Selections => {

UserTitle => {
                'Mr.' => 'Mr.',
                'Mrs.' => 'Mrs.',
            },
version =>{    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
addone => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
addtwo =>{    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
addthree => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
addfour => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
brokerone =>{    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
brokertwo => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
brokerthree => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
brokerfour => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
feedone => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
feedtwo => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
feedthree => {    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
feedfour =>{    '--' => '--',
                'Demo' => 'Demo',
                'Basic' => 'Basic',

},
        },
    };

nd0 · Post by **nd0** » 13 May 2015, 15:39

MikeDelta wrote:So schaut meine COnfig.pm aus diese liegt in /html/Kernel/Config

Da haben wir es doch schon - oder?

Meine config.pm liegt in /html/Kernel

... im Ordner /html/Kernel/Config befindet sich meines Wissens nur die Defaults.pm

MikeDelta · Post by **MikeDelta** » 13 May 2015, 15:45

danke

oh jetzt wird es peinlich - ihr seid spitze danke

nd0 · Post by **nd0** » 13 May 2015, 15:49

Kein Ding,

ABER ALTER

... der Apache fährt ja nichtmal hoch wenn die config.pm in besagtem Ordner liegt ...

service apache2 restart wrote:Action 'start' failed.
The Apache error log may have more information.

Naja hauptsache klappt jetzt

Viel Spaß weiterhin und denk an [SOLVED] im Titel...

Znuny Open Source Ticketsystem

[solved]Zusätzliche Kundenfelder

[solved]Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder

Re: Zusätzliche Kundenfelder