Thursday, December 5, 2013

Odoo OpenERP 7 University Management System

1) Admission :- 
This form keeps track of people came to take admission thentrough this their admission gets confirmed and that cadidate becomes a student of school/college. By clicking on open student profile button user get diverted to student profile. 
2) Student Profile :-
All the details of students like the assignment of that student,health related information and educational history of that student is also maintained. 
3) Faculty :- 
Information of faculty is maintained through this form. Time table of that teacher as well as the subjects he teaches and library details related to his is also maintained. 

 4) Time Table :-  
Time table for the students is generated by this wizard. 

The time table will look like in calender view 

5) Library :-  
library details are managed properly through this. Allocating a library cards to students and faculty. Keeps track of issued books and requsted books,authors and publishers as well of the various books and their movements.  
6) Classroom Management :- 
The record of the classrooms means which classroom is allocated to which class and the facilities (projector , light,fans etc) available in that class room. 
7) Exams :- 
Exam information like exam template, exam sessions,criteria for the exam and resourses allocated for the exam as well as the attendees of exam are also manages through exam section. 
8) Result :- 
Result of students of various exams is recorded. The marksheet of the student can be printed and the result templates also can be created. 
9) Hostel Management :-  
Manageing the hostels in the school/college and the intake of hostel and the capacity of individual rooms and information of rent of the room allocation date and students to whom it is allocated is possible to manage.  
10) Students Migration :-  
Students Migration from standerd to stanard is done. Those students who are passed in 1st year are sent to 2nd . And the standard of students gets changed and the new admission form for next year is automatically gets filled.  
11) Placements Offers :-  
Information of placements offers to student get is also maintained.  

12) Transport Management :-  
Information regarding the transportation facility provided by the school/college is managed. The routes of the transportation facility as well as the information of vehicle and the driver is also managed.  

13) Parents :-  
Information of the parents of students is also managed. 

14) Fees structure :-  
Predefined fee stucture is created to charge that much fees from all those students. 

15) Payroll :-  
Information of payroll is also managed 

16) Attendence :-  
Daily attendence and monthly attemdence of a any particular class is managed. 

Thursday, November 14, 2013


Comparison of APACHE and NGINX web servers. 

I am a rails web developer and always wanted to know what is the best possible way to deploy a rails web site.

I searched a lot on google and got an answers that says use NGINX for mostly static web sites.          

Use APACHE + PASSANGER as easy deployment tool.and some web pages says that use THIN server.  

Finally i deployed one product based web site to test this and tried to find out which the fastest web server i can use.

When hosted with APACHE and tested with APACHE benchmark tool i got the following output.

Server Software:
Server Hostname:
Server Port: 80  
Document Path: /index.html
Document Length: 5907 bytes

Concurrency Level: 5  
Time taken for tests: 151.297 seconds
Complete requests: 1000
Failed requests: 0  
Write errors: 0
Non-2xx responses: 1002  
Total transferred: 6197440 bytes
HTML transferred: 5917882 bytes
Requests per second: 6.61 [#/sec] (mean)
Time per request: 756.487 [ms] (mean)  
Time per request: 151.297 [ms] (mean, across all concurrent requests)
Transfer rate: 40.00 [Kbytes/sec] received

Percentage of the requests served within a certain time (ms)
50% 522
66% 540
75% 559
80% 587
90% 1117
95% 2002
98% 3532
99% 3757
100% 17908 (longest request)  

When hosted with NGINX i got the following output

Server Software: NGINX
Server Hostname:
Server Port: 80
Document Path: /index.html
Document Length: 5907 bytes  

Concurrency Level: 5
Time taken for tests: 145.200 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Non-2xx responses: 1002  
Total transferred: 6197550 bytes
HTML transferred: 5917552 bytes
Requests per second: 5.61 [#/sec] (mean)
Time per request: 754.487 [ms] (mean)
Time per request: 150.297 [ms] (mean, across all concurrent requests)
Transfer rate: 42.00 [Kbytes/sec] received  

Percentage of the requests served within a certain time (ms)
50% 522
66% 530
75% 559
80% 587
90% 1117 95% 2002
98% 3531
99% 3757
100% 17905 (longest request)

By comparing this i can say that both are same but actually sometime it may be depend on network speed to complete a request.

On the server there is 25 gb of ram from which hardly 0.3% is used to run an UNICORN worker at a time. for test i have created 5 unicorn workers.The cpu  is i7 cpu with 2.67GHZ.which has 8 siblings.

For cpu also i seen just a 0.7% is used when serving a request. This is for both for APACHE as well as NGINX.

Let me know your thoughts on which server should i prefer APACHE+PASSANGER, NGINX+PASSANGER, NGINX+UNICORN, APACHE+UNICORN. Or any other choice for fastest rails deployment.

Saturday, October 26, 2013

Odoo OpenERP 7 - Medical Healthcare and Hospital management System

                          Pragmatic has launched another new and advanced Product in the field of Health-care Management . This Product comes with many features like


1) Patient Management with full patient details like General Information , Socio-Economic Details , Diet and exercise details etc
 2) Appointment Management with Features like Confirmation of Appointment , Related Prescriptions , Pediatric Symptom Checklist. 
