txoof/calendar_csv

calendar csv generator for schools

Who I Am

I'm a hacker, maker and mender of things. I love an interesting challenge and can't resist being nerd sniped.

More About Me

• 🔭 I’m currently working on building SQL queries for to interface Student Information Systems with Learning Management Systems
• 🌱 I’m currently learning SQL
• 👯 I’m looking to collaborate on PaperPi, a quiet internet radio
• 📫 How to reach me:
  • [email protected]
  • Stack OverFlow
  • LinkedIn
• 📜My Resume of Projects
• 😄 Pronouns: He/Him

calendar_csv's Issues

Crashes on bad date format

handle crash on bad date formate more gracefully

$ ./gcal_csv_generator.py --schedule_file ./ms_bell_schedule.csv --start "2023/-8/16" --end "2024/06/13" --non_instruction non_instruction_23-24.csv
Traceback (most recent call last):
  File "/Users/aaronciuffo/Documents/src/calendar_csv/./gcal_csv_generator.py", line 443, in <module>
    q = main()
  File "/Users/aaronciuffo/Documents/src/calendar_csv/./gcal_csv_generator.py", line 367, in main
    school_days = set_school_days(start=start, end=end,
  File "/Users/aaronciuffo/Documents/src/calendar_csv/./gcal_csv_generator.py", line 243, in set_school_days
    start_dt = datetime.strptime(start, dt_format)
  File "/Users/aaronciuffo/.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/_strptime.py", line 568, in _strptime_datetime
    tt, fraction, gmtoff_fraction = _strptime(data_string, format)
  File "/Users/aaronciuffo/.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/_strptime.py", line 349, in _strptime
    raise ValueError("time data %r does not match format %r" %
ValueError: time data '2023/-8/16' does not match format '%Y/%m/%d'
12:34:01

simplify schedule CSV conversion to JSON

Convert to JSON on the fly from CSV rather than force conversion process

This simplifies displaying help and makes it easier to work with CSV rather than ugly JSON for end users.

add option to create CSV by quarter and semester

Output A_Block-Q1, A_Block-Q2, A_Block-S1 etc.