Search found 171 matches
- 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...
- 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?
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?
- 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...
- 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 ??
how to create new Framework -> Core::Time::Calendar10 ,11, like ??
- 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
C:\OTRS\Apache2\bin\httpd.exe -k start
- 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 ???
When access http://localhost/otrs/installer.pl error
could not connect to localhost ???
- 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...
- 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 IIS also check no application used 80 or 443. but still facing problem
- 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 .
we are OTRS installing time facing problem .
- 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:Exactly on the 15:30? Wow.kalyana1315 wrote: we have run cron jobs hour ago manually.
How would the image you provided be helpful in diagnosing the issue you're encountering?
we have used RUN NOW! option.
- 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.
- 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
we are restarted OTRS service then Generic agent crons working fine. but after few day facing same problemcrythias wrote:Check CronW service?
crons jobs is not working ?
- 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?
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.reneeb wrote:???
I do not understand what you try to achieve...
any option create new email or other way multiple ticket ticket creating by agent .
- 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 ??
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 ??
- 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
hi jojojojo wrote:use the latest version of otrs (3.3.6)
currently this server in production ,any option to add Column for Dynamic Field display in customerticketoverview with out any update version ?
- 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???
- 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 ??
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 ??
- 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
What is the reason that new ticket creating no cc option customers to send emails?jojo wrote:1) no
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 22 Apr 2014, 15:15
- Forum: Help
- Topic: new agent create through database
- Replies: 19
- Views: 5973
Re: new agent create through database
any option updating sql query User table pw values default encrypted values.jojo wrote:using a direct database query will always screw up caching
or
how to do decrypt otrs user table password using sql query
database:
- 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: "...
- 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
- 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?
- 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.
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.
- 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 ? .
How can check postmastermailbox cron job status in windows ? .
- 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...
- 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...
- 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...
- 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...
- 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.
- 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.
- 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....
- 16 Apr 2014, 13:54
- Forum: Help
- Topic: open ticket report monthly
- Replies: 19
- Views: 7781
Re: open ticket report monthly
hicrythias wrote:Sorry... let me search this as it's not an OTRS question.
any SQL query for OTRS Number open ticket last month with last update state status.
- 16 Apr 2014, 13:44
- Forum: Help
- Topic: open ticket report monthly
- Replies: 19
- Views: 7781
Re: open ticket report monthly
Hi crythias ,crythias wrote:order by change_time desc
change_time or create time shows correct but other rows first value only show this query
- 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...
- 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 (...
- 16 Apr 2014, 09:10
- Forum: General
- Topic: Running OTRS in HTTPS
- Replies: 2
- Views: 1482
- 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_...
- 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...
- 01 Apr 2014, 13:07
- Forum: Help
- Topic: Queue Based survey
- Replies: 4
- Views: 3182
Re: Queue Based survey
Thank you
- 01 Apr 2014, 12:34
- Forum: Help
- Topic: Queue Based survey
- Replies: 4
- Views: 3182
Re: Queue Based survey
how to use limesurvey in OTRS ??crythias wrote:I use limeSurvey.
- 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 ?
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 ?
- 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...
- 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...
- 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?
hi reneeb,reneeb wrote:This is a caching issue. You shouldn't update the database directly, but use the API instead.
we are clear all caches but still showing old information. ur test new browser also but old information showing