Focus Advanced Publishing software ™

The complete accounting and management software solution for managing a publishing or book distribution business

Version: 8.33
Date Published: 16/01/2020
Requires Microsoft SQL 2008 or Later

• Download and Install FAP
  1. Click the Download button to save the zipped installer to disk.
  2. Expand the downloaded ZIP file and double‐click on ‘FAP_ Setup.msi’ to open the Focus Advanced Publishing installer.
  3. Then follow the instructions.
• Activate FAP with Licence
  1. On the Start Page select the Licence tab
  2. Click Activate Licence
  3. Tick the “I already have a shared activation file in the Folder” box and navigate to the folder containing the activation file, e.g. ‘P:\Publishing\FAP’.
  4. Click Next to display your activation code
  5. Click Next, then click Activate Licence to activate
• Install and configure SQL Server
  Download and install a version of the SQL Server of your choice from SQL Server Downloads
• Connect to your SQL database
  1. On the Start Page select the Configuration tab
  2. In the Server Name box enter the server name e.g. ‘focus\SQLExpress’
  3. In the Database Name box enter ‘FOP_Data’
  4. In the Authentication box select ‘SQL Server Authentication’
  5. Enter ‘sa’ in the User Name box and leave the Password box blank.
• Map network drive P:
  The network drive enables users share commone cdocuments and layouts required by the system.

  1. Open windows explorer
  2. Expand ‘Network > SERVER’
  3. Right-click on FOP and select ‘Map network drive…’
  4. In the Drive box select P:
  5. Click ‘Finish’
• Install latest .Net Framework (4.7.2)
  1. Open windows explorer
  2. Expand ‘P:\Installers’
  3. Double-click on ‘dotNetFx40_Full_x86_x64.exe’
  4. Follow the instructions.
• Install Crystal Report Redistributables
  1. Open windows explorer
  2. Expand ‘P:\Installers’
  3. For 64-bit machines run the following files in the order suggested
     • CRRedist2005_X64.msi
     • CRRedist2008_X64.msi
  4. For 32-bit machines run the following files in the order suggested
     • CRRedist2005_X86.msi
     • CRRedist2008_X86.msi
  5. Follow the instructions.
• Setup ODBC Setup Data source name
  1. On Windows Start menu select Control Panel > Administrative Tools > Data Sources (ODBC)
  2. On the ‘User DSN’ tab click Add.
  3. Scroll down the list to select SQL Server, and click Finish.
  4. Type NAME in the Name box.
  5. In the Server box enter the location of your SQL Server ‘SERVER\SQL’.
  6. Click Next.
  7. Set SQL authentication
  8. Login ID: ‘sa’
  9. Password: [BLANK]
  10. Click the Next button.
  11. Tick the Change the default database to: box and select FOP_Data from the dropdown list.
  12. Click Next then Finish.
  13. Click Test Data Source.
  14. Click OK to finish.
  15. On the System DSN tab click Add and repeat steps iii to xiv.

Focus Support is always available to help with your questions. Send an email to support@focusservices.co.uk

On the Start menu select All Programs > Focus Advanced Publishing or double‐click the FAP icon on your desktop

Click OK to activate your licence.

Select the Login tab

Enter the following

• User Name:
• Password:

Tick the Save All Settings box

Click Sign In

Enter your user name and password and click the‘Sign In’ button.