giggity
giggity copied to clipboard
Add a CSV to ICS helper tool
I wrote this to extract the schedule from the website of the EuroBSDCon: https://2023.eurobsdcon.org/program/
Copy-paste the tables into a spreadsheet (like LibreOffice Calc), export as CSV (, as delimiter, " as quote).
It expects:
- lines that start with the event type and day
- lines starting with an empty cell that lists the tracks,
- lines that start with start_time (eventually end), then each talk.
Lot of hardcoding and debug output to cleanup.
Hmm why generate .ics instead of proper Pentabarf though? 😔 IIRC I have a generator for it somewhere..
Ah yes, looks like I've accidentally deleted it: 76c8dbfdf4600069f63ff4c7fa286e084daeaeba Reason: Primary purpose of that script was once to generate Giggity's original native but long deprecated XML format. I forgot I added a little frab
method right in the middle of it.
Would you be interested in merging these?
Seems I should have slept instead, they used OSEM for the CfP :sweat_smile: Should probably be merged at some point yes. I went for ICS because I've been working on it these days and I didn't fancy digging XML, plus I didn't have all the required info…
What do you want to do with this PR for now?
You could use https://github.com/zverik/schedule_convert for that — it produces a Pentabarf XML and ICS from a csv. I use it to merge a regular xml with a table maintained in Google Docs (and exported as csv), for example.