How to customize values in the database

Overview

VISULOX has several standard files in /opt/visulox/setup/database for the messages, views, applications etc.

The installation order is imported. The files can not be changed. If any special customizations are needed,
new files can be put into that directory and the extension must be ".cust".

This allows to modify or add parameters after applying.

Modifications must be applied on any node with the command

CODE

 /opt/visulox/setup/loadconfig.tcl -config <custfile>

The VISULOX update process loads these files automatically.

Configuration

The format of such files is

CODE

{
    presql {
		-- ANY SQL STATEMENT BEFORE DATA
    }   
    <tablename> {
        columns {<list of columns>}
        rows  {
                {<list of values>}
              }
    }   
    postsql {
		-- ANY SQL STATMENT AFTER DATA   
    }   
}

Example to modify a text in the text catalog

CODE

{
    textcatalog {
        columns {lang var icon shorttext description}
        rows  {
                {en {WrongOtp} {sign_warning} {OTP not valid!} {The OTP entered is not correct}}
                {de {WrongOtp} {sign_warning} {OTP nicht gültig!} {Der eingegebene OTP ist falsch}}
              }
    }   
}

Example to change the error message, if a script fails

CODE

{
 textcatalog {
   columns {lang var icon shorttext description}
   rows    {
            {de {loginscripterror} {} {Wenden Sie sich bitte an Ihren Administrator} {}}
            {en {loginscripterror} {} {Call Administrator} {}}
   			}
	}
}

After change, a total service reboot is needed .

Before such a modification is applied we recommend:

to ask support@visulox.com for assistance
to make a backup of the database
no changings are done, when the environment is online

Related information

How to configure alternate mappings for datasources