Sitecore Connector

Sitecore Connector Upgrading to Version 1.6.0

In version 1.6.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.6.0. Connect to your database via your preferred tool and run the following script:

EXEC sp_rename 'TranslationQueue.CreatedBy', 'SubmittedBy', 'COLUMN';
GO

ALTER TABLE TranslationQueue
   ADD Applied datetime NULL,
      Submitted datetime NULL,
      Locked bit NULL;
GO

UPDATE TranslationQueue
SET Submitted = Updated,
Locked = 0;
GO

ALTER TABLE TranslationQueue
   ALTER COLUMN Submitted datetime NOT NULL;
GO

ALTER TABLE TranslationQueue
   ALTER COLUMN Locked bit NOT NULL;
GO

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

2. Install 3 packages:

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

The Sitecore connector should be ready to continue translation.

Was this article helpful?