Before you begin

• Stop all Tealeaf services.
• Locate the Tealeaf Report server installation host and installation directory (TL_HOME). The default one is 'C:\Program Files (x86)\IBM\IBM Tealeaf CX\'.
• Access translation CSV files at <TL_HOME>\\Reporting\DatabaseSchema\For_Rs_Translation\
• Get Server details: Tealeaf Report server and SQL Server like Hostname and login credentials.
• Get TLADMIN user credentials to access the System database (Default database is TL_SYSTEM)
• Identify your distributed environment architecture. There are two possible scenarios for this task:
  • Report Server and SQL Server are on same host.
  • Report Server and SQL Server are on different hosts.

Report Server and SQL Server are on same host

1. Log in to the Report server/SQL server host.
2. Launch the SQL Server management studio using TLADMIN user.
3. Execute following procedure on Tealeaf System database (default name is TL_System) using following command, assuming Tealeaf home path is C:\Program Files (x86)\Acoustic\Acoustic Tealeaf CX.

   execute [dbo].[pr_Populate_Rstranslation_manual] @TLHomePath = 'C:\Program Files (x86)\Acoustic\Acoustic Tealeaf CX', @CustomPath = NULL

4. Perform an IIS reset and start all Tealeaf services.

Report Server and SQL Server are on different hosts

1. Log in to the SQL server host.
2. Create a folder on the SQL Server host, example C:\Tealeaf\TransSQL\
3. Log in to Tealeaf Reporting/Data collector server.
4. On the reporting server, access <TL_HOME>\Reporting\DatabaseSchema\For_Rs_Translation*.csv files. There are 11 files.
5. Copy these 11 CSV files on to the SQL server host custom folder as stated in step 2.
6. Execute the following procedure on Tealeaf System database (default name is TL_System) using following command though SQL Server management studio.

   execute [dbo].[pr_Populate_Rstranslation_manual] @TLHomePath = NULL, @CustomPath = 'C:\Tealeaf\TransSQL\'

7. Perform an IIS reset and start all Tealeaf services.