How to import activities relied to opportunities on the CRM ?

Question

Hello Odoo users,
I have already uploaded my customers, contacts and opportunities on the CRM with Excel files but I have a problem when I want to upload an activities list. My problem is about the due date which not works.
When I upload my Excel file, the due date column send me this error : null value in column "res_model_id" violates not-null constraint DETAIL: Failing row contains (2714, 274365, null, null, null, null, null, null, null, 2019-06-15, f, 2, 2, null, null, 1, 2019-06-14 10:05:38

faOtools · Answer

Each activity has a linked document - e.g. 'Opportunity 1'. It is a requirement.
This link is done through 2 fields 'res_id' (integer) & 'res_model_id' (many2one for ir.model). Thus, when you import you should have those columns.
In res_id you should indicate just a number (an id of related customer, opportunity, etc.). Look at your address line when you open a related document (&id=*197*)
In res_model_id you should either indicate an id of this model. It might be also foundin the address line i

Related Posts	Replies	Views
Automated action how to copy custom field value from another field opportunities crm	1 Dec 22	1604
Show reminders in calendar calendar activities	0 Dec 21	3884
how can i see the leads which are converted to opportunity opportunities crm	0 Mar 15	3100
Lead Generation Solved opportunities crm leads	3 May 24	1721
How to limit access rights to particular menu items ? opportunities crm leads	3 Dec 22	22188

This question has been flagged

Enjoying the discussion? Don't just read, join in!