Search found 171 matches

by kalyana1315
28 May 2014, 08:55
Forum: Help
Topic: survey model feedback form ticket number
Replies: 0
Views: 797

survey model feedback form ticket number

Hi , we are using survey model. 1 created General Info details 2 Questions created 3 Survey model new to activated 4 now once ticket closed survey form link information got mail email. customer after receiving the email survey link. once click link feedback form show question. there is no ticket num...
by kalyana1315
09 May 2014, 10:45
Forum: Help
Topic: AgentTicketZoom option Ticket Feedback Information
Replies: 0
Views: 767

AgentTicketZoom option Ticket Feedback Information

Hi

we are trying added like Ticket Information,Customer Information same as ticket Feedback Information.

how to added AgentTicketZoom .dtl code Survey Stat Details of tickets?
by kalyana1315
07 May 2014, 13:54
Forum: General
Topic: How to create new Calendar ?
Replies: 3
Views: 2276

Re: How to create new Calendar ?

There is a huge calendar block in the Kernel/Config/Files/Framework.xml: <ConfigItem Name="TimeZone::Calendar1Name" Required="1" Valid="1"> <Description Translatable="1">Defines the name of the indicated calendar.</Description> <Group>Framework</Group> <SubGr...
by kalyana1315
07 May 2014, 13:24
Forum: General
Topic: How to create new Calendar ?
Replies: 3
Views: 2276

How to create new Calendar ?

hello,

how to create new Framework -> Core::Time::Calendar10 ,11, like ??
by kalyana1315
06 May 2014, 15:25
Forum: General
Topic: http://localhost/otrs/installer.pl error in windows
Replies: 1
Views: 1442

Re: http://localhost/otrs/installer.pl error in windows

now is working
C:\OTRS\Apache2\bin\httpd.exe -k start
by kalyana1315
06 May 2014, 14:38
Forum: General
Topic: http://localhost/otrs/installer.pl error in windows
Replies: 1
Views: 1442

http://localhost/otrs/installer.pl error in windows

This error just happen after installing Otrs of windows

When access http://localhost/otrs/installer.pl error

could not connect to localhost ???
by kalyana1315
06 May 2014, 14:17
Forum: General
Topic: port 80 is already is use error in otrs
Replies: 5
Views: 1906

Re: port 80 is already is use error in otrs

Also, the fact that you showed me Skype ... netstat -abn Thank you crythias , :) :) Skype Irritatingly, Skype can switch to port 80. To disable it, select Tools > Options > Advanced > Connection then uncheck “Use port 80 and 443 as alternatives for incoming connections”. What’s Using Port 80? Furth...
by kalyana1315
06 May 2014, 13:41
Forum: General
Topic: port 80 is already is use error in otrs
Replies: 5
Views: 1906

Re: port 80 is already is use error in otrs

crythias wrote:It means what it says on the box. Check for competing web servers: IIS, Skype, etc. or change ports.

web servers we checked skype
Skype.JPG
IIS also check no application used 80 or 443. but still facing problem
by kalyana1315
06 May 2014, 13:28
Forum: General
Topic: port 80 is already is use error in otrs
Replies: 5
Views: 1906

port 80 is already is use error in otrs

Hello,

we are OTRS installing time facing problem .
port80.JPG
by kalyana1315
06 May 2014, 13:23
Forum: Help
Topic: Generic agent not runing in windows
Replies: 8
Views: 2503

Re: Generic agent not runing in windows

crythias wrote:
kalyana1315 wrote: we have run cron jobs hour ago manually.
Exactly on the 15:30? Wow.

How would the image you provided be helpful in diagnosing the issue you're encountering?

we have used RUN NOW! option.
by kalyana1315
06 May 2014, 13:15
Forum: Help
Topic: Generic agent not runing in windows
Replies: 8
Views: 2503

Re: Generic agent not runing in windows

Last Run ... about an hour ago? except for the invalid one Generic Agent. What's the problem? hi crythias, there is no logs, we have run cron jobs hour ago manually. actually time interval select 10 min. this happen frequent . once restart service working fine . after few day same issue happening.
by kalyana1315
06 May 2014, 12:20
Forum: Help
Topic: Generic agent not runing in windows
Replies: 8
Views: 2503

Re: Generic agent not runing in windows

