Hi list. Is there a way to make otrs sendt out an email to the admin in the non-workhours, if at new ticket is recived? BR, Mikkel Robin

you should give yourself rights to the "stats" group the same way as you do to normal groups/queues so go to the Admin area, Users <-> Groups ________________________________ Van: otrs-bounces@otrs.org namens Mikkel Nielsen Verzonden: zo 30-9-2007 8:34 Aan: User questions and discussions about OTRS.org Onderwerp: [otrs] Stats Hi list! When i installed otrs, no my debian i was missing some Gdlib modules therefore my stats was not working. I have now install all modules, but i cat find anywhere to enable the stats i my otrs. How do i do this? # ./otrs.checkModules CGI ... ok Date::Pcalc ... ok Date::Format ... ok DBI ... ok DBD::mysql ... ok Digest::MD5 ... ok LWP::UserAgent ... ok IO::Scalar ... ok IO::Wrap ... ok MIME::Base64 ... ok MIME::Tools ... ok Mail::Internet ... ok Net::DNS ... ok Net::POP3 ... ok Net::LDAP ... ok Net::SMTP ... ok Authen::SASL ... ok GD ... ok GD::Text ... ok GD::Graph ... ok GD::Graph::lines ... ok GD::Text::Align ... ok XML::Parser ... Ok BR Mikkel Robin _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

I followed a old suggestion from this list and use PHPmyadmin to import CSV's works well. Barry Keyles -----Original Message----- From: Mike Dent [mailto:mcdent@gmail.com] Sent: Saturday, September 29, 2007 6:35 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Import customers from cvs? On 9/29/07, Hannes Riechmann wrote:

Hello,

is it possible to import customers from a cvs file? I thought about adapting the otrs.addUser script, so that it can add customer and then calling my script for every entry in my cvs file. Anybody knows a better solution?

Thank in advance

Hannes

Hi, I went through this when moving from RT to OTRS, here is the email I sent back to the list with how I did it, hope it helps. Mike mysql> load data infile '/tmp/otrs_test.txt' into table customer_user fields terminated by '\t' lines terminated by '\r' (first_name, last_name, address, postcode, phone1, email, customer_id, valid_id, create_time, create_by, change_time, change_by, login); Query OK, 195 rows affected (0.03 sec) Records: 195 Deleted: 0 Skipped: 0 Warnings: 0 This was after I created some extra fields in the mysql table with:- mysql> alter table customer_user add address varchar (250); Query OK, 1 row affected (0.46 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> alter table customer_user add postcode varchar (250); Query OK, 1 row affected (0.19 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> alter table customer_user add phone1 varchar (250); Query OK, 1 row affected (0.20 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> alter table customer_user add phone2 varchar (250); Query OK, 1 row affected (0.20 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> alter table customer_user add os varchar (250); Query OK, 1 row affected (0.20 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> alter table customer_user add broadband varchar (250); Query OK, 1 row affected (0.44 sec) Records: 1 Duplicates: 0 Warnings: 0 Another thing which got me was the end of line difference in unix and PC! when importing the data to the table above I originally was using '\n', eventually I figured I should be using '\r' ! Even though I was working on a Mac with Excel. So finally all my records are imported and I'm slowly getting to grips with it!

_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/