The Dannon Company

Dannon Sales Portal
–

Deployment Plan


Page
1

of
11







The Dannon Company

Dannon Sales Portal




Deployment Plan





Version 1.6

June 19, 2009




Prepared by

Fulcrum Logic Inc.,

636 Morris Turnpike

Short Hills, NJ
-

07078








Dannon Sales Portal
–

Deployment Plan


Page
2

of
11


Contents

1. INTRODUCTIO
N

................................
................................
................................
................................
....

3

1.1.

P
URPOSE OF THE
D
OCUMENT

................................
................................
................................
................

3

1.2.

S
COPE OF THE
D
OCUMENT

................................
................................
................................
....................

3

2. PRE
-
REQUISITES

................................
................................
................................
................................
..

3

3. DEPLOYMENT PLAN

................................
................................
................................
............................

3

4. SCHEDULE

................................
................................
................................
................................
..............

9

5. NOTES

................................
................................
................................
................................
.....................
10






Dannon Sales Portal
–

Deployment Plan


Page
3

of
11



1.

Introduction

1.1.

Purpose of the Document

The purpose of this document is to describe the plan for deployment of Dannon Sales Portal
application on production environment.

1.2.

Scope of the Document

Only deployment plan for Sales

Portal application is covered in this document. Installation plan for
production set up is provided in a separate document.

2.

Pre
-
requisites

The following pre
-
requisites are assumed to have been satisfied for the deployment to start:



Java 5

or later.




Liferay 5.2 on LINUX



Web Browser

A web browser such as Mozilla Firefox 2/3 or Internet Explorer 6/7



Tomcat 6 and Apache 2 for virtual hosting



MySQL5

MYSQL5 database should be setup runn
ing on 3306 port.

3.

Deployment Plan

The main steps involved in the production setup are segregated into five categories:


1.

Database Setup



Download rar files from
ftp.dannon.com

-

/DSP/Deployment/Database folder



Create S
ales Portal specific tables and import data to Sales Portal tables on
dspportal

schema.

o

Execute following .sql file in
dspportal

schema to create sales portal specific
tables. Make sure the liferay is started and run at least once before executing
this sc
ript. (
Note
: The create script considers the default tables of liferay are
existing under
lportal

schema)


“dsp
-
create
-
mysql.sql”

o

Execute the following .sql file in
lportal

schema to delete the old tables that
were created earlier. Skip this step, if you h
ave created the lportal schema and
ran only the “liferay52
-
default
-
tables
-
mysql.sql”.

“delete
-
old
-
tables.sql”






Dannon Sales Portal
–

Deployment Plan


Page
4

of
11


o

Execute following .sql file in
dspportal

schema to insert data into sales portal
specific tables

“migration
-
insert
-
data.sql”

O


Execute following

.sql file in dspportal schema to insert the folders and files
entries into the tables. This sql script will also change the system user to the
default user of already uploaded jackrabbit documents.


“update
-
data
-
migration
-
tables.sql”.



2.

Application Deployment (Linux Environment)



Document Setup

o

Download jackrabbit folder files from DSP/Deployment/Documents folder.

o

Run liferay.sfx.part01.exe, which will unzip .rar files into a single .exe
F
ile
named as liferay.exe.

It will prompt th
e user for a location where the files
needs to be extracted, select the desired output folder (ex: E:
\
DSP)

o

Once the process is completed a file named “liferay.exe” will be created under
the output folder specified previously.

o

Download 7
-
zip tool from
http://www.7
-
zip.org/download.html

7
-
zip is used to compress the files since it provided a better compression ratio

o

Install 7
-
zip

o

After installation is complete, run 7
-
zip File Manager

o

Navigate to liferay.ex
e and click 'Extract'

o

Select the folder where you would need files to be extracted

o

It will extract the files as needed. These files can be copied to desired location
on production

o

Copy the (jackrabbit) folder where documents are downloaded and paste it a
t
desired user home or any other location on Linux

