Replacing Entries: Updating Playa/Wygwam from {page_x} to {page_y}?

Question

Let's say you've got a bunch of entries in the "Original Generic Page" channel, which are getting replaced by pages with the same URLs in the "New Generic Page" channel. Assume also that entries are linked to one another in various ways (anchors in Wygwam fields; relationships via Playa fields, mainly).

For example, when the old "About" page (entry 5 in the Original Generic Page channel) is closed and replaced with the new one (entry 2000 in the New Generic Page channel), is there a good method for updating all of the other entries that previously referenced entry 5 to point to entry 2000 instead?

This change-over isn't happening all at once, and I suspect it'll be ongoing for quite a while as different channels/layouts are introduced over time.

We're using Structure and Publisher (site is multi-lingual) to possibly complicate things further.

Thoughts, any? Are there any add-ons that can help manage this?

Answer 1

Since Publisher is installed it just means whatever is updated in exp_channel_data also needs to occur in exp_publisher_data for each corresponding entry. Same for exp_sites (site_pages column) and exp_publisher_site_pages.

Are all the entries Structure based? If they are, and they all share the same URL, then it means you just need to update the entry_ids in the site_pages array. So you may need to create an array map of all the old entry_ids to the new entry_ids, and iterate over the site_pages array and make the updates to that array, then save it back to the database.