SharePoint and JIRA/Confluence

I will not be providing the comparison between SharePoint and JIRA/Confluence.Rather I will list out the requirements that can be fulfilled by Both the Products for your company.Choosing of the particular product depends on your requirements.Both the products are standard and mature enough to be used in any small to large scale.

Functional Requirements

Issue Management

• Create issue related to a particular project , assign issue to other users, get email updates about the activities going on that issue.
• Generate report based on that issue.
• Maintain good history and activity log of the particular issue.

Document Management

• Create different types of document library like document, form, wiki, picture, report etc for storing ,accessing ,sharing and collaborating of the documents.
• Versioning of the document,check in and checkout of the documents, track changes in the document by email notifications which includes who made the changes,what changes were made and at what time.
• Enterprise level Search Tool
• Creation of wiki library for storing the documentation of the projects created as a wiki page with attachments and comments.
• Ownership of document and confidentiality and access to the document .

Project Management

• Provisions of adding risks, issues, deliverables associated with the particular project
• Provision for managing contacts, making announcement and post news related to the project.
• List tasks ,responsibilities,and events associated with the project.
• Posting of meeting minutes, attendees and agendas of the meeting.
• Project Portfolio Management
• Classify, evaluate, and appropriately prioritize project to allocate resources to the highest value opportunities
• Monitor progress in terms of actuals and forecasted on key dimensions such as cost, schedules, benefits, and risk and communicate status to all stakeholders
• Customization accordingly to meet the need of project portfolio management

Workflow and Business Process Management

• Creation of custom forms.
• Taking the custom forms in workflow for approval and submissions.
• Business users should be able to collaborate with developers in creating new processes, as well as the implementation and administration of those processes.
• Request Processes with feedback system as well as continuous monitoring of the flow
• Seamless integration with other business application used for Financials, Human Capital Management, Procurement and Logistics, Manufacturing, Sales and Service to utilize the power of both products .
• Integration with other BPM platforms like Human Resource Management, supply chain management.

Collaboration

• Creation of teams and work groups .assign, reassign, or remove access of the users to these teams and work groups
• Share documents for co-authoring.
• "Know what the other team members are doing"
• Coordinate planning, execution and follow-up on tasks
• Online collaboration for sharing information with third person
• Create Team Sites and My Sites
• Management of individual, team level and section level targets
• SLA management between team ,units ,sections ,vendors
• corporate level management of address book ,calendars etc
• Availability of information in email and mobile.
• Very High Level Infromation Updates for TOP management level, Closed Group planning among people from different departments
• Information sharing to TelaiSonera, partners etc

Social Networking

• Profiles of all the users in the company
• Rating, commenting, sharing, or liking / unliking of the posts, sharing of ideas by users, finding the answers.
• Blogs, Forums, Discussions,Polls for involving the users on specific topic or idea

Corporate Intranet

• Without any HTML or page design expertise, publish unlimited intranet and extranet portals with customized brand, look, layout & collaboration tools at department/section/unit levels.
• Navigation should be strategic for the intranet and branding and company culture should be taken in consideration.

Non Functional Requirements

Security

• Active Directory based.
• Many levels of authentication and hack-proof.
• Single Sign On must be provided for the other application that we integrate with sharepoint.

Office Integration

• All the office packages should be integrated .
• Access ,Excel and Visio applications should integrated and users can benefit from the server-side capabilities such as scalability, one centralized version of the document (rendered in a browser friendly format), access to multiple users and security control.
• Offline working with microsoft exchange, integration of microsoft project server,integration with microsoft communication server for company level instant messaging

Usability

• Single solution for most of the purposes.
• Easier navigation and look to follow with i.e easier interface to work with
• Faster performance
• Flexible enough to meet the organization need.

Reporting

• Easily author, display, manage, and locate report for Issues, Projects.
• Manage and display Dashboard pages and KPI's, report sharing and broadcasting
• Performance and review logging report.

Consultancy and Local Support

• Local Support available for implementation and customization
• Branding and Company Culture
• Matching with enterprise's brand look.

Risk Management

• Reasonable cost of ownership
• No difficulty in upgrades
• Good cross-functional processes and integration of other softwares for the purpose of HRM, SCM etc.
• Flexibility that doesn't limits business process change
• Easy handling
• Installation of plugins for extending the application and reasonable cost of the plugins

Web interface of servers in ubuntu

ebox platform is an open source distribution, intended to manage services in computer network

ebox offers a layer of abstraction and management, accessible through a simple web interface, and also a simplified development environment for new features or customization.

For installing ebox in ubuntu

sudo apt-get install ebox

python ide for ubuntu