o

Download portal
-
ext.properties from DSP/Deployment/War folder

o

Copy all the lines from the portal
-
ext to TOMCAT_HOME
\
webapps
\
ROOT
\
WEB
-
INF
\
classes
\
portal
-
ext.properties (Create portal
-
ext.properties if it d
oesn’t
exist). This file specifies the database location, file size limit and type for
uploading document and type of announcement type like shelf obsession,
Stonyfield type.

o

Open the file portal
-
ext. If the jackrabbit folder location needs to be set at
di
fferent location than set the property “jcr.jackrabbit.repository.root” to point
to the “liferay/jackrabbit” location or the location where documents are
copied.

o

Add the following line to the same file to change the file storage mechanism
“
dl.hook.impl=co
m.liferay.documentlibrary.util.JCRHook
”, this should be done
because the jackrabbit folder that we have currently was created using Liferay
5.1, In Liferay 5.2 the file storage type was modified. To make the current
liferay to use the File storage type as
that of 5.1 version, we need to add this
entry.






Dannon Sales Portal
–

Deployment Plan


Page
5

of
11


o

Add all the properties for MySQL in the list below,

jdbc.default.driverClassName=

jdbc.default.url=

jdbc.default.username=

jdbc.default.password=



Setup Context


o

In portal
-
ext.propeties present under WEB
-
INF/c
lasses of Liferay application
(considering the Liferay folder name is portal) add a new entry i.e.
portal.ctx=/portal



o

In web.xml present under WEB
-
INF of Liferay application add a new context
param named root_path and value /portal (i.e.)

<context
-
param
>

<param
-
name>root_path</param
-
name>

<param
-
value>/portal</param
-
value>

</context
-
param>

o

Create a new file named "portal.xml" under TOMCAT_HOME/conf/localhost
with the following content


<Context path="/portal" crossContext="true">


<!
--

JAAS
--
>



<Realm


className="org.apache.catalina.realm.JAASRealm"


appName="PortalRealm"


userClassNames="com.liferay.portal.kernel.security.jaas.PortalPrincipal"


roleClassNames="com.liferay.portal.kernel.security.jaas.P
ortalRole"


/>

</Context>




Deploy plug
-
ins

o

Download war files from DSP/Deployment/War folder

o

Delete the old plugins folders named dannon
-
custom
-
portlets, flash
-
portlet,
liferay
-
jefdi
-
theme under webapps folder. Skip this step, if plugins were never
de
ployed.

o

Copy plug
-
in war file to deploy folder of Liferay tomcat bundle.






Dannon Sales Portal
–

Deployment Plan


Page
6

of
11




dsp
-
flash
-
portlet.war for applying the spotlight.



dsp
-
0609
-
theme.war for applying the custom themes.



dsp
-
portlets.war, which consists of all the custom portlets like dsp
-
announcements
, dsp
-
calendar, dsp
-
journal contents, dsp
-
document
-
library.

o

Go to the TOMCAT_HOME/bin and click on startup.sh by executing cmd >> sh
startup.sh

o

Once all the portlets are deployed, the dsp
-
portlets needs to be customized for
the database configuration, Proc
eed to TOMCAT_HOME/webapps/Dannon
-
custom
-
porlets/WEB
-
INF/classes/portlet
-
config.properties and change the
default values to point to Sales Portal schema or change the file directly in the
war file by opening the dsp
-
portlet.war using zip tools and edit the

file /WEB
-
INF/classes/portlet
-
config.properties.

driverClassName=

url=

username=

password=

Once the database configurations are completed the tomcat server needs to be
restarted to so that the portlets are configured with the provided database
configurati
ons.



Organization Setup:

o

Download lar files from DSP/Deployment/Lar. These lar files contain retailsales
and AFH pages.

o

Login as admin

o

Navigate to the Control Panel from the User dock menu and click on
organizations.

o

Click the “add” button on Organization
portlet, enter the organization name as
“Dannon Retail Sales” and click on save button.

