axelwehner

-- Concrete CMS (v9.2.1) - Fix lowercase database table names 
-- https://gruenphase.com/
--
-- Google Sheets Source:
-- https://docs.google.com/spreadsheets/d/11Eq8ksccPqDvmRv4AgwXDrCwNQXq4wXpeQUh9yAUbaU/edit?usp=sharing

ALTER TABLE `announcements` RENAME TO `Announcements`;
ALTER TABLE `announcementuserviews` RENAME TO `AnnouncementUserViews`;
ALTER TABLE `arealayoutcolumns` RENAME TO `AreaLayoutColumns`;
ALTER TABLE `arealayoutcustomcolumns` RENAME TO `AreaLayoutCustomColumns`;

axelwehner

<?php
/*
 * Converts CSV to JSON
 * Example uses Google Spreadsheet CSV feed
 * csvToArray function I think I found on php.net
 */

header('Content-type: application/json');

// Set your CSV feed