Content Comparison

This describes how to install Beebox-Sitecore Connector on Sitecore Experience Platform 7.0+. Please unzip the packages from Beebox Sitecore Connector Version 7.x rev(xxxxxx) before you perform the following steps.

Getting Started

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– 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 to your Wordbee sales contact to obtain the Beebox Sitecore Connector package. Beebox-Sitecore Connector supports Sitecore XP 7.0, 7.1, 7.2 and 7.5.

Creating the Translation DB

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

You will need the following scripts to complete the process.

• Create 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.
• 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 installation of optional package.

Setting the SQL connection string

The Beebox-Sitecore Connector will make use of the “Beebox_Sitecore_Translation” database and we need to setup 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=&quot;

data source=SQL Server Instance Name;

initial catalog=Beebox_Sitecore_Translation;

user id=Username;

password=password;

MultipleActiveResultSets=True;

App=EntityFramework&quot;"

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>

  <!--

      Sitecore connection strings.

      All database connections for Sitecore are configured here.

  -->

  <addname="core"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=XXXXXXXSitecore_Core"/>

  <addname="master"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=Beebox71Sitecore_Master"/>

  <addname="web"connectionString="user id=XX;password=XXXX;Data Source=XXXXX;Database=Beebox71Sitecore_Web"/>

        

  <addname="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=&quot;

         data source=SQL Server Instance Name;

         initial catalog=Beebox_Sitecore_Translation;

         user id=username;

         password=password;

         MultipleActiveResultSets=True;

         App=EntityFramework&quot;"

         providerName="System.Data.EntityClient" />

  </connectionStrings>

• Modify the highlighted values suitably: You will need to provide the name of SQL Server instance where we created 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: Login as admin to Sitecore Desktop and click Sitecore Start button.

Image Added