RE: [Spam] Re: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread LQ Marshall
The database could be named nearly anything. If you have access to OTRS files the database is referenced in the Config.pm file (it's in the Kernel dir). Don't know if the win32 version uses the same structure though. Probably will have to look for the DB name and then go back to Query analyzer.

RE: [otrs] Otrs Themes

2008-02-08 Thread Brett Davis
I just use the "Standard" theme and mine looks just like the doc's too. Click the "Preferences" link and make sure your "Theme" is set to "Standard". If it is set to Standard yet your screens still don't look like the demo then I'd look into the possibility that someone edited some or all of the .

RE: [otrs] addig columns to ticketstatusview?

2008-02-08 Thread Brett Davis
Hey Stan, No kidding. Users are horrible at descriptive subjects. Seems like I either get a book which gets clipped before getting to the point or, my personal favorite, "Problem!". Gee, really? ;-) I have a few users that simply refuse to include a subject at all which makes it pretty tough

Re: [otrs] Otrs Themes

2008-02-08 Thread Nils Breunese (Lemonbit)
Pico Aeterna wrote: I just recently installed OTRS and am pretty happy with it however I noticed that my installation does not look like the screenshots provided. Is there a theme that I can download to make my installation look the same as the demos shots? AFAIK that is the default theme. Ou

[otrs] Otrs Themes

2008-02-08 Thread Pico Aeterna
I just recently installed OTRS and am pretty happy with it however I noticed that my installation does not look like the screenshots provided. Is there a theme that I can download to make my installation look the same as the demos shots? ___ OTRS mailing

[otrs] addig columns to ticketstatusview?

2008-02-08 Thread Stan McFarland
Hi, I'd like to be able to add a title column to the AgentTicketStatusView display (the customer/subject is frequently not very descriptive). Is there an easy way to do this? Thanks, Stan ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Arch

[otrs] Creating Stats

2008-02-08 Thread Ryan Smith
I would like to create a chart/table with stats on the # of tickets opened and # of tickets closed (preferrably each week). First, from what I can tell it is impossible to do this by week, correct? If that is the case I can live with daily stats. Second, I don't see how to combine both of these

Re: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread BCWINFO
Dear LQ. I found it!!! I have a structure like explorer. The left site, a lot of DBs? I could not find anything like OTRS... On Feb 8, 2008 2:59 PM, LQ Marshall <[EMAIL PROTECTED]> wrote: > > what SQL Tool? Any tip? > > I think you said you were using M$-SQL which implies that there is an > ins

Re: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread LQ Marshall
> what SQL Tool? Any tip? I think you said you were using M$-SQL which implies that there is an install of the MS SQL Query Analyzer on the server. If it was not installed you can install it from the install CD, but it is loaded by default. gl ___ OTR

RE: [otrs] X-OTRS-Headers - Usage

2008-02-08 Thread Duane Owens
Lars, I got it working... I used the perl NET::POP3 module and wrote a script to read each message in. Then I just re-arranged the X-OTRS-Header messages to the top of the message and piped the whole mess out to Postmaster.pl. Regards Duane -Original Message- From: [EMAIL PROTECTED]

[otrs] OTRS doesn't handle UTF-8 emails in HTML format?

2008-02-08 Thread Tomasz Chmielewski
Whenever an UTF-8 email in HTML format is sent to OTRS here, all UTF-8 characters (like German umlauts etc.) are garbled into something like: �ö�� The same UTF-8 email sent in plain text format is displayed correctly. Is it just my setup? If not, is there a workaround to that? I use OTRS

Re: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread BCWINFO
Dear Peter, what SQL Tool? Any tip? On Feb 8, 2008 10:51 AM, Peter van Beugen <[EMAIL PROTECTED]> wrote: > 1. I understand. [EMAIL PROTECTED] = the default user = user_id 1 > > 2. Access the SQL table "group_user" direct (use a sql tool) > > 3. Set for admin = user_id = 1 è th

[otrs] Frederic Fraudeau/FR/Schneider est absent(e).

2008-02-08 Thread frederic . fraudeau
Je serai absent(e) à partir du 08/02/2008 de retour le 14/02/2008. Bonjour, Je suis actuellement absent et serai à nouveau disponible le 14/02/08. Pour toute question technique urgente, merci d'ouvrir un ticket OTRS à l'adresse "http://support.ilevo.com/customer"; ou de de contacter le Support

[otrs] Problems with e-mail notification

2008-02-08 Thread William Murat
Hello! I have 2.2.2 OTRS version installed in a Linux Slackware box. The install process was ok and everything is working just fine. There is only one thing isn´t working: the agent e-mail notification when a new ticket is created to a queue. The agents who need to be notified has the "New t

Re: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread BCWINFO
Peter my dear friend. Let's try to talk the same language, hehehehe. 1.) I was an admin user. But now, I'm just a common user. Trying to understand the concept of groups and roles I just f*c*ed all. I tried the user [EMAIL PROTECTED] and admin but no success too. System tells me that they aren't a

RE: [otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread Peter van Beugen
Can you still login as the default admin user (userid =1)? Do you have access to the MySQL tables? I believe the admin rights can be reset by changing a value in the group_user table The default admin user_id = 1 The default admin group = group_id = 2 In the group_user table User_id = 1

[otrs] I lost all admin power into OTRS!!!

2008-02-08 Thread BCWINFO
Hello everyone! I'm having a lot of fun with OTRS. Very useful system to our company. But now I have a little problem. Changing a lot of permissions (Groups, Roles, etc.) I lost the option Admin with all users. Is there any way to recover this option? __

Re: [otrs] about grouping

2008-02-08 Thread Shawn Beasley
[EMAIL PROTECTED] schrieb: Hi list, I am trying to group user agents and its tickets. Technician users must to see and manage its tickets but not other tickets. Commercial users must to see and manage its tickets but not other tickets. And so on. I would like to avoid technicians agents see (us

Re: [otrs] deleting tickets?

2008-02-08 Thread Shawn Beasley
Hi swood, The delete modlue, like the spam module, only moves tickets to a selected queue and sets a status. The tickets are not deleted. To delete tickets, please use the generic agent, as this is the only way to permanently, and cleanly, remove tickets and all references to them in the DB.

Re: [otrs] reply to a ticket that is not hers

2008-02-08 Thread Nils Breunese (Lemonbit)
Guyard Marc NIS wrote: I want to know if it's possible to reply to a ticket that is not hers. In fact, we work in 24/24 7/7 and we need to update a ticket even if it is not ours (not locked on us). Do you know if it's possible to do that other than changing the owner of the ticket ? Onl

Re: [otrs] Multiple Customer::AuthModule?

2008-02-08 Thread Shawn Beasley
Hi, did you see this post? Lars Jørgensen schrieb: Hi. We use LDAP for the majority of customers and a local OTRS DB for a few customers not in AD. I would like the non-AD users to be able to log in to OTRS and view their tickets. Is it possible to define multiple Customer::AuthModules in C