maybe you should never add anything to defaults.pm
better use the appropriate config files for actions like this.....
just 2ct,
Li
[EMAIL PROTECTED] schrieb am 09.03.2006 18:51:47:
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> > Zaeem Arshad
> > Sent: quinta-feira, 9 de Março de 2006 15:06
> > To: User questions and discussions about OTRS.org
> > Subject: RE: [otrs] Adding new fields in ticket
> >
> > hi,
> >
> > On Thu, 2006-03-09 at 14:44 +0000, Duarte Cordeiro wrote:
> > > You have 2 different options:
> > >
> > > 1) Use freekey[1..8]/freetext[1..8]
> >
> > There are only 4 freekeys shown in a default install of OTRS 2.0 and
> > they can only be added after a ticket is created. My requirement is to
> > populate fields upon creation of the phone ticket.
>
> Just edit the corresponding template page. For example, on 2.0.1,
> one of them is: kernel/ouotput/html/standard/AgentTicketPhone.dtl
> and uncomment the 5 to 8 pairs :)
>
> >
> > > 2) Add this info to the customer table
> > >
> > > I suggest the 2nd, but it always depends on the setup.
> >
> > Exactly. This is what I want. Any pointers on how to do that? I need to
> > make sure that the added fields are consistent with the whole OTRS
> > design as well.
>
> Someone may kick me, but I just edited Kernel/Config/Defaults.pm and...
>
> $Self->{CustomerUser} = {
> Name => 'Database Backend',
> Module => 'Kernel::System::CustomerUser::DB',
> Params => {
> Table => 'customer_user',
> },
> # customer uniq id
> CustomerKey => 'login',
> # customer #
> CustomerID => 'customer_id',
> CustomerValid => 'valid_id',
> CustomerUserListFields => ['first_name', 'last_name', 'email'],
> # CustomerUserListFields => ['login', 'first_name',
> 'last_name', 'customer_id', 'email'],
> CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
> CustomerUserSearchPrefix => '',
> CustomerUserSearchSuffix => '*',
> CustomerUserSearchListLimit => 250,
> CustomerUserPostMasterSearchFields => ['email'],
> CustomerUserNameFields => ['salutation', 'first_name', 'last_name'],
> CustomerUserEmailUniqCheck => 0,
> Map => [
> # note: Login, Email and CustomerID needed!
> # var, frontend, storage, shown (1=always,2=lite),
> required, storage-type, http-link, readonly
> [ 'UserSalutation', 'Saudacao ', 'salutation', 1, 0,
> 'var', '', 0 ],
> [ 'UserFirstname', 'Nome Proprio', 'first_name', 0,
> 1, 'var', '', 0 ],
> [ 'UserLastname', 'Apelido', 'last_name', 0, 1,
> 'var', '', 0 ],
> [ 'UserMiddlenames', 'Nome ', 'middle_names', 1, 1, 'var', '', 0],
> [ 'UserMobile', 'Telefone', 'mobile', 1, 0, 'var', '',0 ],
> ['UserPhone2', 'Outro Contacto', 'phone', 1,0, 'var', '',0],
> [ 'UserFullOrganica', 'Organica', 'organica_text', 1, 0,
> 'var','',1 ],
> [ 'UserLocal', 'Local', 'local', 0, 1, 'int','',0 ],
> [ 'UserFullLocal', 'Local', 'local_text', 1, 0, 'var','',1 ],
> ['UserLocal2', 'Local 2', 'local2',1,0,'var','',0],
>
>
> [ 'UserCargo', 'Cargo', 'cargo', 1, 0, 'var', '', 0],
> [ 'UserOrganica', 'Organica', 'organica', 0, 1, 'int','',0 ],
> [ 'UserEmail', 'Email', 'email', 1, 1, 'var',
> '$Env{"CGIHandle"}?
> Action=""> > &ArticleID=$Data{"ArticleID"}', 0 ],
> [ 'UserLogin', 'Login', 'login', 1, 1,
> 'var', 'http://helpdesk.cm-lisboa.net/otrs/index.pl?
> Action="" 0 ],
> [ 'UserAD', 'LoginAD', 'login_ad', 1, 0, 'var','',0 ],
> [ 'NrMecanografico', 'Nr Mecanografico',
> 'mecanografico', 1, 0, 'var','',0 ],
>
> [ 'UserPassword', 'Password', 'pw', 0, 1,
> 'var', '', 0 ],
> [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1,
> 'var', '', 0 ],
> [ 'UserSapLogin', 'Saplogin', 'sap_login', 1, 0, 'var' ,'',0],
> [ 'UserComputerName', 'Computername', 'computer_name',
> 1, 0, 'var','',0 ],
> [ 'UserComment', 'Comment', 'comments', 1, 0,
> 'var', '', 0 ],
> # [ 'UserOrganicaOld', 'Organica', 'organica_old', 0, 0,
> 'var','',1 ],
> [ 'ValidID', 'Valid', 'valid_id', 0, 1,
> 'int', '', 0 ],
> ],
> # default selections
> Selections => {
> UserSalutation => {
> ' ' => ' ',
> 'Sr.' => 'Sr.',
> 'Sra.' => 'Sra.',
> 'Dr.' => 'Dr.',
> 'Dra.' => 'Dra.',
> 'Eng.' => 'Eng.',
> 'Arq.' => 'Arq.',
> },
> },
> };
>
> Then, just fire up mysql...
> mysql> desc customer_user;
> +---------------+--------------+------+-----+---------------------
> +----------------+
> | Field | Type | Null | Key | Default |
> Extra |
> +---------------+--------------+------+-----+---------------------
> +----------------+
> | id | int(11) | | PRI | NULL |
> auto_increment |
> | login | varchar(100) | | UNI | | |
> | email | varchar(150) | | | | |
> | customer_id | varchar(200) | | | | |
> | pw | varchar(50) | | | | |
> | salutation | varchar(50) | YES | | NULL | |
> | first_name | varchar(100) | | | | |
> | last_name | varchar(100) | | | | |
> | valid_id | smallint(6) | | | 0 | |
> | comments | varchar(250) | | | | |
> | create_time | datetime | | | 0000-00-00 00:00:00 | |
> | create_by | int(11) | | | 0 | |
> | change_time | datetime | | | 0000-00-00 00:00:00 | |
> | change_by | int(11) | | | 0 | |
> | middle_names | varchar(250) | YES | | NULL | |
> | phone | varchar(50) | YES | | NULL | |
> | mobile | varchar(50) | YES | | NULL | |
> | sap_login | varchar(50) | YES | | NULL | |
> | computer_name | varchar(150) | YES | | NULL | |
> | cargo | varchar(150) | YES | | NULL | |
> | organica_old | varchar(100) | YES | | NULL | |
> | local | int(11) | YES | | NULL | |
> | login_ad | varchar(100) | YES | | NULL | |
> | organica | int(11) | YES | | NULL | |
> | local_text | varchar(150) | YES | | NULL | |
> | organica_text | varchar(150) | YES | | NULL | |
> | local2 | varchar(100) | YES | | NULL | |
> | mecanografico | varchar(30) | YES | | NULL | |
> +---------------+--------------+------+-----+---------------------
> +----------------+
> 28 rows in set (0.00 sec)
>
>
>
> Meaning...
> Add a new line to Defaults.pm, and a new table column to customer_user :)
>
>
> Hope it Helps
>
> >
> >
> > Regards
> >
> > --
> > ZA
> >
> >
> > >
> > > > -----Original Message-----
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> > Of
> > > > Zaeem Arshad
> > > > Sent: quinta-feira, 9 de Março de 2006 13:45
> > > > To: [email protected]
> > > > Subject: [otrs] Adding new fields in ticket
> > > >
> > > > Hi,
> > > >
> > > > Any pointers on how to add multiple fields in a new phone ticket like
> > > > phone number, house address etc etc.
> > > >
> > > >
> > > > regards
> > > >
> > > > --
> > > > ZA
> > > >
> > > > _______________________________________________
> > > > 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
> > > > Support oder Consulting für Ihr OTRS System?
> > > > => http://www.otrs.de/
> > >
> > > _______________________________________________
> > > 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
> > > Support oder Consulting für Ihr OTRS System?
> > > => http://www.otrs.de/
> > >
> >
> > _______________________________________________
> > 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
> > Support oder Consulting fr Ihr OTRS System?
> > => http://www.otrs.de/
>
> _______________________________________________
> 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
> Support oder Consulting für Ihr OTRS System?
> => http://www.otrs.de/
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
