2

Has anyone looked into merging several pre-2.6 relationship fields into a 2.6+ multiple relationship field? For example, if I have a book store where each book can have multiple authors and currently have book_author, book_author2, and book_author3. This is clearly ugly and horrible, so I would like to just have book_authors, which would contain the related authors from any of the original three fields that was set.

I'm sure it could be done with enough SQL magicry, but I'm hoping someone has already figured out a good system for it.

3
+50

If you look within the table structure for the relationship, the relationship data is stored within database table exp_relationships so only we need to update this table for the field_id. The parent_id and child_id are already in same format required for multi-relationship.

You need to follow these steps: 1) Make the "book_author" as multi-relations by checking "Allow multiple relations?" from the field settings.

2) book_author2 and book_author3 are no longer needed in relationship so exp_relationships database table need to be updated accordingly by SQL:

UPDATE exp_relationships LEFT JOIN exp_channel_titles 
ON exp_relationships.parent_id=exp_channel_titles.entry_id
SET exp_relationships.field_id=[book_author FIELD ID]
WHERE exp_channel_titles.channel_id=[CHANNEL ID]

You might update the [book_author FIELD ID] and [CHANNEL ID] according to your preference.

Please Note: I didn't try it yet but after seeing all the table structure for multi-relationship, it would work perfectly.

Once everything worked perfectly you can delete fields book_author2 and book_author3.

| improve this answer | |
  • This worked great, although I added a second condition to the join (2nd line) for cases where there are more than one relationship field in a field group: "AND exp_relationships.field_id=[book_author2 FIELD ID]" – Eli Van Zoeren May 19 '13 at 18:46
  • That's great .... – Bhashkar Yadav May 20 '13 at 2:53
  • This worked wonders. I used the modified version @EliVanZoeren posted in the comments and simply deleted the old fields afterwards. – jsuissa Sep 15 '13 at 11:27
-1

I think you would want to look at Matrix + Playa add-ons. You could add a Matrix field book_authors where each row is a Playa field type related to the author channel entries.

Or if each author is not a channel entry but instead more of a list, you could use Low Variables field type as a multi-select field (of author info created in a LV variable group) in your Matrix rows.

| improve this answer | |
  • 1
    EE 2.6 includes a multiple-relationship fieldtype natively (similar to Playa). The question is not how to structure the fields in the future, but how to convert existing data to the new format. – Eli Van Zoeren May 7 '13 at 3:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.