19 Migration

You can migrate an Excel workbook integrated with a REST service using version 1.x of the Oracle Visual Builder Add-in for Excel to use the current version of the add-in. Once you migrate an Excel workbook to the current version, you can no longer use it with version 1.x.

During migration of a 1.x workbook, if you fail to log in to the REST service, migration fails. Close the workbook without saving changes and try again later.

Before you install the current release of the add-in:

• Upload any pending changes from the Excel workbooks that use version 1.x of the add-in
• Click Clear in the Oracle Visual Builder tab for all layouts in the Excel workbook before you migrate
• Before you migrate an Excel workbook, make sure you are prepared to log in to the server configured in the Excel workbook
• If you need to change the service host (the server name that the REST service uses), be sure to do so with version 1.x of the add-in. You cannot change the service host during migration using version 2.0 or later of the add-in

After you install version 2.x of the add-in, clear all layouts before using them with the latest version.

Note:

The add-in's latest version continues to support the migration of 1.x workbooks to the 2.x format. Future versions may no longer let you migrate 1.x workbooks.