Sitecore Connector Upgrading to Version 1.13.x

In version 1.13.0 of the Sitecore Connector, we made some key changes. To upgrade from an earlier version, you'll need to follow these steps:

1. Update your database schema for version 1.13.0. Connect to your database via your preferred tool and run the following script:

   DROP INDEX IF EXISTS [TranslationQueue_FileUri_TargetLanguage_idx] ON [TranslationQueue]
   GO
   CREATE NONCLUSTERED INDEX [TranslationQueue_FileUri_TargetLanguage_idx] ON [TranslationQueue]
   (
   	[FileUri],
   	[TargetLanguage]
   )
   GO
   
   DROP INDEX IF EXISTS [TranslationQueue_ItemId_SourceLanguage_idx] ON [TranslationQueue]
   GO
   CREATE NONCLUSTERED INDEX [TranslationQueue_ItemId_SourceLanguage_idx] ON [TranslationQueue]
   (
   	[ItemId],
   	[SourceLanguage]
   )
   GO
   
   DROP INDEX IF EXISTS [TranslationQueue_Status_idx] ON [TranslationQueue]
   GO
   CREATE NONCLUSTERED INDEX [TranslationQueue_Status_idx] ON [TranslationQueue]
   (
   	[Status]
   )
   GO

   Note: If you don't know your database endpoint, you can find it in your Sitecore configuration at /App_Config/ConnectionStrings.config. The database endpoint is in the SitecoreLocalization entry.

2. Install 3 packages:

   • Smartling.Connector.ver.1.13.0.0.zip - Skip all items when installer prompts you. In this case, you'll preserve your Smartling configuration.
   • Smartling.Connector.Remote.ver.1.13.0.0.zip - Restore value of Server URL property in /sitecore/system/Modules/Smartling Connector/Context right after installation.
   • Smartling.Connector.LinkFieldTranslator.ver.1.13.0.0.zip

The Sitecore connector should be ready to continue translation.