Archive for the ‘Postgresql’ Category

Criminal Information System in OpenERP v6

March 5, 2012 1 comment
Project :
Criminal Information System, Police Line Peshawar, Pakistan
Project Assigned By:
SP Investigation Umer Hayat
Project Completed  By:
Mohsin Yaseen
Software Tools Used:
OpenERP v6
Overview of Modules Developed and Customized in OpenERP:
  1. Single Repository of all criminal record at district and province level
  2. Quick searching of suspect or criminal from different perspective
  3. Analysis of crime rate  from different perspective
Different Perspective Include:
  • District wise crime
  • Police station wise crime
  • Nationality wise crime
  • Main and sub caste wise crime
  • Also Integration of above all perspective
  • And much more.
68 Attributes of Each Criminal:In this criminal repository, 68 attributes are recorded for single criminal including its history of crime. Using these 68 attributes
  1. We can analyze statistically ,
  2. We can search criminal or suspect from 68 different attributes.


HRDC Survey(Statistical Analysis) Project in OpenERP

July 6, 2011 5 comments
Project :
Third Party Validation of Performance of PTCs of Khyber Pakhtoonkhwa Pakistan
Project Assigned By:
Education Department of Khyber Pakhtoonkhwa Pakistan
Project Assigned To:
HRDC, IMSciences Peshawar Pakistan
Project Field Work Domain:
All Schools of Khyber Pakhtoonkhwa Pakistan (No of Sample Schools 5400)
Software for Statistical Analysis and Its Reporting:
First Time OpenEPR used as Statistical Analysis Software and for its Statistical Reporting
Software Tools Used:
OpenERP Framework, Python, Postgresql, PDF & MSExcel and Linux platform as OS
First Time OpenERP for Statistical Analysis and Its Reporting:
First Time OpenERP is used for strong statistical analysis and its reporting.  Approximately 89 users entered 5400 schools data using OpenERP interface from different terminals.Each school have 5 different survey forms i.e. Auditors Form, EDO Form, Secretary Form and Member Council Form.Each form has 40-50 different questions representing school different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.
Overview of Modules Developed in OpenERP for Statistical Analysis
 There are two modules developed for this project
  1. Hrdc
  2. Hrdc_reporting
  • Module hrdc includes objects, tree views, forms views, update data files, wizards, menus and security rights files.
  • Module hrdc_reporting includes 15 different statistical reports (including summary and details). These reports first print in pdf and we also export these report in MSExcel for report writing purpose.
OpenERP Developed Module Demonstration for Statistical Analysis 
•Module hrdc_reporting includes summary and detail (district level) reports, these reports extract from 5400 schools information ( each school have 4 different survey forms).
•These reports includes heavy statistical calculation and shows the situation of different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.
Statistical Reports in MSExcel 
•These all reports are also print in excel format for final report writing purpose.
•Final report presents to Education Department of Khyber Pakhtoonkhwa Pakistan.
HRDC Survey Project in OpenERP 1
HRDC Survey Project in OpenERP 2
HRDC Survey Project in OpenERP 3

PostgreSQL default password

January 20, 2011 14 comments

Step 1: open terminal

Step 2: su postgres

Note: If you don’t remember the postgres (ubuntu user) password then use the command ‘sudo passwd postgres’

Stept 3: Type ‘psql’ and enter

Step 4: Use the following command to change the posgres user password

alter user postgres with password ‘newpassword’;

‘\q’ is used to exit psql

and Finsish

Categories: Postgresql

Enter a Bank statement in Openerp and Its Bank Reconciliation with Invoices:

December 17, 2010 1 comment

I assume that viewer of this post have studied my first and second posts, I will continue using same example I have used in mention two post.

Previous example overview:

List of Suppliers partners: Ahmad, Asif, Dawood & Co, Naeem and Saleem & Co.

List of Customers partners: Crown & Co, Naseem & Co, Rafiq & Sons and Rizwan & Co

we have enter some supplier invoice using supplier partners, and similarly some customers invoices using some customers partners. Above invoices both of supplier and customers were based on accrual. The invoices status was open.

After these accrual basis accounting impact we receipt Rs. 3000 and Rs. 6000 from two customers Naseem & Co and Rafiq & Sons respectively in Bank Acc 123. we reconcile receipt voucher with customers invoices. The these two customers invoice status becomes done. Similarly we also make payment of Rs. 2000, Rs. 2500 and Rs. 1000 to our supplier Asif, Dawood & Co and Naeem respectively. After reconciliation the status of these three supplier invoice were also becomes done.

This was the preview of example we used;

Following are the some snaps , so that you can understand the account balances, partner balances, invoices status (open or done). After these snaps we will continue our topic.

Snap of account balances:

Trial Balance

Read more…

Hire Purchase: Module Development example in openerp

December 14, 2010 20 comments

In this tutorial, I will share how module develops in openerp. First I will explain the functionality of hire purchase (what we are going to develop), second I will develop hire purchase module in openerp. A simple explanation of hire purchase module is sale of goods in installment. In my example, I will ignore the interest portion of hire purchase. I just spread the price of good in number of monthly installment. I can say that, this module is a demo version of hire purchased without installment. In future I will extend this module with interest. In this tutorial I will focus on step by step development of module in openerp.
What hire purchase is read out the wiki about hire purchase, for detail of hire purchase also read wikieducator.

In this tutorial I will cover; how to create openerp objects (in .py file), interaction with object using openerp views (tree and form), openerp wizards and menuitem.

Step 1:

Create the following files and folders.

a. Folder having named ‘hirepurchase’ and 2nd folder having name ‘wizard’ in ‘hirepurchase’ folder.

b. Create the files in hirepurchase folder, i.e.,, hirepurchase_view.xml and

c. Create the files in wizard folder, i.e. and

File structure: hirepurchase folder contains one folder (wizard) and four files (,, hirepurchase_view.xml and Wizard folder contains two files ( and

Read more…

Modules Development in OpenERP: View, Events, Menu and Actions

October 6, 2010 30 comments

In this tutorial I will explain the syntax of views, events, menus and actions in openERP with some examples.
For detail we can check the documentation of design elements in openERP from

List of syntax and examples of different control in OpenERP
1. View file in OpenERP
2. Button in OpenERP
3. Menu Item in OpenERP
4. Tree View in OpenERP
5. Form View in OpenERP
6. View Action in OpenERP
7. Complete form view in OpenERP

1. View file in openERP
a. XML Declaration
b. OpenERP body tag


<?xml version="1.0" encoding="${encoding}"?>
    	[view definitions]

Read more…

Asset Management by Simple Declining Method in OpenERP

September 9, 2010 2 comments

I will use the example from one of my post to customize and use asset management module of openerp. Two steps already mention in my previous post like calculating profit and loss (making balance of income and expenses to zero for the respected year) and forwarding the balances of previous year to next year.

Post 1: Complete asset management example:

Post 2: Calculating profit and loss:

Post 3: Balance forwarding to new year:

In this tutorial I will refer the to post1, post2 and post3 to eliminate the redundancy steps and I follow the steps of post1.

Step 1:

a. Create following three accounts from Financial Management → Configuration → Financial Accounting → Financial Accounts → List of Accounts.

  1. Read more…