Though most forms created on v4 will continue to run without any manual action on your part when upgraded to v5, there are a few migration items that you need to consider. Please read and understand the Planning for v5 which may require your action.
Using version 4.1.7 or later and you want to upgrade to version 5 to take advantage of all the new features? A new menu import item on the Manage Server page is available to help with your upgrade.
The Import /frevvo/data feature is available to the superuser admin only and supports import from the following frevvo GA releases:
- 4.1.7 and later
On This Page:
Migrating from HSQLDB
does not support the use of HSQLDB for use beyond demo/trials of the Live Forms software. If by mistake you continued to use the demo/trial HSQLDB database for production use, you will need to first migrate your data to one of
supported production databases BEFORE you can use the automated migration scripts to upgrade to the latest version of Live Forms.
Upgrading from v4.x - 4.1.6
You will need to upgrade to version 4.1.7 or later before migrating to version 5. Refer to Upgrading Your In House Server to v4.1.7 or later. for the details. When the upgrade to v4.1.7 or later is complete, return to this page and continue with the Upgrading from v4.1.7+ section below:
Upgrading from v4.1.7+
Please read the following upgrade steps prior to starting the migration.
Migration from v4.1.7+ to v5.1.1 is not supported for the Oracle database. Please contact frevvo customer support for details and help.
- Please read and understand the Migration Considerations which may require your action before beginning.
- Backup the v4 server's forms and users databases
- Backup the v4 server's installation directory so that you have a copy of all custom configuration parameters and the v4 server's data folder.
- Stop the v4 server using stop-frevvo.[bat,sh] or through the Computer Management Services console if
is running as a window's service. It is very important that the v4 server is stopped, otherwise the v5 server may not correctly migrate all existing tenant users.
- Download a fresh v5
- Download the latest v5 software.
- Request a v5 license key by emailing support@frevvo.com. Your v4 license key will not work with version 5 of
- The download is a zip file. Extract the contents to any folder of your choice. This folder will be refered to as <frevvo-home> (note that the zip already contains a top level frevvo folder).
- Migrate existing 4.1.7 forms & users databases using the upgrade scripts provided in <frevvo-home>/data/sql. You must execute these SQL scripts to perform a few required database schema updates.
- Navigate to <frevvo-home>/data/sql.
- The scripts are named by database and by release number of the Live Forms version that you are upgrading from. For example, if your
- forms-mysql5-upgrade-417.sql
- users-mysql5-upgrade-417.sql
Consult your DBA or your database specific documentation on how to run these scripts.
If you are upgrading from v4.1.8, v4.1.9, v4.1.10 or v4.1.11, run the v4.1.7 scripts for Step 6.
7. Configure the new installation
- If you made changes to the following files in your v4.1.7 installation, you will need to make the same changes in the v5.1.1 configuration files.
- <frevvo-home>/tomcat/conf/server.xml
- <frevvo-home>/tomcat/conf/Catalina/localhost/frevvo.xml
- We recommend that any changes that were made to the web.xml file be moved to frevvo.xml instead.
- The three files mentioned above include:
Refer to Installation Tasks for more information.
8. Start v5.1 server. Enter the new v5.1 license key obtained in Step 5b .
9. Login as admin superuser
Do NOT login as any user in any tenant other than default before the import: it will create a .user file in the db and will make the import skip that user.
10. Click Import 4.1.7+ /data folder.
11, Enter the path to the v4.1.7 <frevvo-home>/data folder that you want to import into this installation.
checks the .user version and stops the import if the version is not 4.1.7+. Here is an example of the error message if the version you are migrating from is v4.1.4 : "Unsupported migration version: found 4.1.4, but expecting version 4.1.7 or later".
12. Click Import.
All tenants and users in the users database should now be imported into the v5.1 database.
Things to Check:
- login as a tenant admin
- Click on the Configuration Checklist link to verify that all configurations are complete
- login as a tenant designer user
- view and edit a form/flow
- view submissions that existed before
- test forms/flows
Live Forms for Confluence
If you are running Live Forms for Confluence please follow the same instructions above to upgrade your server. Then you must also install the new version of the Live Forms Confluence Add-on into your Confluence server. The
server and the
confluence add-on versions must match.
Database Connector
If you are using the database connector, you must reinstall and configure it again for the v5 installation. Version 5 includes the latest database connector, version 2.3 beta.
Upgrading from v5.x
5.x versions of do not require the migration of the <frevvo-home>/data as all user data is already moved from the filesystem to the database.
Please read the following upgrade steps prior to starting the migration.
- Please read and understand the Migration Considerations which may require your action before beginning.
- Backup the v5 server's forms and users databases
- Backup the v5 server's installation directory so that you have a copy of all custom configuration parameters
- Stop the v5 server using stop-frevvo.[bat,sh] or through the Computer Management Services console if
- Install a fresh v5
- Download the latest v5 software. Note that you will need to provide your login credentials to download the software.
- Request a v5 license key.
- The download is a zip file. Extract the contents to any folder of your choice. This folder will be refered to as <frevvo-home> (note that the zip already contains a top level frevvo folder).
- Configure the new installation
- If you made changes to the following files in your v5 installation, you will need to make the same changes in the new v5 configuration files.
- <frevvo-home>/tomcat/conf/server.xml
- <frevvo-home>/tomcat/conf/Catalina/localhost/frevvo.xml
- We recommend that any changes that were made to the web.xml file be moved to frevvo.xml instead.
- The three files mentioned above include:
Refer to Installation Tasks for more information.
7. Start the v5 server. Enter the new v5 license key obtained in Step 5b.
Things to Check:
- login as a tenant admin
- Click on the Configuration Checklist link to verify that all configurations are complete
- login as a tenant designer user
- view and edit a form/flow
- view submissions that existed before
- test forms/flows
Live Forms for Confluence
If you are running Live Forms for Confluence please follow the same instructions above to upgrade your server. Then you must also install the new version of the Live Forms Confluence Add-on into your Confluence server. The
server and the
Confluence Add-on versions must match.
Database Connector
If you are using the database connector, you must reinstall and configure it again for the v5 installation. Version 5 includes the latest database connector, version 2.3.