[otrs] SLA clock stop

2013-05-20 Thread KalyanaChakravarthy MP
HI Team, I have a ticket with SLA solution time . how to hold or stop sla or change SLA time in manually . can u anyone help me. Thank you, Regards, Kalyana chakravarthy M .P, - OTRS mailing list: otrs - Webpage: http://otrs.o

[otrs] Ticket Number Generator based on customerID or company name

2013-05-20 Thread KalyanaChakravarthy MP
hi, how to create ticket number Generation based on company name or customerID. Any possible way OTRS 3.2.1. can u anybody help me. example company name "XYZ" ticket number will be start like "company name.date.ID.count" --> "XYZ20130510001" ,counter start like 1, if other company

[otrs] update time for customer and mysql database dynamic value store

2013-05-22 Thread KalyanaChakravarthy MP
Hi , 1. How to find the customer update time. Any Ticket agent update time that is change time of ticket . same way customer also updated ticket is change time or any option there Column in database. 2. Specify ticket dynamic value where store in database in ticket table n

[otrs] customer new ticket creation how to add CC and BCC email option

2013-06-04 Thread KalyanaChakravarthy MP
Hi Customer portal new ticket creation how to add CC email option. Currently agent email ticket creation having CC and BCC same way customer view new ticket creation CC , BCC option need . anybody help me. Regards, Kalyana chakravarthy M .P, Sr software Engineer. ---

[otrs] Dynamic Fields date and time based SLA solution time

2013-06-10 Thread KalyanaChakravarthy MP
HI All, Dynamic Fields date and time created as Estimated Resolution Time . I am using SLA Escalation - first response time but not using Escalation - solution time. I want use "Estimated Resolution Time" (Dynamic Fields date and time ) as "Escalation - solution time". If any ticket reach

[otrs] customer auto reply stop

2013-06-24 Thread KalyanaChakravarthy MP
Hi All, OTRS notification system sending customer notification and customer also replying email ticket update is fine. Customer some time set as auto reply like I am out office like some other auto reply . this type auto reply how stop anybody let know Postmaster filter option I set subject

[otrs] text area number and bulleted list not working

2013-06-25 Thread KalyanaChakravarthy MP
Hi Rich Text mode how enable in otrs. Regards, Kalyana chakravarthy M .P, Sr software Engineer. - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.ot

[otrs] text area number and bulleted list not working

2013-06-26 Thread KalyanaChakravarthy MP
HI setting is in Framework -> Core::Web -> Frontend::RichText ,active but still number and bulleted list not working it showing like - - test -tes2 Regards, Kalyana chakravarthy M .P, Sr software Engineer. --

[otrs] Not working tables and colors ticket view

2013-06-27 Thread KalyanaChakravarthy MP
Hi Ticket note option text editor show all table option and color. But after submit ticket overview not showing any table and color all plain text display. Anyone know how to enable table and color ticket views. Example: Name User name Password Result view showing like below,

[otrs] New Ticket create not working table format

2013-06-28 Thread KalyanaChakravarthy MP
Hi , Customer view or agent view create and update ticket text area option table and number list showing fine. But after sending or submit ticket it showing only plain text and number list displaying "-". How to change plan text to rich text. I am trying changes 1. PostmasterAutoHTML2Text

[otrs] Statistics Scheduled

2013-07-03 Thread KalyanaChakravarthy MP
Hi I ma trying to run otrs.GenerateStats.pl -n [-p ] [-o ] [-r -s ] [-m ] [-l ] [-f CSV|Print] [-S ] e. g. 'Year=1977&Month=10' (only for static files) /output/dir/ But Error showing , can anybody help me or give Exmple : Regards, Kalyana chakravarthy M .P, Sr software Engin

[otrs] schedule report in windows

2013-07-04 Thread KalyanaChakravarthy MP
Hi i am run manually below code working fine $HOME/bin/otrs.GenerateStats.pl -n 10020 -f CSV -r 1...@domain.com -r 1...@domain.com -m "Weekly Open Ticket Report" -F WeeklyOpen i try to schedule this like cron job in window , following i done above code created batch file like report.bat . aft

[otrs] android or iphone Application otrs Customer URL?

2013-07-09 Thread KalyanaChakravarthy MP
Hi All, OTRS DS Helpdesk Application installed in mobile . OTRS Agent login working fine. but Customer user login not working . i am used agent login name: test url : www.mysite.com/otrs/json.pl username: xyz password : * i tryed customer login same way

Re: [otrs] Agent last Login timestamp?

2013-07-17 Thread KalyanaChakravarthy MP
Hi all admin interface you have the info "last login" also shown in the overview table. :) SELECT CONCAT(first_name,last_name) as Agnet_Name ,u.login, Preferences_value as LastLogin FROM otrs.user_preferences,users u where preferences_key like '%UserLastLoginTimestamp%' and user_id = u.id or

[otrs] udpate to SLA or State changes priority automatically

2013-10-21 Thread KalyanaChakravarthy MP
Hi ALL I have following issue: a new note is added - if now an update is made to either the ticket Type or a new state one can see a short refresh (a small animation next to these fields) and the ticket priority changes for the first available one in the list. -Ticket priority very high chang

[otrs] customer Email Ticket is not updated it creates new ticket in otrs

2013-12-23 Thread KalyanaChakravarthy MP
Hi All, Customer reply to tickets through email that ticket is updated. but suddenly customer reply email ticket created as new ticket number. other than ticket number any possible something similar at the beginning of the subject to recognize that it is no new ticket. Thank you & Regards, Kal

[otrs] open ticket report monthly

2014-04-16 Thread KalyanaChakravarthy MP
Sql Query: SELECT ticket.tn, ticket.id,ticket_history.state_id,ticket_state.name, max(ticket_history.change_time) AS change_time FROM ticket_history LEFT JOIN ticket ON (ticket.id = ticket_history.ticket_id) LEFT JOIN ticket_state ON (ticket_state.id = ticket_history.state_id) LEFT JOIN ticket_s