Data import for attachments from existing system to OTRS

[GMunjal]

Hi,

We implement OTRS for ticket system. previously we used some other ticket system in which attachments were saved on local system and not in DB.

So now we have to perform data migration from existing system to OTRS. For ticket attachments we are able to map all fields except the content.
As we have to insert all the content for all tickets from local system path to DB.

Is there is any way to import the attachment data from local system to DB field ?
Which encryption is used to store the content of attachments in DB field ?
Or is there is any way we can store the attachment on local path and not in DB ?

Thanks in advance.


Regards
Gmunjal

[crythias]

otrs/bin/otrs.ArticleStorageSwitch.pl (move storage location between DB and FS)

usage: otrs.ArticleStorageSwitch.pl -s ArticleStorageDB -d ArticleStorageFS [-c <JUST_SELECT_WHERE_CLOSE_DATE_IS_BEFORE> e. g. -c '2011-06-29 14:00:00' -C
<JUST_SELECT_WHERE_CLOSE_IS_OLDER_IN_DAYS] e. g. -C '5' [-f force]



Edit Config Settings in Ticket -> Core::Ticket
Ticket::StorageModule (Determine where OTRS stores new article attachements: DB or FS)

Please back up fs and database prior to doing anything. I can't help you do or undo this.

[GMunjal]

Thanks for the reply.

I can use the file system for further saving attachments, but of migrating data o have to create the file system same as it is which is very effort consuming,
can any one suggest to save the ticket attachments from some other system to OTRS dB article_attachment table. The only issue is in content column.

any do this type of migration in which we pick the attachment one by one from some machine FS and copy the content into content column of article_attachment.


Regards,
GMunjal