Skip to Content
This question has been flagged
modulesdatabase
2 Replies
12884 Rodiniai
Portretas
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 

Portretas
Atmesti
Portretas
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

Portretas
Atmesti
Daniele Morelli
Autorius

Thank you very much for your kind answer!

Yenthe Van Ginneken (Mainframe Monkey)

You're welcome, best of luck!

Portretas
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>

Portretas
Atmesti
Daniele Morelli
Autorius

Thanks!

Related Posts Replies Rodiniai Veikla
Uninstall a module without losing info in the DB
modules database uninstall
Portretas
Portretas
1
kov. 15
9312
how to get rid of test data without loosing installed Modules?
modules database data
Portretas
Portretas
1
kov. 15
5486
Nuevo menú en "CRM"
modules
Portretas
Portretas
Portretas
Portretas
3
liep. 25
2769
Allow Access to update module
modules
Portretas
Portretas
Portretas
Portretas
3
geg. 25
4642
Database disappeared from list after activating Google Oauth for administrator
database
Portretas
0
liep. 25
2288