Sitecore Connector Upgrading to Version 1.6.x

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.