[Solved]Informationen Kundenbenutzer

Hilfe zu Znuny Problemen aller Art
Forum rules
Locked
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

[Solved]Informationen Kundenbenutzer

Post by MikeDelta »

Hey ich habe ein eigenartiges Problem.
Es geht um den KundenBenutzer - manchmal werden mir Informatioen im TicketZoom angezeigt und manchmal nicht - obwohl Daten eingetragen wurden.
Ich erkenne aktuell keinen Zusammenhang.
Hat dieses Problem jemand erfolgreich gelöst?

Liebe Grüße
Mike
Last edited by MikeDelta on 26 May 2015, 14:52, edited 1 time in total.
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

Weitere Info
Eintrag von mir gelöscht da falsch :(
Last edited by MikeDelta on 26 May 2015, 14:01, edited 2 times in total.
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Informationen Kundenbenutzer

Post by RStraub »

Externe Datenbank oder LDAP angebunden?
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

Externe DB
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Informationen Kundenbenutzer

Post by RStraub »

Zur Referenz, nachdem dein 2. Beitrag gerade gekürzt wurde :)

Du siehst manchmal Kundeninfos und manchmal nicht, obwohl diese im OTRS gepflegt sind UND sie tauchen nicht in der customer_user tabelle auf?

Das klingt absolut merkwürdig. Ist das Problem unabhängig vom Customer-User und seiner Customer-ID? Taucht das Problem nur bei manchen Nutzern auf, oder zufällig bei allen?
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

Hey vergiss den zweiten EIntrag der war Mist :)
Alles in der DB vorhanden

Das Problem taucht bei manchen Benutzern auf - ich kann es gerade nicht "festnageln" ich finde auch kein "pattern"
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Informationen Kundenbenutzer

Post by RStraub »

Kannst du Screenshots (geschwärzt) hochladen oder die Attribute listen die auftauchen bzw. nicht auftauchen ?
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

hier meine config.pm

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} = '127.0.0.1';

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

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

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

    # 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/xxxxx/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$
      $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, 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',
                'Discovery' => 'Discovery',
                'Andromeda' => 'Andromeda',
            },
addone => {
                '--' => '--',
                'Born' => 'Born',
                'Umland' => 'Umland',
                'Gabel' => 'Gabel',
                'Markttechnik' => 'Markttechnik',
            },
addtwo => {
                '--' => '--',
                'Born' => 'Born',
                'Umland' => 'Umland',
                'Gabel' => 'Gabel',
                'Markttechnik' => 'Markttechnik',
            },
addthree => {
                '--' => '--',
                'Born' => 'Born',
                'Umland' => 'Umland',
                'Gabel' => 'Gabel',
                'Markttechnik' => 'Markttechnik',
            },
addfour => {
                '--' => '--',
                'Born' => 'Born',
                'Umland' => 'Umland',
                'Gabel' => 'Gabel',
                'Markttechnik' => 'Markttechnik',
            },
brokerone => {
                '--' => '--',
                'AMP' => 'AMP',
                'Arrowfield' => 'Arrowfield',
                'CapTrader' =>  'CapTrader',
                'Dukascopy' => 'Dukascopy',
                'FXCM' => 'FXCM',
                'IB' => 'IB',
                'LMAX' => 'LMAX',
                'MB' => 'MB',
                'Optimus' => 'Optimus',
                'Progressive' => 'Progressive',
                'TF4L' => 'TF4L',
                'XTB' => 'XTB',
            },
brokertwo => {
                '--' => '--',
                'AMP' => 'AMP',
                'Arrowfield' => 'Arrowfield',
                'CapTrader' =>  'CapTrader',
                'Dukascopy' => 'Dukascopy',
                'FXCM' => 'FXCM',
                'IB' => 'IB',
                'LMAX' => 'LMAX',
                'MB' => 'MB',
                'Optimus' => 'Optimus',
                'Progressive' => 'Progressive',
                'TF4L' => 'TF4L',
                'XTB' => 'XTB',
            },
