I've checked that we have all the expected fields for FY 26/27 in CiviCRM. The only one that isn't there compared to previous years is Is FY 2025-2026 donor, but that seems to have been removed from our code, so I assume we don't need it any more (we can easily use a FY total field > 0 for the same result).
For Acoustic, we can add both_funds_usd_total_fy2627 before July 1.
Change #1276052 had a related patch set uploaded (by Lars SG; author: Lars SG):
[wikimedia/fundraising/tools@master] Add both_funds_usd_total_fy2627 to Acoustic export
Change #1276052 merged by Eileen:
[wikimedia/fundraising/tools@master] Add both_funds_usd_total_fy2627 to Acoustic export
Change #1276058 had a related patch set uploaded (by Lars SG; author: Lars SG):
[wikimedia/fundraising/crm@master] Remove FY2018_2019 fields from CiviCRM
I have disabled the three FY 2018_2019 (and one FY 2017-2018) fields in Civi as well and updated code to stop updating them, these can be deleted after updating triggers in the maintenance window.
Change #1276058 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Remove FY2018_2019 fields from CiviCRM
@Eileenmcnaughton it is now, though it will need some doing in maintenance week also.
@Dwisehaupt or @Jgreen can you run these please on silverpop:
ALTER TABLE silverpop_export_stat
DROP COLUMN all_funds_total_2018_2019,
ADD COLUMN all_funds_total_2026_2027 DECIMAL(20, 2) AFTER all_funds_total_2025_2026;
ALTER TABLE silverpop_export
DROP COLUMN all_funds_total_2018_2019,
ADD COLUMN all_funds_total_2026_2027 DECIMAL(20, 2) AFTER all_funds_total_2025_2026;Done.
MariaDB [silverpop]> ALTER TABLE silverpop_export_stat
-> DROP COLUMN all_funds_total_2018_2019,
-> ADD COLUMN all_funds_total_2026_2027 DECIMAL(20, 2) AFTER all_funds_total_2025_2026;
Query OK, 0 rows affected (0.018 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [silverpop]> describe silverpop_export_stat;
+--------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------+------------------+------+-----+---------+-------+
| email | varchar(255) | NO | PRI | NULL | |
| all_funds_latest_donation_date | datetime | YES | MUL | NULL | |
| all_funds_total_2019_2020 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2020_2021 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2021_2022 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2022_2023 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2023_2024 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2024_2025 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2025_2026 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2026_2027 | decimal(20,2) | YES | | NULL | |
| all_funds_lifetime_usd_total | decimal(20,2) | YES | | NULL | |
| foundation_donation_count | int(10) unsigned | NO | | 0 | |
| foundation_first_donation_date | datetime | YES | | NULL | |
| foundation_highest_usd_amount | decimal(20,2) | YES | | NULL | |
| donor_segment_id | decimal(20,2) | YES | | NULL | |
| donor_status_bin | int(10) unsigned | YES | | NULL | |
| endowment_first_donation_date | datetime | YES | | NULL | |
| endowment_number_donations | int(10) unsigned | NO | | 0 | |
| endowment_highest_usd_amount | decimal(20,2) | YES | MUL | NULL | |
+--------------------------------+------------------+------+-----+---------+-------+
19 rows in set (0.001 sec)MariaDB [silverpop]> ALTER TABLE silverpop_export
-> DROP COLUMN all_funds_total_2018_2019,
-> ADD COLUMN all_funds_total_2026_2027 DECIMAL(20, 2) AFTER all_funds_total_2025_2026;
Query OK, 0 rows affected (0.018 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [silverpop]> describe silverpop_export;
+---------------------------------------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------------------------------+---------------------+------+-----+---------+-------+
| id | int(10) unsigned | NO | PRI | NULL | |
| modified_date | datetime | YES | MUL | NULL | |
| contact_id | int(10) unsigned | YES | UNI | NULL | |
| contact_hash | varchar(32) | YES | | NULL | |
| first_name | varchar(128) | YES | | NULL | |
| last_name | varchar(128) | YES | | NULL | |
| preferred_language | varchar(12) | YES | | NULL | |
| email | varchar(255) | YES | UNI | NULL | |
| opted_in | tinyint(1) | YES | | NULL | |
| opted_out | tinyint(1) | YES | | NULL | |
| do_not_solicit | tinyint(1) | YES | | NULL | |
| sms_consent | tinyint(1) | YES | | NULL | |
| employer_id | int(10) unsigned | YES | | NULL | |
| employer_name | varchar(255) | YES | | NULL | |
| direct_mail_latest_appeal | varchar(255) | YES | | NULL | |
| matching_gifts_provider_info_url | varchar(255) | YES | | NULL | |
| guide_url | varchar(255) | YES | | NULL | |
| online_form_url | varchar(255) | YES | | NULL | |
| foundation_has_recurred_donation | tinyint(1) | YES | | NULL | |
| foundation_has_active_recurring_donation | tinyint(1) | YES | | NULL | |
| foundation_recurring_first_donation_date | datetime | YES | | NULL | |
| foundation_recurring_latest_donation_date | datetime | YES | | NULL | |
| foundation_recurring_active_count | tinyint(3) unsigned | YES | | NULL | |
| foundation_recurring_latest_contribution_recur_id | int(10) | YES | | NULL | |
| recurring_has_upgrade_activity | tinyint(1) | YES | | NULL | |
| foundation_highest_usd_amount | decimal(20,2) | YES | | NULL | |
| foundation_highest_native_amount | decimal(20,2) | YES | | NULL | |
| foundation_highest_native_currency | varchar(3) | YES | | NULL | |
| foundation_highest_donation_date | datetime | YES | | NULL | |
| all_funds_lifetime_usd_total | decimal(20,2) | YES | | NULL | |
| donation_count | int(10) unsigned | NO | | 0 | |
| all_funds_total_2019_2020 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2020_2021 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2021_2022 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2022_2023 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2023_2024 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2024_2025 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2025_2026 | decimal(20,2) | YES | | NULL | |
| all_funds_total_2026_2027 | decimal(20,2) | YES | | NULL | |
| endowment_first_donation_date | datetime | YES | | NULL | |
| endowment_number_donations | int(10) unsigned | NO | | 0 | |
| endowment_highest_usd_amount | decimal(20,2) | YES | | NULL | |
| latest_currency | varchar(3) | YES | | NULL | |
| latest_currency_symbol | varchar(8) | YES | | NULL | |
| latest_native_amount | decimal(20,2) | YES | | NULL | |
| all_funds_latest_donation_date | datetime | YES | | NULL | |
| foundation_first_donation_date | datetime | YES | | NULL | |
| city | varchar(128) | YES | | NULL | |
| country | varchar(2) | YES | | NULL | |
| state | varchar(64) | YES | | NULL | |
| postal_code | varchar(128) | YES | | NULL | |
| donor_segment_id | int(11) | YES | | NULL | |
| donor_status_bin | int(10) unsigned | YES | | NULL | |
| double_opt_in_activity | tinyint(1) | YES | | 0 | |
| is_eligible_for_donor_portal | tinyint(1) | YES | | NULL | |
+---------------------------------------------------+---------------------+------+-----+---------+-------+
55 rows in set (0.002 sec)