VERSION(S):

E-Sales 2.1 

SITUATION IDENTIFIED IN:

E-Sales 2.1 SP5 - Dashboards


SITUATION DESCRIPTION:

Field name translations are not displayed in the Dashboards pages using bcbe for the connection with a baan system. 
Instead the default english fieldnames are used. Also in the manager pages the definition of the labels and translated fieldnames do not allow entry of translations 
for more than one language.

SOLUTION DESCRIPTION:

Translated fieldnames in the Dashboard pages are now handled correctly.
Also in the manager pages it is now possible to define labels for all installed languages.

The solution consists of the following files:

1 readme.txt: This solution description

2 dashboardlabels.txt: Please read this before using this solution !!

3 ASP Pages:

Salesorderlist.asp		copy this file to <root>\E-Dashboard\dashboards\Customer
Purchaseorderlist.asp		copy this file to <root>\E-Dashboard\dashboards\Employee
Customerlist.asp		copy this file to <root>\E-Dashboard\dashboards\Employee
Supplierlist.asp		copy this file to <root>\E-Dashboard\dashboards\Employee
Purchaserfqlist.asp		copy this file to <root>\E-Dashboard\dashboards\Employee
Customerview.asp		copy this file to <root>\E-Dashboard\dashboards\Employee
I18nfieldnames.asp		copy this file to <root>\E-Dashboard\manager
Maintainlabels.asp		copy this file to <root>\E-Dashboard\manager
LabelsDashboard.asp		copy this file to <root>\E-Dashboard\include

4 XSL Sheets:

genericview.xsl			copy this file to <root>\xsl
generic.xsl			copy this file to <root>\xsl

5 A java classes:

BCBEDataProvider.class			copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe
BCBEMetaDataProvider.class		copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe
BCBEMetaDataProvider$FieldInfo.class	copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe
BCBEConnectionWrapper.class		copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe
BCBEConnectionPool.class		copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe
BCBEBackend.class			copy this file to \winnt\java\classes\com\baan\e_enterprise\backend\bcbe

6   Primarykey.sql		This file has to be copied to the local disk where the database server is installed
				Run the query.
				(Login to the database server where EProcurement database is present
				Open Query Analyser (Start--->Programs--->Microsoft SQL Server 7.0 -->Query Analyser)
				Connect  to the database server
				Once connected, choose file option in the menu ---> Click open ----> Select the .sql file.
				Now press "F5" to execute the code.)
				

7   Sortfield.sql
				This file has to be copied to the local disk where the database server is installed
				Run the query.


8   BCBEBackend.dll		
				To Register this dll take the following steps:
				
				A. On the webserver, you have to stop the website and Microsoft Transaction Server    
				processes.
				To do this :
				Open a  command window (start-> run -> type: cmd -> ok)
				Within the command-window run the following commands:
				net stop iisadmin /y
				mtxstop   (run mtxstop 3 times, becauses that process is running more then one time on        
				the webserver).

				B. Now unregister the existing BCBEBackend.dll
				Open a commond window (see step A).
				Within this command window go to the folder Program files\baan\E-Enterprise2.0\components\EBackend
				Type : regsvr32 /u BCBEBackend.dll
				Now the BCBEBackend.dll will be unregistered. Now rename the BCBEBackend.dll to	BCBEBackend.bak

				C. Copy the attached BCBEBackend.dll to the own folder Program files\baan\E-Enterprise2.0\components\EBackend
								
				D. Register the attached dll's
				Open a commond window (see step A).
				Within this command window go to the folder Program files\baan\E-Enterprise2.0\components\EBackend
				Type : regsvr32 EBackend.dll
				
				E. Reboot de webserver


PATH TO SOLUTION:
ftp://ftp.support.baan.com/updates/E-Enterprise/E-Sales/2.1/Sol_After_SP5/2.1.5.115306/