{"id":23591,"date":"2024-04-17T11:08:26","date_gmt":"2024-04-17T09:08:26","guid":{"rendered":"https:\/\/www.wjst.de\/blog\/?p=23591"},"modified":"2024-04-17T11:12:58","modified_gmt":"2024-04-17T09:12:58","slug":"from-start-to-finish-programming-with-chatgpt-in-60s","status":"publish","type":"post","link":"https:\/\/www.wjst.de\/blog\/sciencesurf\/2024\/04\/from-start-to-finish-programming-with-chatgpt-in-60s\/","title":{"rendered":"From start to finish programming with ChatGPT in 60s"},"content":{"rendered":"

Create a PHP script that can read a CSV in the form start_date, end_date, event and output as ICS file<\/p><\/blockquote>\n

\r\nfunction convertDate($date)\r\n{\r\n    $dateTime = DateTime::createFromFormat('m\/d\/Y', $date);\r\n    if ($dateTime === false) {\r\n        return false; \/\/ Return false if date parsing fails\r\n    }\r\n    return $dateTime->format('Ymd');\r\n}\r\n\r\n\/\/ Function to escape special characters in text\r\nfunction escapeText($text)\r\n{\r\n    return str_replace(["\\n", "\\r", ",", ";"], ['\\n', '\\r', '\\,', '\\;'], $text);\r\n}\r\n\r\n\/\/ Read CSV file\r\n$csvFile = 'uci.csv'; \/\/ Replace with your CSV file name\r\n$icsFile = 'uci.ics'; \/\/ Output ICS file name\r\n\r\n$handle = fopen($csvFile, 'r');\r\nif ($handle !== false) {\r\n    \/\/ Open ICS file for writing\r\n    $icsHandle = fopen($icsFile, 'w');\r\n\r\n    \/\/ Write ICS header\r\n    fwrite($icsHandle, "BEGIN:VCALENDAR\\r\\n");\r\n    fwrite($icsHandle, "VERSION:2.0\\r\\n");\r\n    fwrite($icsHandle, "PRODID:-\/\/Your Company\/\/NONSGML Event Calendar\/\/EN\\r\\n");\r\n\r\n    \/\/ Read CSV line by line\r\n    while (($data = fgetcsv($handle, 1000, ',')) !== false) {\r\n        $startDate = convertDate($data[0]);\r\n        $endDate = convertDate($data[1]);\r\n        print_r($data) . PHP_EOL;\r\n        echo $startDate;\r\n        \r\n        if ($startDate === false || $endDate === false) {\r\n            continue;\r\n        }\r\n        $event = escapeText($data[2]);\r\n\r\n        \/\/ Write event to ICS file\r\n        fwrite($icsHandle, "BEGIN:VEVENT\\r\\n");\r\n        fwrite($icsHandle, "UID:" . uniqid() . "\\r\\n"); \/\/ Unique identifier\r\n        fwrite($icsHandle, "DTSTART;VALUE=DATE:" . $startDate . "\\r\\n");\r\n        fwrite($icsHandle, "DTEND;VALUE=DATE:" . $endDate . "\\r\\n");\r\n        fwrite($icsHandle, "SUMMARY:" . $event . "\\r\\n");\r\n        fwrite($icsHandle, "DESCRIPTION:" . $event . "\\r\\n");\r\n        fwrite($icsHandle, "END:VEVENT\\r\\n");\r\n    }\r\n\r\n    \/\/ Write ICS footer\r\n    fwrite($icsHandle, "END:VCALENDAR\\r\\n");\r\n\r\n    \/\/ Close files\r\n    fclose($icsHandle);\r\n    fclose($handle);\r\n\r\n    echo "ICS file generated successfully.";\r\n} else {\r\n    echo "Error: Unable to open CSV file.";\r\n}\r\n<\/pre>\n
Source data are  from UCI<\/a> and output is here<\/a> from where it can be added as a calendar. BTW created also my first “hello world” Swift\/iPhone app using this source\u00a0<\/a>although this took a bit more time…<\/p>\n\n
 <\/p>\n
\n  CC-BY-NC Science Surf , accessed 26.04.2026<\/span>\n <\/div>","protected":false},"excerpt":{"rendered":"
Create a PHP script that can read a CSV in the form start_date, end_date, event and output as ICS file function convertDate($date) { $dateTime = DateTime::createFromFormat('m\/d\/Y', $date); if ($dateTime === false) { return false; \/\/ Return false if date parsing fails } return $dateTime->format('Ymd'); } \/\/ Function to escape special characters in text function escapeText($text) … Continue reading From start to finish programming with ChatGPT in 60s<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[3358,2962,4875,4874],"class_list":["post-23591","post","type-post","status-publish","format-standard","hentry","category-computer-software","tag-ai","tag-calendar","tag-ics","tag-uci"],"_links":{"self":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/23591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/comments?post=23591"}],"version-history":[{"count":4,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/23591\/revisions"}],"predecessor-version":[{"id":23595,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/23591\/revisions\/23595"}],"wp:attachment":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/media?parent=23591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/categories?post=23591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/tags?post=23591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}