aleksis/AlekSIS
Watch
10
0
Fork
You've already forked AlekSIS
 0
Code Issues 36 Pull requests 17 Projects Releases 6 Packages 2 Wiki Activity Actions

[ROADMAP] Migration to new data model for timetables #58

New issue
Closed
opened 2023-04-02 16:46:13 +02:00 by hansegucker · 59 comments
hansegucker commented 2023-04-02 16:46:13 +02:00
Owner
Copy link

This currently consists of work in the following apps:

The following things have to implemented and tested:

  • Import of all kinds of data from Untis
  • Calendar frontend
  • Export of ICS files (AlekSIS/official/AlekSIS-App-Chronos#40)
  • Direct integration of iCal feeds in calendar software (AlekSIS/official/AlekSIS-App-Chronos#40)
  • Display of lessons, substitutions, supervisions, events, and extra lessons in calendar frontend
  • Tracking of timetable changes and sending of notifications

These are the steps:

  • Creation of new models in Cursus (AlekSIS/onboarding/AlekSIS-App-Cursus!105)
  • Creation of new models in Lesrooster (AlekSIS/onboarding/AlekSIS-App-Lesrooster!105)
  • Basic implementation of calendar feeds in Core (AlekSIS/official/AlekSIS-Core!1252)
  • Basic implementation of calendar frontend in Core (AlekSIS/official/AlekSIS-Core!1252)
  • Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289)
  • Merge of Holiday model and basic calendar frontend (AlekSIS/official/AlekSIS-Core!1289, AlekSIS/official/AlekSIS-Core!1252)
  • Import of all data from AlekSIS-App-Untis (AlekSIS/official/AlekSIS-App-Untis!270)
    • Subjects
    • Rooms
    • Absence Reasons/Types
    • Person absences
    • Class absences
    • Room absences
    • Teachers
    • Classes
    • Slots and breaks
    • Supervisions
    • Lessons (Lesrooster)
  • Exam model in Cursus
  • Fix not working django-jsonstore
  • Event generation from lessons in Chronos (https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/merge_requests/301)
  • Event generation from supervisions in Chronos (https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/merge_requests/301)
  • Import more data from AlekSIS-App-Untis
    • Substitutions (amending lesson events in Chronos)
    • Extra lessons (free event via Chronos)
    • Supervision substitutions (amending supervision events in Chronos, AlekSIS/official/AlekSIS-App-Chronos#189)
    • Events (free event via Chronos)
    • Exams (free event via Chronos)
    • Change tracking
    • Clean up import
    • Update logging
  • Ensure __str__ methods and name mixins for m2m fields everywhere
  • Ensure all necessary attributes at calendar events and customize displaying of events in AlekSIS' own calendar frontend (all data from old frontend have to be included)
  • Substitutions should be cancelled at the substituted plan
  • Calendar events with current changes should be marked extra
  • Check permissions for calendars
  • Test with teacher and student accounts
  • Fix typing everywhere
  • Implement filtered calendar feeds for e.g. room timetables
  • New Chronos frontend
    • Room timetables, teacher timetables, class/course timetables (AlekSIS/official/AlekSIS-App-Chronos#150)
    • Special views (AlekSIS/official/AlekSIS-App-Chronos#119, AlekSIS/official/AlekSIS-App-Chronos#120)
    • Substitutions as table and as PDF
  • Working notification system (AlekSIS/official/AlekSIS-App-Chronos#201, https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/issues/209)
  • Migration path from old Chronos to new Chronos
  • Dropping of old models in Chronos
  • Frontend for managing holidays in Core (@ZugBahnHof, AlekSIS/official/AlekSIS-Core!1365)
  • Fix versions
  • Document new data model with text and graphic
  • Document usage of calendar system
This currently consists of work in the following apps: - Core (AlekSIS/official/AlekSIS-Core!1408) - Chronos (https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/merge_requests/301) - Cursus (AlekSIS/onboarding/AlekSIS-App-Cursus!106) - Lesrooster (AlekSIS/onboarding/AlekSIS-App-Lesrooster!106) - Untis (AlekSIS/official/AlekSIS-App-Untis!270) - Kolego (master) The following things have to implemented and tested: - [ ] Import of all kinds of data from Untis - [x] Calendar frontend - [x] Export of ICS files (AlekSIS/official/AlekSIS-App-Chronos#40) - [ ] Direct integration of iCal feeds in calendar software (AlekSIS/official/AlekSIS-App-Chronos#40) - [ ] Display of lessons, substitutions, supervisions, events, and extra lessons in calendar frontend - [ ] Tracking of timetable changes and sending of notifications These are the steps: - [x] Creation of new models in Cursus (AlekSIS/onboarding/AlekSIS-App-Cursus!105) - [x] Creation of new models in Lesrooster (AlekSIS/onboarding/AlekSIS-App-Lesrooster!105) - [x] Basic implementation of calendar feeds in Core (AlekSIS/official/AlekSIS-Core!1252) - [x] Basic implementation of calendar frontend in Core (AlekSIS/official/AlekSIS-Core!1252) - [x] Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289) - [x] Merge of Holiday model and basic calendar frontend (AlekSIS/official/AlekSIS-Core!1289, AlekSIS/official/AlekSIS-Core!1252) - [ ] Import of all data from AlekSIS-App-Untis (AlekSIS/official/AlekSIS-App-Untis!270) - [x] Subjects - [x] Rooms - [x] Absence Reasons/Types - [x] Person absences - [ ] Class absences - [ ] Room absences - [x] Teachers - [x] Classes - [x] Slots and breaks - [x] Supervisions - [x] Lessons (Lesrooster) - [ ] Exam model in Cursus - [x] Fix not working django-jsonstore - [x] Event generation from lessons in Chronos (https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/merge_requests/301) - [x] Event generation from supervisions in Chronos (https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/merge_requests/301) - [ ] Import more data from AlekSIS-App-Untis - [x] Substitutions (amending lesson events in Chronos) - [x] Extra lessons (free event via Chronos) - [x] Supervision substitutions (amending supervision events in Chronos, AlekSIS/official/AlekSIS-App-Chronos#189) - [x] Events (free event via Chronos) - [ ] Exams (free event via Chronos) - [x] Change tracking - [ ] Clean up import - [ ] Update logging - [x] Ensure `__str__` methods and name mixins for m2m fields everywhere - [x] Ensure all necessary attributes at calendar events and customize displaying of events in AlekSIS' own calendar frontend (all data from old frontend have to be included) - [x] Substitutions should be cancelled at the substituted plan - [x] Calendar events with current changes should be marked extra - [x] Check permissions for calendars - [x] Test with teacher and student accounts - [x] Fix typing everywhere - [x] Implement filtered calendar feeds for e.g. room timetables - [ ] New Chronos frontend - [x] Room timetables, teacher timetables, class/course timetables (AlekSIS/official/AlekSIS-App-Chronos#150) - [ ] Special views (AlekSIS/official/AlekSIS-App-Chronos#119, AlekSIS/official/AlekSIS-App-Chronos#120) - [ ] Substitutions as table and as PDF - [ ] Working notification system (AlekSIS/official/AlekSIS-App-Chronos#201, https://edugit.org/AlekSIS/official/AlekSIS-App-Chronos/-/issues/209) - [ ] Migration path from old Chronos to new Chronos - [ ] Dropping of old models in Chronos - [x] Frontend for managing holidays in Core (@ZugBahnHof, AlekSIS/official/AlekSIS-Core!1365) - [ ] Fix versions - [ ] Document new data model with text and graphic - [ ] Document usage of calendar system
hansegucker commented 2023-04-02 16:46:14 +02:00
Author
Owner
Copy link

assigned to @hansegucker

assigned to @hansegucker
hansegucker commented 2023-04-02 16:46:35 +02:00
Author
Owner
Copy link

marked the checklist item Creation of new models in Cursus (AlekSIS/onboarding/AlekSIS-App-Cursus!105) as completed

marked the checklist item **Creation of new models in Cursus (AlekSIS/onboarding/AlekSIS-App-Cursus!105)** as completed
hansegucker commented 2023-04-02 16:46:36 +02:00
Author
Owner
Copy link

marked the checklist item Creation of new models in Lesrooster (AlekSIS/onboarding/AlekSIS-App-Lesrooster!105) as completed

marked the checklist item **Creation of new models in Lesrooster (AlekSIS/onboarding/AlekSIS-App-Lesrooster!105)** as completed
hansegucker commented 2023-04-02 16:46:40 +02:00
Author
Owner
Copy link

marked the checklist item Basic implementation of calendar feeds in Core (AlekSIS/official/AlekSIS-Core!1252) as completed

marked the checklist item **Basic implementation of calendar feeds in Core (AlekSIS/official/AlekSIS-Core!1252)** as completed
hansegucker commented 2023-04-02 16:46:41 +02:00
Author
Owner
Copy link

marked the checklist item Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289) as completed

marked the checklist item **Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289)** as completed
hansegucker commented 2023-04-02 16:46:43 +02:00
Author
Owner
Copy link

marked the checklist item Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289) as incomplete

marked the checklist item **Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289)** as incomplete
hansegucker commented 2023-04-02 16:47:17 +02:00
Author
Owner
Copy link

marked the checklist item Subjects as completed

marked the checklist item **Subjects** as completed
hansegucker commented 2023-04-02 16:47:18 +02:00
Author
Owner
Copy link

marked the checklist item Rooms as completed

marked the checklist item **Rooms** as completed
hansegucker commented 2023-04-02 16:47:19 +02:00
Author
Owner
Copy link

marked the checklist item Teachers as completed

marked the checklist item **Teachers** as completed
hansegucker commented 2023-04-02 16:47:20 +02:00
Author
Owner
Copy link

marked the checklist item Classes as completed

marked the checklist item **Classes** as completed
hansegucker commented 2023-04-02 16:47:21 +02:00
Author
Owner
Copy link

marked the checklist item Slots and breaks as completed

marked the checklist item **Slots and breaks** as completed
hansegucker commented 2023-04-02 16:47:24 +02:00
Author
Owner
Copy link

marked the checklist item Lessons (Lesrooster) as completed

marked the checklist item **Lessons (Lesrooster)** as completed
hansegucker commented 2023-04-14 14:53:28 +02:00
Author
Owner
Copy link

marked the checklist item Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289) as completed

marked the checklist item **Creation of new Holiday model in Core (AlekSIS/official/AlekSIS-Core!1289)** as completed
hansegucker commented 2023-04-14 14:53:39 +02:00
Author
Owner
Copy link

marked the checklist item Fix not working django-jsonstore as completed

marked the checklist item **Fix not working django-jsonstore** as completed
yuha commented 2023-05-26 15:40:17 +02:00
Member
Copy link

mentioned in issue #59

mentioned in issue #59
hansegucker commented 2023-05-27 13:00:51 +02:00
Author
Owner
Copy link

marked the checklist item Event generation from lessons in Chronos as completed

marked the checklist item **Event generation from lessons in Chronos** as completed
hansegucker commented 2023-05-27 13:00:52 +02:00
Author
Owner
Copy link

marked the checklist item Event generation from supervisions in Chronos as completed

marked the checklist item **Event generation from supervisions in Chronos** as completed
hansegucker commented 2023-05-27 13:03:06 +02:00
Author
Owner
Copy link

marked the checklist item Supervisions as completed

marked the checklist item **Supervisions** as completed
hansegucker commented 2023-05-27 13:48:54 +02:00
Author
Owner
Copy link

Where to put room and group absences????

Where to put room and group absences????
hansegucker commented 2023-06-04 17:10:57 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 18:15:37 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 18:16:35 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 18:17:44 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 20:56:00 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 22:42:48 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 22:44:43 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 22:54:23 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 22:58:52 +02:00
Author
Owner
Copy link

marked the checklist item Substitutions (amending lesson events in Chronos) as completed

marked the checklist item **Substitutions (amending lesson events in Chronos)** as completed
hansegucker commented 2023-06-04 22:58:53 +02:00
Author
Owner
Copy link

marked the checklist item Supervision substitutions (amending supervision events in Untis) as completed

marked the checklist item **Supervision substitutions (amending supervision events in Untis)** as completed
hansegucker commented 2023-06-04 22:59:05 +02:00
Author
Owner
Copy link

marked the checklist item Supervision substitutions (amending supervision events in Untis) as incomplete

marked the checklist item **Supervision substitutions (amending supervision events in Untis)** as incomplete
hansegucker commented 2023-06-04 22:59:06 +02:00
Author
Owner
Copy link

marked the checklist item Supervision substitutions (amending supervision events in Chronos, AlekSIS/official/AlekSIS-App-Chronos#189) as completed

marked the checklist item **Supervision substitutions (amending supervision events in Chronos, AlekSIS/official/AlekSIS-App-Chronos#189)** as completed
hansegucker commented 2023-06-04 23:00:00 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-04 23:00:21 +02:00
Author
Owner
Copy link

marked the checklist item Absence Reasons/Types as completed

marked the checklist item **Absence Reasons/Types** as completed
hansegucker commented 2023-06-04 23:00:22 +02:00
Author
Owner
Copy link

marked the checklist item Person absences as completed

marked the checklist item **Person absences** as completed
hansegucker commented 2023-06-04 23:00:51 +02:00
Author
Owner
Copy link

marked the checklist item Basic implementation of calendar frontend in Core (AlekSIS/official/AlekSIS-Core!1252) as completed

marked the checklist item **Basic implementation of calendar frontend in Core (AlekSIS/official/AlekSIS-Core!1252)** as completed
hansegucker commented 2023-06-05 20:41:53 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-05 20:44:07 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-05 20:46:48 +02:00
Author
Owner
Copy link

marked the checklist item Extra lessons (free event via Chronos) as completed

marked the checklist item **Extra lessons (free event via Chronos)** as completed
hansegucker commented 2023-06-05 21:20:43 +02:00
Author
Owner
Copy link

marked the checklist item Events (free event via Chronos) as completed

marked the checklist item **Events (free event via Chronos)** as completed
hansegucker commented 2023-06-05 21:47:54 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-11 20:17:40 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-06-11 20:24:22 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-07-16 21:22:05 +02:00
Author
Owner
Copy link

marked the checklist item Ensure __str__ methods and name mixins for m2m fields everywhere as completed

marked the checklist item **Ensure `__str__` methods and name mixins for m2m fields everywhere** as completed
hansegucker commented 2023-07-16 21:22:18 +02:00
Author
Owner
Copy link

marked the checklist item Calendar events with current changes should be marked extra as completed

marked the checklist item **Calendar events with current changes should be marked extra** as completed
hansegucker commented 2023-07-16 21:22:28 +02:00
Author
Owner
Copy link

marked the checklist item Fix typing everywhere as completed

marked the checklist item **Fix typing everywhere** as completed
hansegucker commented 2023-07-18 21:12:05 +02:00
Author
Owner
Copy link

marked the checklist item Change tracking as completed

marked the checklist item **Change tracking** as completed
hansegucker commented 2023-07-18 21:26:10 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-07-23 13:37:50 +02:00
Author
Owner
Copy link

marked the checklist item Merge of Holiday model and basic calendar frontend (AlekSIS/official/AlekSIS-Core!1289, AlekSIS/official/AlekSIS-Core!1252) as completed

marked the checklist item **Merge of Holiday model and basic calendar frontend (AlekSIS/official/AlekSIS-Core!1289, AlekSIS/official/AlekSIS-Core!1252)** as completed
hansegucker commented 2023-07-23 19:30:02 +02:00
Author
Owner
Copy link

marked the checklist item Ensure all necessary attributes at calendar events and customize displaying of events in AlekSIS' own calendar frontend (all data from old frontend have to be included) as completed

marked the checklist item **Ensure all necessary attributes at calendar events and customize displaying of events in AlekSIS' own calendar frontend (all data from old frontend have to be included)** as completed
hansegucker commented 2023-07-23 19:30:14 +02:00
Author
Owner
Copy link

marked the checklist item Substitutions should be cancelled at the substituted plan as completed

marked the checklist item **Substitutions should be cancelled at the substituted plan** as completed
hansegucker commented 2023-07-23 19:30:45 +02:00
Author
Owner
Copy link

marked the checklist item Check permissions for calendars as completed

marked the checklist item **Check permissions for calendars** as completed
hansegucker commented 2023-07-23 19:30:48 +02:00
Author
Owner
Copy link

marked the checklist item Test with teacher and student accounts as completed

marked the checklist item **Test with teacher and student accounts** as completed
hansegucker commented 2023-08-07 13:37:51 +02:00
Author
Owner
Copy link

marked the checklist item Frontend for managing holidays in Core (@ZugBahnHof, AlekSIS/official/AlekSIS-Core!1365) as completed

marked the checklist item **Frontend for managing holidays in Core (@ZugBahnHof, AlekSIS/official/AlekSIS-Core!1365)** as completed
hansegucker commented 2023-08-16 19:59:09 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-08-16 20:06:17 +02:00
Author
Owner
Copy link

changed the description

changed the description
hansegucker commented 2023-09-20 12:37:16 +02:00
Author
Owner
Copy link

marked the checklist item Implement filtered calendar feeds for e.g. room timetables as completed

marked the checklist item **Implement filtered calendar feeds for e.g. room timetables** as completed
hansegucker commented 2023-09-20 12:37:37 +02:00
Author
Owner
Copy link

marked the checklist item Room timetables, teacher timetables, class/course timetables (AlekSIS/official/AlekSIS-App-Chronos#150) as completed

marked the checklist item **Room timetables, teacher timetables, class/course timetables (AlekSIS/official/AlekSIS-App-Chronos#150)** as completed
hansegucker commented 2024-03-07 12:38:45 +01:00
Author
Owner
Copy link

marked the checklist item Calendar frontend as completed

marked the checklist item **Calendar frontend** as completed
hansegucker commented 2024-03-07 12:38:51 +01:00
Author
Owner
Copy link

marked the checklist item Export of ICS files (AlekSIS/official/AlekSIS-App-Chronos#40) as completed

marked the checklist item **Export of ICS files (AlekSIS/official/AlekSIS-App-Chronos#40)** as completed
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
renovate/vuetify-4.x
renovate/major-eslint-monorepo
renovate/docker.io-selenium-standalone-firefox-4.x
renovate/biomejs-biome-2.x
renovate/eslint-config-prettier-10.x
renovate/eslint-plugin-vue-10.x
renovate/strip-ansi-6.x
postgres-new-location
renovate/yaml-eslint-parser-2.x
renovate/jsonc-eslint-parser-3.x
renovate/strip-ansi-7.x
cherry-pick-b825f692
compose-update
add-postgresql-client-17
migrate-to-uv
LDulc3p0yxRKJCd5
postgres-with-ext
stable-2023.6
update-core-base-image
improve-release-management
65-build-release-docs-from-tags
59-roadmap-timetable-creation-in-aleksis
nix-devenv
43-docs-add-glossary-section
stable-2021.12
2021.12.handbook-print
handbook-kram
add-k8s
update/tox-makemessages
ci/use-poetry-version-short
release/2021.6
update/translations-20210608
26-add-a-check-for-missing-migrations-to-the-pipelines
18-official-translations-for-first-distribution-release
24-job-failed-24178
active-pytest-celery
23-ci-use-browserstack-for-selenium-tests
17-docs-build-docs-of-all-official-apps
debdolph-master-patch-43252
fix-ci-config
revert-cd35824d
feature/run-make-if-available
gettext-lazy
update-tox2
2026.4.0
2026.4.0rc3
2026.4.0rc2
2026.4.0rc1
2023.6.1
2023.6
2025.1
2025.1.1
2025.1-rc.2
2025.1-rc.1
2023.6b2
2023.6b1
2023.1b1
2023.1b0
2023.1.dev0
2022.6.1
2022.6.post1
2022.6.post0
2022.6
2021.12.1
2021.12.1.dev0
2021.12.post0
2021.6rc2
2021.6rc1
2021.6b2
2021.6b1
2021.06b0
Labels
Clear labels   
Security

   
TeX
Needs LaTeX template

  
board
done

  
board
ready

  
board
todo

  
part
backend
 Backend (view code, models, logic, etc.)

  
part
ci

  
part
docs
 Issue or addition to the documentation

  
part
frontend
 Frontend (templates, etc.)

  
part
i18n
 Translation or internationalisation issue

  
part
non-technical
 Non-technical (policy, maintenance, etc.) issue or discussion

  
part
packaging
 Issue concerning the packaging of AlekSIS and components

  
prio
1
 Priority High

  
prio
2
 Priority Medium

  
prio
3
 Priority Low

  
release-mr-5.x
  
size
large

  
size
medium

  
size
small

  
source
customer
 Requested by a customer or affiliated user

  
source
customer::fsmw

  
source
customer::fss

  
source
customer::teckids

  
source
downstream
 Issue or merge request from other projects using AlekSIS or parts of it

  
type
breaking

  
type
bug
 Bug

  
type
feature
 New feature

  
type
refactoring

  
workflow
blocked
 Issue is blocked by another issue

  
workflow
confirmed
 The bug is reproducible and will be fixed

  
workflow
current-todo

  
workflow
discussing
 Needs to be discussed before implementation

  
workflow
new-app
 Requires new AlekSIS app, which has to be created

  
workflow
wontfix
 The bug is not reproducible or the feature was decided against

  
source::aleksolotl
No labels
Security
TeX
board
done
board
ready
board
todo
part
backend
part
ci
part
docs
part
frontend
part
i18n
part
non-technical
part
packaging
prio
1
prio
2
prio
3
release-mr-5.x
size
large
size
medium
size
small
source
customer
source
customer::fsmw
source
customer::fss
source
customer::teckids
source
downstream
type
breaking
type
bug
type
feature
type
refactoring
workflow
blocked
workflow
confirmed
workflow
current-todo
workflow
discussing
workflow
new-app
workflow
wontfix
source::aleksolotl
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
hansegucker
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
aleksis/AlekSIS#58
No description provided.