These are instructions for enabling ULC within Manitou for Canadian customers. If more information is needed, please contact Bold Support.
Instructions
To enable ULC (Underwriters Laboratories of Canada), update the moptions table option number 804 with the account ID number from CRM. Use the script below to automatically handle configuring ULC.
NOTE: There is a single item in this script that must be changed to match the site it is being run for. Specifically, @AccountID will need to be changed to reflect the Account ID we have on file for the respective customer (Must be an integer only).
If ULC is already configured but not working, let the customer know and troubleshoot why it is showing as not configured.
USE MANITOU
GO
Declare @AccountID int;
/*------------------------------------------------
Please change '909' to the correctsite's Accounting ID below
*/------------------------------------------------
Select @AccountID = '909';
/*------------------------------------------------
Script created by: Chris Narowski
Last updated by: Chris Narowski
Last modified date: 08/27/18
Additional Notes:
This should be compatible with all Manitou Versions.
If there are any issues with the script, please verify no changes
have recently been made to the MOptions Schema.
Do not edit any of the following
------------------------------------------------*/
Declare @ULCoption varchar (50);
SELECT @ULCoption = 'Pending';
SELECT @ULCoption = (SELECT OPTCHAR FROM MOPTIONS WHERE OPTIONNO = 804)
IF EXISTS (SELECT * FROM MOPTIONS WHERE OPTIONNO = 804)
BEGIN
PRINT 'Moption Exists, setting ULC...'
IF (@ULCoption IS NULL)
BEGIN
UPDATE MOPTIONS SET OPTCHAR = @AccountID WHERE OPTIONNO = 804;
print 'The Account ID has successfully been set to '+ CAST(@AccountID as varchar(10))
END
ELSE
BEGIN
IF @AccountID = @ULCoption
BEGIN
PRINT 'ULC already has been configured with the requested Account ID of '+ CAST(@AccountID as varchar(10))
END
ELSE
BEGIN
PRINT 'ULC already has been configured with a different Account ID of '+ @ULCoption
END
END
END
ELSE
BEGIN
INSERT INTO MOPTIONS (LASTUPD, CREDATE, OPTIONNO, OPTIONTXT, DATATYPE, OPTBOOL, OPTINT, OPTCHAR, OPTDATE)
VALUES('2012-04-17 20:04:23.517','2012-04-17 20:04:23.517','804','ULCSERIALID','2','0',NULL,@AccountID,NULL);
PRINT 'MOption did not exist, the moption has been created with the correct Account ID.'
END