[otrs] restore article_attachment from article_plain after table crash

Hi, in my otrs installation i've a partly destroyed article_attachment table. All attachments of 2 month are lost after repair proccess. I saw that the attachments are still saved in the article_plain table. Is there a simple method or tool to "convert" the attachments out of the plain e-mail int

[otrs] Integration with Remote Support Software

Hi All, I would like to know what Remote Support Software can be easily integrated into OTRS? E.g Teamviewer, gotomeeting, webex etc... Also if anyone has done this I would appreciate any recommendations/limitations. Derek Kiely -

Re: [otrs] restore article_attachment from article_plain after table crash

Unfortunately, I don't see how this would be possible or even get what you want. The schema is different between plain and attachment and plain holds the body, while the attachment hold the ... This would be a good case for attempt to export before repair and I recommend automysqlbackup in the futu

Re: [otrs] Integration with Remote Support Software

I'd be interested, too ... For TeamViewer, you may be able to do the following: Make CustomerID.tvc files for each connection -- or usernames -- but at least something that you can have a relationship between the ticket customer and the connection icon. This assumes that you know this information