Znuny and ((OTRS)) Community Edition

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 ...

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...

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: ...

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...

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...

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.)

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...

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...

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...

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...

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...

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 ...