Sitecore Connector

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.

Was this article helpful?