Re: [otrs] How to use Import/Export Management to create links between config items

2011-03-16 Thread Martin Aigner
Thanks Udo, you approach works as expected. Excellent API btw. Best, Martin On Tuesday, March 08, 2011 11:44:19 AM Udo Bretz wrote: Hello Martin, unfortunately the Import/Export script is currently not able to create links between objects. But you could write a script, which uses

Re: [otrs] FAQ article help

2011-03-16 Thread Silver springs
Hi Lukasz, Thanks for your reply on the FAQ article help. Im not sure if I understand what you said about the f_subject and other fields. Please let me know what are these f_subject, f_field1 etc .. What do these attributes represent when I select them ? Could you please tell me what they mean

Re: [otrs] FAQ article help

2011-03-16 Thread Marco Vannini
Harg, this is going to be very long :D ... What Lukasz has indicated you are the fields related to the FAQ's tables in the OTRS database. OTRS store the information that you enter in the variuos forms of the tool in a repository. With the SELECT provided, that must be executed via command line

[otrs] Config Items data

2011-03-16 Thread Straccialano, Rosanna
Hi, Can somebody please tell me why the config items data is written in XML within the xml_storage table and not just normal fields like everything else? Is there a reason for this? Thank you, Rosanna - OTRS

[otrs] Agent reply via email

2011-03-16 Thread Kristofer Pettijohn
Hello, I am using OTRS 3.0.6. Is it possible for agents to reply via email? I would like the agents to be able to reply to the notifications they receive, and then have the email picked up by OTRS, OTRS will recognize that it is an agent (rather than the customer), add the notes to the

Re: [otrs] FAQ article help

2011-03-16 Thread Lukasz Hadyna
Hey Winter, f_subject is the Title of the FAQ entry, f_field1 through f_field6 are other fields within the FAQ entry (solution, problem, symptom... etc), unfortunately I can not identify these for you as we are currently only using f_field3 (solution) and f_subject (we put our FAQ questions as

[otrs] Follow up based on number in email body

2011-03-16 Thread Robert Poreba
Hi All, We are logging calls with 3rd party and give them our OTRS Ticket number as a reference. They reply to us with this number in the body of their email, always with format of: Reference 1: *TicketNumber* I know I can use PostmasterFollowUpSearchInBody to scan the whole body but I was

[otrs-de] illegal mix of collations

2011-03-16 Thread Sebastian Cabrera
Hallo zusammen, In letzter Zeit hab ich es schon öfter bemerkt das Emaileingänge loopen nachdem folgender Fehler aufgetreten ist: OTRS-otrs.PostMaster.pl-1337[21013]: [Error][Kernel::System::Ticket::Article::_ArticleGetId][Line:1826]: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and

Re: [otrs-de] illegal mix of collations

2011-03-16 Thread Frank Kruse
Hallo Sebastian, OTRS-otrs.PostMaster.pl-1337[21013]: [Error][Kernel::System::Ticket::Article::_ArticleGetId][Line:1826]: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM article WHERE ticket_id = ? AND