Search found 139 matches

by ndhvu275
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
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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)
by ndhvu275
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 ...
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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
by ndhvu275
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
by ndhvu275
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
2-25-2014 5-59-27 PM.png
I remember it was displaying in OTRS version 3.2. Please help me

Thanks a lot

Vu Nguyen
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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

wurzel wrote: copy - paste or forward.
Hi,

Where can I execute to copy, paste or forward? Could you explain more detail

Thanks
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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
12-19-2013 8-39-39 AM.png
file odbc.ini
12-19-2013 8-43-31 AM.png
by ndhvu275
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...
by ndhvu275
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 ...
by ndhvu275
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

jojo wrote:ensure that your database is utf8
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?
12-13-2013 11-12-07 AM.png
Thanks

Vu Nguyen
by ndhvu275
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

reneeb wrote:It's most likely an error in your .sopm or your config-XML...
Yes thanks. It's really an error from my .sopm. It's now ok.

Thanks again
Vu Nguyen
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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
by ndhvu275
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...
by ndhvu275
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 ...
by ndhvu275
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 ...
by ndhvu275
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
by ndhvu275
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 ...
by ndhvu275
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...
by ndhvu275
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

crythias 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.
Anyway thank you. Maybe I have to develop a field on Create Queue screen, that's also the design from customer to me :(

Vu Nguyen
by ndhvu275
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,...
by ndhvu275
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...
by ndhvu275
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...
by ndhvu275
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

reneeb wrote:Make an AgentTicketPhoneNguyen.pm, create a config file that has all the options for AgentTicketPhone adopted for AgentTicketPhoneNguyen, deactivate AgentTicketPhone.
Ah this is a really nice solution. Thank you very much, I will do like this

Thanks again

Vu Nguyen
by ndhvu275
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...
by ndhvu275
20 Jul 2013, 05:16
Forum: Help
Topic: Enalbe Dynamic Field in AgentTicketBulk
Replies: 4
Views: 2043

Re: Enalbe Dynamic Field in AgentTicketBulk

crythias wrote:Use Generic Agent to set a DynamicField for multiple tickets.
Yes,it's a nice solution. Thanks so much
by ndhvu275
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 ...
by ndhvu275
19 Jul 2013, 10:05
Forum: Help
Topic: Enalbe Dynamic Field in AgentTicketBulk
Replies: 4
Views: 2043

Re: Enalbe Dynamic Field in AgentTicketBulk

reneeb wrote:After a quick look at the config files I assume that you need to change the sources...
Thanks reneeb, yes of course :(
by ndhvu275
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
by ndhvu275
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...