Thursday, 18 September 2014

Odoo V8 Release

Your Ends Here....

Odoo(OpenERP) V8 released....

You can find more information here.....

Try Online(any apps) : Start..
(if you know apps name then just go :
No Need to register

Official announce :

What is Odoo :

Release Note:

Brand Assets


Wednesday, 28 May 2014

work with Marketing Campaign Odoo(formelly OpenERP)

How to work with Marketing Campaign Odoo(formelly OpenERP) ?

1. If you want to send an email based on campaign, you need to create campaign first with mode: Normal(can be any).
2. Assign that created campaign to the segment.You can also apply filter, if you want to send an email to specific group.
3. You need to run the campaign, and then you can run the segment.
4. Based on the given criteria, Campaign follow-up will be taken.
Based on syncronization mode the mail will be sent.

For more info:

Hope this information may help you.

Sunday, 18 May 2014

Tuesday, 25 March 2014

Work with web-controller OpenERP

How to override web controller in openerp 8.0.

Here, i try to define one example that may be useful to you to understand how to work with web controller in openerp 8.0.

Existing controller (addons/web/controllers/ :
- class name Home, and method index

class Home(http.Controller):

    @http.route('/', type='http', auth="none")
    def index(self, s_action=None, db=None, **kw):
        return http.local_redirect('/web', query=request.params, keep_hash=True)

Now, here i define how to override existing controller...
 - Here, my class name Website, and in parameter i pass path of controller which i want to inherit, so here "Home" class which is in addons/web/controllers/ so in path i pass : openerp.addons.web.controllers.main.Home.

 - @http.route : in openerp 8.0 the route system changed.
           '/' : '/' route will match the new index() method in Website.
        'type' : There are different type like http,json...
                 (http : normal http requests by passing, Json : Methods that received JSON can be defined by passing 'json')

class Website(openerp.addons.web.controllers.main.Home):
    @http.route('/', type='http', auth="public", website=True, multilang=True)
    def index(self, **kw):
            main_menu = request.registry[''].get_object(, request.uid, 'website', 'main_menu')
            first_menu = main_menu.child_id and main_menu.child_id[0]
            # Dont 302 loop on /
            if first_menu and not ((first_menu.url == '/') or first_menu.url.startswith('/#') or first_menu.url.startswith('/?')):
                return request.redirect(first_menu.url)

Wednesday, 5 March 2014

Change report fonts in OpenERP


Let's change font in openerp reports. I mean some time we need to change the report font in our company font. Simple answer go to every report(.rml) and change manually every where.

I have simple way to just replace the font.

Steps :
 - Download Community module from : l10n_cn_fonts
 - Just replace your fonts don't forget to put fonts in l10n_cn_fonts/fonts folder.
 - Replace the font name in the file accordingly.
 - Install module

So, now at the time of rendering it will always consider your fonts.


Friday, 21 February 2014

OpenERP Complete Example

Complete Example:

Steps :
1. Create a new customer
2. Create a new product category and product
3. Add Minimum Stock Rules
4. Create a Bill of Material
5. Warehouse and locations
6. Create a sales quotation
7. Confirm the sales order
8. Run the scheduler
9. Change the purchase request and confirm it
10.Receive the products
11.Create the draft purchase invoice
12.Run the scheduler again
13.Start manufacturing
14.Deliver the goods to the customer and create draft sales invoice
15.Create the sales invoice
16.Confirm the purchase invoice

Thursday, 20 February 2014

To know object/table size openerp

Hi all ,

Every time after backup we check how much space needed. Its necessary, but its normal if we have lots of space, but when database size continuously increase then we need to check which table/object increase your database size so fast.

So, in PostgreSQL if we want to see which table/object increase your database size then by following sql query, you can easily know which object consume how much.

[Query ]:
SELECT nspname || '.' || relname AS "relation",
pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
AND C.relkind <> 'i'
AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size(C.oid) DESC
LIMIT 100;