Hi Alina,
I would think about trying to format the excel sheet to have one row per record. This makes it easier to ingest. For example, in the row for “Company A”, you have 8 objects represented (the Tasks) and some extra (implicit) logic about associating those records to Department A and Department B. Instead, I’d think about creating an import file like this:
Importance | Difficulty | Department | Company
---------- | ---------- | ---------- | -------
2 | 1 | A | A
1 | 3 | A | A
2 | 1 | A | A
2 | 4 | A | A
2 | 1 | B | A
Here, each row defines a Task, and then you can tell which Department and which Company to assign it to based on the values in those columns.
Hope this helps!
Hi
Can you modify your domain model association if yes I will suggest you to modify it as given below which will further simplify this.
company1< --------*department1<---------*task