Archive for the ‘Python’ 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.


Inno8Tech (Outsource Project) Success Story in OpenERP v6

March 2, 2012 3 comments
Project :
Outsource Project (Inno8Tech)
Project Assigned By:
Project Completed  By:
Mohsin Yaseen and Waqas Pitafi
Software Tools Used:
OpenERP v6
Overview of Modules Developed and Customized in OpenERP:
Customized Modules are; 
-Finance, Sale and Purchase
-HR, Expense, Contract, Payroll, Attendance, Time Sheet and Recruitment 
-Project Management
Developed Modules are; 
-Project based Employee Advances & Recovery, Integration with invoice (finance), approval workflow
-Email and sms alerts against project completion, task assignment, task completion, project based advance requisition, advance approval and advance rejection. 

Project: Police Information System in OpenERP v6

March 1, 2012 Leave a comment
Project :
Police information System
Project Assigned By:
Police Line District Mardan, NWFP Pakistan
Project Completed  By:
Mohsin Yaseen
Software Tools Used:
OpenERP v6
Overview of Modules Developed in OpenERP for Mardan Police Line:
This Module is developed for Purpose of Police Personal Evaluation at Mardan District of NWFP Pakistan
This Module includes,
– Officer Personal Informations,
– Current Posting and Current Rank
– History of All Posting and Promotion according to time
– Courses Passed during career and gain points
– Good Points assigned by senior and its all history of officer
– Different punishments given by senior officer and its bad points
– Leave Qouta, Earned leave history, Medical Leave History and Casual Leave History
– Record complaints against officer from differ persons, These complaints will only read by senior officer.
– Promotion and Posting Policy enforcement
– Retirement and experience in career
– Reports:
Strength of Police Station
Posting Wise Officer Selection
Course Assignment wise Officer Selection
Officer Selection by current posting tenure
Officer Selction by posting in home Police Station or circles

OpenERP Training in Pakistan from NUST, Islamabad (Non OpenERP Partner)

February 9, 2012 8 comments

Dear Viewers,

NUST offering OpenERP training. NUST is one of the ‘TOP 100 UNIVERSITIES IN ASIA’ and one of the best educational industry in Pakistan. NUST have 16-18 schools of different areas in Pakistan including capital cities.

This workshop has been designed for both IT Professionals and people from Management background who would like to explore how HRM can be effectively managed through an open source ERP solution. The workshop is also beneficial for IT and Management students to know about state of the art in ERP solutions deployment and its related challenges.

Please Follow the details from given advertisement.


Contact With:


A center of excellence for quality education and research

Sector H-12 Islamabad Tel: 051 9085 2400 Fax: 051 8317363

OpenERP: Couldn’t find package setup install

December 9, 2011 Leave a comment

Hello Friends!

If any one find the error ‘Couldn’t find package setup install’ during installation of openerp in ubuntu 10,

Then just install the python-setuptools from synaptic manager or using this command from terminal sudo apt-get install python-setuptools

Note: Following the steps mentioned in official OpenERP website.


Categories: OpenERP, Python, Ubuntu

OpenERP many2many Domain Filtering Example

September 29, 2011 2 comments

Class 1:

class cms_program_specialization_type(osv.osv):
    _name = 'cms.program.specialization.type'
    _columns = {
        'name': fields.char('Specialization Type',size=100,required=True),

Class 2:

class cms_program_specialization(osv.osv):
    _name = 'cms.program.specialization'
    _columns = {
        'name': fields.char('Specialization',size=100,required=True),
        'specialization_type': fields.many2one('cms.program.specialization.type', 'Specialization Type', required=True),



Class 3: This is the object where many2many is define:

class cms_course(osv.osv):
    _name = 'cms.course'
    _columns = {
        'name': fields.char('Course Name',size=300,required=True),
        'taught_in_specialization_main': fields.many2one('cms.program.specialization.type','Main Specialization'),
        'taught_in_specialization_detail': fields.many2many('cms.program.specialization', 'tbl_course_in_specialization_rel', 'course_id', 'specialization', 'Course Taught in', required=True),

Now the for view of object cms.course where domain filter is used

    <record model="ir.ui.view" id="view_cms_course_form">
        <field name="name">cms.course.form</field>
        <field name="model">cms.course</field>
        <field name="type">form</field>
        <field name="arch" type="xml">
            <form string="cms.course">
                <field name="name"/>
		<field name="taught_in_specialization_main"/>
		<field name="taught_in_specialization_detail" colspan="4" domain="[('specialization_type','=',taught_in_specialization_main)]"/>
Categories: OpenERP, Python, XML

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