Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.When importing matching questions via a CSV file there is a major bug.
The format follows like this, let's assume a | delimiter to help remove some confusion.
guid|title|body|match1|match2|match3|match4|match5
Then within each match, the format is:
question,answer,feedback
So one full row would be like this
1|example title|example body|match1 question,match1 answer,match1 feedback|match2 question,match2 answer,match2 feedback|match3 question,match3 answer,match3 feedback|match4 question,match4 answer,match4 feedback|match5 question,match5 answer,match5 feedback
However, if you want to have commas in your question, answer or feedback, everything gets screwed up.
Example for a match column
Here is the question, and a comma in the question, here is supposed to be the answer, and here is supposed to be the feedback.
This returns like this:
Question: Here is the question
Answer: and a comma in the question
Feedback: here is supposed to be the answer
Adding quotes around them doesn't appear to make a difference.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | qq_import_match.png | 49.8 KB | ganesan g |
Comments
Comment #1
ganesan g CreditAttribution: ganesan g commented@vand I just copy paste the format which you posted here to csv file and changed delimeter to "|". Then I imported the nodes. It correctly places the question , answer and feedback. See the attached snapshot.
I think you went somewhere wrong while importing csv file.
If you use delimiter ',' and if you use the same for question, answer, feedback, you should put question, answer and feedback around double quotes. The format should be like this.