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 firstname.lastname@example.org.
I'm creating a script that will link BBIS to eCRM in various environments (DEV, TST, STG, etc), and I have a script for each environment that changes the current BBIS URLs stored in the [SETTINGS] table, to the URLs associated with that specific server.
So far, I've managed to find all references, except for the 'Blackbaud Internet Solutions URL' found within eCRM [eCRM Home Page > Web > Blackbaud internet Solutions URL].
After a database refresh (ie. Taking the production database, and copying it over to Staging), we run the script, and BBIS is happy... almost. We still have to manually change that one URL.
If anyone can point out the Database Location, I can add it to my script.
And example of my current script is:
-- RE7 Service URL and CustomServiceURL
SET Value = 'https://at-tweb23.its.sfu.ca/TST/BBNCSvc/MasterService.asmx'
WHERE ID IN (33, 34)
The table that contains that value is NETCOMMUNITYINTEGRATION.
More generally, you can often see the SQL behind CRM forms by entering page design mode, right clicking on the task (in this case, the "Blackbaud Internet Solutions" task under the "Web" functional area), and selecting "view xml".