o

Repeat steps 3 and 4 for creating AFH organization with only change of name
as “Dannon Away From Home”

o


Click on the View all tab of the organization portlet

o

Click the
“Actions” button aligned with the Dannon Retail Sales organization in
the search list

o

Click on “Manage pages”

o

Click the Export/Import >> Import tab

o

Browse the .lar file and click on Import button.

Leave other settings as default.

o

Repeat steps 6 to 10 for
Dannon Away From Home.






Dannon Sales Portal
–

Deployment Plan


Page
7

of
11


o

Execute this step only after the organizations are created. Retrieve organization
id from database for Dannon Retail Sales and Dannon Away From Home.

o

Fill the template data of “#retailsalesorgid#” and “#afhorgid#” with the
correspond
ing organization ids in.

“update
-
data
-
migration
-
tables for Organization.sql”.

o

Execute “update
-
data
-
migration
-
tables for Organization.sql”.

Organization id can be obtained from Control Panel
-

Organization
–

Actions
-

Edit
-

Group Id




Setup Organization P
ages

o

Click on the View all tab of the organization portlet

o

Click the “Actions” button aligned with the Dannon Retail Sales organization in
the search list

o

Click on “Manage pages”

o

Click on Look and Feel menu. Select dsp
-
0609
-
theme to apply the custom
theme
changes.

o

Go to Retails sales page and perform the following step for performance
scorecard section.



Click on the configuration button



Click Add Web Content button



Enter the Name as: ‘Performance Scorecards’ (case sensitive)



Click on ‘save ‘and ‘approve’ b
utton

Note: The Performance Score Card section needs to be configured since
the article may get expired while we were importing it as a lar file. The
contents are dynamically retrieved from the document library, so we don’t
need any structure or template h
ere.

o

Download brand logos from DSP/Deployment/War/Brand_Product_System.zip
and unzip the file to extract images of brands.

o

Click on Admin tab and navigate to Image Gallery. If Brand_Product_System
folder is not existing then create the folder named as Bra
nd_Product_System.
Add the images inside these folders like
Activia, danactive, lightnfit,
dannon, danimals
and
stonyfield.

o

If an error occurs on archive portlet on brand secondary page follow the
following steps:



Click on the configuration button



Click Ad
d Web Content button



Enter the Name as: BRAND_PRODUCTS_Archives_Activia (case
sensitive)



Click on ‘save’ and ‘approve’ button







Dannon Sales Portal
–

Deployment Plan


Page
8

of
11




Search for BRAND_PRODUCTS_Archives_Activia



Click the link (BRAND_PRODUCTS_Archives_Activia), which appears
after the search.



Simi
larly, configure other 6 brands Archive section

Note: The archive section needs to be reconfigured because the contents
are dynamically fetched from different folders based on the different
brands.

o

For the Corporate Announcement, Click on configuration an
d change the path
to
,



Click on the configure button



Enter the title for the RSS feed to replace the title in the feed if
necessary



Enter the URL for the rss feed in the URL field.

http://rs
s.dannonculture.uswpl.danet/announcements



Repeat steps 1
-
3 for
http://rss.dannonculture.uswpl.danet/newsandpr



Select the option for
Show Feed Title and Show Feed Published Date



Select the no o
f entries to be shown per rss.



Click the save button

o

In AFH Announcements section, click on Configuration of the portlet from the
AFH Home page. Select the view as “Public Private” so that the AFH
announcement’s view is now reflected to the “Public Private
” view.


3.

User Setup



Create User Groups
–
Dannon Retail Sales Admin, Dannon Retail Sales Employee,
Dannon Away From Home Admin, Dannon Away From Home Employee, Stonyfield
Employee, Dannon Employee



Associate users with user groups


4.

Add Stonyfield User: This s
tep is to create users in Liferay.



Login as admin and navigate to Admin Tab



Click on Organization tab under Enterprise Admin Portlet



