Monday, 24 December 2012

Use of lambda in OpenERP 7.0

                                                                                                                    Pinakin Nayi
                                                                                                                    OpenERP , Gandhinagar, India
Different use of lambda in OpenERP 7.0
In OpenERP we are using a lambda function, here i described some of function that all are normally use, that may be useful to you also.
- Map your ids using lambda :
    ids = map(lambda x: x[0],

- Get date using lambda
    'date2': lambda *a: time.strftime('%Y-%m-%d')
- Get Company id using lambda
    'company_id': lambda self,cr,uid,c:    
    self.pool.get('res.users').browse(cr, uid, uid, c),
- Get user id using lambda
    'user_id': lambda self, cr, uid, context=None: uid,
- Get start and end date using lambda
    'date_start': lambda *a: time.strftime('%Y-01-01'),
    'date_stop': lambda *a: time.strftime('%Y-12-31'),
- Get Currency id using lambda
    'currency_id': lambda self,cr,uid,c:self.pool.get('res.users').browse(cr, uid, uid,
- Get month and year using lambda
    'month': lambda *a: time.gmtime()[1],
    'year': lambda *a: time.gmtime()[0],
    'month': lambda *a:,
    'year': lambda *a:,


Wednesday, 12 December 2012

Celebrate 12/12/12 12:12:12

I just passed the moment in OpenERP, Gandhinagar. So, i am so excite to share with all of you.
Just about to celebrate 12/12/12 12:12:12

Celebrating 12/12/12 12:12:12 with OpenERP..

Monday, 10 December 2012

5 steps to configure new Employee in OpenERP 7.0

                                                                                                                         Pinakin Nayi
                                                                                                                         OpenERP, Gandhinagar,

Only 5 steps with OpenERP 7.0.
Complete process of new Employee in OpenERP. Employee Payroll complete process in Openerp.

5 Steps to complete process :

Step 1. Create Employee

Step 2. Create Bank Account

Step 3. Create Salary Rule

Step 4. Salary Structure

Step 5. Employee Payslip.

How to work with thunderbird and OpenERP V 7.0

                                                                                                                       Pinakin Nayi
                                                                                                                       OpenERP, Gandhinagar,

Thunderbird what a cool idea.
Mozilla Thunderbird lets you manage multiple POP and IMAP email accounts and reads RSS feeds.
OpenERP provides such a facility which makes you able work with direct Thunderbird. 

I will try to explain how its useful in OpenERP.
- With the use of thunderbird you can direct push a particular mail to particular contacts in OpenERP.
- You can manage your leads, and lots of thing with OpenERP7.

Here i described video that will showing you how to work with OpenERP thunderbird plugin.
Here , How to work with thunderbird and OpenERP V 7.0.


Work with different languages in OpenERP

                                                                                                                          Pinakin Nayi
                                                                                                                          OpenERP, Gandhinagar,

Work with different languages

Working with different languages in OpenERP.  Here i tried to show you how we configure languages as well as translated term. OpenERP default provides translated term but which term you define dynamically enter that you have to translated value.

Here i tried to define video that will show you how to define term.
Work with different languages in OpenERP.


Thursday, 6 December 2012

Install All Modules at once in OpenERP 7.0

                                                                                                           Pinakin Nayi
                                                                                                           OpenERP , Gandhinagar,India.

How to install all modules at once in OpenERP 7.0?
Hello to all,
When we use OpenERP than sometimes its needed to install all modules without selecting one by one and install it.  OpenERP 7 gives you facility so, you can install all modules at once. I think its more useful, am i right?
Here i described some of steps which make 

Step 1 :

Step 2 :

Step 3 :


Wednesday, 28 November 2012

5 features in OpenERP

                                                                                                                          Pinakin Nayi

5 features in OpenERP really nice. Have you tried???

1)  Google docs
    Add attachment to any particular record or any module. You can add google docs.

2)  Import Google meeting,Import Google Contacts
    To import the meeting from your google account(google calandar) to OpenERP Event Management Module.To import the contacts from your google account(google contacts) to OpenERP contacts.

3)  Sign in with Google and Facebook(auth openid)
    You can login in OpenERP with different login id.

4)  Lunch Module
    One of the best and very useful module in OpenERP. To Manage company meals.

5)  Fleet Module
    vehicles-related data of company. You can keep track of vehicle contracts, car-related services and refueling logs. With this module you can easily keep records of your vehicles, assign an employee to them, update the odometers and so on.


How to create Purchase order from Scheduler?

                                                                                                                          Pinakin Nayi

Purchase Order from Scheduler in OpenERP 7

Procurement is most useful in OpenERP, here i described some of steps that show you flow.

Here steps that might be useful to you.

Step 1 : Warehouse
    - Create New Product
    - Update Quantity on Hand
    - Set Sale price and cost price
    - Create Supplier for that particular product
    - Create minimum stock rules for that particular product

Step 2 : Sale Order
    - Create one sale order(select product and set related quantity available)
    - Confirm order

