July 2012 - otrs - OTRS mailing lists

OTRS + CRM Implementation
by Chris Watt 26 May '25

26 May '25

I have been googling this for hours and it seems to have been mentioned on here but no one has ever given anything. What I want to do is link OTRS with a CRM program like SugarCRM (or similar). Has anyone done this before/know how to do it? Basically I want the tickets to be copied into SugarCRM automatically, with all approriate fields, and customers to be stored in the same location. I read somewhere that one guy had done it but he provided no further info. Cany anyone help? Cheers ~Chris

3 2

Thorsten Kocher/Spirit21 ist außer Haus.
by TKocher＠spirit21.de 19 Apr '17

19 Apr '17

Ich werde ab 13.05.2005 nicht im Büro sein. Ich kehre zurück am 30.05.2005. Vielen Dank für Ihre Email. Leider befinde ich mich bis Montag, 30. Mai 2005 außer Haus und kann daher Ihre Nachricht nicht bearbeiten. Bitte rufen Sie mich in dringenden Fällen mobil unter 0172 6377392 an. Vielen Dank für Ihr Verständnis. Thorsten Kocher Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.

36 63

MSSQL, CS_OPT_TEXTSIZE failed and the solution mentioned in the CHANGELOG
by Johannes Scholz 06 Aug '13

06 Aug '13

Hello, I am using MSSQL as customer backend and I am getting the infamous CS_OPT_TEXTSIZE error. The CHANGELOG suggests to set the "Attribute => {}" option of the database backend, in order to prevent LongReadLen being set. This is what I did: Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Sybase:server=XXX; database=XXX', User => 'xxx', Password => 'xxx', Table => 'XXX', Attribute => {}, ... } Despite the "Attribute" var being set it seems to be ignored, as I am still getting a lot of "Setting of CS_OPT_TEXTSIZE failed. at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 319." errors. PRODUCT = OTRS VERSION = 3.1.2 BUILDDATE = Fri Mar 2 08:35:30 CET 2012 BUILDHOST = otrsbuild.otrs.com Compile-time settings (established with the "configure" script) Version: freetds v0.82 freetds.conf directory: /etc/freetds MS db-lib source compatibility: no Sybase binary compatibility: yes Thread safety: yes iconv library: yes TDS version: 4.2 iODBC: no unixodbc: yes The MSSQL server is 2008 R2, TDS protocol version is set to 8.0. Any ideas? Regards, Johannes Scholz

2 1

Enable CC ?
by Hussein E. Hijazi 28 Mar '13

28 Mar '13

Hi Is it possible for enabling CC'ing when a customer creates a ticket? Sometimes folks are making a ticket and they want other people to know that. Thanks, Hussein

3 4

get rid /otrs/index.pl
by Adi Ariyanto 22 Aug '12

22 Aug '12

I want get rid /otrs/index.pl, based on http://forums.otterhub.org/viewtopic.php?f=60&t=9329, every step I have follow but I get error root@ticketing:~# /etc/init.d/apache2 restart Syntax error on line 56 of /etc/apache2/sites-enabled/otrs.conf: Invalid command 'PerlResponseHandler', perhaps misspelled or defined by a module not included in the server configuration Action 'configtest' failed. The Apache error log may have more information. failed! My apache error log Fri Jul 27 14:07:46 2012] [notice] caught SIGTERM, shutting down Any idea? ________________________________ This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error.

6 9

lookup customer email addresses ?
by ipguy 09 Aug '12

09 Aug '12

hi all i'd like to lookup customer email addresses from our vtiger mysql database hosted on a remote server. Is this possible ?

3 4

Lightbox HowTo on OTRS
by Gerald Young 07 Aug '12

07 Aug '12

Slightly out of the ordinary thing, but I had fun with it ... How to add Lightbox2 to OTRS so when you click on an image attachment, it does that popover effect. http://forums.otterhub.org/viewtopic.php?f=60&t=16302

3 6

Try to restore OTRS
by Adi Ariyanto 01 Aug '12

01 Aug '12

First of all thank you for anyone that answer my question :) After I try run backup otrs on my otrs virtual machine, now I want to try to restore it, i got an error "ERROR: Already existing tables in this database. A empty database is required for restore!" Information 1. I am used my copy of OTRS vmware, it's very fresh, just need run /installer.pl to setup My question is 1. It's a fresh system, I even not yet create a ticket, just test that /index.pl is opened, but why I got an error about existing tables? How to make this restore test is work ? Thank you ________________________________ This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error.

5 10

How to bounce a lot of tickets ?
by claude 01 Aug '12

01 Aug '12

Hi, Can I bounce a lot of tickets to a specific external address at one time ? I try with GenericAgent job but in its properties I don't find this possibility. Thanks and regards Claude

2 2

Can't edit customer
by Lars Jørgensen 31 Jul '12

31 Jul '12

Hi, Normally when I edit a customer, I get this: normal customer But with some customers, I get this: problem customer What's the difference between these customers? -- Lars

5 5