giggity icon indicating copy to clipboard operation
giggity copied to clipboard

Add a CSV to ICS helper tool

Open mmuman opened this issue 1 year ago • 5 comments

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.

mmuman avatar Aug 11 '23 01:08 mmuman

Hmm why generate .ics instead of proper Pentabarf though? 😔 IIRC I have a generator for it somewhere..

Wilm0r avatar Aug 11 '23 07:08 Wilm0r

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?

Wilm0r avatar Aug 11 '23 07:08 Wilm0r

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…

mmuman avatar Aug 11 '23 11:08 mmuman

What do you want to do with this PR for now?

Wilm0r avatar Aug 14 '23 08:08 Wilm0r

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.

Zverik avatar Aug 22 '24 12:08 Zverik