function sync_bdcs() { try { $year = get_option('snowflake_sync_year'); $quarter = get_option('snowflake_sync_quarter'); add_snowflake_log('bdcs', "Debug: Fetched year={$year}, quarter={$quarter}"); if (!$year || !$quarter) { add_snowflake_log('bdcs', 'Year or Quarter not set in settings.', true); return; } $calendar_filter = $year . '-Q' . $quarter; add_snowflake_log('bdcs', "Debug: Generated calendar_filter = {$calendar_filter}"); $rows = fetch_from_snowflake("SELECT * FROM BLUE_VAULT.BDC.BDC_MASTER WHERE YEAR_AND_QUARTER = '{$calendar_filter}'"); if (!is_array($rows)) { add_snowflake_log('bdcs', "Returned result is not an array", true); return; } $count = 0; $sponsors_synced = false; foreach ($rows as $row) { $title = $row['BDC_NAME'] ?? ''; if (!$title) { add_snowflake_log('bdcs', "Missing BDC_NAME in row, skipped", true); continue; } $existing = get_page_by_title($title, OBJECT, 'bdcs'); $post_id = $existing ? $existing->ID : wp_insert_post([ 'post_type' => 'bdcs', 'post_status' => 'publish', 'post_title' => $title, 'post_name' => sanitize_title($title), 'post_date' => current_time('mysql'), ]); if (!$post_id || is_wp_error($post_id)) { add_snowflake_log('bdcs', "Failed to insert post for {$title}", true); continue; } update_post_meta($post_id, 'year', $row['YEAR'] ?? ''); update_post_meta($post_id, 'quarter', $row['QUARTER'] ?? ''); update_post_meta($post_id, 'year_and_quarter', $row['YEAR_AND_QUARTER'] ?? ''); update_post_meta($post_id, 'short_name__c', $row['BDC'] ?? ''); update_post_meta($post_id, 'cik_number__c', $row['CIK_NUMBER'] ?? ''); update_post_meta($post_id, 'fund_id__c', $row['FUND_ID'] ?? ''); update_post_meta($post_id, 'program_type__c', $row['PROGRAM_TYPE'] ?? ''); update_post_meta($post_id, 'offering_status__c', $row['OFFERING_STATUS'] ?? ''); $sponsor_name = $row['SPONSOR_NAME'] ?? ''; if ($sponsor_name) { $sponsor_post = get_page_by_title($sponsor_name, OBJECT, 'sponsor'); if (!$sponsor_post && !$sponsors_synced) { sync_sponsors(); $sponsors_synced = true; $sponsor_post = get_page_by_title($sponsor_name, OBJECT, 'sponsor'); } if ($sponsor_post) { update_post_meta($post_id, 'sponsor_id__c', $sponsor_post->ID); } else { add_snowflake_log('bdcs', "Sponsor '{$sponsor_name}' not found for {$title}", true); } } $count++; } add_snowflake_log('bdcs', "Successfully synced {$count} BDC records for {$calendar_filter}."); } catch (Exception $e) { add_snowflake_log('bdcs', 'Exception: ' . $e->getMessage(), true); } } Kyle Van Pelt: The Fuel of Future Innovation - Blue Vault

Questions? info@bluevaultpartners.com | 877-256-2304

U

Home > Videos > Podcast Clips > Kyle Van Pelt: The Fuel of Future Innovation

April 26, 2021
Kyle Van Pelt: The Fuel of Future Innovation
Podcast Clips | Technology | Videos

Recent

Most Popular

Blue Vault Q2 2023 Performance Reports Update

Blue Vault Q2 2023 Performance Reports Update

October 3, 2023

Blue Vault Q2 2023 Performance Reports Update 10-3-2023 Blue Vault wishes to acknowledge and apologize for the delay in publishing some Q2 2023 NTR Individual Performance Pages (IPPs) as well as the full review. We recently added additional reporting metrics to our IPPs, and that, combined with coverage of all share classes and some additional…
Blue Vault Q2 2023 Performance Reports Update

Blue Vault Q2 2023 Performance Reports Update

September 25, 2023

Blue Vault Q2 2023 Performance Reports Update 9-25-2023 Blue Vault has published the Q2 2023 Nontraded BDC Industry Review as well as Individual Performance Report and Limited Operations pages for the following offerings (newly published pages in bold font): Nontraded REITS American Healthcare REIT Q2 2023 Apollo Realty Income Solutions Q2 2023 (limited operations) Ares…

Explore

Blue Vault Logo
Don’t miss alts news
and educational events
Subscribe Now