Znuny and ((OTRS)) Community Edition

When i try it, it does not work. Anybody help us to do it?

Solved: I should use key format like this;

What do you mean with "connect"? Do you want to import data from CMDBuild to OTRS? Do you need only a link to the asset from the ticket zoom? Do you need to "export" data from OTRS to CMDBuild? I just only need a link to the asset from the ticket zoom. I can use SOAP web service...

Export it from Admin page.

How can i connect CMDBuild to OTRS (Help Desk), to reference incidents with CMDB assets.
I m using Cmdbuild application because, OTRS cmdb module does not have report

Hi,

I want to separate my parent and child tickets. When i use your way like ticket_id is not equal to target_key filter, somethings is wrong. The result is not correct i think. Did you try it? Is there another way to separate them?

Not yet I m looking for solution.

Hi, Since updating to 3.3.11, I have a problem with OTRS running on OpenSuse. When making a reply to a customer’s message, the mail address of the customer is encapsulated by HTML " tags like this: I am able to delete the mail address from the list and add it again, then I don’t have any “quote...

Hi, When I apply "Edit default services" from "Admin > Customer User <> Services > Edit default services" for my all customer, it is not effected to all customer. Any problem i have with latest version? My version is : 3.3.8 I have a lot of services and i could not create new tic...

Hi, My version is 3.3.8. I use this code in AgentTicketClose.dtl. But it doesnt work. What is wrong? <script type="text/javascript">//<![CDATA[ function nonetext() { $("[id^=DynamicField]").parent().addClass( 'Hidden' ); $("[id^=LabelDynamicField]").parent().addClass('H...

Is it possible to do it for AgentTicketClose.dtl?

These parameters should be in params function.
SourceCharset => 'utf-8',
DestCharset => 'utf-8',

I did it like this DestCharset => 'utf-8', but there is no change?
I think this parameter does not effect my code?

I decide to use only one backend, but my problem is Turkish characters are not shown correctly:(

These two parameters does not effect my data?
SourceCharset => 'utf-8',
DestCharset => 'ISO-8859-9',

Any advice you have?

Hi, I want to get more customer info when i create ticket. I decide to use more than one customer backend. I did everything in documents at the below. http://otrs.github.io/doc/manual/admin/3.3/en/html/external-backends.html Everythings are working well except turkish character problem. When i check...

Hi, I need some ticket data to use in my report. I use web service to get it by using SOAP connector. My function is sometimes working but sometimes does not work and getting error. Anybody has this issue? Error: Fatal error: Uncaught SoapFault exception: [soap:Client] Application failed during requ...

crythias wrote:Optimize your query.

After optimize my query, it is working well. Thank you for your support.

Without understanding why you need to get everything from all your tickets on a consistent basis, the first response is "don't do this" ... Or: run this intensive command against a replication database in off hours. Or: Cache this request to a file Or: EXPLAIN the sql request (keyword ter...

crythias wrote:If the db is crashed, repair it. Hope you have a backup.

Crash means locked:) My sql is working but my old version takes 3 minutes. But at the moment, it takes 54minutes.
Do you have any suggestion?

jojo wrote:well my testsystem has only a few tickets.

Ok, our live system has over 20000 tickets. What is wrong i could not understand:(

jojo wrote:also the SQL works like a charm on a 3.3.

Sure? Is it working 3.3? When i try there is no response and DB was crashed:(

jojo wrote:use the statistic type ticket list to get the info

I know, but i should get it via SQL or function, because i will transfer these data to other database to report it. Please help me.

jojo wrote:http://ftp.otrs.org/pub/otrs/doc/databa ... tabase.png

Thank for your support. I need these two info for tickets. How can i get these two info? Any SQL command or function are helpfull for me.

"first_response_time" and "close_time"

jojo wrote:there were a lot of changes. Check actual ERP diagram or SQL update script. Posting the error would also be good.

Can you share these documents with me. When i run this sql, all tables are locked and OTRS is crashed.

Hi, Anybody help me to resolve my problem. After upgrade from 3.2.10 to 3.3.5, my SQL command does not work. What was changed in DB? It was working good in 3.2.10. My SQL is; SELECT (SELECT GROUP_CONCAT(dfv.value_text) FROM dynamic_field_value dfv WHERE dfv.id = t.id ) dynamic_field_values , t.id ti...