crythias wrote:Check CronW service?
we are restarted OTRS service then Generic agent crons working fine. but after few day facing same problem

crons jobs is not working ?
Capture.JPG
by kalyana1315
02 May 2014, 11:57
Forum: Help
Topic: OTRS create a new multiple ticket?
Replies: 3
Views: 1924

Re: OTRS create a new multiple ticket?

reneeb wrote:???

I do not understand what you try to achieve...
we having five clients . now i want to create ticket all client one ticket that is same subject and body but customer id and ticket id is different need.

any option create new email or other way multiple ticket ticket creating by agent .
by kalyana1315
02 May 2014, 09:31
Forum: Help
Topic: OTRS create a new multiple ticket?
Replies: 3
Views: 1924

OTRS create a new multiple ticket?

hello,


how can create new multiple ticket by agent . currently agent creating by new email or phone ticket. same way any option we are try create multiple ticket by agent ??
by kalyana1315
30 Apr 2014, 09:26
Forum: Help
Topic: Column for Dynamic Field display in customerticketoverview
Replies: 6
Views: 2192

Re: Column for Dynamic Field display in customerticketovervi

jojo wrote:use the latest version of otrs (3.3.6)
hi jojo
currently this server in production ,any option to add Column for Dynamic Field display in customerticketoverview with out any update version ?
by kalyana1315
30 Apr 2014, 09:22
Forum: Help
Topic: Column for Dynamic Field display in customerticketoverview
Replies: 6
Views: 2192

Re: Column for Dynamic Field display in customerticketovervi

jojo wrote:just add it via Ticket::Frontend::CustomerTicketOverview###DynamicField

OTRS 3.1.4 vision Ticket::Frontend::CustomerTicketOverview###DynamicField option not available how to customerticketoverview.dtl???
by kalyana1315
30 Apr 2014, 08:56
Forum: Help
Topic: Column for Dynamic Field display in customerticketoverview
Replies: 6
Views: 2192

Column for Dynamic Field display in customerticketoverview

Hi,

