I'm trying to import events including their tickets in Odoo 12 CE .
First I created a product which is an event-ticket (I created this manuelly for testing).
And then I tried to import an event, which links to this product for making the connection to the ticket (the ticket's product id is in the last column):
name | date_end | seats_min | date_start | seats_max | event_type_id/id | user_id/id | event_ticket_ids/product_id/id |
NameOfTest_event | 2020-04-15 15:00:00 | 2 | 2020-04-22 10:00:00 | 15 | __export__.event_type_8_7bdd61d9 | __export__.res_users_6_65a45dc7 | __export__.product_template_24_4d96eb18 |
And then testing the import I get the following error:
null value in column "name" violates not-null constraint DETAIL: Failing row contains (25, null, null, 21, 24, null, null, limited, null, null, null, null, null, 6, 2020-01-14 10:32:41.482955, 6, 2020-01-14 10:32:41.482955). in line 2
I tried to import the event without the ticket (all columns except the last one) and this worked (only event, without ticket), so the other columns seem to be sufficient for the event.
But there seems to be an information missing to create also the link to the event-ticket-product.
Does anybody have an idea, which information I should add - or (if this is not possible in event-import) how I can import the link event-ticket-product separatly?
Thank you!
Anja