Exporting Attachments

[RichH]

My OTRS system is configured:

OTRS Version: 3.1.3
OS: Window Server 2008 R2 SP 1
Database: MS SQL Server 2008 R2
Perl Version: Strawberry Perl 5.12.3.0

I'm trying to switch from DB article attachment storage to file system storage and need to export all attachments from the MS SQL database.

When I export using VBScript the attachments are unreadable. There seems to be some character code conversion that's needed, but I haven't been able to figure it out. A text file that consists of just the letter 'a', exports to 'YWFh'. Any other files like .wav files are unreadable by their associated programs. Does anyone know what character code translation is needed and how the best way to run it is?

Also, I tried the otrs.articlestorageswitch.pl script, but got the errors below. Does anybody know how to get this running?

Any help would be greatly appreciated.

Thanks!

C:\Program Files (x86)\OTRS\OTRS\bin>perl otrs.articlestorageswitch.pl -s articlestoragedb -d articlestoragefs
NOTICE: 1/203101 (TicketID:130)
Subroutine ArticleStorageInit redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 25.
Subroutine ArticleDelete redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 41.

Subroutine ArticleDeletePlain redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 124.
Subroutine ArticleDeleteAttachment redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 159.
Subroutine ArticleWritePlain redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 201.
Subroutine ArticleWriteAttachment redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 228.
Subroutine ArticlePlain redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 294.

Subroutine ArticleAttachmentIndexRaw redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 353.
Subroutine ArticleAttachment redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 504.
Subroutine _ArticleDeleteDirectory redefined at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket/articlestoragedb.pm line 653.
Can't locate package Kernel::System::Ticket::articlestoragedb for @Kernel::System::Ticket::ISA at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket.pmline 239.
Can't locate package Kernel::System::Ticket::articlestoragedb for @Kernel::System::Ticket::ISA at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket.pm line 239.
Can't locate object method "ArticleStorageInit" via package "Kernel::System::Ticket" at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket.pm line 239.
Can't locate package Kernel::System::Ticket::articlestoragedb for @Kernel::System::Ticket::ISA at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/Ticket.pm line 239.

[jojo]

try otrs.ArticleStorageSwitch.pl -s ArticleStorageDB -d ArticleStorageFS (capitalisation is needed!)