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.