Import Custom Company Colours into Security Informer Module for Microsoft Dynamics GP

This post is part of the GP Elementz from ISC Software series.

One of the available modules in the GP Elementz is the Color Changer. This allows you to change the colour of certain elements of the Microsoft Dynamics GP client such as the windows background. Out-of-the-box the available colours are quite strong and I was asked by a client if we could add some softer colours.

In order to get them the colours quickly, I had a look around online for some pastel colours and found a reasonable palette which I worked out the RGB values for. Those colours are embedded in the below script which, when run against the system database, will insert them into the ELZ_COLD table for use in the Color Changer tool.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
INSERT INTO ELZ_COLD
	(
		ELZ_Definition_ID
		,DSCRIPTN
		,ELZ_Red_Paint
		,ELZ_Green_Paint
		,ELZ_Blue_Paint
		,ELZ_Colour_Value
	)
VALUES
	('Azure*','Azure','0','124','255','31999')
	,('Turquoise*','Turquoise','172','233','221','11332061')
	,('Emerald*','Emerald','181','239','206','11923406')
	,('Peter River*','Peter River','183','220','244','12049652')
	,('Amethyst*','Amethyst','221','198','231','14534375')
	,('Wet Asphalt*','Wet Asphalt','185','192','201','12173513')
	,('Green Sea*','Green Sea','173','222','212','11394772')
	,('Nephritis*','Nephritis','180','228','201','11855049')
	,('Belize Hole*','Belize Hole','181','212','233','11916521')
	,('Wisteria*','Wisteria','219','189','229','14400997')
	,('Midnight Blue*','Midnight Blue','181','189','196','11910596')
	,('Sun Flower*','Sun Flower','251','235','165','16509861')
	,('Carrot*','Carrot','246','211','175','16176047')
	,('Alizarin*','Alizarin','248','195','185','16303033')
	,('Clouds*','Clouds','250','252','252','16448764')
	,('Concrete*','Concrete','219','226','226','14410466')
	,('Orange*','Orange','253','221','170','16637354')
	,('Pumpkin*','Pumpkin','240','195','163','15778723')
	,('Pomegranate*','Pomegranate','235','186','180','15448756')
	,('Silver*','Silver','232','234','236','15264492')
	,('Asbestos*','Asbestos','211','217','217','13883865')
GO