Click the “Actions” button aligned with the Stonyfield organization in the search list



Click on Add User, fill the details

and click on save button, click on the password link on
the right side of the portlet, fill the details and click on save button.



Go to ‘UserGroups’ tab and associate the user to the corresponding UserGroup by
clicking Action

Assign Members for the corres
ponding UserGroup







Dannon Sales Portal
–

Deployment Plan


Page
9

of
11


5.

Roles and Permissions



Create Organization Roles
-

Dannon Retail Sales Admin, Dannon Retail Sales Employee,
Dannon Away From Home Admin, Dannon Away From Home Employee, Stonyfield
Employee, Dannon Employee



Set Permissions on Roles by clic
king on Actions

Define Permissions


Add Portlet
Permissions, Click on the required Portlet to set the permission, Select the
corresponding permission for individual portlets and submit the changes. Details on this
is provided in a separate document ‘DSP D
efine Role Permissions.xls’



Associate users to organizational roles from Organization Admin portlet and clicking
Actions

Assign User Roles on corresponding Organization


6.

Setting Permissions on a Page



Navigate to user dock menu present next to the welcome m
essage



Select Manage pages



Select the desired page to set the permissions and click on Permissions button



Select the roles for which the page should be visible and click on Submit button



Refer to Pages column of ‘DSP Define Role Permissions.xls’ for detail
ed setup of
permissions on pages


7.

Flash Configuration



Click on configuration link of the Flash Portlet



Click on browse button to select flash file from the document library,



Click on save to apply the changes.


8.

Virtual Hosting Configuration



Refer to Apache

Virtual Hosting.doc for detailed setup


4.

Schedule

Anticipated schedule is depicted below:


Deployment

Start

Finish

Resource

Database Setup




Import data of Liferay default
tables

Fri 6/5/09

Fri 6/5/09

David

Execute script to create sales
portal specif
ic tables and
import data

Fri 6/5/09

Fri 6/5/09

David

Application Deployment




Application Deployment on
Mon 6/8/09

Mon 6/8/09

David






Dannon Sales Portal
–

Deployment Plan


Page
10

of
11


testing environment

Configure application
-

Build
Pages, Import portlets

Tue 6/9/09

Tue 6/17/09

David

Application Depl
oyment &
Configuration on production
environment.

Wed 6/22/09

Wed 6/23/09

David

Configure application
-

Build
Pages, Import portlets

Wed 6/22/09

Wed 6/23/09

David

User Setup




User Set up (Dannon, Retail,
Stonyfield, AFH, External)
-

create user groups
and assign
members

Mon 6/18/09

Wed 6/22/09

David

Permissions




Create Roles


Wed 6/22/09

Wed 6/23/09

David

Set Permissions on Roles

Wed 6/22/09

Wed 6/23/09

David

Associate Roles and User
Groups

Wed 6/22/09

Wed 6/23/09

David

5.

Notes



Migration of documen
ts should be resumed on prod environment.



Content like links, spotlight, documents, images on pages in Sales Portal may need to be
configured



Development is done on windows



Using rar files on Linux

o

Download binary package from official rarlab site:

$ cd /
tmp

$ wget http://www.rarlab.com/rar/rarlinux
-
3.6.0.tar.gz

o

Untar file

$ tar
-
zxvf rarlinux
-
3.6.0.tar.gz

o

Both unrar and rar commands are located in rar sub
-
directory. Just go to rar
directory:

$ cd rar

$ ./unrar

o

Now copy rar and unrar to /bin directory:

# c
p rar unrar /bin

o

Task: To open rar (unpack) file in current directory type command:

$ unrar e file.rar

Please note that replace file.rar filename with your actual filename.






Dannon Sales Portal
–

Deployment Plan


Page
11

of
11


o

Task: List (l) file inside rar archive:

$ unrar l file.rar

o

Task: To extract (x) fil
es with full path type command:

$ unrar x file.rar