1. Should you have more than one instance of NumberOk (including NumberOk Reporter) sharing the same database make sure to start with a computer that hosts the database file:

(a) Open C:\ProgramData\FF\NumberOk3\NumberOk.ini

(Check Locations section if the above doesn’t work in your case)

(b) Find parameter Database.FB_host 

If the value is 127.0.0.1 you’re definitely on the right computer, otherwise, identify the right computer by the
IP address specified therein.

2. Make sure to be logged in to Windows as Administrator or a user with administrative privileges.

3. Check the current database type:

(a) Open C:\ProgramData\FF\NumberOk3\NumberOk.ini

(Check Locations section if the above doesn’t work in your case)

(b) Find parameter Database._Type 

If the value is FIREBIRD then NumberOk update is possible.

4. Have the latest release of NumberOk, which is always available at NumberOk last version

1. Quit every instance of NumberOk (including NumberOk Reporter) that shares the same database.

2. Take notes of NumberOk and FireBird binaries, and data file locations.

3. Back up NumberOk settings.

4. Back up the database.

File Locations

Take notes of actual locations.

Go to On the "Settings"-"General" tab and press the “Backup configuration” button as in the screenshot below.
The backup copy of the configuration file will be stored at the next path C:\Users\Public\Documents.

In case the original NumberOK.ini from the C:\ProgramData\FF\NumberOk3 folder is disabled and the NumberOk software starts up not special,
the NumberOk software will automatically run with the configuration file from the C:\Users\Public\Documents folder.

You will do the same on every computer having NumberOk installed before the upgrade.

NB! This is only required to undertake on a computer that hosts the FireBird database.

1. Open database storage folder in Windows Explorer.

2. Create and open for editing a new file backup.cmd

3. Copy the following lines thereto:

@SET ISC_USER=SYSDBA

@SET ISC_PASSWORD=masterkey

@SET FB_BIN="C:\Program Files (x86)\FireBird\bin"

@SET GBAK=%FB_BIN%\gbak.exe

@SET N3WORKPATH="C:\ProgramData\FF\NumberOk3"

@SET FB_DB=%N3WORKPATH%\NumberOk3.fdb

@SET FB_BAK=%N3WORKPATH%\NumberOk3.fbk

@SET GBAK_LOG=%N3WORKPATH%\BACKUP.LOG

@del /q %GBAK_LOG% > nul 2>&1

@%GBAK% -b %FB_DB% %FB_BAK% -g -v -y %GBAK_LOG%

The above contains default locations. Should those be different, amend as appropriate.

Check specifically lines containing SET FB_DB. If there is no NumberOk3.fdb in the Database storage location but instead e.g.
NumberOk.fdb change filenames for FB_DB and FB_BAK as appropriate.

Save the file.

4. The process may take a certain time depending on database size and computer performance.
 It will not only make a backup copy but the copy will also be thinner as records marked for deletion will be removed.

4a. Consider cleaning up the database (NumberOk: Settings > General - Clear database) with the Remove screenshots box checked.

4b. Check if the current disk has sufficient free space.
There should be as much as 3 times more free space NumberOk3.fdb occupies (for backup and log files), plus some extra space for OS needs on drive C (consider extra 3 to 5 Gb).

4c. When ready, launch Windows Console cmd.exe at database storage folder and run backup.cmd

Wait until you can see command prompt and cursor again.

Should the folder contain NumberOk3.fbk (or another .fbk file as amended in backup.cmd) and BACKUP.LOG and no error messages
reported upon job completion then the backup process has passed smoothly.

NB! This is only required to undertake on a computer that hosts the FireBird database.

1. Open database storage folder in Windows Explorer.

2. Create and open for editing a new file restore.cmd

3. Copy the following lines thereto:

@SET ISC_USER=SYSDBA

@SET ISC_PASSWORD=masterkey

@SET FB_BIN="C:\Program Files (x86)\FireBird\bin"

@SET GBAK=%FB_BIN%\gbak.exe

@SET N3WORKPATH="C:\ProgramData\FF\NumberOk3"

@SET FB_DB=%N3WORKPATH%\NumberOk3.fdb

@SET FB_BAK=%N3WORKPATH%\NumberOk3.fbk

@SET GBAK_LOG=%N3WORKPATH%\RESTORE.LOG

@del /q %GBAK_LOG% > nul 2>&1

@%GBAK% -c %FB_BAK% %FB_DB% -nodbtriggers -v -y %GBAK_LOG%

This is an optional action as the Update process doesn’t affect those folders.

Consider cleaning up the database (NumberOk: Settings > General - Clear database) with the Remove screenshots box checked.
This will also remove outdated ANPR snapshots.

Go to the Snapshots-n-Reports folder and copy the folders to desired alternative storage.

NB! This section is applicable only to a computer that hosts both NumberOk installation and database storage.

Please, note that database structure update may take plenty of time, depending on database size. Consider cleaning up the database prior to the upgrade.

Launch the NumberOk installation file.

During installation please make sure the Install FireBird server and Update database structure options are checked.

The installation process will update NumberOk preserving the settings and updating the database structure-preserving the contents.

Upon completion, please, check NumberOk settings against stored notes or screenshots.
 You may need to re-establish connections with external devices (cameras, control modules, loops, sensors etc.)

This section is applicable only for the computers that use a database installed at a different server/workstation that is already successfully upgraded.

Uncheck Install FireBird server box and continue.

NumberOk supports expanding the system 

• by adding new  sources to one server (Max 36 channels for video sources/ 64 channels for meta sources)

• by adding new servers which will work with one common database server. All servers must be in one local network with a permanent guaranteed  internet connection

NumberOk supports virtual machine 

NumberOk supports up to 200 recognition channels or up to 10 servers, which work in one system (one common database).