There are many python ides available for coding python in ubuntu.They are eric,wingide,spe.

The ide that i prefer for ubuntu is geany.It is fast and lightweight ide and it is very easier to compile and execute python files in this ide.

for installing geany in ubuntu

sudo apt-get install geany.

Interface designer for gui programming in ubuntu

There are many interface designer available in ubuntu.They are wxwidgets,Qt,Glade.

Glade is the interface designer for GTK and gnome.

Glade is programming language independent, and does not produce code for events, but rather an XML file that is then used with an appropriate binding.

for installing glade interface designer in ubuntu

sudo apt-get install libgtk2.0-dev

sudo apt-get install glade-3

c/c++ ide for ubuntu

Geany is the fast and lightweight ide for ubuntu.

For installing Geany in ubuntu type in terminal

sudo apt-get install geany

My bookmarked websites

->Comparison of web application frameworks

http://en.wikipedia.org/wiki/Comparison_of_web_application_frameworks

http://www.web-hosting-top.com/web-hosting/directory.control-panels

->List of web application frameworks
http://en.wikipedia.org/wiki/List_of_Ajax_frameworks

->List of ajax frameworks

http://en.wikipedia.org/wiki/List_of_Ajax_frameworks

Building web applications with java

Building non-trivial web applications with Java is no trivial task.From a high-level, developers are faced with decisions about how they are going to construct user interfaces, where the business logic will reside, and how to persist application data.ach of these three layers has their own questions to be answered. What technologies should be implemented across each layer?How can the application be designed so that it is loosely coupled and flexible to change? Does the architecture allow layers to be replaced without affecting other layers? How will the application handle container level services such as transactions?
Fortunately, there have been developers that have run into these reoccurring problems and built frameworks to address these issues. A good framework relieves developers from attempting to reinvent the wheel for complex problems; it is extensible for internal customization; and it has a strong user community to support it.

For the presentation layer we will use Struts; for our business layer we will use Spring; and for our persistence layer we will use Hibernate.

how to create professional website with typo3 in 1 day

Phase 1:-

->After installing typo3 in ubuntu,go to extension manager and go to import extensions and upload extension file templavoila_1.3.7.t3x.

->Create folder templates in fileadmin folder and paste your template in this folder.

->Click templavoila and start wizard now!

->Choose template file index.html.

->Write the name of the site and username for the site.

->Start the mapping process.

->Go to mapping and map content area,main menu and sub menu if any.

->Click on save and return.

->Click on select html header parts.

->Click header parts and click on save and return.

->Click on write main menu typoscript code and sub menu typoscript code and click on finish wizard!

Phase 2:-

->Click on user settings and click the edit and advanced functions tab and click the recursive delete and save the configuration.

->Click on page and delete all main menus of default.

->Click on templavoila and click the /site/storage folder/.

->Click on update mapping.

->Click on information and click on modify DS/TO/

->Add new fields.

->Write the name of the new field,the parameters are mapping type=element and title=field title and editing type=content element and click on add.

->Map the new field and set it.

->Click on save as.

->Update existing data structure and template object.

->Same for other fields.

Phase 3:-

->For multilanguage site click on page and click the main page file copy the file and paste after.

->Unhide the file.

If the rich text editor takes time to load then import extension htmlRteopenoffice skin and then install it then uninstall it.

Typoscript code

## Menu [Begin]

lib.mainMenu = HMENU

lib.mainMenu.entryLevel = 0

lib.mainMenu.language =fr

lib.mainMenu.wrap =

|

lib.mainMenu.1 = TMENU

lib.mainMenu.1.NO {

allWrap =

|

}

lib.mainMenu.1.ACT = 1

lib.mainMenu.1.ACT {

allWrap =

|

}

## Menu [End]

lib.subMenu = HMENU

lib.subMenu.entryLevel = 1

lib.subMenu.wrap =

|

lib.subMenu.1 = TMENU

lib.subMenu.1.NO {

allWrap =

|

}

lib.subMenu.1.ACT = 1

lib.subMenu.1.ACT {

allWrap =

|

}

config.spamProtectEmailAddresses = 1

page = PAGE

page.typeNum = 0

page.10 = USER

page.10.userFunc = tx_templavoila_pi1->main_page

}

Localization:

config{

linkVars = L

sys_language_mode = content_fallback

sys_language_overlay = hideNonTranslated

}

config.sys_language_uid = 0

config.language = en

[globalVar = GP:L=20]

config{

sys_language_uid = 15

language = fr

locale_all = fr_FR

}

