/
Framework Installation : Framework MyNewHome

Framework Installation : Framework MyNewHome

The following guide is designed to install Framework MyNewHome on the system.

Article Index

Pre-Requisite Checklist

Step 1 - Restore Database

Restores the Microsoft SQL Server MyNewHome database.

Restore Database - Framework MyNewHome

  1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).

  2. Connect to the required server.

  3. Right-click on Databases and click Restore Database.... The Restore Database dialog will be displayed.

  4. In the To Database field, enter the Framework Database Name (e.g. FworkSQLMNH)

  5. In the From Device field, click the Browse button. The Specify Backup dialog will be displayed.

  6. Click the Add button. The Locate Backup File dialog will be displayed.

  7. Select the folder and file location of the Microsoft SQL Server backup file.

    1. Typical Folder: \[fw folder]\Service\01 - Default Data\

    2. Typical File: FworkSQLMNHXX.bak

  8. Click the OK button. The Locate Backup File dialog will close.

  9. Click the OK button. The Specify Backup dialog will close.

  10. In the Restore column, tick the backup to be restored.

  11. Select the Options tab.

  12. In the Restore the database file as list, click the Browse button for the Framework MyNewHome database (i.e., FworkSQLMNH). The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.

  13. Select the folder location where the database will be restored to e.g. [fw folder]\Data\DataMSSQL\.

  14. In the File Name field, enter the file name: FworkSQLMNH.mdf

  15. Click the OK button.

  16. In the Restore the database file as list, click the Browse button for the Framework MyNewHome database log (i.e., FworkSQLMNH_log). The Locate Database Files dialog will be displayed.
    OR
    Use the default file location.

  17. Select the folder location where the database will be restored to e.g. \[fw folder]\Data\DataMSSQL\.

  18. In the File Name field, enter the file name: FworkSQLMNH_log.ldf

  19. Click the OK button.

  20. Click the OK button. The database restoration will be performed.

  21. Close Microsoft SQL Server Management Studio.

Step 2 - ODBC DSN Configuration

Restores the MyNewHome Microsoft SQL Server 2008 database.

Microsoft 64-Bit Operating Systems include two ODBC Data Source Administrator executable files.

Depending on the operating system, use the following to open the correct ODBC Data Source:

On 32-Bit Operating Systems: Use either:
Start Menu > Control Panel > Administrative Tools > Data Sources (ODBC)
OR
\\%SystemRoot%\system32\odbcad32.exe (e.g., C:\Windows\system32\odbcad32.exe).

On 64-Bit Operating System: Use:
\\%SystemRoot%\SysWOW64\odbcad32.exe (e.g., C:\Windows\SysWOW64\odbcad32.exe).

ODBC DSN Configuration - Framework MyNewHome

  1. Open Data Sources (ODBC).

  2. Select the System DSN

  3. Click the Add The Create New Data Source dialog will be displayed.

  4. Select SQL Native Client 10.0.

  5. Click the Finish The Create a New Data Source to SQL Server dialog will be displayed.

  6. Enter the following details:

    • Name: FworkSQLMNH

    • Description (optional): Enter a description for the database connection. For example, Framework MyNewHome.

    • Server: Select the SQL Server from the Server drop-down list.
      OR
      Enter the SQL Server name.

      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS

       

  7. Click the Next

  8. Click the Next

  9. Tick Change the default database to.

  10. From the drop-down list select: FworkSQLMNH

  11. Click the Next

  12. Click the Finish The ODBC Microsoft SQL Server Setup dialog will be displayed.

  13. Click the Test Data Source...

  14. If successful, click the OK

  15. Click the OK The ODBC Microsoft SQL Server Setup dialog will close.

  16. Click the OK The Data Sources (ODBC) dialog will close.

Step 3 - Install Framework MyNewHome

On all systems required to run Framework MyNewHome:

  1. Open Windows Explorer.

  2. Browse to: \[fw folder]\Setup\Framework MyNewHome\vx.x.x\Setup\ (where x.x.x refers to the latest version of Framework MyNewHome).

  3. Double-click Framework MyNewHome.msi. The Welcome step will be displayed.

  4. Click Next . The Licence Agreement step will be displayed.

  5. Select I accept the terms in the licence agreement.

  6. Click Next. The Customer Information step will be displayed.

  7. Enter User Name and Organisation

  8. Select Anyone who uses this computer (all users).

  9. Click Next. The Setup Type step will be displayed.

  10. Select Complete.

  11. Click Next. The Ready To Install the Program step will be displayed.

  12. Click Install to begin the installation.

  13. Click Finish to complete the installation.

Step 4 - Test Framework MyNewHome

  1. Start Framework MyNewHome (Start > All Programs > Insula Software > Framework MyNewHome).

  2. Log on to the system.

Step 5 - User Acceptance Tests


The following is a list of view only tests that should be performed after upgrading the application.

These tests should only be performed after the first installation of Framework MyNewHome.



Screen / View

Menu Path

Completed

Screen / View

Menu Path

Completed

Start Framework MyNewHome





Log in as a user other than a super-user





View all screens via menu bar





View all screens via sidebar