Installation

How to Install QuickEasy BOSPrint

This topic covers the from scratch install of QuickEasy BOSPrint. This installation documentation only covers 64-bit and 32-bit system types. Installation for a Linux type server click here.

Contact QuickEasy Helpdesk before starting with installation for necessary files and scripts.

The QuickEasy BOS installation can be broken up in 5 key steps:

1. Create a Directory

This is where all the QuickEasy BOS data files will be stored during installation.

Create a QuickEasy or BOS folder in C Drive

Create a folder in your C drive (local or server) and call it QuickEasy or BOS.
Create the following sub-folders:
1. Data
2. DataBackup
3. Temp
4. Docs
5. Utilities

These folders will be populated by files created in the installation and files received from QuickEasy Helpdesk.

- You will populate the Data folder with .FDB files and DataBackup folder with .fbk files. Backup files will be provided by QuickEasy Helpdesk for initial installation.

2. Install Firebird

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

a. Download Firebird

Download Firebird 3.0 (64-bit) here.

If you have a 32-bit operating system type download the suitable Firebird here.

How to identify your system type:

Windows 7

Navigate to Start menu (bottom left on toolbar) > Computer > System Properties (top menu) > System type.

Windows 10

Navigate to Start menu > Settings (gear icon) > System > About (menu on the left) > System type.

b. Runs Firebird's Setup Wizard

Once the correct Firebird is downloaded run the application and follow the 11 steps in the Firebird setup wizard. See screenshots below :

1. Select language and click OK

2. Check the I accept the agreement and click Next.

3. Click Next.

4. Browse the correct installation folder if necessary and click Next.

5. For server install select Full installation. If the installation is for a user client select Minimum Client install. Click Next.

6. If you don't want a Start Menu folder Check the box or simply click Next.

7. Check the Generate client library as GDS32.DLL for legacy InterBase support box and click Next.

8. Enter the SYSDBA Password.

Set the Password to hjisthebest and click Next.

9. Click Install to begin installation. After you clicked on install, a window will appear with a loading bar to show the installation progress.

10. After installation is completed this window will appear and simply click Next.

11. You have completed the Firebird Wizard. Click Finish.

3. Installation with Tools

QuickEasyTools is a utility that can be used to setup and maintain your Firebird database.

The installation can be done with Tools or FlameRobin. This topic will cover how to do the install with Tools.

If you want to do installation with FlameRobin, click here.

Note

Using Tools is recommended.

Tools offer more functionality than FlameRobin because it is custom built for QuickEasy BOS. On Tools you will find additional BOS fixes, scripts and downloads that is not available in FlameRobin.

a. Download Tools

Follow the steps below to download Tools.

Click here to download Tools. Contact QuickEasy Helpdesk for assistance.
Extract Tools into the QuickEasy or BOS folder you created in the C drive.
Run Tools.

b. Register a Server on Tools

Follow these steps to Register a Server on Tools. See screenshots below:

1. Navigate to Server (in the top menu) and select Register Server.

2. Enter a server name if necessary, it can be a name, cloud or IP address. Click Register.

The newly created Server is now visible in Tools.

c. Register a Database on Tools

Follow these steps to Register a Database on Tools. See screenshots below:

1. Right-click on the server and select Register Database.

2. A Register Database window will open. Click on the Browse button.

3. Navigate to the Data file you created in the C drive. Enter a file name with .FDB at the end and click Open. If you have already registered a database in FlameRobin you simply select the desired .FDB file and click open.

4. The name fields will now be populated. Click Register to register the database.

The registered database is now visible in Tools.

d. Restore the database on Tools

Follow the steps below on how to restore a database in tools.

Contact QuickEasy Helpdesk for a blank database backup .fbk file.

1. Right-click on the database, navigate to Database Tools and select Restore.

2. A Restore window will appear. Click Browse.

3. Navigate to the DataBackup folder you created in the C drive. Select the .fbk that you received from QuickEasy Helpdesk and click Open.

