Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

[SOLVED] How to add values to a column which belongs to an existing table from a XML file (config) [v7]?

By
Juan Formoso
on 10/10/14, 7:14 AM 1,143 views

Hello! I created a new table called res.country.region and added a column in res.country.state called region_id, to know to which region a state belongs to.

I also created a module which add some data to the new table res.country.region. I do this through an XML file, and it works well.

But now, I am trying to add the respective region_id to several states of res.country.state. which I am pretty sure that exist. How can I do this through a XML file?

This is an example of a XML record I used to fill in the res.country.region table:

<record model='res.country.region' id='myregionid01'>
    <field name='name'>My region</field>
    <field name='code'>MR</field>
    <field name="country_id" ref="base.es"/>  <!-- I copied this line from other file, and it points to the country, but I do not know how it does -->
</record>

This is an example of what I have now:

        <record model='res.country.state' id='mystateid01'> <!-- How can I point here to an existing state in res.country.state to fill only its empty column region_id? -->
            <field name="region_id" ref="¿?"/>
        </record>

 

1

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 10/10/14, 7:18 AM

The default syntax for this is "module_name.xml_record_id". 

So for example if your module is called region_extend and you have multiple records in your XML for regions, you will need to check for those ids. If you have region catalonia named like <record id="cata"/>, then you reference should be like so:

<field name="region_id" ref="region_extend.cata"/>

Hope this helps.

[EDIT]

If I understand you correctly, you already have records for countries as well as regions. These were all added by hand, and now you want to link them? In that case using the importer might help.

Take the following steps:

  1. Export the list of regions (go to regions list view, select all records and press "Export" to export as CSV). Make sure to export their ID at least.
  2. Export a list of countries in the same way, make sure to export the columns id and region_id at least, next to the purple coloured fields that are mandatory!
  3. Open in Excel or equivalent software and copy-paste the Id's from the region export to the country-export under the region_id column of the appropriate country.
  4. Import the country list.

Once imported, all the existing id's (aka countries) will be updated and only completely new countries will be added.

Hope this helps you out a little.

Thank you! But if the record was introduced by hand (not through XML), does it have an xml_id?

Juan Formoso
on 10/10/14, 7:39 AM

Apart from that, if I type in ref my_module_name.my_state_xml_id, it works great (with states I introduced through XML files). But the problem is the integrity error I get after, because it tells me that I am introducing null values for code and name fields (which are mandatory), and in fact that's true, because supposely they are already filled in, and I am only adding the region_id value.

Juan Formoso
on 10/10/14, 7:49 AM

I edited my previous answer. Furthermore, handmade records never have an XML id and are therefor not approachable by said Id.

Ludo - Neobis
on 10/10/14, 9:47 AM

Your code will create new state, so it's required to fill the required field. Unless mystateid01 already defined.

Ben Bernard
on 10/10/14, 10:18 AM

@Ludo - Neobis Thank you so much for your patience. I am reading myself and I was not clear at all with my comment because I asked other doubt I had. I am going to explain the main problem better: I installed a module (made by other people) which inserts several states on my database. I created other module which creates the res_country_region table and fills it with several regions, in addition to add a column called region_id in the table res_country_state. Now, in res_country_state, I have the states (the ones introduced by the module I did not create) with their column region_id empty. And I want to fill in with their respectives regions through a XML file, if this is possible.

Juan Formoso
on 10/10/14, 10:23 AM

@Ben Bernard But "mystateid01" is the xml_id, not the table id, isn't it? I write there "mystateid01" because that is the xml_id of the state I want to update. The XML file which introduced that state on the database had "mystateid01" as xml_id.

Juan Formoso
on 10/10/14, 10:29 AM

@Juan Then you need to add the module name that introduced "mystateid01", for example if it's "custom_mod". Then the id should be "custom_mod.mystateid01".

Ben Bernard
on 10/10/14, 10:54 AM

@Ben Bernard Thank youuuuuuuuuuuuuuuuuuuuu!!!!!!!!!!!!!!!! I do not have enough karma to convert your comment into an answer, but if you want answer the question and I'll mark it as the right one. Thank you a lot!!!!

Juan Formoso
on 10/10/14, 12:04 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/10/14, 7:14 AM
Seen: 1143 times
Last updated: 3/16/15, 8:10 AM