Search found 12 matches
- 07 Dec 2022, 18:59
- Forum: Help
- Topic: Determining whether an article is stored in DB or filesystem
- Replies: 0
- Views: 2107
Determining whether an article is stored in DB or filesystem
Hello, For some reason, I have migrated a part of my (OTRS 6) tickets from the (MariaDB) otrs database onto the filesystem, and Ieft another part in the DB. This works as expected, no problem with that. But now, I am wondering if, using only a MySQL request (i.e. without using commands at the Linux ...
- 25 Nov 2022, 20:36
- Forum: Help
- Topic: Shrinking communication_log_object_entry table
- Replies: 1
- Views: 282
Shrinking communication_log_object_entry table
Hello, I run OTRS 6. The (MariaDB) communication_log_object_entry table is growing and its size is now more than 40GB, which becomes to be a problem. (I think this growth is mainly because there is really a lot of postmaster filters that are applied to the incoming emails, and there are many incomin...
- 17 Oct 2022, 12:03
- Forum: Developers
- Topic: How to customize (via javascript) an AgentTicketFreeText with conditions on the ticket queue
- Replies: 0
- Views: 3814
How to customize (via javascript) an AgentTicketFreeText with conditions on the ticket queue
Hello, I want to customize the AgentTicketFreeText form contents/appearence with variations being based on the current ticket queue. I have a custom AgentTicketActionCommon.tt (in /opt/otrs/Custom/Kernel/Output/HTML/Templates/Standard/AgentTicketActionCommon.tt) and I know I can add something like: ...
- 21 Sep 2022, 09:46
- Forum: Help
- Topic: Making the "Ticket#" prefix optional for ticket number recognition in incomin,g emails
- Replies: 1
- Views: 305
Making the "Ticket#" prefix optional for ticket number recognition in incomin,g emails
Hello, In my OTRS 6 installation, incoming emails whose subject contains: Ticket#<ticketnumber> are correctly considered as followups for the ticket. But incoming emails whose subject contains just: <ticketnumber> are not considered as followups and just create "oorphan" tickets in the Raw...
- 30 Nov 2021, 19:02
- Forum: General
- Topic: Creating a dynamic field (dropdown) programmatically (MySQL)
- Replies: 5
- Views: 1394
Re: Creating a dynamic field (dropdown) programmatically (MySQL)
Hi schulmann, thanks for the suggestion (using Perl OTRS libray), I admit it makes sense, but I do not want to learn all the OTRS and Perl stuff! (moreover I do not program using Perl) I'm looking for a simple/quick solution, i.e. just a basic use of SQL for creating and/or updating some appropriate...
- 30 Nov 2021, 18:48
- Forum: General
- Topic: Creating a dynamic field (dropdown) programmatically (MySQL)
- Replies: 5
- Views: 1394
Re: Creating a dynamic field (dropdown) programmatically (MySQL)
Thanks Alexus, but the ImportExportDynamicFields you mention does not answer to my question and to my needs.
(As far as I know that would just allow me to copy a dynamic field from a server to another one, but would provide no help for creating the dynamic field and its numerous keys/values.)
(As far as I know that would just allow me to copy a dynamic field from a server to another one, but would provide no help for creating the dynamic field and its numerous keys/values.)
- 30 Nov 2021, 18:38
- Forum: General
- Topic: Creating a dynamic field (dropdown) programmatically (MySQL)
- Replies: 5
- Views: 1394
Creating a dynamic field (dropdown) programmatically (MySQL)
Hello, I plan to create a dynamic field of type "Dropdown", but as it will have a lot of keys/values (200), and as I'll create the same field on several servers (at least test then production), I do not want to enter things manually using the OTRS "AdminDynamicFieldDropdown" form...
- 15 Sep 2021, 10:22
- Forum: General
- Topic: Customization of fields in CustomerTicketMessage.tt
- Replies: 1
- Views: 1040
Customization of fields in CustomerTicketMessage.tt
Hello, To make my dynamic field SiteCode appear in the customer ticket creation form, I have added to CustomerTicketMessage.tt this code: <div class="Row Row_DynamicField_SiteCode"> <label id="LabelDynamicField_SiteCode" for="DynamicField_SiteCode" class="Mandatory...
- 09 Sep 2021, 17:42
- Forum: Help
- Topic: Which SQL for listing tickets with all their dynamic fields
- Replies: 1
- Views: 940
Which SQL for listing tickets with all their dynamic fields
Hello, Which SQL request would allow me to list tickets with all the dynamic field values? (something similar to what we obtain from OTRS search results when selecting CSV as the output, or when using the "statistics" feature) - I know how to "SELECT * FROM tickets t", how to mak...
- 20 Aug 2021, 17:51
- Forum: General
- Topic: Pre-filling the article "Text" in the creation form (based on a template)
- Replies: 2
- Views: 1042
Pre-filling the article "Text" in the creation form (based on a template)
Hello, I know that I can craft URLs to bring up the AgentTicketPhone ticket creation form with some values already selected. For example, I use: https://myserver/otrs/index.pl?Action=AgentTicketPhone;Subaction=StoreNew;ExpandCustomerName=1;SelectedCustomerUser=foobar;PreSelectedCustomerUser=customer...
- 17 Aug 2021, 19:45
- Forum: General
- Topic: Maximum reasonable number of dynamic fields
- Replies: 3
- Views: 1185
Maximum reasonable number of dynamic fields
Hello, (Version: OTRS 6) My users are requesting the creation of more and more dynamic fields. I am wondering what is the number of dynamic fields that should be considered reasonably as a maximum. For example, is it considered reasonable and workable to have more than 200 different dynamic fields d...
- 14 Apr 2021, 09:49
- Forum: General
- Topic: Ticket Commands in generic Agent not working
- Replies: 16
- Views: 8261
A possible solution [Re: Ticket Commands in generic Agent not working]
I had the same issue (apparently unable to create/write a file into /tmp from a bash script invoked by a generic agent) So, for the records, I write here what was for me the solution (on CentOS). The file was in fact written, but instead of being written in /tmp, it was written in a subdirectory of ...