4. The name field will now be populated. Click Restore.

5. Wait for Restore Completed notification and click Close.

NB

In step 4 above, you are able to check the Replace existing database check-box. This will replace the existing database.

This is used when your database has been corrupted and you want to restore your database with a backup .fbk (Database Backup file).

Do not check this box if you wish to keep your current .FDB (Database) unchanged.

e. Execute scripts into the database on Tools

The installation scripts will be provided by QuickEasy Helpdesk, paste the files into the Utilities folder you created in C drive.

Follow these steps to install installation scripts to the database on Tools. See screenshots below:

1. Right-click on the database and select Connect. The database will appear blue when connected.

2. Right-click on the connected database and select Execute SQL Statements.

3. A Execute SQL Statement window will appear.

4. Navigate to your Utilities folder in the C drive where you pasted all the install scripts provided by QuickEasy Helpdesk.

5. Simply drag and drop the first .sql file into the Execute SQL window and click on the Play icon (in the top menu) to execute.

6. The script will be executed. When the script execution is done, close the window.

7. Right-click on the database and select Disconnect.

8. Right-click on the database and select Connect.

9. Again right-click on the database and select Execute SQL Statements.

10. Drag and drop the next script into the Execute SQL window and execute.

11. When the script execution is done, close the window and disconnect the database. Reconnect the database and execute the next install script. Basically repeating step 1 to 7 over and over until all installation scripts has been executed.

We recommend disconnecting between executions as a precaution.
It is of extreme importance to execute the scripts in numerical order and to only execute one script at a time.

When you are finished with all executions, Disconnect the database.

Contact QuicEasy Helpdesk for any assistance and for required scripts.

Here is a short video demonstrating the install script execution process:

f. Create a Database Backup on Tools

Follow the steps on how to create a database backup on Tools.

1. Right-click on the connected database, navigate down to Database Tools and select Backup.

2. Click on the browse button.

3. Navigate to the DataBackup folder you created in the C drive. Here you will see the previous .fbk file you used to restore the database. Enter a new File name with .fbk at the end and Click Open.

4. The name field will now be populated. Click Backup to backup your current database.

5. Once the database backup is finished, close the Backup database window.

If you navigate to your DataBackup folder in the C drive you will see the newly created database backup in the list.

4. Create a QEDB File

The QEDB file is basically a path to your database. Follow the steps below to create your QEDB file.

Create a new text document with Notepad in the QuickEasy or BOS folder you created in the C drive.
Name the document QEDB .ini
Enter the database name between [] and press enter.
- Example: [CCDEMO] or [My Company]
Enter DBCommon= and the database location next to it. See screenshot below for example.
- Example: DBCommon=localhost:C:\BOS\Data\CCDEMO_2017.FDB

This is case sensitive.

You can find the database location at the bottom of tools. See image below:

5. When finished, click Save and close the text document.

5. Executable

If you used FlameRobin to this point you will need to install QuickEasy Tools now. See step 3.

Download BOSPrint_Exe on Tools

Download the BOSPrint_Exe file that corresponds with the same version of scripts you executed in Tools.

In this example we used BOSPrint 2017.03 Install scripts, so we need BOSPrint_Exe_2017_03.

Follow the steps below to download the .exe file:

1. Navigate to Utilities (in the top menu) and select QuickEasy Downloads.

2. A Downloads window will appear. Select the correct .exe file and click Download.

3. Navigate to where you want the file to be downloaded and click Save.

4. A notification will appear if the download is complete. Click OK, and close the Download window.

5. Extract the file into the QuickEasy or BOS folder you created in the C drive.

- It is of extreme importance that the .exe file is in the same folder as the QEDB.ini file.

6. Run the QuickEasy Application. Installation is completed.

7. Navigate to Setup > Settings & Defaults > Settings > click the Update button > Yes to update the settings within the application.

8. Create a shortcut to the BOS executable - C Drive > QuickEasy or BOS folder > QuickEasy exe > right-click > Create shortcut

