I have a CSV as below:
chapter, headings, sentences 1, heading one, "1,2,3,4,5,6,7" 2, heading two, "1,2,3,4,5" 2, heading three, "6,7,8"
I want to migrate it to Drupal. The heading columns have to be migrated to the taxonomy heading. Once a heading is added, it should loop through the value in sentences and update the sentence entity by adding a reference to it.
The entity to be updated should be loaded matching the sentence column and chapter column. The sentences entity is already pre-populated with data.
Fields in each entity:
Taxonomy: heading(string) Entity(sentences): sentence_no(int) heading_reference(entity_reference) sentence(string) chapter_no(entity_reference)
I tried this tutorial. While the link is straight forward it doesn't really help my need.
I am ok if I migrate to D7 or D8. However D8 is preferred.