Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
4918 Zobrazení

I have imported multiple contacts and sub-contacts (e.g. invoice address, delivery address,..) into ODOO. 

I realised that my import had errors and need to delete certain invoice and delivery addresses. However, i can only do through lookup's in Excel. 

Is there any possibility to export the records in .csv and mark the External ID i want to delete with the import functionality ? 

Avatar
Zrušit

I made a custom field on the list view of contacts with created on date, then created custom filter for created on date and deleted them by multiselect checkbox. You need studio for this method. 

Nejlepší odpověď

You can not delete the records while importing, but what you can do is do the lookup in Excel and add a column "Active" to your spreadsheet. For the incorrect/duplicate records set this to false. When you import the file these records will be archived in Odoo and you won't see them again unless you specifically search for archived contacts.

If you really want to delete the records, you could overwrite the name of the contact in Excel to, for example, "Delete 1", "Delete 2", etc. Import the file and then search in Odoo in Contacts app for "Delete", select all records in list view and click Action > Delete.

When you export the contacts from Odoo make sure you have selected "i want to update data" so that the first column contains the external ID of the record in Odoo. If you then import the data, the existing records will be overwritten.

Avatar
Zrušit
Nejlepší odpověď

As a footnote to Mr. Mens' response, at least in Odoo Ent. 17, instead of True and False, you need to use 1 and 0.  His answer helped me!!

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
lis 24
1696
1
lis 24
2216
1
říj 23
2906
3
pro 23
20797
0
kvě 21
7655