This topic explains how you can use the install scripts to quickly setup QuickEasy BOS. For more on how to install QuickEasy, click here.

Startup Scripts

Startup Scripts are essential an must be executed when a new Database is created. Without the Startup scripts you will not be able to log-in to QuickEasy BOS.

The Startup scripts contains two (.sql) scripts and they have the following purpose:

1. Startup - This contains two scripts.

   1. Startup Script - This script does the following:

      • Creates the company record and sets the licensing information.

      • Creates the Admin user who has access to all the Modules.

      • Adds the default Transaction statuses and default Alerts.

      • Links default Templates.

      • Adds base currency for ZAR.

      • Inserts default units for Materials.

      • Adds two default Stock locations.

      • Adds Categories for Materials, Services, Customers, Suppliers, Accounts and Jobs.

      • Creates default Workflow modules.

      • Adds default Contact positions.

      • Adds default Production codes.

      • Adds a list of default Accounts and default Accounting Transaction Types.

      • Adds default Credit Terms.

      • POS - This script sets up the POS functionality.

        • Creates Accounts for Tips, POS shortfall, POS surplus, Casual wages.

        • Creates Transaction Types for Tips Received, Shortfall, Tips paid, Surplus.

        • Inserts denomination for local currency from R200 to 5c.

   2. Create Staff - This script is predominantly used for testing and populates the database with Reps and Production Staff records.

Setup Scripts

The Setup scripts will configure QuickEasy BOS with generic setups, automatically creating Customers/Suppliers and setting up Pre-Press, Finishing, Printing Types, Despatch and Production parameters.

The following Setup scripts are available:

2. Customers - This is to populate a demo database with pre-setup Customers content for testing purposes or sales demonstrations. This is not necessary if you are setting up a customer's BOSPrint.

3. Suppliers - This populates the database with a list of paper Suppliers by region.

4. Prepress - This script sets up the application with Pre-Press options: Artwork supplied, Copy and image supplied, Existing artwork, Design and Layout. This script also sets up the Production Stages for these Services.

5. Finishing - This script sets up the application with Finishing Services: Binding, Cylinder, Folding, Guillotine, Handwork, and Morgana.

6. Print Types - This script provides Printing Types (Litho, NCR and Digital), and includes the Presses, Setups, Sections, Ink groups, Run options and Production Stage for each Press per Print Type.

7. Despatch & Packaging - This populates the application with Despatch and Packaging options and contains multiple region selections for Despatch. This also creates some Packaging options: Shrink wrap, Boxed A4, Boxed A3, Wrap in brown paper and Boxed business cards.

10. Final - This script finalises the setup. This links all created Production Stages for each Production staff member. This is to be run after all the other scripts have been run.

Find what you need on QuickEasy Tools.

QuickEasy Tools provides everything you need for QuickEasy BOS. You are able to download files from Tools as well as update and maintain your Database.

Downloads

QuickEasy Tools provides a list of downloadable QuickEasy files.

• Executable files can be found in QuickEasy Downloads. See screenshots below:

Fixes and Upgrade Scripts

Fixes and scripts can be found in the Execute SQL Statement window.

• Fixes are used to fix and improve the current version of QuickEasy BOS.

• Scripts are used to upgrade to the next version of QuickEasy BOS.

See screenshots below on how to execute a fix or script on QuickEasy Tools.

If you want to execute more than one script make sure to disconnect and reconnect between execution as a precaution.