Saturday, September 5, 2009

Working with jFusion

Joomla!! We all know that it is a really powerful tool as CMS. Now after having jfusion in the market it got more acceptablity.

Now one can use jfusion to connect any other php script / software / web application with joomla and create a comprihancive system. jfusion actually works in two phases.
1) User sync between Joomla and other scripts
2) Autologin (Automatic session would created when person logs in to master script)

So using this you would now creat a comprihancive system of your choice with different applications available in the market.

Currently jfusion bundles following plugins :
1) Joomla (if you want to connect between two joomla)
2) moodle
3) Magento
4) phpbb3
5) elgg
6) docu wiki
7) gallery2
8) MyBB
9) SMF
10) vbulletin

Apart from that one can create its plugins for any other scrip.
We did it for one of our client.

We have created jfusion plugin for follwoing softwares as well.
1) OsCommerce (User + Admin)
2) OsTicket (Admin)
3) Adquick (User + Admin)
4) AffiliatePRO (User + Admin)
5) PHPFOX (User + Admin)

Basically current plugins which are supplied with jfusion at the moment are just for users only but we can alter them to make it workin in admin part also.

JUst give us a mail if you would like to see the on going demo of this project and if you want to have something customized for you in the same regards.

Wednesday, August 26, 2009

Open ERP Web Installation Clear Instrution (Windows Version)

To setup openERP (5.0.x) web version (for Windows) I did faced lot of problem due to non continuty of data at any single source.


Please follow the steps to get it working fast..
1) Install Python ( 2.5.4) (Don't use newer version as you need not get it compitable with Turbogear Plugin)
  • Grab the Python 2.5 Installer.
    For x86 processors:python-2.5.4.msi
    For Win64-Itanium users: python-2.5.4.ia64.msi
    For Win64-AMD64 users: python-2.5.4.amd64.msi
  • Run the installer.
  • Add Python to your path.

    To do this, go to System Properties -> Advanced -> Environment Variablesand add or edit the PATHvariable to have;C:\Python25;C:\Python25\Scripts, assuming you installed Python to the default location.

2) Install TurboGear 1.0.8.

You can run Python from any shell if your Python scripts directory is on your path. By default the scripts directory is C\:Python25\Scripts

  1. Open up a command line prompt (Start -> Run and type cmd)
  2. Download tgsetup.py and run
python tgsetup.py
*Make sure that tgsetup.py file is placed at the current directory of your propt. If not then do it from Windows explorer.
  1. Make sure your installation succeeded by running tg-admin info

3) Install PostGREs SQL 8.4

4) Install Database Driver.

In Our case OPENERP uses Postgres as Database and Python is 2.5. So Click here to download windows installer.

5) Install OPENerp Server Now.

System Requirements The server installation works on: • Windows 2000 • Windows XP • Windows Vista • Windows Server 2000 • Windows Server 2003 • Windows Server 2008 with disks formatted in NTFS (not a FAT or FAT32 partition). Note: Open ERP Server doesn’t work on Windows 98 or ME; for obvious reasons – these can’t be formatted using NTFS. 
Preparing the server for the first time run The Windows service for Open ERP Server is installed during the installation and it’s set up to start the server automatically on system boot. The configuration file is now automatically saved in the installation directory, in: C:\Program Files\OpenERP Server\openerp-server.conf

//Deciding what is the purpose of the server//
You have three possibilities for the first launch. This section is really important because the correct initialization can be crucial.
You can initialize the database with Open ERP Server to:
1. You want to take a look on the system with demo data loaded
2. You are installing a new clean installation (without demo data)
3. You are upgrading an existing version.

Open Command Propt(Start Menu > Run > CMD) and go to OpenERP Folder. Execute this step to do that cd\"Program Files"\"OpenERP Server"\

// First time run with demo data //
To initialize Open ERP Server with the demo data, you need to add this option to the above command:
Open ERP Server Installation
--init=all
Sample command:
openerp-server.exe -d terp -r postgresadmin -w postgresadminpasswd --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log"
--db_port=5432 -s --stop-after-init --init=all

Notation :   openerp-server.exe -d  -r  -w  --db_host=localhost --db_port=5432 --logfile="" -s --stop-after-init  The initialization of Open ERP Server provides the necessary informations for the connection to the database PostgreSQL and indication of the choice of data to load. Here is the explanation of used options: • -d  : Name of the database created for Open ERP Server. • -r  : Name of the [=PostgreSQL=] administrator. • -w  : Administrator’s password. • –db_host= : Address of the server where [=PostgreSQL=]is, if you have installed [=PostgreSQL=] on the same computer as Open ERP Server, you can enter localhost, or the IP address or the name of the distant server. • –db_port= : Port number where listens [=PostgreSQL=]. Default is 5432. • -s : This option allows you to save the options in configuration file of Open ERP Server. • –stop-after-init: This option stops the ERP server after initialization. • –logfile=””: specify a logfile where all the output of ERP Server will be saved.

This command will initialize the Open ERP Server and fill its PostgreSQL database with the demo data.

//First time run without demo data (or new clean version)//
Execute the command with an option excluding the demo data:
--without-demo=all
This will load all modules, but will not load the demo data.
Sample command usage:
openerp-server.exe -d terp -r postgresadmin -w postgresadminpasswd --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log"
--db_port=5432 -s --stop-after-init --without-demo=all
Recreate a new database:If you have more than one database , you may force the server to initialize by using the “-i
all” or “–init=all” command line option.
If you already initialized the database and you have the demo data loaded, you can recreate a new database


//First time run with an upgraded version of Open ERP Server//
Execute the command with an option that updates the data structures:
--update=all
Sample command usage:
openerp-server.exe -d terp -r postgresadmin -w postgresadminpasswd --db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log"
--db_port=5432 -s --stop-after-init --update=all

// Starting of OpenERP Server //
Now go to
Start >> All Programs >> OpenERP Server >> Start Service
Its Done.. Congratulations, you have successfully installed the Open ERP Server

6) Install OpenERP Client Now.

Just follow instruction.
The installation program creates shortcuts in the main program menu and on the desktop. Be sure to have an Open ERP Server running somewhere (on your computer or on a distant server) to be able to use the Client software.
Passwords:
Log in to TERP (This database name, which can differ so use the one that you have created while creating server) database using default username and password
• Username = admin
• Password = admin
Enjoy!

7) Install OpenERP Web Client now..

Start web server from StartMenu >> Program Files >> OpenERP Web >> Start OpenERP Web
If installed with all default settings then you can access it at http://localhost:8080 or if you want to access it remotly then "IP of that computer":8080 for example IP of that machine is 192.168.0.199 then it would be http://192.168.0.199:8080

Enjoy..
Do post your valuable comments to improve this.