3) Inpatient Management with features like Diet Details , Nutrition and care plan etc.
4) ICU with details like GCS , ECG , APACHE 2 score etc.
5) Roundings with options like Six P's , Vital signs , Respiratory Details etc 
6) Patient Ambulatory Care informations.
7) Patient Laboratory test Management.
8) Newborn records with details like Neonatal signs and symptoms ,Neonatal Reflex check.
9) Pharmacy with related entries in Warehouse.
10) Pre - configured data according to ICD-10 Standard for Diseases , Medical procedures , Recreational drugs , Medical Specialties , Disease Categories etc.
11) Various Reports like appointments per doctor , appointments per month , Appointments per specialty.

1) User can Create Patient with information like Diseases , Socio-Economic conditions , Lab Tests , General Information , Medication , Lab Tests etc.

2) Patient Family records can be created where in all the members of one family can be added in the records.

3) Appointments can be created for the patients. 
4) Related Pediatric Symptoms checklist evaluations can be added in the Appointments. 
5) Prescriptions related to the Appointments can also be added. 
6) Records of the patients admitted in the hospitals are created. In this , information like Diet and Nutrition of the patient , care plan etc are added as well. 
7) Intensive Care Unit Details of the patients like 

A) GCS (Glasgow Comma Scale)  

B) ECG ( Electrocardiogram ) 

C) APACHE ll Score ( Acute Physiology and Chronic Health Evaluation 2 Score )  

8) New Born Record can be created in which details like Neonatal Signs and Symptoms , Neonatal Reflex check etc can be recorded.  
9) Invoices for the services provided in the hospital can be created. They have direct effect in the balance sheet.

A) Lab tests invoice.  
B) Appointments to be invoiced.
C) Prescriptions to be invoiced.
10) Many reports can be printed by the system. These help in Efficient Decision making and Management of the hospital. 

A) medicament list Report.
B) Appointment Evaluation per doctor report.
C) Appointment Evaluation Per medical Center Report.
D) Appointment evaluation per prescription Report .
E) Appointment evaluation per specialty Report .

Wednesday, October 16, 2013

Odoo OpenERP 7 integration with Avatax.

                          Pragmatic Techsoft has come up with module to integrate OpenERP and Avatax system for sales tax calculation. This module helps to calculate Sale Tax based on customer address along with handling of Shipping Charges,Avatax Tax Code,Customer Exemption and Invoice or Product Returned.  

1.Customer Address Validation
When user creates new customer he needs to validate his address form Avatax for accurate sale tax calculation. He can also mark customer as exempt.

2.Calculation of Sale Tax
When creating sell order select customer and product and click on calculate button which will calculate sale tax amount for given sell order based on Customer address.
3.Validate Invoice
When we create Invoice from sell order and validate that invoice a record is created in Avatax Admin Console with uncommitted state. Invoice order in Avatax Gives Us Jurisdiction vice Tax distribution.
4.Pay Invoice
When user make payment for OpenERP Invoice state of order at Admin console marked as committed.
5. Returned Invoice
When user return Payment for invoice a new record is created in Avatax Admin Console with doc-type as Return Invoice and Negative amount indicating that invoice amount is returned.
6. Tax Code
User can create there own tax rule/s in Avatax these tax rules are handled from OpenERP . These tax Rule define whether particular product is taxable in particular state/county/city or not . In OpenERP on Product For you can define Tax Code for Products when we send request to Avatax for that product according to customer destination it Returns Tax Amount for that Product.
                    In above case we have assigned Tax Code VAT-2 for Product this VAT-2 Tax code is non Taxable in Customer address so no tax is calculated for this Sell Order
                    Similarly When we create Sell Order for Customer who is exempted from Tax for any Reason in that situation not tax is calculated for that customer Order or Invoice

Friday, October 11, 2013

Odoo OpenERP 7 Integration with Fedex, UPS and USPS

                          Pragmatic Techsoft has come up with OpenERP 7 module which integrates OpenERP delivary orders with worlwide couriers like Fedex,UPS and USPS inorder to generate Rate for shipping and Shipping Labels.
                          This is a comprehensive web based shipping integration module used for getting shipping charge details from shipping above agengies according to Service Type;Pacakage Details;Pacaging Type etc. 


                        Below mentioned are the key features of shipping Integration which can be configured & customized as per clients requirment:   

Key Features:  
1) Integrated with FEDEX, UPS,USPS
2) Generating rate of shipping according to weight of delivery order, type of shipping service used and shipping agency selected for delivery of order.
3) Integrated with different service types like Local, Internation, Airbill etc.
4) Generates label along with tracking number , barcode and DataMatrix code.
5) Download and Print shipping receipt.

Once user confirm sale order respective delivary order is generated from where user can select which shipping agency will be used to deliver order.  

 1.Generating Shipping Quotes for FedEx  

Once delivery order is creted user has to specify Weight of Delivery order;Shipping Type,Dropoff Type,Packaging Type. When user click on Generate Shipping Quotes request is send to FedEx which returnes cost of shipping according to specified weight and selected shipping Type. 

 2.Request to Generate Shipping Label for FedEx  

Once user get shipping cost he can request to generat label of shipping i.e Receipt of Shipping which is in image form that can be downloaded and printed any time. 
 3.Opening Shipping Label For FedEX 
 4.Shipping Label Details for FedEx 
 5.Shipping Label For FedEx 
 Similarly user can generate shipping charge and label for UPS and USPS.  

B) UPS  

1. Generating Shipping Quotes for UPS 
2.Label For UPS 

 1. Generating Shipping Quotes For USPS 
 or USPS 
User can use all Shipping agencies (FedEx;UPS and USPS) at once to generate rate and label. 
 Generated Shipping Quotes