Attachments download

[cesco_78]

Hello,
I've a question...

I need to extract data from the OTRS DB (MySQL) in Microsoft Office, I created an ODBC connection and I can extract all data I need exept the attachments. There is a way to have a link to the file directly from Excel or Access?

thank You

Regards

[crythias]

be default, it's a binary blob in the database.

[cesco_78]

But there isa a way to download and convert it in a PDF like i can do in OTRS web interface?

Thanks!

[crythias]

No.

[jojo]

if you write some code which will convert the base64 coded data into binary yes (you need some developers for this!)

[cesco_78]

But there is not an "user-exit" or an api to ask to OTRS the attachment?

[jojo]

there is a webservice for reading tickets

[cesco_78]

Where i can find it, please?

[jojo]

read the developer docu on docs.otrs.org

[crythias]

http://dev.otrs.org/
http://dev.otrs.org/3.1/Kernel/System/T ... ticle.html

Code: Select all

ArticleAttachment()
get article attachment (Content, ContentType, Filename and optional ContentID, ContentAlternative)
    my %Attachment = $TicketObject->ArticleAttachment(
        ArticleID => 123,
        FileID    => 1,   # as returned by ArticleAttachmentIndex
        UserID    => 123,
    );
returns:

    my %Attachment = (
        Content            => "xxxx",     # actual attachment contents
        ContentAlternative => "",
        ContentID          => "",
        ContentType        => "application/pdf",
        Filename           => "StdAttachment-Test1.pdf",
        Filesize           => "4.6 KBytes",
        FilesizeRaw        => 4722,
    );