Re: [otrs] IMAP on Windows

I can't seem to find these sections in sysconfig to tell the perl module where to get the e-mail from. Where do I get these settings? Unfortunately I don;t have POP e-mail for this so it does have to draw it all from an IMAP server. And also unfortunately I am stuck with a Windows machine. Wha

Re: [otrs] Change to the field tn

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mariuxi Campoverde schrieb: > I would like to be able to change to the field tn of the table ticket to > have something like this: > > Ticket#200703190001 > Ticket#200703190002 > Ticket#200703190003 > > How do I change this? Hi th

Re: [otrs] POP3 and SSL (idea)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Miguel Angel Bayona Pérez schrieb: > It seems that more and more, POP3 e-mail access is done via SSL (i.e. > gmail). Current implementation in OTRS (i.e. PostMasterPOP3.pl) is done > via Net::POP3 module which does not support SSL. Would it be possible

[otrs] Possible bug in OTRS - email address falsely marked as invalid

> We received an email from [EMAIL PROTECTED] When our support operator tries > to send the reply, OTRS returns a message: "invalid config > ([EMAIL PROTECTED]). The email address works, we have confirmed this. > > Bug or feature? My guess is, the email address validation subroutine does > not kno

RE: [otrs] Can I create stats for time units?

There is an SQL box in the Admin area, but you probably better use a nice MySQL tool: Recently I ran into a free -and pretty good- tool (so for anyone who it might interest): http://www.mentattech.com/download/installer_mysql_turbo_manager_free.ex e

RE: [otrs] Can I create stats for time units?

Yes: month(t.create_time) = 3 see: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html and you can do anything on time/dates Regards, Peter Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Donald Musser Verzonden: dinsdag 20 maart 2007 23:03 Aan: U

Re: [otrs] Can I create stats for time units?

Hm...I see...simple enough, I suppose. Two questions come to mind in light of this info: - would it be possible to reflect that so that it's easily viewable in the web interface? - to modify the time period I'm searching for, could I do something like this tp get work units for March? month(

RE: [otrs] Can I create stats for time units?

You can pretty easy create a query like: SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join system_user AS u ON t.create_by = u.id WHERE year(t.create_time) = '2006' GROUP BY t.create_by It will give you userid, firtstname, lastnam

[otrs] Can I create stats for time units?

Hello everyone, I've had a bit of exposure to OTRS, as my company has been using it as our ticketing system for months now. We recently made the decision to start recording work units, and I wanted to know if anyone knew of a way to incorporate work units into the STATS objects. More specifically

RE: [otrs] POP3 and SSL (idea)

You can use Fetchmail to POP it to a local account and then POP in in OTRS Regards, Peter -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Miguel Angel Bayona Pérez Verzonden: dinsdag 20 maart 2007 18:06 Aan: otrs@otrs.org Onderwerp: [otrs] POP3 and SSL (ide

[otrs] POP3 and SSL (idea)

It seems that more and more, POP3 e-mail access is done via SSL (i.e. gmail). Current implementation in OTRS (i.e. PostMasterPOP3.pl) is done via Net::POP3 module which does not support SSL. Would it be possible (and easy) to repalce it with the Mail::POP3Client? Unfortunatelly, I'm not a perl

[otrs] Change to the field tn

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#200703191022] and then I compose other ticket gets a ticket number [Ticket#200703191034] I would like to be able to change to the field tn

Re: [otrs] 3 questions about: stats per user, per agent and about email notification

Hi Akis, Akis schrieb: > About reporting... > I had a lot of problems with the stats provided by OTRS. I used a > reporting tool (infomaker) which solved all my problems even in very > comlicated queries. > I suggest you do the same > >