March 2007 - otrs - OTRS mailing lists

Change to the field tn
by Mariuxi Campoverde 26 Mar '07

26 Mar '07

Hi: Can you help me with a question? When I compose an new ticket phone or new ticket mail, automatically gets a ticket number like this: [Ticket#2007031910000022] and then I compose other ticket gets a ticket number [Ticket#2007031910000034] I would like to be able to change to the field tn of the table ticket to have something like this: Ticket#2007031900000001 Ticket#2007031900000002 Ticket#2007031900000003.... How do I change this? Thanks a lot for your help Regards Mariuxi Campoverde Montero Help Desk mariuxic(a)winet.com.pe Central : (511) 222-8000 Help Desk : (511) 446-4222 Ventas : (511) 222-8000 http://www.wi-net.net **

4 5

Stats problem
by Vicente Barbera 25 Mar '07

25 Mar '07

Hi All, i've just installed otrs on a FreeBSD box via ports, spanish language, everything works fine but stats. When i click into de stats links i see this error on otrs logs... "error OTRS-CGI-10 Can not open Directory: /usr/local/otrs/scripts/test/sample/" And the next one on the IE explorer "Internat Server Error" And another one on FreeBSD box console: "[Error][Kernel::System::Stats::_AutomaticSampleImport][Line 2293]" What's happening? Regards, Vicente.

1 0

Ticket Number
by Tom 25 Mar '07

25 Mar '07

Hello, Is DATE NumberGenerator generates Ticket number from current date (YearMonthDay) + SystemID + Counter and the Counter is reseted to 0 every day or Counter just increments day by day? Is SystemID may be null ? I understand that in Autoincrement generator counter must not be reseted but in Date NumberGenerator may be reseted for example every day or not ? I wonder about to have short as possible Ticket number and the best ticket identifier at once. Is there anybody encounterd such problems and will share with his experiences? Tom

1 0

Delete 900 tickets manually by script
by mario 24 Mar '07

24 Mar '07

Hello List, we have ~900 new Mails due to a wrong configuration. Is there a way to delete those tickets manually from the Database or something. They all have the same Subject/Content. Thanks, Mario

2 2

Soporte para Mexico
by Plinio Jose Sosa Chagoyan 24 Mar '07

24 Mar '07

Hay algún usuario originario de México con el que pudiera intercambiar experiencias? Saludos cordiales PSC __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/

2 1

OTRS v2.1.6 for Ubuntu Breezy
by mario 24 Mar '07

24 Mar '07

Hello List, we use OTRS since 2 years or so. We keep running into Problems such as unicode issues, broken attachments an so on. We would like to always use the newest stale OTRS version if possible. Is there apt repository we could use to maintain our OTRS? Thanks, Mario

2 1

Connection to Oracle Database
by Yosua Winata 24 Mar '07

24 Mar '07

Dear all, Hi, ny name is yosua. I would like to ask to you all, how is the way to connect otrs to oracle database? Usually, I am using mysql. Because the capacity of mysql isn't enough, I would like to using oracle. Can someone help me? Thank you for your help. Regards, Yosua --------------------------------- Never miss an email again! Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.

1 0

Ticket::NumberGenerator, clearing database
by Tom 23 Mar '07

23 Mar '07

Hello I'm new one to OTRS and I try to SET best configuration for me . I use OTRS2 2.0.4p01-17 on debian. I want to set Ticket::NumberGenerator: to AutoIncrement. Now for Ticket::NumberGenerator I have DateChecksum under WEB SysConfig. When I change to AutoIncrement there is problem with fetching new emails and I have such notice in system log when system try to fetch email through PostMasterPOP3: "Can't create PID PostMasterPOP3, because it's already running (xxxxxxxxxxxxxx/9287)! " When I run PostMasterPOP3.pl with force otpion under console there I have error in AutoIncrement.pl script: "Quantifier follows nothing in regex; marked by <-- HERE in m/+ <-- HERE .{0,2}(10\d{5,10})/ at /usr/share/otrs/Kernel/System/Ticket/Number/AutoIncrement.pm line 110, <PRODUCT> line 4." Is this BUG or what? What is the problem, how to change Ticket::NumberGenerator ? Which tables (mysql) may I truncate to clear data such as fetched emails (attachements), ticket history, notes etc. ? I mean truncate tables which collects data ivolved with fetched emails, I mean which tables truncate to reset OTRS (not to delete users,queues states,Salutations, notifications and other similar)? Reinstall of hole database is nedded I mean is this safe to truncate single tables? What for are options when sending answer or new email ticket from OTRS: Time units (work units) Pending Date (for pending* states) ? Thx in advance

1 0

Can't find notification for Agent::NewTicket and pt_BR, try it again with en!
by Marcos Kamada 23 Mar '07

23 Mar '07

Hi Folks! How can I fix this error? Regards, Marcos Kamada _________________________________________________________________ MSN Busca: fácil, rápido, direto ao ponto. http://search.msn.com.br

1 0

HTML replys
by Will Sheldon 23 Mar '07

23 Mar '07

I'm sorry if i am repeating an earlier thread here, but all i could find was from some time ago. Has there been any progress with regard to viewing and sending HTML messages? Our customers frequently send us (embedded) screenshots, so a click to view for image attachments would be a suitable alternative to viewing the full html. Also it'd be nice to be able to append an html signature to messages, or insert a block of html to messages with some kind of markup tag. I'd be quite happy to try to code this functionality, but I haven't looked into how OTRS works yet, so any pointers would be hugely appreciated. W.

1 0