Restore an accidentally deleted image in BBIS

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)) + … Continue reading Restore an accidentally deleted image in BBIS

Creating a BBIS part so that the ADF doesn’t need hard coded values (GUIDs and URLs)

We got our ADF developed by Blackbaud and had issues with the need to hard code GUIDs and URLs. The hard coded values looked something similar to this. var BBI = BBI || {     // update these values when updating changelog     Config: {         version: 1.5,         updated: '01/15/2016',         isEditView: !!window.location.href.match('pagedesign'),         responsive: true     },     Defaults: {         rootpath: … Continue reading Creating a BBIS part so that the ADF doesn’t need hard coded values (GUIDs and URLs)

Download a file to the user’s browser via CRM

To download a custom file in CRM using VB you need to create a class that inherits Blackbaud.AppFx.Server.AppCatalog.AppCustomFileDownloadProcess like so. Imports Blackbaud.AppFx.Server Imports System.IO Public Class TestFileDownloadHandler     Inherits AppCatalog.AppCustomFileDownLoadProcessor     Public Overrides Function CheckSecurity() As SecurityCheckResult         Return SecurityCheckResult.SecurityCheckPassed     End Function     Public Overrides Sub ValidateArgs()         If String.IsNullOrEmpty(Me.RequestArgs.Parameters("Text")) Then             Throw New Exception("Text parameter not provided")         End If     End … Continue reading Download a file to the user’s browser via CRM

Moving attributes between environments

There are many times when I need to move attributes from one environment to another. Below is what I use, it prints out one big script that you can copy and paste and run. set nocount on; declare @SQL nvarchar(max) = N''; declare @ATTRIBUTES table(ID uniqueidentifier primary key, NAME nvarchar(100), ATTRIBUTERECORDTYPEID uniqueidentifier, DATATYPECODE tinyint, CODETABLECATALOGID uniqueidentifier, ONLYALLOWONEPERRECORD … Continue reading Moving attributes between environments