page.10{

styles.content.get = CONTENT

styles.content.get {

table = tt_content

select.orderBy = sorting

select.where = colPos=0

select.languageField = sys_language_uid

}

[global]

my view

"Don't think anything visually"
"Forget everything in 60 seconds"

"The whole cumbersome things happens in the mind - so don't get afraid"


->the above things are not to think but to exist in daily life"

How to install typo3 in ubuntu

->Go to sourceforge.net

->Download the source and dummy packages of typo3

source package:-typo3_src-4.2.1.tar.gz

dummy package:-dummy-4.2.1.tar.gz

->Extract the files to the desktop

->Copy the files to /var/www/cms

->Apply all permissions to the folders

sudo chmod 777 -R -v /var/www/cms/*

->Make a database typo3 in phpmyadmin

->Open http://localhost/cms

->Follow the steps

How to install caldev server in ubuntu

>>>>>>>>>>>>>process to install caldev server in ubuntu>>>>>>>>>>>>

a>Open terminal.

b>sudo gedit /etc/apt/sources.list.

c>Add (deb http://debian.mcmillan.net.nz/debian unstable awm ) to the end of the line.

d>Save and close gedit.

e>sudo apt-key advanced --keyserver subkeys.pgp.net --recv-keys CCA377BD77494424B0DB674F8C90347F8F068012

f>sudo apt-get update

sudo apt-get install libawl-php

sudo apt-get install rscds

g>Install postgresql in ubuntu

$ sudo apt-get install postgresql postgresql-client postgresql-contrib

$ sudo apt-get install pgadmin3

h>Reset the password for the ‘postgres’ admin account for the server, so we can use this for all of the system administration tasks. Type the following at the command-line (substitute in the password you want to use for your administrator account):

$ sudo su postgres -c psql template1

template1=# ALTER USER postgres WITH PASSWORD 'password';

template1=# \q

That alters the password for within the database, now we need to do the same for the unix user ‘postgres’:

$ sudo passwd -d postgres

$ sudo su postgres -c passwd

Now enter the same password that you used previously.

i>Then, from here on in we can use both pgAdmin and command-line access (as the postgres user) to run the database server. But before you jump into pgAdmin we should set-up the PostgreSQL admin pack that enables better logging and monitoring within pgAdmin. Run the following at the command-line:

$ sudo su postgres -c psql < /usr/share/postgresql/8.3/contrib/adminpack.sql j>Finally, we need to open up the server so that we can access and use it remotely - unless you only want to access the database on the local machine. To do this, first, we need to edit the postgresql.conf file:

$ sudo gedit /etc/postgresql/8.3/main/postgresql.conf

Now, to edit a couple of lines in the ‘Connections and Authentication’ section…

Change the line:

#listen_addresses = 'localhost'

listen_addresses=localhost

and also change the line:

#password_encryption = on

to

password_encryption = on

Then save the file and close gedit.

Now for the final step, we must define who can access the server. This is all done using the pg_hba.conf file.

$ sudo gedit /etc/postgresql/8.3/main/pg_hba.conf

Comment out, or delete the current contents of the file, then add this text to the bottom of the file:

# DO NOT DISABLE!

# If you change this first entry you will need to make sure that the

# database

# super user can access the database using some other method.

# Noninteractive

# access to all databases is required during automatic maintenance

# (autovacuum, daily cronjob, replication, and similar tasks).

#

# Database administrative login by UNIX sockets

local all postgres ident sameuser

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only

local all all md5

# IPv4 local connections:

host all all 127.0.0.1/32 md5

# IPv6 local connections:

host all all ::1/128 md5

# Connections for all PCs on the subnet

#

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

host all all localhost 255.255.255.0 md5

That’s it, now all you have to do is restart the server:

$ sudo /etc/init.d/postgresql-8.3 restart

And all should be working.

j>install Apache, PHP and finally MySQL.

k> Database Stuff

Once all the package installations are done you start by making the DAViCal database in PostgreSQL. To this purpose you create 2 functional accounts in postgreSQL. Assuming you have root or sudo rights;

>sudo su

>su postgres -c "createuser davical_app"

You will get asked about superusers, roles and databases, but "just say NO" to all questions, this functional ID needs only minimum rights. Repeat the process to create one more user, "davical_dba".

l>Once these 2 functional IDs are created go to "/etc/postgresql/8.1/main/" and open the file pg_hba.conf with an editor of choice. (You may want to back up the file before editing, just in case.) Add the following 3 lines near or at the top;

local all all trust

local davical davical_dba trust

local davical davical_app trust

Then restart your postgreSQL server by;

>/etc/init.d/postgresql-8.1 restart

Now you can run the script to create the DAViCal database. This is done as follows;

>su postgres -c /usr/share/rscds/dba/create-database.sh

(previously I had ">su postgres -c /usr/share/davical/dba/create-database.sh" but that was a

mistake due to me doing a cut'n'paste from an older document. Someone was kind enough to

point that out in an edit.)

i>Once the creation script has run correctly, go back to the pg_hba.conf file and remove the line

local all all trust

m>restart the database daemon. (This step is not strictly necessary for the installation, but do you really want just anybody with a local account free access to all the databases? Thought not.)

If you want to test that your database creation was successful,

>sudo su

>su postgres

>psql davical

davical=# \z

You should see about 30 tables all with some sort of access permission to "davical_dba". (Type "\q" to exit pqsl)

n>

cd /var/www

sudo mkdir cal

sudo ln -s /usr/share/rscds/htdocs/ cal/

sudo /etc/init.d/apache2 restart

Next step is to actually configure DAViCal. Go to "/etc/davical/". Currently it should be an empty directory. Create a configuration file with the naming convention localhost-conf.php,

The content of the configuration file should be as follows;

domain_name = "localhost";

// $c->sysabbr = 'rscds';

$c->admin_email = 'admin@example.net';

$c->system_name = "Really Simple CalDAV Store";

// $c->collections_always_exist = true;

// $c->enable_row_linking = true;

$c->default_locale = en_US.UTF-8;

$c->pg_connect[] = 'dbname=davical port=5432 user=davical_app';

?>

Creating a symbolic link to localhost-conf.php helps when you want to test or administer the installation from the server locally.

cd /etc/rscds/

ln -s localhost-conf.php localhost-conf.php

cd /usr/share/rscds/inc

ln -s /usr/share/awl/inc/* .

1. In a browser go to "http://localhost/cal/".

2. You will find a login screen.

3. Enter "admin" for username.

4. Enter the password obtained after running the database creation script.

Congratulations! You should now find yourself in the administration screen, with the ability to create new users.

If you forgot the Admin Password

If at this point you are saying, "d*mn, where is that admin password I wrote down...", no sweat. Do the following;

>sudo su

>su postgres

>psql davical -c 'select username, password from usr;'

Only the initial "admin" password is stored in plain text. All subsequent users have their password stored in an encrypted state. If you change the admin password through the web interface it will also be encrypted from that point forward.

give me the half share of the money after the installation.

how to backup ubuntu os

I have two hard disks one running ubuntu Os and the other is empty unformatted partition.I had to backup the ubuntu Os to the unformatted hard disk. I did the following steps.

->I installed gparted. I formatted the unformatted partition /dev/sdb with ext3

filesystem.

->It created the partition table sdb1.

->I then mounted that partition to /mnt/backupdrive/backup

->I installed sbackup from apt-get

sudo apt-get install sbackup.

->I then used it to backup my ubuntu Os to sdb1

how to setup lamp in ubuntu

This guide is divided into 3 steps: installing/tesing Apache, PHP and finally MySQL.

Lets start with Apache:
1. Open the terminal (we will be using it through most of my guide) from Applications > Accessories > Terminal
2. Install apache2 using apt-get by typing the following

sudo apt-get install apache2

Note that you should know the root password.
Now everything should be downloaded and installed automatically.
To start/stop apache2 write:

sudo /etc/init.d/apache2 start

sudo /etc/init.d/apache2 stop

Your www folder should be in: /var/www/

If everything is OK you should see an ordinary HTML page when you type: http://localhost in your firefox browser

Finished with Apache ? lets conquer PHP:
1. Also in terminal write:

sudo apt-get install php5 libapache2-mod-php5

or any php version you like

2. restart apache

sudo /etc/init.d/apache2 restart

This is it for PHP
Wanna test it ? Just create an ordinary PHP page in /var/www/ and run it.
Example:

sudo gedit /var/www/test.php

and write in it: < ?php echo “Hello World”; ?>

Now run it by typing http://localhost/test.php in firefox… You should see your ” Hello World ”

66 % is over, lets continue to installing MySQL:
1. Again and again in terminal execute:

sudo apt-get install mysql-server

2. (optional) If you are running a server you should probably bind your address by editing bind-address in /etc/mysql/my.cnf and replacing its value (127.0.0.1) by your IP address
3. set your root password (although mysql should ask you about that when installing)

mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(’xxxxxx’);

4. Try running it

mysql -uroot -pxxx

where xxx is your password.
Note: You can install PHPMyAdmin for a graphical user interface of MySQL by executing

sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

5. restart apache for the last time

sudo /etc/init.d/apache2 restart

Congratulions your LAMP system is installed and running
Happy Coding

UPDATE:
Due to the large number of people emailing about installing/running phpmyadmin.
Do the following:

sudo apt-get install phpmyadmin

The phpmyadmin configuration file will be installed in: /etc/phpmyadmin
Now you will have to edit the apache config file by typing

sudo vi /etc/apache2/apache2.conf

and include the following line:

Include /etc/phpmyadmin/apache.conf

Restart Apache

sudo /etc/init.d/apache2 restart

Another issue was making mysql run with php5
First install these packages:

sudo apt-get install php5-mysql mysql-client

then edit php.ini and add to it this line : ” extensions=mysql.so” if it isnt already there

sudo vi /etc/php5/apache2/php.ini

Restart Apache

sudo /etc/init.d/apache2 restart

Installing BIRT Using Update Manger

If you already have the Eclipse SDK installed, you can easily add BIRT to your existing installation using Update Manager.

Installing BIRT using Update Manager Instructions

Step 1: Start Eclipse and navigate to Help > Software Updates > Find and Install.

Step 2: Select Search for New Features to install.

Step 3: Choose the Callisto Discovery Site.

Step 4: After Update Manager checks for available features, check the option to select Charting and Reporting.

Step 5: Press the Select Required button to find the additional components that BIRT uses.

Step 6: Press Next and on the following page, accept the license terms.

Step 7: Press Finish and Update Manager will download the required components.

Step 8: On the Feature Verification page, select Install All (BIRT components are currently not signed, so you can ignore this warning).

Step 9: Restart Eclipse.

Step 10: You can now start designing BIRT reports by selecting the Report Design perspective.

Choose Window > Open Prespective > Other... and then Report Design.

Why Struts

We need a mechanism that can separate the presentation layer of a web application from business logic. Luckily we have MVC and we have Struts. MVC is a design pattern (best practice method) that separates the application design into there main parts:



Model, View and Controller



* Model - data and logic (business logic methods).

* View - output displayed to the user

* Controller - takes the input from the user and passes it to the relevant model. The model returns and based on the result, the controller decides which view (page) to show the user.

Download the source code of eclipse project from here :- registration
Download the videos for configuring struts in eclipse here:-
video-1
video-2
video-3
video-4

SET UP ENVIORNMENT

sudo gedit /etc/profile

JAVA_HOME="/usr/lib/jvm/java-6-sun-1.6.0.06"

PATH=$JAVA_HOME/bin:$PATH

export PATH JAVA_HOME

$JRE_HOME="/usr/lib/jvm/java-6-sun-1.6.0.06"

export $JRE_HOME

$CATALINA_HOME="/home/mifos/Desktop/apache/apache-tomcat-5.5.17/"

export $CATALINA_HOME

sudo gedit /etc/enviornment

JAVA_HOME="/usr/lib/jvm/java-6-sun-1.6.0.06"

$CATALINA_HOME="/home/mifos/Desktop/apache/apache-tomcat-5.5.17/"

sudo gedit ~/.bashrc

export JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.06

export CATALINA_HOME=/home/mifos/Desktop/apache/apache-tomcat-5.5.17/

apt-get cheat sheet

apt-get command cheat sheet for Debian Linux

apt-get is the command-line tool for handling packages for Debian Linux which is use to:

• Install/manage individual packages
• Upgrade packages
• Apply security patch(s)
• Keep Debian system up to date
• Download source .deb files
• Front-end to many GUI and other utilities

Here is quick cheat sheet you will find handy while using apt-get at shell prompt:

Syntax	Description	Example(s)
apt-get install {package}	Install the new package. If package is installed then try to upgrade to latest version	apt-get install zip apt-get install lsof samba mysql-client
apt-get remove {package}	Remove/Delete an installed package except configuration files	apt-get remove zip
apt-get --purge remove {package}	Remove/Delete everything including configuration files	apt-get --purge remove mysql-server
apt-get update apt-get upgrade	Resynchronize the package index files and Upgrade the Debian Linux system including security update (Internet access required)	apt-get update apt-get upgrade
apt-get update apt-get dist-upgrade	Usually use to upgrade to Debian distribution. For example Woody to Sarge upgrade. 'dist-upgrade' in addition to performing the function of upgrade, also intelligently handles changing dependencies with new versions of packages; apt-get has a "smart" conflict resolution system, and it will attempt to upgrade the most important packages at the expense of less important ones if necessary.	apt-get update apt-get dist-upgrade

how to show apt-get install < any package>

edit /etc/apt/sources.list file

how to setup mysql in ubuntu from apt-get

sudo apt-get install mysql-server-5.0
sudo apt-get install mysql-admin
sudo apt-get install mysql-query-browser

must restart the system after installing these packages