1. Home
  2. Knowledge Base
  3. Software
  4. Administration
  5. How to Customize EIOBoard Status Colors

How to Customize EIOBoard Status Colors

Web

With the release of version 10.2.3 came a change in status colors in the EIOBoard as well as the ability to easily customize and create new status colors.Ā  To create a new status color, go to the administration panel in the web application and select “Statuses”

 

Next, select “Edit” or create a new status.Ā  Selecting a custom color allows you to add a color with the color picker.Ā  Clicking on the up and down arrows next to the RGB input type will allow for HSL and Hex input.

If you are interested in reverting the new colors to the legacy status colors from before version 10.2.3, please see this knowledge base article.

Desktop Application

While you cannot create new custom colors in the Desktop Application, you can still assign new status colors while managing statuses.

1. In the Desktop Application Administration panel, go to the Status Management Tab. There you can select edit on a status to change it’s properties.

2. Then you can select the color you want to be used for that status and click update to save

 

Database

If you would like to change or add color options that are available when you are selecting available colors for your status color, this can be done on the back end by editing the database.

Note: Because this requires you to edit your EIOBoard database, this feature is only available to Customer-Hosted customers. Also, because you are editing the EIOBoard database, you must be very careful to not change any other settings or database tables that may impair EIOBoardā€™s functionality. If you are an EIOBoard-Hosted customer who would like to add colors OR if you are a Customer-Hosted customer who would like EIOBoardā€™s support team to take care of this database work for you, feel free to purchase a Block of Support. EIOBoardā€™s support team can do all the necessary work for you over a web conference! For details, visit EIOBoard Training and Consulting.

To edit the colors in your EIOBoard database, follow these instructions:

  1. On the server machine with your EIOBoard database, open SQL Server Management Studio.
  2. Browse to your EIOBoard database (the default name is SolutionSavant).
  3. Browse to the table labeled ā€œdbo.Colorsā€. Right-click on this table, and click Edit Top 200 Rows. This will bring up all the columns in this table that you need to edit, along with all the existing colors in the database.

You are now able to edit existing colors or add new colors. Here is what each column in this table is for:

  • ColorSys: This is a unique number for this color. Never repeat a number in this column! Please start your numbering at 500,000 (and continue from there to 500,001; 500,002; etc.).
  • ColorCode: This is the Hexadecimal Code for each color. In other words, this determines what color is represented by this row. If you are not familiar with this, you can simply select the code you want from http://www.colorpicker.com/. The characters that appear above the table (after the ā€œ#ā€) is the Hex Code for the color you have selected.
  • ColorName: This is the title of the color, which will show up in EIOBoard in the Status Management tab of the Administrator.
  • Sequence: This is the order that the colors show up in EIOBoard in the Status Management tab of the Administrator.

To edit an existing color, make the changes you would like to each column. However, DO NOT edit the ColorSys column (since this is a unique number for each color).

To add a new color, add all the new information to the bottom row. Be sure to enter a unique ColorSys and a unique Sequence!

Once you are finished editing or adding colors, deselect the row you are editing and click the button to save the changes. However, the old colors are still cached in your EIOBoard. To fix this issue and update the cache, click toĀ run a query. Run the following query against your EIOBoard database:

UPDATE OrganizationSettings SETĀ UpdateVersionStatusĀ =Ā UpdateVersionStatus+1

 

You can now change your EIOBoard statuses to any colors you have added, and all edited colors will be automatically changed in your users’ EIOBoards!

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support