Step 3 : Warehouse
    - Create Delivery order
        - check availability
            - Process
                - Validate

Step 4 : Scheduler
    - Run Scheduler

Step 5 : Purchase Order
    Now , you can look there is one purchase order created with related quantity.


Monday, 22 October 2012

How to Export your bookmarks from Google Chrome?

Pinakin Nayi

Hello To all,

Normally, its needed to export our bookmarks and transfer to our
How to Export your bookmarks from Google Chrome?

Here , a solution this may be useful to you all.

Thursday, 4 October 2012

How to add Linkedin button in your blogger

                                                                                                      Pinakin Nayi
                                                                                                      OpenERP, Info-city,

1.Login to your blogger Dashboard--> Design- -> Edit HTML

2.Click on "Expand Widget Templates"

3.Scroll down to where you see below code:
                         <div class='post-header-line-1'/>

4.Now Copy your "Linkedin share button" code and paste it just below the above code.

NOTE: If you can't find <div class='post-header-line-1'/> in your template, paste your "Linkedin share button" code just before <data:post.body/> .

Code 1 : Vertical Count

<b:if cond='data:blog.pageType == "item"'>
<div style='float:right;margin-left:10px;'>
<script src='' type='text/javascript'/><script data-counter='top' expr:data-url='data:post.url' type='in/share'/>

Sunday, 19 August 2012

How to convert rst2html?

                                                                                                    Pinakin Nayi
                                                                                                    OpenERP, Info-city,

How to convert rst2html??
 Here are code that may be useful to you.
 Before that install python-docutils

