I want to move an attachment from subprod to a producation instance

[Timothy F1]

I have a picture embedded in a notification template that isn't coming up with my update set when I promote to the next instance. I see a generic icon where the picture should be.

[Timothy F1 · Accepted solution]

Background

Attachments are made of 2 files. There is an attachment record in sys_attachment with information about the attachment, and the binary data which contains the actual file that's attached, which is located in sys_attachment_doc.

How to Move the attachment

Locate the attachment (usually by it's sys_id, which the notification will reference if you inspect the html) in the sys_attachment table. Export it's XML or add it to your update set.   Find the file it points to in the sys_attachment_doc table. Also export as XML/add to an update set.

Import into the production instance as you would any other XML file.

Special thanks to Tim Woodruff for explaining this and a bunch of other information about attachments here: https://snprotips.com/blog/2016/2/25/understanding-and-using-glideattachment