I have a dynamic fields I would like to add as columns to CustomerTicketOverview displays. we are trying like $QData{"DynamicField_*} isn't working.


how to added dynamic field as a column to a CustomerTicketOverview display ??
by kalyana1315
29 Apr 2014, 15:39
Forum: Help
Topic: CC in customer new create ticket
Replies: 3
Views: 1600

Re: CC in customer new create ticket

jojo wrote:1) no
What is the reason that new ticket creating no cc option customers to send emails? :( :( :(
by kalyana1315
29 Apr 2014, 15:16
Forum: Help
Topic: CC in customer new create ticket
Replies: 3
Views: 1600

CC in customer new create ticket

hi 1 . Is there a way to add a CC field to the customer new ticket page? Many of our customers are in the practice of sending into copying to their manger. It would be nice to have this available on the customer new ticket creation option. 2. what is difference open source OTRS and OTRS Best Practic...
by kalyana1315
28 Apr 2014, 14:40
Forum: Help
Topic: Postmaster Mail Account dispatching Problem ?
Replies: 5
Views: 2331

Re: Postmaster Mail Account dispatching Problem ?

we have using only one email fetch account . postmaster queue already disabled (invalid). but only few email going on that invalid queue other email selected queue only creating ticket Yes, you mentioned that. If someone used that exact phrase to talk to you about the problem, what would be the fir...
by kalyana1315
28 Apr 2014, 13:30
Forum: Help
Topic: Postmaster Mail Account dispatching Problem ?
Replies: 5
Views: 2331

Re: Postmaster Mail Account dispatching Problem ?

Yes. Either PostmasterFilter or another email fetch account set for disabled queue or don't have any invalid Queues or followups to existing tickets attached to invalid Queues. hi crythias , we have using only one email fetch account . postmaster queue already disabled (invalid). but only few email...
by kalyana1315
28 Apr 2014, 12:50
Forum: Help
Topic: Postmaster Mail Account dispatching Problem ?
Replies: 5
Views: 2331

Postmaster Mail Account dispatching Problem ?

Hello, We have configure POP3S mail box ,dispatching by selected queue and it is working fine. but some time few email dispatching by select different queue. select queue name postmaster this queue already invalid . dispatching problem happening only few fetching mails other mail dispatching by sele...
by kalyana1315
23 Apr 2014, 09:16
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

you can not decrypt passwords how is storing database values OTRS user table username and password. front end Add Agent option enter password is plan text but database storing encrypted password. we are trying finding encrypted code otrs perl program ? any one know about encrypted update me file na...
by kalyana1315
22 Apr 2014, 15:36
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

how can update pw valuse useing sql query ? Read this entire thread again until you understand that your question should not be answerable. If you require plain text passwords, use your own backend authentication table. You can do whatever you want with that. Hi crythias, we are trying to OTRS user...
by kalyana1315
22 Apr 2014, 15:15
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

jojo wrote:using a direct database query will always screw up caching
any option updating sql query User table pw values default encrypted values.
or
how to do decrypt otrs user table password using sql query

database:
pw.JPG
by kalyana1315
22 Apr 2014, 14:29
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

The goal is to create users using plain text passwords bin/otrs.AddUser.pl otrs.AddUser.pl [-f firstname] [-l lastname] [-p password] [-g groupname]... [-e email] username if you define -g with a valid group name then the user will be added that group you can define multiple groups line this: "...
by kalyana1315
22 Apr 2014, 12:35
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

RStraub wrote:The goal is to create users without using plain text passwords?

The goal is to create users using plain text passwords
by kalyana1315
22 Apr 2014, 10:11
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

Re: new agent create through database

reneeb wrote:You shouldn't work on the database yourself! There's a script in the $OTRS_HOME/bin/ directory that can be used to create agents.

that one working fine. but we are try update through database. how to storing password in otrs database use table?
by kalyana1315
22 Apr 2014, 09:30
Forum: Help
Topic: new agent create through database
Replies: 19
Views: 5973

new agent create through database

Hi

how to create new agent through otrs database back-end . we are facing problem password value other this all are updating working fine.


any one help me. OTRS database user table how update though manually.
by kalyana1315
21 Apr 2014, 13:48
Forum: Help
Topic: postmastermailbox cron job status
Replies: 0
Views: 863

postmastermailbox cron job status

hi

How can check postmastermailbox cron job status in windows ? .
by kalyana1315
17 Apr 2014, 14:04
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

avoid it in the inner join. final :D :D :D :D Open Ticket : SELECT ticket.tn, ticket.id, ticket_history.state_id, ticket_state.name, ticket_history.change_time AS change_time FROM ticket_history LEFT JOIN ticket ON ( ticket.id = ticket_history.ticket_id ) inner JOIN (SELECT ticket.tn, Max(ticket_hi...
by kalyana1315
17 Apr 2014, 13:11
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

unable to replicate. copy/paste in phpmyadmin yielded no errors. Hi final i got result the row associated with the max date SELECT ticket.tn, ticket.id, ticket_history.state_id, ticket_state.name, ticket_history.change_time AS change_time FROM ticket_history LEFT JOIN ticket ON ( ticket.id = ticket...
by kalyana1315
17 Apr 2014, 12:46
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

SELECT ticket.tn, ticket.id, ticket_history.state_id, ticket_state.name, ticket.change_time AS change_time FROM ticket_history LEFT JOIN ticket ON ( ticket.id = ticket_history.ticket_id ) INNER JOIN (SELECT ticket.tn, Max(ticket.change_time) AS max_change FROM ticket_history LEFT JOIN ticket ON tic...
by kalyana1315
17 Apr 2014, 09:50
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

from the search, I found this post which means ... SELECT ticket.tn, ticket.id,ticket_history.state_id,ticket_state.name, ticket.change_time AS change_time FROM ticket_history LEFT JOIN ticket ON (ticket.id = ticket_history.ticket_id) INNER JOIN (SELECT ticket.tn, MAX(ticket.change_time) as max_cha...
by kalyana1315
16 Apr 2014, 16:28
Forum: Help
Topic: Statistics report preview month ticket status
Replies: 6
Views: 1733

Re: Statistics report preview month ticket status

crythias wrote:You won't be able to do this through OTRS built-in reports.

Thank crythias


any other way find solution of this issue.
by kalyana1315
16 Apr 2014, 16:08
Forum: Help
Topic: Statistics report preview month ticket status
Replies: 6
Views: 1733

Re: Statistics report preview month ticket status

count tickets from ticket_history. hi crythias count tickets show wrong value. information: i create one ticket last month state is new and same month ticket open state , next month ticket is closed. now statistics report last month is ticket state is show close. actually status last month is open.
by kalyana1315
16 Apr 2014, 15:54
Forum: Help
Topic: Statistics report preview month ticket status
Replies: 6
Views: 1733

Statistics report preview month ticket status

I want to create some statistics about ticket states for a period of time. I.e. I want to know how many ticket were in each state a period of one month.How can I create a report that remembers how many open tickets that were in status "new", "open", etc for a period of time (e.g....
by kalyana1315
16 Apr 2014, 13:54
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

crythias wrote:Sorry... let me search this as it's not an OTRS question.
hi

any SQL query for OTRS Number open ticket last month with last update state status.
by kalyana1315
16 Apr 2014, 13:44
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

crythias wrote:order by change_time desc
Hi crythias ,

change_time or create time shows correct but other rows first value only show this query
by kalyana1315
16 Apr 2014, 13:36
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

At the moment it just groups the records and only gets the max date and not the row associated with the max date According to my demo data, it pulls 5 columns. For every ticket number, it shows the state of the ticket. database: '100005', ----------- '6', ----------- 'open', ---------------'2013-06...
by kalyana1315
16 Apr 2014, 12:31
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

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_state_type ON (...
by kalyana1315
16 Apr 2014, 09:10
Forum: General
Topic: Running OTRS in HTTPS
Replies: 2
Views: 1482

Re: Running OTRS in HTTPS

by kalyana1315
16 Apr 2014, 08:20
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

Re: open ticket report monthly

Also, http://forums.otterhub.org/viewtopic.php?f=53&t=14242#p67562 Hi crythaias, SELECT u.login owner, ts.name state, th.name fromto, th.create_time createtime, th.ticket_id ticket_id FROM `ticket_history` th LEFT JOIN users u ON u.id = th.owner_id LEFT JOIN ticket_state ts ON ts.id = th.state_...
by kalyana1315
15 Apr 2014, 12:48
Forum: Help
Topic: open ticket report monthly
Replies: 19
Views: 7781

open ticket report monthly

Hi , we are using last few month OTRS. now trying monthly report but report showing wrong data. if any one month ticket is open and other month ticket close.final report showing only close status. Please any help how to find SQL query month wise that means one ticket worked two months we need two mo...
by kalyana1315
01 Apr 2014, 13:07
Forum: Help
Topic: Queue Based survey
Replies: 4
Views: 3182

Re: Queue Based survey

Thank you :D :D :D
by kalyana1315
01 Apr 2014, 12:34
Forum: Help
Topic: Queue Based survey
Replies: 4
Views: 3182

Re: Queue Based survey

crythias wrote:I use limeSurvey.
how to use limesurvey in OTRS ??
by kalyana1315
01 Apr 2014, 09:51
Forum: Help
Topic: Queue Based survey
Replies: 4
Views: 3182

Queue Based survey

HI All,

we are using 8 queues.

for four queue one survey and other four queue one survey . that means we are trying two different survey based on queue


anyone help how to implement different survey based on queue ?
by kalyana1315
27 Mar 2014, 16:11
Forum: Help
Topic: otrs ticket information sql query update back end?
Replies: 6
Views: 2743

Re: otrs ticket information sql query update back end?

Check this and see if you can verify what you think you did. http://forums.otterhub.org/viewtopic.php?f=53&t=16009#p77686 we are tested query SELECT ticket.*, dynamic_field.name, dynamic_field.label, dynamic_field_value.value_text from ticket left join dynamic_field_value on (dynamic_field_valu...
by kalyana1315
27 Mar 2014, 15:48
Forum: Help
Topic: otrs ticket information sql query update back end?
Replies: 6
Views: 2743

Re: otrs ticket information sql query update back end?

Infom_ticket.JPG I don't see anything in the image that indicates what would be considered a dynamic field? hi crythias we are using two dynamic Ticket text filed. Additional Contact Information: SLA Remark : Ur are updated (some wrong text date corrected) backend database table . otrs.dynamic_fiel...
by kalyana1315
27 Mar 2014, 14:50
Forum: Help
Topic: otrs ticket information sql query update back end?
Replies: 6
Views: 2743

Re: otrs ticket information sql query update back end?

reneeb wrote:This is a caching issue. You shouldn't update the database directly, but use the API instead.
hi reneeb,

we are clear all caches but still showing old information. ur test new browser also but old information showing