Step : 1 
     Import library
                 from docutils.core import publish_string
 Step : 2
     overides :  that is overide the default setting.
                 embed_stylesheet : that is true/false that make to use default stylesheet or not
                 doctitle_xform   : Enable or disable the promotion of a lone top-level section
                                    title to document title (and subsequent section title to
                                    document subtitle promotion;
                 stylesheet_path='./css/voidspace.css', you can set external style sheet

   Examples :
         overrides = dict(embed_stylesheet= False, doctitle_xform= False)
         output = publish_string(source= desc, writer_name= 'html', settings_overrides= overrides)

Html rst tags : 
      put Video in rst :
    .. raw:: html

    <div style="margin-top:10px;">
      <iframe src="" width="427" height="356" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" style="border:1px solid #CCC;border-width:1px 1px 0;margin-bottom:5px" allowfullscreen> </iframe> <div style="margin-bottom:5px"> <strong> <a href="" title="OpenERP CRM &amp; Marketing Screencast" target="_blank">OpenERP CRM &amp; Marketing Screencast</a> </strong> from <strong><a href="" target="_blank"></a></strong> </div>

You can also refer documentation :

And you can also use Online Demo

How to look like : 
 before : 
  After : (apply rst2html)


Monday, 30 July 2012


                                                                                                                           Pinakin Nayi
                                                                                                                           OpenERP Gandhinagar.
Hello Friends ,

   You all are going to search how to use <html> in OpenERP .xml file here is solution that may be useful to you.

In this example i am just changing description of module in html.. (account ,module)

<record id="base.module_account" model="ir.module.module">
            <field name="description"><![CDATA[
                <h2><u>Accounting and Financial Management.</u></h2>
                    This applies to the modules containing modulename_process.xml.
                        <li>General Accounting</ol>
                        <li>Cost/Analytic accounting</ol>
                        <li>Third party accounting</ol>
                        <li>Taxes management</ol>
                        <li>Customer and Supplier Invoices</ol>
                        <li>Bank statements</ol>
                        <li>Reconciliation process by partner</ol>
                    Creates a dashboard for accountants that includes:
                        <li>List of Customer Invoice to Approve</ol>
                        <li>Company Analysis</ol>
                        <li>Graph of Treasury</ol>
                    <p>The processes like maintaining of general ledger is done through the defined financial Journals (entry move line orgrouping is maintained through journal) for a particular
financial year and for preparation of vouchers there is a module named account_voucher.</p>

and server/trunk/openerp/addons/base/module/module_view.xml

<page string="Description">
                            <field name="description" widget="text_html"/>


Monday, 23 July 2012

Deleted Records in OpenERP

                                                                                                                            Pinakin Nayi
                                                                                                                            OpenERP, Gandhinagar.

Something you need to keep in mind is how OpenERP “deletes” its records. 

It does not physically remove them. 

It just marks them as deleted

And it does so with the active field in the table. 

This field, which happens to be a boolean field, if true indicates that the record is not deleted. 

Otherwise you should not take the record into account in your queries.


Friday, 20 July 2012

Debugging your OpenERP module

                                                                                                                            Pinakin Nayi
                                                                                                                            OpenERP, Gandhinagar.

Debugging your OpenERP modules is quite straightforward, as long as you know basic Python programming. Just insert the following line in your
import pdb;pdb.set_trace()
Then restart your openerp-server with the –debugoption
# openerp-server –debug
Then monitor your server console. You will see your server stop and show you a command line prompt where you will be able to debug your program.
You will find further information in the Python documentation website.


Tuesday, 17 July 2012

Event Management Module

Hello Friends ,

         You all are going to search "Event Management Module" or "Event Management System" documentation or .ppt or Diagram for "EMM". I will provide you all this.

Mail me for getting documentation or .ppt. ( ).

Pinakin Nayi


Secure your ubuntu

                                                                                                                          Pinakin Nayi
                                                                                                                          OpenERP , Gandhinagar.

Quick post of a script worth using. If your openerp-server is running on a Linux server, this server should be secured. Linux is a more secure server than Windows, but still is vulnerable to attacks. If you are new to the security field in Linux, there is a tool you should try, Bastille Unix. If you are using an
Ubuntu distribution, you can install this tool with the following command:
# sudo apt-get install bastille
After running the command bastille, you will see a wizard like window interface which will guide you through the different steps of hardening your system. These steps involve setting file permissions, disabling FTP,Firewall, Printing, disabling unnecesary services and accounts. Not only this is a very good tutorial on Linux security, but also a tool for hardening your system.
Be aware that your security obligations do not end here, this is just a very good first step.

Wednesday, 11 July 2012

Graph Draw

                                                                                                        Pinakin Nayi
                                                                                                        OpenERP, Gandhinagar
                                                                                                        Mo. 08460643746

Hello Friends ,

You can use it, as per your requirement that will draw graph.

  You all are going to search a "How to draw Graph using java Script or Jquery".

I hope this will be helpful to you all.

Primarily just create with simple .html file.

Requirements :
                     sigma.min.js   you can download it from

            <script src="js/sigma.min.js"></script>
   <div class="container">
        <div class="sigma-parent" id="sigma-example-parent">
                <p class="sigma-expand" id="sigma-example">
    <script type="text/javascript">
var sigRoot = document.getElementById('sigma-example');
         var sigInst = sigma.init(sigRoot);
         node1 = {label: 'Hello', color: '#ff0000', size:5, x:1, y:3};
         node2 = {label: 'World', color: '#bb0000', size:10,x:2, y:2};
         sigInst.addNode('hello', node1);
        sigInst.addNode('world', node2);
        sigInst.addEdge('hello_world','hello','world', {size:2, label:"Hello World"});
                  defaultLabelColor: '#ccc',
                  font: 'Arial',
                  edgeColor: 'source',
                  defaultEdgeType: 'curve'
                  minNodeSize: 1,
                  maxNodeSize: 10

<style type="text/css">
  /* sigma.js context : */
  .sigma-parent {
    position: relative;
    border-radius: 4px;
    -moz-border-radius: 4px;
    -webkit-border-radius: 4px;
    height: 500px;
  .sigma-expand {
    position: absolute;
    width: 30%;
    height: 100%;
    top: 0;
    left: 0;
    padding-bottom: 8px;
    padding-top: 12px;



Monday, 9 July 2012


Outlook Plugin of OpenERP 

Sometimes its needed to how to install plugin , we have plugin but we don't know the way from where we install it, So, i hope this will be useful to you .  OpenERP.

-  First you need MSI file of the plugin to install this file you can find from the below path of your    
      - addons
                     -  For 32 bit machine addons/plugin_outlook/static/openerp-outlook-plugin/OpenERPOutlookPluginSetup32.msi * 
                     -  For 64 bit machine addons/plugin_outlook/static/openerp-outlook-plugin/OpenERPOutlookPluginSetup32.msi 

- Double click on msi file and click on next next and finish as you install exe in windows. 
    Once it is installed, If office 2007 You can see the OpenERP menu. 
    If office 2010 You can see the menu : Addin -> OpenERP


Thursday, 21 June 2012

Indian Culture

OpenERP Mail Server Setting

                                                                                                                       Pinakin Nayi
                                                                                                                       Info-city, Gandhinagar.

OpenERP Mail Configuration.

OpenERP Outgoing Mail Server Setting..

       You all are going to search how to set OpenERP Outgoing mail server setting. I hope these are helpful to you.


Thursday, 3 May 2012

OpenERP Security issue

OpenERP Security its too cool..
Security is the main issue in any organization or firm because without it, its became handicapped . 
So, its needed in OpenERP to define security means access rules as well as access rights that will restrict the user to use particular.

Here i described one security file that will describe the groups.

I hope its useful to you all. 
Security and implies_ids

<?xml version="1.0" encoding="utf-8"?>
    <data noupdate="1">
    <record id="base.group_library_user" model="res.groups">
        <field name="name">Library User</field>
    <record id="base.group_library_librarian" model="res.groups">
        <field name="name">Librarian</field>
    <record id="base.group_lib_resuser_employee" model="res.groups">
        <field name="name">Employees</field>
        <field name="category_id" ref="base.module_category_human_resources"/>
        <field name="implied_ids" eval="[(4, ref('base.group_library_user'))]"/>