Attachement from v5 were not migrated to v7

secretaris@msgdenbosch.nl

I have succesfully migrated everything from Acymailing v5 to v7 but the attachments of the send mails are not attached after the migration while they are still attached in Acymailing v5. How to fix this?

jvstratum

Hi,

They are not migrated as far as I know. You need to migrate attachments manually. During the migration, as far as I know, only data that is stored in the DB is migrated.

A good start would be to copy the attachments to the right upload folder: copy everything from .../media/com_acymailing/upload to ...media/com_acym/upload

After that check if you files are attached. If not you need to re-attach them to your mails.

secretaris@msgdenbosch.nl

jvstratum I had already tried that but then i have to re-attach lots of attachment for each mail. I hope there is a way to keep it simple and fix this in the database.

jvstratum

Hi,

I honestly don't know if that's possible. If you have a valid Essential or Enterprise license you can ask the devs if they have a solution by opening a support ticket here: https://www.acymailing.com/support/

secretaris@msgdenbosch.nl

I have solved the problem with the following update script

I have copied all the attachments from the folder media/com_acymailing/upload to media/com_acym/upload.

Then is changed the database field attach a:1:{i:0;O:8:\"stdClass\":3:{s:%:\"filename\";s%%:\"media/com_acymailing/upload/document.xls\";s:4:\"size\";i:25600;s:%:\"extension\";s:%:\"xls\";}} to [{"filename":"media\/com_acym\/upload\/Document.doc","size":25600}]

Multiple attachments were added like [{"filename":"media\/com_acym\/upload\/Document.xls","size":25600},{"filename":"media\/com_acym\/upload\/Document2.doc","size":22800}]

UPDATE `jos_acym_mail` SET `attachments`='[{  "filename" : "media/com_acym/upload/Document1.pdf",  "size" : 1222893}]' WHERE `id` = 95;
UPDATE `jos_acym_mail` SET `attachments`='[{  "filename" : "media/com_acym/upload/Document2.pdf",  "size" : 3057209},{  "filename" : "media/com_acym/upload/Document3.docx",  "size" : 38579}]' WHERE `id` = 96;

Acymailing v5 uses the fieldname attach and Acymailing v7 uses the fieldname attachments
Acymailing v5 uses the fieldname mailid and Acymailing v7 uses the fieldname id

jvstratum

Hi,

I'm glad you've managed to solve this on your own. Thanks for sharing the solution. Enjoy your Acymailing!