Upgrading FocusOPEN 3.4.4.x to 3.4.5.x


The upgrade from FocusOPEN 3.4.4.x to 3.4.5 should not be deployed to a production instance without testing it first on a development server (and making full backups).

Windows system administration and SQL Server knowledge are required. If you do not have these skills, you are advised to request priority support assistance from the My Account area. You must have a Commercial licence to be able to access our support plans, alternatively, use the forum to request assistance from the FocusOPEN community.

Note 1: This upgrade procedure is for 3.4.4.x users only, do not attempt a direct upgrade from an older version to 3.4.5.

To check your current version, enable engineer user mode for your account and view the utilities/settings page in the admin area. The FocusOPEN version will be at the bottom of the page.

Backups & Preparation

Backup your FocusOPEN installation.

You are advised to use the sandbox deployment guide to make a backup of your current FocusOPEN installation (with all assets and users), upgrade that and then take your old 3.4.4 edition off-line and re-point the domain to the new 3.4.5 deployment.

A backup of the whole FocusOPEN application folder is recommended with at least the webroot being the minimum. It is especially important you make a copy of your configuration settings and original database.


Open the upgrade.cmd batch file and check the connection parameters to your FocusOPEN database and then run the upgrade.cmd script. You need to change three different areas:


Swap (LOCAL) for the instance of your local SQL Server.

echo osql -n -E -d FocusOPEN -S %FocusOPENDB_SQLSERVER% -i "345_updates.sql"
osql -n -E -d FocusOPEN -S %FocusOPENDB_SQLSERVER% -i "345_updates.sql"

Swap 'FocusOPEN' for the name of the FocusOPEN database.

If you installed FocusOPEN previously without changing the database name you may only need to change the database connection instance (at the top of the script).

Using SSMS To Upgrade The Database

Alternatively, you can use SQL Server Management Studio to execute the “345_updates.sql” updater script in the the DatabaseSetup\UpgradeScripts folder of the deployment package. The database schema and data is unchanged from to

Upgrade Application Webroot and Change Config Settings

  1. Make a backup copy of your App_Data folder
  2. Make a backup copy of your AuthPlugins folder
  3. Make a backup copy of your Config folder
  4. Make a backup of your web.config file
  5. Make a backup copy of your Brands folder
  6. Copy the webroot folder from the deployment package over the top of your existing webroot to replace and update your files.
  7. Delete the App_Data and Brands folders
  8. Move the Config, AuthPlugins and web.config folders/files over to a location away from the Webroot - you will need these later
  9. Copy your Config folder back to to the webroot to replace the one from the deployment package.
  10. Copy your Brands folder back to to the webroot to replace the one from the deployment package.
  11. Copy your web.config file back and make the changes described below.

Add the following keys if not already present ( users may have some of these already)

<add key="CheckAllUserGroupsForMetadataAccess" value="false"/>
<add key="NumericSearchTermsMatchAssetIDsOnly" value="false"/>
<add key="UseFreetext" value="false"/>
<add key="FilterSearchPunctuation" value="false"/>
<add key="ApprovedSearchCharacters" value="-:," />
<add key="FilterAdminSearchForAssetUploaders" value="false"/>
<add key="BrandTerm" value="Brand"/>
<add key="BrandTermPlural" value="Brands"/>
<add key="AllowPreviewsForContactSheets" value="true"/>
<add key="LinkLightboxTerm" value="Link"/>
<add key="ShowGeoLocLink" value="false"/>
<add key="AdminAssetIdsTextboxFilter" value="true"/>
<add key="AlphanumericallySortCategoriesByDefault" value="true"/>
<add key="EditableDuration" value="false"/>
<add key="ContactSheetSendingMinimumRole" value="5"/>
<add key="EnableRoleIDToViewEditAssetsOutsidePrimaryGroup" value=""/>
<add key="GenericAssetTypeName" value="generic"/>
<add key="AutoSelectedPrimaryGroup" value="0"/>

The following key has been added to the controls section of web.config

<add tagPrefix="app" src="~/Controls/Admin/UserListControl.ascx" tagName="UserListControl" />

You are recommended to use a diff or file comparison tool such as Beyond Compare to verify that you have incorporated all the revised settings

You can normally use the web.config file from the deployment package and copy it over the top of your old one - although you may lose any settings modifications you have made. Consult the deployment guide for a full explanation of the new settings.


The AdminNavigation.config file hass been updated with new features to allow the batch modification of users and some other adjustments. Unless you have changed this on an existing installation, you can usually copy the files wholesale from the deployment package over the top.

Finishing Up and Testing

Once you have completed the upgrade procedure, you are recommended to restart IIS and ensure basic functions still work like logging in, uploading and cataloguing.

If you have difficulties with the upgrade, try a fresh deployment of and see if that is successful.

upgrading-focusopen-3.4.4-to- · Last modified: 2013/07/28 16:17 by admin