brokerthree => {
                '--' => '--',
                'AMP' => 'AMP',
                'Arrowfield' => 'Arrowfield',
                'CapTrader' =>  'CapTrader',
                'Dukascopy' => 'Dukascopy',
                'FXCM' => 'FXCM',
                'IB' => 'IB',
                'LMAX' => 'LMAX',
                'MB' => 'MB',
                'Optimus' => 'Optimus',
                'Progressive' => 'Progressive',
                'TF4L' => 'TF4L',
                'XTB' => 'XTB',
            },
brokerfour => {
                '--' => '--',
                'AMP' => 'AMP',
                'Arrowfield' => 'Arrowfield',
                'CapTrader' =>  'CapTrader',
                'Dukascopy' => 'Dukascopy',
                'FXCM' => 'FXCM',
                'IB' => 'IB',
                'LMAX' => 'LMAX',
                'MB' => 'MB',
                'Optimus' => 'Optimus',
                'Progressive' => 'Progressive',
                'TF4L' => 'TF4L',
                'XTB' => 'XTB',
            },
feedone => {
                '--' => '--',
                'BrokerNative' => 'BrokerNative',
                'Barchart' => 'Barchart',
                'CQG' => 'CQG',
                'IQFeed' => 'IQFeed',
                'TaiPan' => 'TaiPan',
                'Teletrader' => 'Teletrader',
                'Yahoo' => 'Yahoo',
                'Google' => 'Google',
            },
feedtwo => {
                '--' => '--',
                'BrokerNative' => 'BrokerNative',
                'Barchart' => 'Barchart',
                'CQG' => 'CQG',
                'IQFeed' => 'IQFeed',
                'TaiPan' => 'TaiPan',
                'Teletrader' => 'Teletrader',
                'Yahoo' => 'Yahoo',
                'Google' => 'Google',
            },
feedthree => {
                '--' => '--',
                'BrokerNative' => 'BrokerNative',
                'Barchart' => 'Barchart',
                'CQG' => 'CQG',
                'IQFeed' => 'IQFeed',
                'TaiPan' => 'TaiPan',
                'Teletrader' => 'Teletrader',
                'Yahoo' => 'Yahoo',
                'Google' => 'Google',
            },
feedfour => {
                '--' => '--',
                'BrokerNative' => 'BrokerNative',
                'Barchart' => 'Barchart',
                'CQG' => 'CQG',
                'IQFeed' => 'IQFeed',
                'TaiPan' => 'TaiPan',
                'Teletrader' => 'Teletrader',
                'Yahoo' => 'Yahoo',
                'Google' => 'Google',
            },
        },
    };
   

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

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

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

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

1;
Image
Last edited by MikeDelta on 26 May 2015, 14:24, edited 2 times in total.
Top
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Informationen Kundenbenutzer

Post by RStraub »

Ich könnte mir das so erklären:

1) Nichts taucht auf -> Das dürfte nur bei Prozesstickets der Fall sein, die keinen Kunden brauchen. Bei Mail/Telefon Tickets sind die Kundenfelder zwingend erforderlich.

2) Manche Attribute tauchen nicht auf -> Dem Kundenbenutzer ist kein Kunde (per CustomerID) zugeordnet.

Und dann fällt natürlich die schwer modifizierte Config.pm auf. Tritt das Problem auch mit der Standard-Datei auf?
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

Hey anbei noch ein screenshot
siehe oben
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

und wenn alles funktioniert schaut es so aus

Image
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

Mit der orginal config.pm habe ich das gleiche Problem.
Ich verstehe es nicht
"Kundeninformationen"="keine"
Top
MikeDelta
Znuny newbie
Posts: 33
Joined: 13 Jan 2015, 13:26
Znuny Version: 4.0.4

Re: Informationen Kundenbenutzer

Post by MikeDelta »

okay
gelöst

Username des Kunden muss die MailAdresse sein :( dann sieht man auch die Kundeninformationen *schäm*
Top
Locked

Return to “Hilfe”