Migrate past board agendas from board site to cpl.org
As a part of the board-agendas migration of not just the minutes, but the board agendas themselves, they need to be migrated from where they're stored on board.cpl.org (and that file path as well)
This ticket is for the actual migration itself.
Functions:
- searchable archive of the board agendas (and only the board agendas).
Tentative scope:
-
classify them as post_type cpl_agenda
-
the contents of the agenda (written as html, stored in the drupal database in the field_data_body table) will be migrated to the post_content table within WordPress
-
- Sub-tasks: do a test run migration of 1-4 agendas; Stakeholders are not too concerned about the -
determine if the content of the agenda is at least presentable, ; then write additional CSS needs to be written;unfortunately, it appears that the lists were not written with semantic HTML; still valid html (they were written with paragraphs and line breaks); don't worry about going back to remediate all of them; if we receive a request to remediate them, I will do it then. The content is still readable. -
triple-check to ensure that no paths are https://board.cpl.org/files (they should already all be https://cpl.org/board); I did this in the fall when we moved to big scoots and in preparation of the migration) (UPDATE: there were several, but they were not cpl_agenda posts, but agendas of post type of post that I'll delete because they don't have attachments to them and were already imported in the import. -
complete the migration -
use wp-cli search and replace to update the file paths in the cpl_agenda folder; I have the full command already written somewhere again... UPDATE wp_dtex_posts SET post_content = REPLACE(post_content, 'cpl.org/board/files/', 'cpl.org/wp-content/uploads/board/') WHERE post_status = 'publish' and post_type = 'cpl_agenda';
Additional tasks are made as issues with board-agendas label
How I'm doing it: light modification of the plugin;
issues:
the page titles for the agendas between the CPL agendas (since 2020) are slightly different: in 90+% of cases, they are "Agenda - Month MM, YYYY" ;
for 2020, we've settled on: November 17, 2020 Joint Finance & Human Resources Committee Meeting Agenda
and October 15, 2020 Board of Trustees Regular Meeting Agenda
Will that make a difference in the search results that it'll just say the agenda.
These imported agendas won't have any of custom_fields filled in but that's ok: there were 3 and their uses:
- the file box provided an easier way assisting in the uploading of related files so the user wouldn't have to use the media uploader: (not quite relevant here)
- the date field which is currently used to generate a uniform excerpt on the front page - custom-post-agendas#5 (closed)
- the meeting type filed, used for the custom excerpt on the frontpage and on https://cpl.org/board-agendas ; if need be, I'd have to go fill it in for the past agendas, but really not necessary)
I don't think adding the meeting date or meeting type into custom fields will really add much value to the users; since the search results will be able to provide the date, thanks to the title; and the search results will fingers crossed contain the portion of the post_content that contains the search term
holding off on the migration until Monday since I'm off tomorrow.
linger questions: Should do #311 (closed) - before or after the migration of the existing board agendas