[otrs] Problem Getting Mail

2009-09-24 Thread Prince Chavez
(stops @: Message 1/2 (test-em...@non-ssl-pop3.com), only the non-ssl one. I am stuck so please help. I feel this is a wonderful piece of software (loved the demo), but I just cant get it to work. Thanks in advance, Prince -- Prince Chavez Customer Relations Manager Tonerboss.com 714.482

[otrs] Access denied for user 'otrs'@'localhost'

2009-09-25 Thread Prince Chavez
Hi All, I previously installed otrs2.2.4 on an Ubuntu 8.04 server, but it lacked imaps/pop3s support. So i removed it from my system and manually installed 2.4.4. Took me a while, but I managed to get the perl modules and apache configured. One thing I didn't remove was the database from my o

Re: [otrs] Access denied for user 'otrs'@'localhost'

2009-09-25 Thread Prince Chavez
yAdmin Amazing how much looking into the error logs and Google can help solve problems! Prince Chavez Customer Relations Manager Tonerboss.com Nathan Campbell wrote: Have you run the db update scripts?   Nathan Campbell Dallas Symphony Orchestra

Re: [otrs] cron pop3

2009-10-01 Thread Prince Chavez
/opt, enter the following: ---begin cut --- */5 * * * * /opt/otrs/bin/PostMasterMailbox.pl --- end cut --- to save it, press ctrl+O to exit from nano ctrl+x Hope that helps Prince Chavez Customer Relations Manager Tonerboss.com This message is intended solely for the use of the ori

[otrs] Mass Import Customers

2009-12-28 Thread Prince Chavez
Hi, I was wondering, is there was a way to import a csv (containing username,firstname,lastname, customerid, and email) to otrs's customer database? And if it was possible to associate other data (add fields if you will) to the customers? -- Prince Chavez Customer Relations Ma

[otrs] OTRS Reports

2009-12-28 Thread Prince Chavez
Hi, We were wondering how we could generate a report based on the following criteria (for both email and phone contact):  a.  Ratio solved within 1 to 2 response  b.  Ratio solved within 3 to 4 responses  c.  Ratio solved with more than 5 responses. Thanks in advance! -- Prince Chavez

Re: [otrs] Mass Import Customers

2009-12-29 Thread Prince Chavez
Thanks to all for your prompt reply! I will check out Thorsens module :) Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for the use of the original addressee(s) and may contain information that is privileged and confidential. Any

[otrs] Stats - Number of calls / emails before closure

2010-02-03 Thread Prince Chavez
Hi all, How can we track the number of updates (notes, phonecalls, emails) on a ticket before it was marked closed? Thanks in advance! -- Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for the use of the original addressee(s

Re: [otrs] Stats - Number of calls / emails before closure

2010-02-10 Thread Prince Chavez
E('2010-01-01') AND DATE('2010-02-01')) GROUP BY ticket.tn ORDER BY ticket.create_time ASC Regards, Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for the use of the original addressee(s) and may contain in

[otrs] Migration

2010-12-29 Thread Prince Chavez
, -- Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for the use of the original addressee(s) and may contain information that is privileged and confidential. Any

Re: [otrs] Migration

2010-12-29 Thread Prince Chavez
Which particular files, and would a simple import/export using phpMyAdmin work? Thanks Prince Chavez Customer Relations Manager TonerBoss.com 714-482-0377 x 6524 This message is intended solely for