Internet Business Consulting Services Corporation
Archive for the ‘OpenERP’ Category
How to install OpenERP 6 RC1 on Ubuntu 10.04
OpenERP 6 requires Python 2.6 and Postgres 8.4. This document describes how to install these on Ubuntu 10.04.
These instructions should be run as root on your server.
Install and configure Postgresql 8.4
1. Install Postgres 8.4
apt-get install postgresql
1a. Make sure GCC is install
apt-get install gcc
2. Allow remote PgAdmin clients access to the database: edit /etc/postgresql/8.4/main/pg_hba.conf. Add this line:
listen_addresses = ‘*’
You could tighten this address range for better security. This is completely optional
3. Create openerp user
su – postgres
createuser –createdb –no-createrole –pwprompt openerp
Enter password for new role: …..
Enter it again: …..
Shall the new role be a superuser? (y/n) y
4. Create an openerp database
createdb -O openerp openerp
5. Allow openerp-server to login to postgresql: edit /etc/postgresql/8.4/main/pg_hba.conf. Modify lines as indicated below:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# “local” is for Unix domain socket connections only
# MODIFY THE EXISTING LINE TO LOOK LIKE THIS:
local all all trust
# IPv4 local connections:
# MODIFY THE EXISTING LINE TO LOOK LIKE THIS:
host all all 127.0.0.1/32 trust
# ADD THIS LINE TO ALLOW REMOTE ACCESS; use your own IP address range:
local all all 10.10.155.0/24 trust
# IPv6 local connections:
host all all ::1/128 ident
You could tighten this address range and methods for better security.
6. Set the logging level. To tell Postgres to log all SQL activity (i.e. to see all the SELECT’s, UPDATES, DELETEs and INSERT statements), add this line to /var/lib/pgsql/data/postgresql.conf:
log_statement = ‘all’
7. Restart Postgres
service postgresql-8.4 restart
Install Python 2.6
1. Install Python and the Develment packages:
apt-get install python
apt-get install python-dev
Install packages required for OpenERP 6
1. Install setuptools:
wget http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz
Then unpack it and install it:
python setup.py install
2. Install easy_install:
easy_install Cython
3. Install pip:
easy_install pip
4. Use pip to make sure these packages are installed:
pip install mako
pip install pydot
pip install reportlab
pip install pyyaml
pip install pywebdav
5. Install required dependencies for OpenErp 6:
apt-get install python-psycopg2
apt-get install python-reportlab
apt-get install python-pychart
apt-get install python-pydot
apt-get install python-egenix-mxdatetime
apt-get install python-lxml
apt-get install python-tz
apt-get install python-imaging
apt-get install python-vobject
apt-get install libxml2
apt-get install libxml2-devel
6. Install libtool:
apt-get install libtool
7. Install psycopg: Download it and then install it with:
apt-get build-dep python-psycopg2
pip install psycopg
Install and configure the OpenERP 6 Server
1. Download the OpenERP6 server. Unpack it and install it:
python26 setup.py install
2. Add an openerp user:
adduser openerp
3. Make sure the new log file exists and is writable:
touch /var/log/openerp-server.log
chown openerp /var/log/openerp-server.log
4. Make sure the directory for the pidfile is writable by openerp:
mkdir /var/run/openerp
chown openerp /var/run/openerp
5. Edit ~openerp/.openerp_serverrc; make changes to look like this (don’t enter the “…” lines):
debug_mode = True
log_level = debug_rpc
root_path = /usr/local/lib/python2.6/site-packages/openerp-server
addons_path = /usr/local/lib/python2.6/site-packages/openerp-server/addons
db_host = ‘localhost’
db_port = 5432
db_user = openerp
db_name = openerp
db_password = set-your-own-password-here
6. Edit ~openerp/.bashrc
export LD_LIBRARY_PATH; LD_LIBRARY_PATH=/usr/local/lib
7. Give the OpenERP server user permission to install new modules
chown openerp /usr/local/lib/python2.6/dist-packages/addons
8. Create a startup file called /etc/init.d/openerp-server, and add it as a service. Here is the contents of the script:
#!/bin/sh
#
# OpenERP init script v0.1 for centos by Open-Future
# Bert Deferme – www.open-future.be – bert@open-future.be
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 3 as
# published by the Free Software Foundation.
#
# For a copy of the GNU General Public License, see .
# chkconfig: 345 60 61
# description: starts the openerp-server service
NAME=openerp-server
USER=openerp
PATH=/sbin:/bin:/usr/sbin:/usr/bin
DAEMON=/usr/bin/openerp-server
PIDFILE=/var/run/openerp/$NAME.pid
DAEMONOPTS=”–syslog –log-level=debug –pidfile=${PIDFILE}”
checkpid() {
[ -f $PIDFILE ] || return 1
pid=`cat $PIDFILE`
[ -d /proc/$pid ] && return 0
return 1
}
do_start() {
if [ -f $PIDFILE ]; then
echo “pidfile already exists: $PIDFILE”
exit 1
fi
echo -n “Starting $NAME: ”
su – $USER -c “nohup $DAEMON $DAEMONOPTS >/dev/null 2>&1 &”
sleep 3
checkpid
if [ $? -eq 1 ]; then
rm -f $PIDFILE
echo “failed.”
exit 1
fi
echo “done.”
}
do_stop() {
checkpid
if [ $? -eq 1 ]; then
echo -n “$NAME not running… (no pidfile found)”
exit 0
fi
echo -n “Stopping $NAME: ”
pid=`cat $PIDFILE`
kill -15 $pid
sleep 2
if [ $? -eq 1 ]; then
echo “Failed. (pidfile found but process didn’t exist)”
exit 1
fi
echo “done.”
}
do_status() {
echo -n “Checking $NAME: ”
checkpid
if [ $? -eq 1 ]; then
echo “stopped.”
else
echo “running.”
fi
}
do_restart() {
do_stop
if [ $? -eq 1 ]; then
exit 1
fi
do_start
}
case “$1″ in
start) do_start ;;
stop) do_stop ;;
restart|force-reload) do_restart ;;
status) do_status ;;
*)
N=/etc/init.d/$NAME
echo “Usage: $N {start|stop|restart|status}” >&2
exit 1
;;
esac
exit 0
Here is how to create it:
vi /etc/init.d/openerp-server
chmod 755 /etc/init.d/openerp-server
sudo update-rc.d openerp-server defaults
sysv-rc-conf – make sure 235 are checked off for openerp-server
9. Edit /etc/init.d/openerp-server and make the DAEMONOPTS line look like this. If file was not created see steps below to create:
DAEMONOPTS=”–logfile=/var/log/openerp-server.log –log-level=debug_rpc_answer –pidfile=${PIDFILE}”
See /usr/local/lib/python2.6/dist-packages/openerp-server/tools/config.py for other valid log levels.
10. Start the Openerp server:
service openerp-server start
Install and configure the OpenERP Web Server
1. Install the dependent, pyparsing:
should be installed if you have already installed the dependecies above, to check run
apt-get install python-pyparsing
2. Install the OpenERP Web Server
tar -xzf openerp-web….tar.gz
cd openerp-web…
sudo python setup.py install
3. Create the OpenERP Web Server configuration file:
cp /usr/local/lib/python2.6/dist-packages/openerp_web-6.0.0_rc1-py2.6.egg/openerp-web/doc /etc
4. Edit the configuration file, /etc/openerp-web.cfg. Add or uncomment lines to be like this:
log.access_file = “/var/log/openerp-web/access.log”
log.error_file = “/var/log/openerp-web/error.log”
…
company.url = ‘http://www.yoururl.com/your_logo.jpg’
5. Make sure the log directory /var/log/openerp-web exists and is owned by openerp.
mkdir /var/log/openerp-web
chown openerp /var/log/openerp-web
6. Create a startup file called /etc/init.d/openerp-web, and add it as a service. Here is the contents of the script:
#!/bin/sh
#
# OpenERP init script v0.1 for centos by Open-Future
# Bert Deferme – www.open-future.be – bert@open-future.be
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 3 as
# published by the Free Software Foundation.
#
# For a copy of the GNU General Public License, see .
# chkconfig: 345 61 60
# description: runs the openerp-web service
NAME=openerp-web
USER=openerp
PATH=/sbin:/bin:/usr/sbin:/usr/bin
DAEMON=/usr/bin/openerp-web
PIDFILE=/var/run/openerp/$NAME.pid
DAEMONOPTS=”-c /etc/openerp-web.cfg”
checkpid() {
[ -f $PIDFILE ] || return 1
pid=`cat $PIDFILE`
[ -d /proc/$pid ] && return 0
return 1
}
do_start() {
if [ -f $PIDFILE ]; then
echo “pidfile already exists: $PIDFILE”
exit 1
fi
echo -n “Starting $NAME: ”
su – $USER -c “nohup $DAEMON $DAEMONOPTS >/dev/null 2>&1 &”
pid=`ps -ef|grep openerp-web|grep -v grep|cut -d ” ” -f3`
echo $pid > $PIDFILE
sleep 3
checkpid
if [ $? -eq 1 ]; then
rm -f $PIDFILE
echo “failed.”
exit 1
fi
echo “done.”
}
do_stop() {
checkpid
if [ $? -eq 1 ]; then
echo -n “$NAME not running… (no pidfile found)”
exit 0
fi
echo -n “Stopping $NAME: ”
pid=`cat $PIDFILE`
kill -15 $pid
sleep 2
if [ $? -eq 1 ]; then
echo “Failed. (pidfile found but process didn’t exist)”
exit 1
fi
rm $PIDFILE
echo “done.”
}
do_status() {
echo -n “Checking $NAME: ”
checkpid
if [ $? -eq 1 ]; then
echo “stopped.”
else
echo “running.”
fi
}
do_restart() {
do_stop
if [ $? -eq 1 ]; then
exit 1
fi
do_start
}
case “$1″ in
start) do_start ;;
stop) do_stop ;;
restart|force-reload) do_restart ;;
status) do_status ;;
*)
N=/etc/init.d/$NAME
echo “Usage: $N {start|stop|restart|status}” >&2
exit 1
;;
esac
exit 0
Here is how to create it:
vi /etc/init.d/openerp-web
chmod +x /etc/init.d/openerp-web
sudo update-rc.d openerp-web defaults
sysv-rc-conf – make sure 235 are checked off for openerp-web
7. Start the Openerp web server:
service openerp-web start
Toner Man to Implement OpenERP
Tonerman (Tonerman.com), located in Kaysville, Utah, is a toner re-manufacturing company. They have been re-manufacturing toner cartridges for laser printers since 1988. Tonerman ships anywhere. They have next day shipping anywhere in Utah and will deliver in person and provide support for companies located in Salt Lake City, Ogden, Layton, Kaysville, Murray, North Salt Lake, Bountiful, and surrounding areas.
There are many companies that provide cheap products, but after more than 20 years of experience in toner re-manufacturing, their product is high-quality and comes with a satisfaction guarantee.
In order to improve their market penetration in Salt Lake City, Utah areas, and their ability to serve their clients who need printer support services, Toner Man is implementing an ERP system.
ERP stands for Enterprise Resource Planning. Many small to medium sized businesses don’t know what ERP is. Typically a small business manages their business using Quickbooks, paper and a variety of other integrated or un-integrated disparate systems.
Some Examples:
E-commerce example:
If a company had e-commerce and had online orders they might download orders from the internet and import them into Quickbooks manually. This is quite common, they might import the orders themselves, or just a monthly or weekly summary of orders so they can account for their online sales. Information about their customers would then exist partly in Quickbooks and partly in their e-commerce system.CRM – Sales Management Example:
If a company had sales staff they might manage their sales using paper, an in house CRM ( Customer Relationship Management System) like Act, or a hosted CRM solution like Salesforce.com, SugarCRM, and vtigercrm. The problem they encounter in any of these scenarios eventually is an integration problem. They have to import their customers into their accounting software if it is Peachtree or Quickbooks or whatever any time they get an order they have to copy the clients data into the accounting software. Further, any time the sales person needs information about a customer – did they pay are things past due is there a hold on the account, did an address or phone number change, have we done business with this account etc. they have to ask the accountant. Not having this information like an address change may be expensive for the guy who just made a call on that business. At the end of a year they may have different data for many accounts in each system. Eventually if the company grows, the manual process breaks down and they have to figure out some way to integrate the systems.OpenERP is an integrated Solution
By choosing OpenERP to for CRM – Customer Relationship Management, Tonerman is able to be way ahead of the game. As their company grows and they migrate more of their business process to OpenERP their cost of doing business will decrease or stay the same rather than increasing because their processes will be more automated, they will be using less paper, and repeat entries will be eliminated. Currently they are doing only CRM, but in the future they may also use the MRP – Manufacture Resource Planning to manage toner manufacturing module, HR-Human Resources Module to manage attendance, accounting to manage the books etc. There is also e-commerce integration capability with Magento E-commerce. If they use this with the accounting module for example they wouldn’t have multiple copies of product data – only one.OpenERP CRM is being implemented with iBCScorp
Internet Business Consulting Services Corporation-iBCScorp.com headquartered in Saint George Utah is an OpenERP implementation and integration company. They will be providing OpenERP Installation and maintenance. They will also be training sales staff on OpenERP CRM, and completing the OpenERP Implementation using OpenERP 6.0.
Sales force productivity management
Tonerman looks forward to using OpenERP’s CRM capabilities to manage its sales force and continue to grow its client base, serving its clients across the Wasatch Front and nationwide.OpenERP Custom Sample Module Development – OpenERP Quick Start Guide
Introduction
This article will explain the basic steps involved in developing custom OpenERP modules. It is a “Hello World” kind of guideline, therefore you won’t be able to find out all the theories behind OpenObject platform here. Instead you will get all the necessary information to get started with. Sample module given here is fully functional and tested on OpenERP version 6.0-RC2 (with Web Client on Chrome browser). You will be able to download the complete source code at the end of this article.Module Description
The sample module we are going to develop is a simple Notebook application. It helps to take down notes and contains just three fields namely “Title”, “Note” and “Date” in its data model.Module Structure
An OpenERP module consists of some basic elements as explained below. Note that what is explained here is only the basic files required and structure will be more complex in real world applications.- module_name.py – contains the application logic and database table structure definition.
- __init__.py – init script will load the application’s main python-module and related in application initialization.
- view_name.xml – contains the application interface definition and menu structure.
- __openerp__.py – is the module descriptor file. In previous versions of OpenERP this was known as “__terp__.py”
File Contents
Even though there is no specific order, I am going to start with the main python class (module) of our OpenERP module. This will handle the core functionality of the module and also will generate the database table to store related data.
[ notebook.py ]
[python] from osv import fields, osv import time class notebook(osv.osv): _name = "notebook" _description = "Simple Notebook" _columns = { ‘title’ : fields.char(‘Title’, size=30, required=True), ‘note’ : fields.text(‘Note’), ‘note_date’ : fields.date(‘Date’), } notebook() [/python] Next we import the python module we created in application initialization script.[ __init__.py ]
[python] import notebook [/python] After that we define the view and menu structure of our module.[ notebook_view.xml ]
[xml] <?xml version="1.0" encoding="utf-8"?> <openerp> <data> <record model="ir.ui.view" id="notebook_tree_view"> <field name="name">notebook.tree</field> <field name="model">notebook</field> <field name="type">tree</field> <field name="arch" type="xml"> <tree string="Notebook"> <field name="title"/> <field name="note"/> <field name="note_date"/> </tree> </field> </record> <record model="ir.ui.view" id="notebook_form_view"> <field name="name">notebook.form</field> <field name="model">notebook</field> <field name="type">form</field> <field name="arch" type="xml"> <form string="Notebook"> <field name="title"/> <field name="note"/> <field name="note_date"/> </form> </field> </record> <record model="ir.actions.act_window" id="action_notebook_form"> <field name="name">notebook</field> <field name="res_model">notebook</field> </record> <menuitem name="Notebook" icon="terp-project" id="notebook_menu"/> <menuitem name="Notes" parent="notebook_menu" id="notebook_menu_mainform" action="action_notebook_form"/> </data> </openerp> [/xml] Finally create the application descriptor as follows.[ __openerp__.py ]
[python] { "name" : "notebook", "version" : "0.1", "author" : "Keerthi Bandara @ iBCScorp", "website" : "http://www.ibcscorp.com/", "category" : "Generic Modules/Others", "depends" : ["base"], "description" : "Simple demo module", "init_xml" : ["notebook_view.xml"], "demo_xml" : [], "update_xml" : [], "active": False, "installable": True } [/python]Packaging and Installing New Module
To prepare your module for installation, you may simply compress the module directory into a zip archive (e.g. notebook.zip). Once your module archive is ready, you can continue the installation by following the given path below. 1. Login to OpenERP admin view and open “Import Module” screen under “Modules” section in “Administration” area. Select newly created module archive and click “Import Module” button. Note: Sometimes on OpenERP V6 (RC2), the message ”Loading..” will be continuously displayed, even though your module is successfully imported. In that case simply close the message window and continue to next step.
2. After importing new module, it will appear under OpenERP “Modules” list. It can be easily located by Searching for the module name. Once you found the module, mark it for installation, then select the check box in front of the module and click “Apply Scheduled Upgrades” link.
Click on “Start update” to continue the installation.
Accessing Your Module
After installing your module successfully, it will appear on the home screen of your OpenERP client as follows.
The sample source code explained above is available here.
Conclusion
Motivation behind preparing this article was the difficulty I have faced in finding out a proper start up guide in custom OpenERP module development. Even official documentation appeared to be incomplete/inconsistent at the moment of writing this article.
Anyway there is a lot more to explore in OpenERP module development. As an OpenERP partner, iBCScorp is always willing to help you in your OpenERP implementation project. If you found this post useful just leave a comment and do not hesitate to contact us on any OpenERP related issue.
Commercial Lighting and Electric OpenERP
Commercial Lighting and Electric has contracted with Internet Business Consulting Services Corporation (IBCScorp) to assist with its OpenERP implementation.
Commercial Lighting and Electric will use OpenERP’s CRM, project management and accounting modules to help streamline and improve the profitability of its business.
They chose OpenERP CRM over other competitive products like SugarCRM and Salesforce because it is flexible and can easily be adapted to their needs, but also because it is tied in with their project management and accounting modules requiring either less data entry, or less customization which would be required to integrate accounting with Sugar CRM and or Salesforce.
Being integrated with the project management allows the project managers to see any details, documents, e-mails or other information necessary to better manage their projects. Project management is a very important part of Commercial Lighting and Electrics business. Because the work flow can be managed and modified inside of OpenERP, Commercial Lighting and Electric will be able to implement their project management process how it best works for them.
Using general and analytical accounts, Commercial Lighting and Electric should be able to manage the cost’s associated with each job more effectively knowing if each job was profitable and making sure it is completed on time. Migrating from Quickbooks to Openerp will give them advantages of having a completely integrated platform running their business rather than having accounting on the side as an additional thing that needs done.
It is expected that the OpenERP implementation will be completed over three months period of time. Installing OpenERP from source as a service
Installing OpenERP especially for a new comer would be a little bit difficult at first, not because OpenERP itself is difficult to install, but if you follow the official documentation then probably you have chances to mess things up since the doc is not 100% up-to-date and it is somewhat misleading with all the comments from various users.
Here I am going to guide you how to install OpenERP running as a service. The recent releases of debian based distros has
OpenERP as deb package so one can easily install it with a synaptic package management system, but instead here I am going to show you how to install an OpenERP server and web client from source and then run it as a service.
Server : Ubuntu 10.04 (Lucid Lynx) OpenERP version : 5.0.14 PostgreSQL version : 8.4 Python version : 2.6 You need administrative (sudo) privilages on the server.
Login to the server as an administrative user (sudo). We first need to install a PostgreSQL server if it is not already installed.
$ sudo apt-get install postgresql
Then we need to create a PostgreSQL database user for openerp. For doing this you need to switch to PostgreS user.
$ sudo su – postgres
$ createuser --createdb --username postgres --no-createrole --pwprompt openerp
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
$ exit
Now if you try to login to the database as this user, you will get an error.
$ psql -U openerp -W
$ psql: FATAL: Ident authentication failed for user "openerp"
To fix this we need to change PostgrSQLl configuration so that it uses ident based authentication instead of password based authentication.
$ sudo vi /etc/postgresql/8.4/main/pg_hba.conf
change the line
#local all all ident
to
local all all md5
then it should be as following
# Database administrative login by UNIX sockets
local all postgres ident
# 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
# IPv6 local connections:
host all all ::1/128 md5
Now download OpenERP server and web client to a convenient location. I downloaded them to the OpenERP directory created in my home directory.
$ mkdir ~/openerp
$ cd ~/openerp
$ wget http://www.openerp.com/download/stable/source/openerp-server-5.0.14.tar.gz
$ wget http://www.openerp.com/download/stable/source/openerp-web-5.0.14.tar.gz
Extract the server and web archives.
$ tar zxvf openerp-server-5.0.14.tar.gz
$ tar zxvf openerp-web-5.0.14.tar.gz
Installing OpenERP-server
To install the OpenERP server execute the setup script.
$ cd ~/openerp/openerp-server-5.0.14
$ sudo python setup.py install
The server is normally installed to /usr/local/lib/python2.6/dist-packages/openerp-server
Now you can run the server in console by executing the command.
$ openerp-server --db_user=openerp --db_password=<password>
Installing openerp-web
First you need to install the required libraries for the openerp-web.
$ sudo apt-get install python-psycopg2 python-reportlab python-egenix-mxdatetime python-tz python-pychart python-pydot python-lxml python-vobject python-profiler
Also install python-dev and build-essential if they are not already installed.
$sudo apt-get install python-dev build-essential
$sudo apt-get install python-setuptools
Now change to the lib directory in the extracted openerp-web and run the populate.sh script. This will install all the dependencies required.
$ cd ~/openerp/openerp-web-5.0.14/lib
$ ./populate.sh
$ cd ..
Now you can run the web client by executing openerp-web in console.
$ openerp-webYou should be getting the following output.
[03/Nov/2010:10:11:35] ENGINE Bus STARTING
[03/Nov/2010:10:11:35] ENGINE Started monitor thread ‘_TimeoutMonitor’.
[03/Nov/2010:10:11:35] ENGINE Started monitor thread ‘Autoreloader’.
[03/Nov/2010:10:11:35] ENGINE Serving on 0.0.0.0:8080
[03/Nov/2010:10:11:35] ENGINE Bus STARTED
Running openerp-web as a service
Copy following openerp-web scripts from the installation directory in to specified locations.
$ sudo cp /usr/local/lib/python2.6/dist-packages/openerp_web-5.0.6-py2.6.egg/scripts/openerp-web /etc/init.d/
(This is the init script used to start/stop openerp-web)
$sudo cp /usr/local/lib/python2.6/dist-packages/openerp_web-5.0.6-py2.6.egg/config/openerp-web.cfg /etc/
(This is the openerp-web configuration file)
Grant execute permission to /etc/init.d/openerp-web
$sudo chmod +x /etc/init.d/openerp-web
Edit /etc/init.d/openerp-web file. In the file we need to provide the user who runs openerp. First we need to create new system user for this. I named mine as ‘openerp’.
$ useradd openerp
( this is the system user for running the server and web-client )
$ sudo vim /etc/init.d/openerp-web
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin
DAEMON=/usr/local/bin/openerp-web
USER=”your system username”
Next edit /etc/openerp-web.cfg and specify the log files.
$ sudo gedit /etc/openerp-web.cfg
log.access_file = “/var/log/openerp-web/access.log”
log.error_file = “/var/log/openerp-web/error.log”
Lets create the log file directory and grant ownership to openerp user.
$ sudo mkdir /var/log/openerp-web/
$ sudo chown openerp /var/log/openerp-web/
Now run following command to start the OpenERP Web automatically on system startup (Debian/Ubuntu).
$ sudo update-rc.d openerp-web defaults
Now you can start the daemon like this:
$ sudo /etc/init.d/openerp-web start
Running openerp-server as a service
I could not find an init script for server in installation directory. So lets create a one.
$ sudo vim /etc/init.d/openerp-server
And enter the following script.
#!/bin/sh
### BEGIN INIT INFO
# Provides: openerp-server
# Required-Start: $syslog
# Required-Stop: $syslog
# Should-Start: $network
# Should-Stop: $network
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Enterprise Resource Management software
# Description: Open ERP is a complete ERP and CRM software.
### END INIT INFO
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin
DAEMON=/usr/local/bin/openerp-server
NAME=openerp-server
DESC=openerp-server
USER=openerp
test -x ${DAEMON} || exit 0
set -e
case “${1}” in
start)
echo -n “Starting ${DESC}: “
start-stop-daemon –start –quiet –pidfile /var/run/${NAME}.pid \
–chuid ${USER} –background –make-pidfile \
–exec ${DAEMON} — –config=/etc/openerp-server.conf
echo “${NAME}.”
;;
stop)
echo -n “Stopping ${DESC}: “
start-stop-daemon –stop –quiet –pidfile /var/run/${NAME}.pid \
–oknodo
echo “${NAME}.”
;;
restart|force-reload)
echo -n “Restarting ${DESC}: “
start-stop-daemon –stop –quiet –pidfile /var/run/${NAME}.pid \
–oknodo
sleep 1
start-stop-daemon –start –quiet –pidfile /var/run/${NAME}.pid \
–chuid ${USER} –background –make-pidfile \
–exec ${DAEMON} — –config=/etc/openerp-server.conf
echo “${NAME}.”
;;
*)
N=/etc/init.d/${NAME}
echo “Usage: ${NAME} {start|stop|restart|force-reload}” >&2
exit 1
;;
esac
exit 0
Grant execute permissions to this script.
$ sudo chmod +x /etc/init.d/openerp-server
The following will make it run automatically on system startup.
$ sudo update-rc.d openerp-server defaults
Now we need to create a config file for the server. The server reads the config settings in the file on startup.
$ sudo vim /etc/openerp-server.conf
[options]
# Enable the debugging mode (default False).
verbose = False
debug_mode = False
# The file where the server pid will be stored (default False).
#pidfile = /var/run/openerp.pid
# The file where the server log will be stored (default False).
logfile = /var/log/openerp-server.log
# The unix account on behalf openerp is running.
process_user = openerp
# The IP address on which the server will bind.
# If empty, it will bind on all interfaces (default empty).
interface = localhost
# The TCP port on which the server will listen (default 8069).
#port = 8070
# Enable debug mode (default False).
debug_mode = False
# Launch server over https instead of http (default False).
secure = False
# Specify the SMTP server for sending email (default localhost).
smtp_server = localhost
# Specify the SMTP user for sending email (default False).
smtp_user = False
# Specify the SMTP password for sending email (default False).
smtp_password = False
# Specify the database name.
db_name = False
# Specify the database user name (default None).
db_user = openerp
# Specify the database password for db_user (default None).
db_password = <password_for_openerp_user>
# Specify the database host (default localhost).
db_host = localhost
# Specify the database port (default None).
db_port = 5432
# Specify the price accuracy.
#price_accuracy =
#Specify the addons path
addons-path = /usr/local/lib/python2.6/dist-packages/openerp-server/addons/
Lets create the server log file and grant the ownership to OpenERP user.
$ sudo touch /var/log/openerp-server.log
$ sudo chown openerp /var/log/openerp-server.log
That’s it. Now you can start the server by executing
$ sudo /etc/init.d/openerp-server start
Now from a web browser navigate to OpenERP. You will get the OpenERP login screen.
http://yourdomain:8080
OpenERP : Customizing Task View – Project Management Module
Adding Task Creator to Project / Task View
OpenERP Project Management module provides great set of features in managing daily tasks within the organization. By default, the Task Detail page does not display the person who created the task. As the task assigner, it is really important to identify the person who has created/assigned a particular task. With the OpenERP’s rich support/flexibility in customizations, this can be resolved in no time. (more…)iBCScorp hires a new Project Manager
iBCScorp hires an additional project manager for its US office.
This person will fill an important role in helping service the needs of US Domestic clients. She has 5+ years management experience for a telecommunications company and a BS in Computer Science. She has experience in the following technologies:- RDBMS: MS SQL SERVER, MY SQL
- Frameworks: ASP.NET MVC
- Markup languages: HTML, CSS
- Browser Scripting: Java Script, AJAX
- Server Scripting: ASP.NET (C#), PHP, Python, Java, C, C++ C#,
- Servers: IIS, LAMP, DNS, LDAP, NFS, MailX, Samba PDC
- IDE’s: Visual Studio, Visual FoxPro, Mozart, GDB, Geany, Dream Weaver
- Design: DFD, UML, ERD, Three-Tire Architectural Design, MVC
- Versioning Systems: Git
- MYSQL Frontend: phpmyadmin
How to use Timesheets in OpenERP
iBCScorp is making and publishing video’s via YouTube and ibcscorp.com. The videos are to not only to help the employees of iBCScorp better learn how to use the magnificent tool of Open ERP, but also allow anyone else to get an idea of how OpenERP software could be useful in their business.
Other training videos are being created and will soon be published on YouTube and iBCScorp.com. If you have any questions about Open ERP or all of the advantages it can provide for any business, please contact iBCScorp.
To view the YouTube video about timesheet click here.
The video covers all of the details anyone needs to know in order to use timesheet’s in Open ERP. A few of the details that are covered in the video are as follows:
- How to create a new timesheet in Open ERP
- How to clock in and out with in the timesheet
- How to complete a task
- How to import tasks into the timesheet
