SchoolTool

Import Error on Timetables

Bug #1301885 reported by Tom Hoffman on 2014-04-03

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	SchoolTool	New	Undecided	Unassigned

Bug Description

I attempted to import a school.xls file exported from a 2.62 instance of SchoolTool on a production server to an instance on a virtual machine on my computer. I received the following error message:

SectionTimetables
-----------------
is not a valid day id for the given timetable:
A7, A44

I then exported a school.xls file from the instance on my VM. When I attempted to import this file I received the same error message.

Revision history for this message

Proberts042 (proberts42) wrote on 2014-04-03:

school_section_timetable.xlsx Edit (54.1 KiB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

Attaching the requested document.

Revision history for this message

Tom Hoffman (tom-hoffman) wrote on 2014-04-04:

school_section_timetable.xlsx Edit (47.2 KiB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

OK, you had a few repeated lines in the first couple sections in SectionTimetables, and I got rid of those (attached).

I then got this:

is not a valid period id for the given day:
B10-12, B15-17, B21-23, B26-29, B33, B43-46, B49-51, B54-57, B60-62, B66

Which is caused by the period times corresponding to the times in the other timetable, so you'll have to sort that out manually.

Let me know if it works after you get those sorted.

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.