Search found 139 matches
- 21 Aug 2017, 09:17
- Forum: Help
- Topic: Deadlock found when trying to get lock; try restarting transaction...
- Replies: 4
- Views: 31399
Re: Deadlock found when trying to get lock; try restarting transaction...
Anyone met this issue, please share a bit. Thanks
- 18 Aug 2017, 10:28
- Forum: Help
- Topic: Deadlock found when trying to get lock; try restarting transaction...
- Replies: 4
- Views: 31399
Re: Deadlock found when trying to get lock; try restarting transaction...
Thanks Mod for your recommend. But it's really an issue on production, just post to hope someone met and solved the same issue
- 18 Aug 2017, 05:59
- Forum: Help
- Topic: Deadlock found when trying to get lock; try restarting transaction...
- Replies: 4
- Views: 31399
Deadlock found when trying to get lock; try restarting transaction...
Hello all, Sometime, I am get a Deadlock error logs when creating tickets. It took over 1 week, but I cannot solve it. Please help me Server info - OTRS 4.0.9 installed on CentOS 6 - MySQL db servers use Galera cluters Error log Jul 26 19:15:51 otrs02 GenericInterfaceProvider-11[11224]: [Error][Kern...
- 20 Jun 2016, 12:24
- Forum: Developers
- Topic: how to create customers and services via SOAP
- Replies: 4
- Views: 4397
Re: how to create customers and services via SOAP
hi,
this post was long time, but is there any way to get external customer data via SOAP? Some customer does not allow to get customer data directly via view (using customer backend)
this post was long time, but is there any way to get external customer data via SOAP? Some customer does not allow to get customer data directly via view (using customer backend)
- 21 May 2015, 10:21
- Forum: Help
- Topic: Count all tickets, not count tasks
- Replies: 4
- Views: 3890
Re: Count all tickets, not count tasks
I'm creating a ticket report as a customization. In the my OTRS 4.x system can have ticket and task (creates via split functionality), But I'd like to count all tickets had been created in a period time, not count tasks. So how do you know the difference between a task and a ticket? Typically that ...
- 20 May 2015, 10:12
- Forum: Help
- Topic: Count all tickets, not count tasks
- Replies: 4
- Views: 3890
Re: Count all tickets, not count tasks
Hi,
This is my blocking issue. Please somebody, experts, guru help me
Thanks
Vu Nguyen
This is my blocking issue. Please somebody, experts, guru help me
Thanks
Vu Nguyen
- 19 May 2015, 11:06
- Forum: Help
- Topic: Count all tickets, not count tasks
- Replies: 4
- Views: 3890
Count all tickets, not count tasks
Dear, I'm creating a ticket report as a customization. In the my OTRS 4.x system can have ticket and task (creates via split functionality), But I'd like to count all tickets had been created in a period time, not count tasks. So my query would be SELECT Count(DISTINCT ticket.id) AS COUNT FROM ticke...
- 08 Apr 2014, 11:31
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Re: Migrate ticket from old OTRS to new OTRS
First, thank your reply Many information are stored as IDs with foreign keys, are the two OTRS instances identical? (E.g. instance A has a custom ticket status "waiting for third party". Does instance B has the same status? Are the IDs of those status identical? The same accounts for queue...
- 08 Apr 2014, 09:25
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Re: Migrate ticket from OTRS to another OTRS
Thanks for your helps, Now I have a new requirement from customer. Two companies are working with 2 different OTRS systems, there is a change all staffs company A will move to company B. Then, they want to move all pending tickets from OTRS A to OTRS B as migration data. The pending tickets includes...
- 11 Mar 2014, 09:02
- Forum: Help
- Topic: How to show a customer field in queue overview
- Replies: 1
- Views: 1918
Re: How to show a customer field in queue overview
Hi, Finally. I sovled this issue by a customization. For example I want to display column Customer City on AgentTicketQueue overview In original file Custom/Kernel/Output/HTML/TicketOverviewSmall.pm. Find the words "# customer info (customer name)" and customize as below # customer info (c...
- 11 Mar 2014, 04:57
- Forum: Help
- Topic: How to install 2 OTRS instances on Windows
- Replies: 1
- Views: 930
How to install 2 OTRS instances on Windows
Dear all, I'm working with multi projects (OTRS) at the same time, but the version OTRS for each project is different. Currently, I have to use multi virtual machines, but it is uncomfortable for developers. Is it possible to install 2 OTRS instance on Windows, not using virtual machines? Please giv...
- 03 Mar 2014, 12:07
- Forum: Help
- Topic: How to show a customer field in queue overview
- Replies: 1
- Views: 1918
How to show a customer field in queue overview
Hi, I'm working with OTRS 3.3, I'm trying to config a customer field in queue overview, but not found yet. My question is: - Is it possible to do by config? If yes, please show me where in sysconfg - I know it is possible to show dynamic field in queue overview, so I config the mapping customer fiel...
- 27 Feb 2014, 08:59
- Forum: Help
- Topic: Display Close tickets in Customer Information
- Replies: 2
- Views: 1897
Re: Display Close tickets in Customer Information
Hi,
It's simple just config in Frontend::CustomerUser::Item###17-ClosedTickets, enable it.
Vu Nguyen
It's simple just config in Frontend::CustomerUser::Item###17-ClosedTickets, enable it.
Vu Nguyen
- 26 Feb 2014, 12:49
- Forum: Help
- Topic: Display Close tickets in Customer Information
- Replies: 2
- Views: 1897
Re: Display Close tickets in Customer Information
Anyone know how to config? please help me thanks
Vu Nguyen
Vu Nguyen
- 25 Feb 2014, 13:04
- Forum: Help
- Topic: Display Close tickets in Customer Information
- Replies: 2
- Views: 1897
Display Close tickets in Customer Information
Dear,
I'm working with OTRS 3.3, is it possible to show the close tickets in customer information by configuration, please see the picture
I remember it was displaying in OTRS version 3.2. Please help me
Thanks a lot
Vu Nguyen
I'm working with OTRS 3.3, is it possible to show the close tickets in customer information by configuration, please see the picture
I remember it was displaying in OTRS version 3.2. Please help me
Thanks a lot
Vu Nguyen
- 27 Jan 2014, 04:58
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Re: Migrate ticket from old OTRS to new OTRS
Hi, Where can I execute to copy, paste or forward? Could you explain more detail depends on the system you are using: Windows: STRG+C -> STRG+V Mac: CMD+C -> CMD+V Florian Sorry wurzel, I'm still not understand, what screen I have to do like that or I have to develop? Thanks Vu Nguyen
- 27 Jan 2014, 04:56
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Re: Migrate ticket from old OTRS to new OTRS
if you wan't to upgrade read the UPGRADING file of the new version and have a look in the admin book on http://doc.otrs.org/3.3/en/html/upgrading.html Thanks your idea, but my customer don't want to do that. They just want to migrate the open tickets to the new system I'm going to use create OTRS w...
- 24 Jan 2014, 09:55
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Re: Migrate ticket from old OTRS to new OTRS
Hi,wurzel wrote: copy - paste or forward.
Where can I execute to copy, paste or forward? Could you explain more detail
Thanks
- 24 Jan 2014, 03:53
- Forum: Help
- Topic: Migrate ticket from old OTRS to new OTRS
- Replies: 12
- Views: 7511
Migrate ticket from old OTRS to new OTRS
Dear all,
I'm facing an issue to migrate ticket data from the old OTRS to new OTRS, I don't know how to do that. I'm just thinking I have to migrate via script direct in database
Anyone know how to do this issue? Please help me tks
Vu Nguyen
I'm facing an issue to migrate ticket data from the old OTRS to new OTRS, I don't know how to do that. I'm just thinking I have to migrate via script direct in database
Anyone know how to do this issue? Please help me tks
Vu Nguyen
- 17 Jan 2014, 12:02
- Forum: Help
- Topic: Wrong display customer name with special characters
- Replies: 4
- Views: 2239
Re: Wrong display customer name with special characters
Thanks reneeb, my issue was sovled. There is a small I would like to share with you. In the external customer database, for example the firstname field with varchar(50), but you put the data is longer than varchar(50) (data is Téster-èìhmGiIiVîavyëEvëézAhàoVvXPrýSnLHäLHWéìóapÿ). Then, in the AgentTi...
- 30 Dec 2013, 05:04
- Forum: Help
- Topic: Also create an article to parent ticket
- Replies: 11
- Views: 9083
Re: Also create an article to parent ticket
Hi ndhvu275, I am using 3.0 so not able to do this as I am getting error when using your code..,.. And please let me know how to create a event for this? Hi, In folder /opt/otrs/Kernel/System/Ticket/Event, you create a new file (event file). For example the name is UpdateToParent.pm. Then you can r...
- 19 Dec 2013, 03:45
- Forum: Help
- Topic: Wrong display customer name with special characters
- Replies: 4
- Views: 2239
Re: Wrong display customer name with special characters
The collation of customer backend is SQL_Latin1_General_CP1_CI_AS
However, in OTRS system. I can query the right customer data via command line as below file odbc.ini
However, in OTRS system. I can query the right customer data via command line as below file odbc.ini
- 18 Dec 2013, 12:46
- Forum: Help
- Topic: Wrong display customer name with special characters
- Replies: 4
- Views: 2239
Wrong display customer name with special characters
Dear, I'm using OTRS 3.3.x on CentOS 64 bit, my OTRS is using the customer data backend from the external MS SQL database, the connection via DSN OBDC of Microsoft. But there are something wrong displaying the customer name My customer name in external database is : Servië Somalië Oekraïne Tunesië B...
- 13 Dec 2013, 11:10
- Forum: Help
- Topic: JSON/PP/pp.pm line 468
- Replies: 5
- Views: 2986
Re: JSON/PP/pp.pm line 468
If the database is not utf-8, you have to declare what charset it uses! Actually I cannot access to customer data. So I just disabled charset like above, my system is running OK with data is utf-8 and not utf-8. But it maybe impact to others I never know. I would like to ask "Is it acceptable ...
- 13 Dec 2013, 06:34
- Forum: Help
- Topic: JSON/PP/pp.pm line 468
- Replies: 5
- Views: 2986
Re: JSON/PP/pp.pm line 468
What happen if my DB is not utf-8? Maybe I have to disable charset utf-8 in customer backend file in picture. That means it is acceptable for all kinds of charset in incoming data, is it correct? Thanksjojo wrote:ensure that your database is utf8
Vu Nguyen
- 13 Dec 2013, 05:07
- Forum: Help
- Topic: Cannot build package with OTRS 3.3.x
- Replies: 3
- Views: 1468
Re: Cannot build package with OTRS 3.3.x
Yes thanks. It's really an error from my .sopm. It's now ok.reneeb wrote:It's most likely an error in your .sopm or your config-XML...
Thanks again
Vu Nguyen
- 13 Dec 2013, 05:05
- Forum: Help
- Topic: JSON/PP/pp.pm line 468
- Replies: 5
- Views: 2986
Re: JSON/PP/pp.pm line 468
Hi, I'm facing this issue as well when searching customer in AgentTicketPhone screen, customer data is from external database MS SQL. Did you solve it? Please share to me some idea. I'm using OTRS 3.3.x, the package JSON::XS is version 2.3 The error maybe JSON cannot understand some strange characte...
- 11 Dec 2013, 10:03
- Forum: Help
- Topic: Cannot build package with OTRS 3.3.x
- Replies: 3
- Views: 1468
Cannot build package with OTRS 3.3.x
Dear, I'm facing some errors related to XML::Parser when building a custom package with OTRS version 3.3.x. As I know with the OTRS version 3.2.x, package XML::Parser was using version 1.40, but it's changed into 1.41 in OTRS version 3.3.x. Below picture is my error What can I do with it? Please hel...
- 06 Nov 2013, 09:28
- Forum: Help
- Topic: A filter with no customer in notification event
- Replies: 3
- Views: 1970
Re: A filter with no customer in notification event
Hi,
I did it by a customization. You can go to file /opt/otrs/Kernel/Ticket/Event/NotificationEvent.pm, let make a filter "no customer" in it
Vu Nguyen
I did it by a customization. You can go to file /opt/otrs/Kernel/Ticket/Event/NotificationEvent.pm, let make a filter "no customer" in it
Vu Nguyen
- 06 Nov 2013, 09:25
- Forum: Help
- Topic: Configure ACL in OTRS 3.3 beta
- Replies: 5
- Views: 2318
Re: Configure ACL in OTRS 3.3 beta
I can make ACL to show/hide dynamic filed base on a queue is selecting. Maybe you did this? http://forums.otterhub.org/viewtopic.php?f=60&t=8032 Yes, thanks. Finally, I have to develop like you guided. It's acceptable for now, but for later my customer wants to show/hide a dynamic field base on...
- 30 Oct 2013, 05:05
- Forum: Help
- Topic: Configure ACL in OTRS 3.3 beta
- Replies: 5
- Views: 2318
Re: Configure ACL in OTRS 3.3 beta
Hi,
In the old version is 3.2, I can make ACL to show/hide dynamic filed base on a queue is selecting. It's really bad to block it for this version. Btw, is there any way to do like this? Please help me
Thanks
Vu Nguyen
In the old version is 3.2, I can make ACL to show/hide dynamic filed base on a queue is selecting. It's really bad to block it for this version. Btw, is there any way to do like this? Please help me
Thanks
Vu Nguyen
- 24 Oct 2013, 03:40
- Forum: Help
- Topic: Configure ACL in OTRS 3.3 beta
- Replies: 5
- Views: 2318
Configure ACL in OTRS 3.3 beta
Dear all, I'm trying to work OTRS version 3.3, it's really nice to be included ACL configuration. But I'm facing an issue: I want to hide my dynamic field when enter AgentTicketPhone screen, this dynamic field will be appeared when 'Taken BO' queue is selected. I configured as below but it's not wor...
- 21 Oct 2013, 09:13
- Forum: Help
- Topic: A filter with no customer in notification event
- Replies: 3
- Views: 1970
A filter with no customer in notification event
Dear all,
I'm working on otrs 3.3, I'm trying to config a filter with CustomerID = null in a Notification Event. Is it possible with regex? Do you have any idea about please help
Thanks
Vu Nguyen
I'm working on otrs 3.3, I'm trying to config a filter with CustomerID = null in a Notification Event. Is it possible with regex? Do you have any idea about please help
Thanks
Vu Nguyen
- 26 Sep 2013, 04:49
- Forum: Help
- Topic: jpeg file with OTRSSignatureImages
- Replies: 1
- Views: 742
jpeg file with OTRSSignatureImages
Hi all, I'm using a package OTRSSignatureImages-1.1.1 to upload image in Signature. A strange! a jpeg image cannot display in email that OTRS sent out to my mailbox, however it can display in OTRS. I tested many times, it's happening with jpeg file only. This maybe a bug from package or I's wrong so...
- 26 Sep 2013, 04:39
- Forum: Help
- Topic: Sync ticket between multiple otrs.
- Replies: 12
- Views: 5051
Re: Sync ticket between multiple otrs.
The Generic Interface also provides the possibility to develop invokers as it allows queuing. So you should use the GI Framework and not just an event module Hi jojo, I will investigate to develop with GI framework. Do you have any link is talking about it like an example? Please give me Thanks so ...
- 25 Sep 2013, 05:58
- Forum: Help
- Topic: Sync ticket between multiple otrs.
- Replies: 12
- Views: 5051
Re: Sync ticket between multiple otrs.
Hi, For development, let follow: http://blog.otrs.org/2012/10/03/easy-ticket-creation-via-generic-interface/#more-1122 Back to an example to sync tickets between 2 OTRS, like: if I udpate/create a ticket in OTRS A, this would be synced in OTRS B. Below is my development: - In this case, OTRS B is a ...
- 24 Sep 2013, 10:07
- Forum: Help
- Topic: Sync ticket between multiple otrs.
- Replies: 12
- Views: 5051
Re: Sync ticket between multiple otrs.
the out of the box webservice waits for another sytem to connect. So you need to develop a module that connects to the other system Hi jojo, I'm wondering, is it possible a requester of service on OTRS A call a provider (eg: TicketCreate) of service on OTRS B? Do by configure in webserver? Thanks Vu
- 23 Sep 2013, 06:34
- Forum: Help
- Topic: Sync ticket between multiple otrs.
- Replies: 12
- Views: 5051
Re: Sync ticket between multiple otrs.
Hi, I think that could be possible with Webservices. (I never did this) Flo Dear all, I'm facing the same issue, I'm thinking to use webservice as well. But I don't know to config or I have to develop something? I tried to follow this http://doc.otrs.org/3.2/en/html/webservice_gui.html. But now my ...
- 30 Jul 2013, 04:38
- Forum: Help
- Topic: Customize a filed in Queue screen
- Replies: 9
- Views: 2394
Re: Customize a filed in Queue screen
There is no need to add any field to queue for any reason, especially not for security, routing, or identification. Thanks your recommendation, it's really good information to consult for my customers. But in this case, my customer want to do like above, they designed already. Finally, I could find...
- 29 Jul 2013, 09:30
- Forum: Help
- Topic: Customize a filed in Queue screen
- Replies: 9
- Views: 2394
Re: Customize a filed in Queue screen
Anyway thank you. Maybe I have to develop a field on Create Queue screen, that's also the design from customer to mecrythias wrote:ok... I'm not sure what you're trying to accomplish, but everything you generally want to do is stuff that's happening before it hits the queue.
Vu Nguyen
- 29 Jul 2013, 04:00
- Forum: Help
- Topic: Customize a filed in Queue screen
- Replies: 9
- Views: 2394
Re: Customize a filed in Queue screen
Let's say your CompanyA has an otrs email address of CompanyASupport@yourotrs (Customer based queues are a pain to manage and unnecessary. The Queues are for Agents, and what *they* can do, not for who sends the message.) You'll set your postmaster mail settings for that email to go to QueueA. Now,...
- 27 Jul 2013, 05:13
- Forum: Help
- Topic: Customize a filed in Queue screen
- Replies: 9
- Views: 2394
Re: Customize a filed in Queue screen
Hi Crythias, The requirement like below: 1. Define 2 customer backend from external DBs, for example they name A, B. 2. In Create Queue screen, I want to define a dropdownlist field names "External customer". It must be select A or B 3. My OTRS is using Postermaster to create ticket via in...
- 26 Jul 2013, 06:30
- Forum: Help
- Topic: Customize a filed in Queue screen
- Replies: 9
- Views: 2394
Customize a filed in Queue screen
Dear all, Is it possible to add a field into Queue screen of Admin page? it like to define a filed in Agent screen using Kernel::Output::HTML::PreferencesGeneric. Below pic is my example In Create Queue screen, how can I do like this? http://forums.otterhub.org/download/file.php?mode=view&id=235...
- 22 Jul 2013, 13:06
- Forum: Help
- Topic: Can't install/upgrade package, file x already used in pack..
- Replies: 4
- Views: 1579
Re: Can't install/upgrade package, file x already used in pa
Ah this is a really nice solution. Thank you very much, I will do like thisreneeb wrote:Make an AgentTicketPhoneNguyen.pm, create a config file that has all the options for AgentTicketPhone adopted for AgentTicketPhoneNguyen, deactivate AgentTicketPhone.
Thanks again
Vu Nguyen
- 20 Jul 2013, 05:57
- Forum: Help
- Topic: Can't install/upgrade package, file x already used in pack..
- Replies: 4
- Views: 1579
Re: Can't install/upgrade package, file x already used in pa
check the README file in the Custom directory Hi jojo, First thank you, I know it. As my above exmaple, the AgentTicketPhone.pm is already used in another package, it's also placed in /Custom folder. The problem if I use this file to customize and make a package as well, during installation the err...
- 20 Jul 2013, 05:16
- Forum: Help
- Topic: Enalbe Dynamic Field in AgentTicketBulk
- Replies: 4
- Views: 2043
Re: Enalbe Dynamic Field in AgentTicketBulk
Yes,it's a nice solution. Thanks so muchcrythias wrote:Use Generic Agent to set a DynamicField for multiple tickets.
- 19 Jul 2013, 10:28
- Forum: Help
- Topic: Can't install/upgrade package, file x already used in pack..
- Replies: 4
- Views: 1579
Can't install/upgrade package, file x already used in pack..
Dear all, I had a problem with can not use a file is already existed in other package. This is my error Can't install/upgrade package, file Custom/Kernel/Modules/AgentTicketPhone.pm already used in package OTRSxx-x.x.x I know I have to reuse AgentTicketPhone.pm is existing to customize more. I also ...
- 19 Jul 2013, 10:05
- Forum: Help
- Topic: Enalbe Dynamic Field in AgentTicketBulk
- Replies: 4
- Views: 2043
Re: Enalbe Dynamic Field in AgentTicketBulk
Thanks reneeb, yes of coursereneeb wrote:After a quick look at the config files I assume that you need to change the sources...
- 18 Jul 2013, 11:28
- Forum: Help
- Topic: Enalbe Dynamic Field in AgentTicketBulk
- Replies: 4
- Views: 2043
Enalbe Dynamic Field in AgentTicketBulk
Dear all,
Is it possible to enable dynamic field in Bulk view?
Thanks
Vu Nguyen
Is it possible to enable dynamic field in Bulk view?
Thanks
Vu Nguyen
- 11 Jul 2013, 06:00
- Forum: Help
- Topic: Migrate only changes in sysconfig
- Replies: 6
- Views: 2234
Re: Migrate only changes in sysconfig
The concept is this: 1) create a vanilla/base install of OTRS without configuration changes. 2) determine a diff of the base install of Config.pm and the Config/Z*Auto.pm 3) ignore the parts in diff for Config.pm related to the database connection. 4) store the diff information as a file and copy i...