Skip to Content
This question has been flagged
modulesdatabase
2 Replies
9865 Views
Avatar
Daniele Morelli

Hi, i am using odoo11.

I'd like to make a module that, when installed, simply adds some records to the database. For example, it should add some lines to the res_partner table (the content of those lines would simply be hardcoded in the module itself).

How can I accomplish that? My main problem is that i don't exactly know where to write my code so that it is executed during the installation of the module...

Thanks for any help 

Avatar
Discard
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Best Answer

Hi Daniele,

You can do this by creating an XML file that contains the data. When you add this XML file to the __manifest__.py file it will be loaded when installing (or updating) the Odoo module. An example of a data record:

<?xml version="1.0" ?>
<odoo>
    <record id="some_record" model="your.model">
        <field name="name">Name of the record</field>
    </record>
</odoo>

You can just load the XML file in the __manifest__ in order to have the data available when installing the app:

# always loaded
    'data': [
        'data/your_data_file.xml',
    ]

You can also find examples of this in the official Odoo code, for example in the app "projects".
Example of data: https://github.com/odoo/odoo/blob/11.0/addons/project/data/project_data.xml  
Example of loading the data: https://github.com/odoo/odoo/blob/e0b1718e4a1ab641f56fef242ae1d6c13254b53c/addons/project/__manifest__.py#L35

Regards,
Yenthe

Avatar
Discard
Daniele Morelli
Author

Thank you very much for your kind answer!

Yenthe Van Ginneken (Mainframe Monkey)

You're welcome, best of luck!

Avatar
subbarao
Best Answer

Hello Daniele,

By using XML we can do it, see the following example sale order import with two lines while install the module.

<record id="sale_order_1" model="sale.order">

            <field name="partner_id" ref="base.res_partner_2"/>

            <field name="partner_invoice_id" ref="base.res_partner_2"/>

            <field name="partner_shipping_id" ref="base.res_partner_2"/>

            <field name="user_id" ref="base.user_demo"/>

            <field name="pricelist_id" ref="product.list0"/>

            <field name="team_id" ref="sales_team.team_sales_department"/>

            <field name="date_order" eval="(DateTime.today() - relativedelta(months=1)).strftime('%Y-%m-%d %H:%M')"/>

        </record>


        <record id="sale_order_line_1" model="sale.order.line">

            <field name="order_id" ref="sale_order_1"/>

            <field name="name">Laptop E5023</field>

            <field name="product_id" ref="product.product_product_25"/>

            <field name="product_uom_qty">3</field>

            <field name="product_uom" ref="product.product_uom_unit"/>

            <field name="price_unit">2950.00</field>

        </record>


        <record id="sale_order_line_2" model="sale.order.line">

            <field name="order_id" ref="sale_order_1"/>

            <field name="name">Pen drive, 16GB</field>

            <field name="product_id" ref="product.product_product_30"/>

            <field name="product_uom_qty">5</field>

            <field name="product_uom" ref="product.product_uom_unit"/>

            <field name="price_unit">145.00</field>

        </record>

Avatar
Discard
Daniele Morelli
Author

Thanks!

Related Posts Replies Views Activity
Uninstall a module without losing info in the DB
modules database uninstall
Avatar
Avatar
1
Mar 15
6968
how to get rid of test data without loosing installed Modules?
modules database data
Avatar
Avatar
1
Mar 15
3337
Setup Odoo with specific database
database
Avatar
Avatar
2
Nov 24
1862
database locked
database
Avatar
Avatar
Avatar
2
Oct 24
345
my data base is locked
database
Avatar
Avatar
2
Aug 24
362