This question has been flagged
1 Reply
3997 Views
exporttagsmany2manymany2many_tags
Avatar
Josef

Hi, 


I want to export my contacts (View: res.partner.tree) for an external program. 

M contacts are categorized with tags. Most of my contacts have more than one tag. But if I export my data with the tags, (Field: category_id --> many2many field) I have several lines in my excel sheet, but I need only one line with all information. 

I guess this is the standard Odoo behavior. If there is more than 1 field then Odoo will automatically create a new line.


For example:

At the moment the export is:  

Contactname, email,  Tag1

                                   , Tag2

                                   , Tag3

I need 

Contactname, email, Tag 1 Tag2 Tag3


Is there a workaround I can use?

Avatar
Discard
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello Josef,


If you are using the odoo's base export then select "Tags/External ID" for exporting the tags alongside other partner details.


If you will select "Tags/External ID"  the tags will be added in the sheet in comma separated format. 


 But for choosing "Tags/External ID" you need to make sure that your old database(from you are exporting) and new database(in which you will import) have the same external_ids for tags field. 


See the example below:

Regards,




Email:     odoo@aktivsoftware.com  

Skype: kalpeshmaheshwari

   

Avatar
Discard
Josef
Author

I tried it, it works. Thanks for your help. It is a pitty that the export not works with the tag names.