Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

Restore an accidentally deleted image in BBIS

By: Chris Whisenhunt

Posted on: February 9, 2017

Ever had an image accidentally deleted in BBIS? Read on to find out how to restore it!

Images in BBIS are handled via an image handler and are stored in the database. Before restoring the database give this a try.

declare @IMAGEID int = 3558;
declare @IMAGEKEY nvarchar(50) = 'Image_' + cast(@IMAGEID as nvarchar(10)) + '_0',
@CURRENTDATE datetime = getdate();

update SITEIMAGES set DELETED = 0, INTRASHBIN = 0 where ID = @IMAGEID;
exec spAddUpdate_CacheItem @IMAGEKEY, @CURRENTDATE, 0;

🙂 Happy coding!

* this has only been tested in BBIS 6.64.166.0 (CRM 4)

Leave a Reply

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean