Installing the plugin

Wordbee can provide two types of installation packages. For old instances, it can be a zip package, and for new it can be updated package.

Beebox-Sitecore Connector is the name of the Sitecore module distributed as a .zip and contains Sitecore following packages.

Beebox Sitecore Connector Files– contains assemblies and UI artifacts
Beebox Sitecore Connector Items– contains Sitecore item definition for various settings for core & master database
Beebox Sitecore Connector Optional Entity Framework DLLs– (this assembly is only related to the zip package) contains optional Entity framework assemblies to run Beebox-Sitecore Connector, only required to install if Entity framework assemblies are already not part of the Sitecore instance.

These components are installed together. Please connect Wordbee sales to obtain the Beebox Sitecore Connector package. Beebox-Sitecore Connector supports Sitecore XP 7.x, 8.x, 9.x and 10.x.

Creating the Translation DB

We need to create a translation database required by Beebox-Sitecore Connector having two tables as described below.

You will need the following scripts to complete the process.

Create a Translation Table
Create Jobs Table

Launch SQL Server instance with admin credentials.

Create Database: Create a new database named “Beebox_Sitecore_Translation”.
Create Tables: With “Beebox_Sitecore_Translation”database selected run SQL scripts “Create Translation Table” and “Create Jobs Table”.

Installing the packages

Login to Sitecore as admin and: Launch Sitecore Installation Wizard, upload, and install the packages as described.

Install zip package

Mandatory: Beebox Sitecore Connector Items.zip & Beebox Sitecore Connector Files.zip

Upload and install Beebox Sitecore Connector Items.zip, followed by Beebox Sitecore Connector Files.zip. Restart the Sitecore client, once promoted to do so.

Optional:Beebox Sitecore Connector Optional Entity Framework DLLs

Only install optional package, if the solution already does not has a reference to Entity Framework. You should look into the bin folder of the solution for EntityFramework.dll

and EntityFramework.SqlServer.dll, if they are already present, skip the installation of an optional package.

Install updated package

The packages that you need to install are listed in the installation window below. The URL where Sitecore installation is available is: YourSitecoreDomain/sitecore/admin/UpdateInstallationWizard.aspx

Please upload 2 packages which you received from wordbee and install them.

In case the package gets conflict wit other your custom plugins please notify our support team support@wordbee.com

Setting the SQL connection string

The Beebox-Sitecore Connector will make use of the “Beebox_Sitecore_Translation” database and we need to set up the connection string appropriately so that it may access the database.

Inside the ………..\Website\App_Config\Include\Beebox folder, locate Beebox.Sitecore.config.
- Copy the sample connection string:as displayed provided at the bottom of the Beebox.Sitecore.config or copy from the below sample.

<add name="Beebox_Sitecore_TranslationEntities"

connectionString="metadata=res://*/Beebox_Sitecore_Translation.csdl|

res:///Beebox_Sitecore_Translation.ssdl|res:///Beebox_Sitecore_Translation.msl;

provider=System.Data.SqlClient;

provider connection string="

data source=SQL Server Instance Name;

initial catalog=Beebox_Sitecore_Translation;

user id=Username;

password=password;

MultipleActiveResultSets=True;

App=EntityFramework""

providerName="System.Data.EntityClient" />

Locate connectionStrings.config, usually placed at…./Website/App_Config/ConnectionStrings.config and paste the new connectionString at the bottom of existing connection strings as given below.
<connectionStrings>

<add name="core"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=XXXXXXXSitecore_Core"/>
<add name="master"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=Beebox71Sitecore_Master"/>
<add name="web"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=Beebox71Sitecore_Web"/>

<add name="Beebox_Sitecore_TranslationEntities"
connectionString="metadata=res://*/Beebox_Sitecore_Translation.csdl|res://*/Beebox_Sitecore_Translation.ssdl|res://*/Beebox_Sitecore_Translation.msl;
       provider=System.Data.SqlClient;
       provider connection string="
       data source=SQL Server Instance Name;
       initial catalog=Beebox_Sitecore_Translation;
       user id=username;
       password=password;
       MultipleActiveResultSets=True;
       App=EntityFramework""
       providerName="System.Data.EntityClient" />
</connectionStrings>
Modify the highlighted values suitably: You will need to provide the name of the SQL Server instance where we created the Beebox_Sitecore_Translation database and corresponding username and password.

Verify the installation of Beebox-Sitecore connector

Once the above steps are performed successfully, we will have a visual clue of success in the form of a few Beebox Applications, tabs on ribbons and context menu on items.

Beebox Applications: Log in as admin to Sitecore Desktop and click Sitecore Start button.

Beebox Tab: In your Content Editor ribbon, you should observer a new Tab called “Beebox” as given in the screenshot below.

Beebox Item Content Menu: Select any item from the content tree, right-click to find new Beebox Translate Item commands as given in the screenshot below

Inherit Beebox Field Translation Setting Template

IMPORTANT This step is required and skipping it will prevent items from being added to the Content Selector.

The Beebox Field Translation Settings template has fields to enable and disable translation of the fields or template, thus providing an opportunity for developers and administrators to configure what is translatable.

By default, all the non-Sitecore templates are translatable, Launch Sitecore Content Editor and navigate to templates node:

Beebox Field Translation Setting: You will observe a Beebox template folder, drill down to the template and notice the “Beebox Field Translation Setting” template.
Inherit into Template and Template Field template: Inherit the “Beebox Field Translation Setting” template into “Template” and “Template Field” as shown in the screenshot below.