December 2002 - dev - OTRS mailing lists

[PATCH] view customer data on ticket
by Wiktor Wodecki 10 Dec '02

10 Dec '02

Hello, You can assign a ticket to a customer. However in the queue view you can click on the customers number. I'd like to see information about the customer, and rather not a customer login prompt. I don't know, what are you thinking? Discussion welcome :-) PS: I know this is only a first hack and the output page isn't very pretty (because I didn't look at the dtl thingy yet) -- Regards, Wiktor Wodecki

2 7

[PATCH] minor cosmetic
by Wiktor Wodecki 10 Dec '02

10 Dec '02

hi there, just something very small and cosmetic *grin* -- Regards, Wiktor Wodecki

2 1

[PATCH] get customer info from LDAP
by Wiktor Wodecki 10 Dec '02

10 Dec '02

hi there, here's the first revision of the promissed patch. There are a couple of FIXME's still in there, but basically it is working. However, I have one problem I cannot resolve. It wont display a currect drop-down menu on index.pl?Action=AgentCustomer&TicketID=378154 but it correctly displays customer information. I get the following logfile messages: [Tue Dec 10 17:33:02 2002] index.pl: Use of uninitialized value in string comparison (cmp) at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/Output/HTML/Generic.pm line 800. [Tue Dec 10 17:33:02 2002] index.pl: Use of uninitialized value in string comparison (cmp) at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/Output/HTML/Generic.pm line 800. [Tue Dec 10 17:33:02 2002] index.pl: Use of uninitialized value in concatenation (.) or string at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/Output/HTML/Agent.pm line 670. I don't think the third error bothers much, however the first two do. I don't know enough about perl to say what's wrong. Any help would be appreciated as well as comments to the code. PS: I also corrected some typos in the code :P PPS: I wont be in office till Thursday, so please be patient with my answer(s). -- Regards, Wiktor Wodecki

1 0

Crypt and Compress modules in CVS!
by Martin Edenhofer 09 Dec '02

09 Dec '02

Hi, JFYI. I added compress and crypt support for the ticket/article storage to the CVS. It means if you use "Kernel::System::Ticket::Compress::Zlib" as TicketCompressModule (in Config.pm) all attachments and plain emails will be stored compressed with Zlib. Default is "Kernel::System::Ticket::Compress::Plain". If you use "Kernel::System::Ticket::Crypt::Blowfish" as TicketCryptModule (in Config.pm) all attachments and plain emails will be stored encrypted with Blowfish encryption algorithm. Default is "Kernel::System::Ticket::Compress::Plain". Note: Don't change this setting if your system is in use. Set this setting on setup time. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneier

1 0

[PATCH] increase userfriendlyness on PhoneViewNew and AgentCustomer
by Wiktor Wodecki 05 Dec '02

05 Dec '02

hi there, I don't want my customer-care guys to remember what the customer id was..... Note that this also uses the comment field as the company name field. -- Regards, Wiktor Wodecki

2 1

Customer User Management view question
by Wiktor Wodecki 05 Dec '02

05 Dec '02

Hello list, I'm curious whether the combobox displays id(login) or login(id). Whatever it is it doesn't make much sense to me. While importing data from our LDAP to the database for transition I added the company name in the comment field and I'd like to see it in the combobox. Is it enough to change Kernel/System/CustomerUser.pm to reflect this? Are there any plans in extending the db scheme for a "company name" field? -- Regards, Wiktor Wodecki

1 1

Language initialisation problem in current CVS :-(
by Ingo Ciechowski 02 Dec '02

02 Dec '02

Hi, after a while I just reinstalled OTRS from CVS again (on a SuSE Linux 8.1 system with perl 5.8 and postgres) and unfortunately ran into some trouble. My first try to access http://localhost/otrs/index.pl results in an "Internal server error" from my apache and the following entries in the apache error log: [Fri Nov 29 21:49:24 2002] null: Use of uninitialized value in string eq at /opt/OpenTRS/bin/cgi-bin/../../Kernel/System/Ticket/Article.pm line 50. [Fri Nov 29 21:49:24 2002] null: Use of uninitialized value in string eq at /opt/OpenTRS/bin/cgi-bin/../../Kernel/System/Ticket/Article.pm line 50. [Fri Nov 29 21:49:49 2002] [error] Can't use an undefined value as a HASH reference at /opt/OpenTRS/bin/cgi-bin/../../Kernel/Output/HTML/Generic.pm line 65. If I reload the page the proper login screen gets displayed, but there is an extra section: Language: Got no Data ref in OptionStrgHashRef()!submit Trying to login is similar: Server error on first submit, first reload in the browser and correct screen after a second reload... In the Preferences dialog (showing up after second reload) there's no choice of languages... Hope this helps to figure out some workaround. Ingo -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/B/O d+(-) s+:++ a C++ UL++++$ P++$ L+++@ E- W+++@ N+ o? K? w-- O M++@ V PS+ PE++ Y+ PGP++ t++ 5 X R tv+ b+@ DI+@ D--- G+ e? h-- r+++@ y? ------END GEEK CODE BLOCK------

2 4

string too long in initial_insert.sql
by Ingo Ciechowski 01 Dec '02

01 Dec '02

Hi, PostgreSQL claims during loading initial_insert.sql that the following insert statemant contains a too long string in the 'name' field: INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic Charset (Windows-1251)', 'Windows-1251', 'Windows-1251 - cp1251', 1, 1, current_timestamp, 1, current_timestamp); You might want to define a larger string field in the schema. Ingo -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/B/O d+(-) s+:++ a C++ UL++++$ P++$ L+++@ E- W+++@ N+ o? K? w-- O M++@ V PS+ PE++ Y+ PGP++ t++ 5 X R tv+ b+@ DI+@ D--- G+ e? h-- r+++@ y? ------END GEEK CODE BLOCK------

2 1