Installation with FlameRobin

FlameRobin is a database administration tool for Firebird. The setup below is similar to the Tools setup.

If installation is done with FlameRobin, Tools must be used for .exe downloads, fixes and updates. That will require you to register a server; and the database you registered in FlameRobin again in Tools to run scripts.

a. Download and Extract FlameRobin

Download FlameRobin-0.9.2-1-setup-x64.exe here.
- Again make sure of your system type, (64-bit, 32-bit). For other system types download the correct FlameRobin.exe here.
Extract the FlameRobin files into the Utilities folder you created in the C drive.
Open the FlameRobin Application.

b. Register a Server on FlameRobin

Follow these steps to Register a Server on FlameRobin. See screenshots below:

1. Navigate to Server > Register Server or right-click on Home and select Register Server.

2. Enter a Display name and Hostname, in this case localhost. Enter the Port number provided by the QuickEasy Helpdesk. Click Register.

c. Restore a backup into new database on FlameRobin

Follow these steps to Restore a database on FlameRobin. See screenshots below:

1. Right click on the server and select Restore backup into new database.

2. Click on the Browse icon next to Database path.

3. Navigate to the Data folder you created in the C drive and enter a new File name with .FDB at the end and click Open. Name fields will automatically populate.

4. Enter the Username and Password provided by QuickEasy Helpdesk. Click Save.

5. Click on the Browse icon next to Backup file and and navigate to the DataBackup folder you created in C drive; and select a .fbk file you received from QuickEasy Helpdesk. Click Open.

6. The Backup file field will now be populated with a .fbk file. Click Start Restore.

7. Wait until the Database restore is finished. Any errors will be displayed in red, contact QuickEasy Helpdesk for assistance in the event of an error. Close the Restore Database window.

d. Execute scripts into the database on FlameRobin

The installation scripts will be provided by QuickEasy Helpdesk, paste the files into the Utilities folder you created in C drive.

Follow these steps to install installation scripts to the database on FlameRobin. See screenshots below:

1. Right-click on the database and select Connect.

2. Again right-click on the database and select Run a query.

3. An Execute SQL statements window will appear.

4. Navigate to your Utilities folder in the C drive where you pasted all the install scripts provided by QuickEasy Helpdesk.

5. Simply drag and drop the first .sql file into the Execute SQL window and click on the Play icon (in the top menu) to execute.

6. The script will be executed. When the script execution is done, close the window.

7. Right-click on the database and select Disconnect.

8. Right-click on the database and select Connect.

9. Again right-click on the database and select Run a query.

10. Drag and drop the next script into the Execute SQL window and execute.

11. When the script execution is done, close the window and disconnect the database again. Reconnect the database and execute the next install script. Basically repeating step 1 to 7 over and over until all installation scripts has been executed.

We recommend disconnecting between executions as a precaution.
It is of extreme importance to execute the scripts in numerical order and to only execute one script at a time.

When you are finished with all executions, Disconnect the database.

Contact QuicEasy Helpdesk for any assistance and for required scripts.

e. Create a Database Backup on FlameRobin

Follow the steps below to create a backup of your database.

1. Right-click on the database, navigate down to Actions and select Backup database.

2. Click on the browse icon next to Backup file.

3. Navigate to the Backup folder you created in the C drive. Here you will see the previous .fbk file you used to restore the database. Enter a new File name and Click Save.

4. Click Start Backup to backup your current database.

5. Once the database backup is finished, close the Backup database window.

If you navigate to your Backup folder in the C drive you will see the newly created backup in the list.

Backups are used to restore databases.

In the event that you need to restore a database you will do the following:

Right-click on the database you want to restore, navigate to Actions and select Restore database.
Click on the browse icon.
Select the desired backup .fbk file and click Open.
Click Start Restore.
When Restore is finished close the Restore Database window.

You are done with FlameRobin; return to step 4 in the installation documentation to continue and finish the installation.

Google Sites

Report abuse