UPLOADING INDIVIDUAL TIMETABLES

Administration
1

dear support team,
Im trying to upload individual csv timtable files and i keep getting error messages. I succeeded in loading a master timetable for one class. i use version gibbon 15. please find below the error message.
File import:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null

kindly help

2

ERROR MESSAGE
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘spaceName’ cannot be null
The import file could not be temporarily stored in the database for analysis.
FINAL DECISION
You cannot proceed. Fix the issues listed above and try again.

3

Hi Omo,

It sounds like the spreadsheet column for spaceName is missing or some fields may be empty. On the TT import page it lists Space Name - the Gibbon name for the room the lesson takes place in` as the sixth column. If you check your data, do you have all six columns, and if so does that column have any empty fields?

Hope this helps!
4

Hi Omo,

Please feel free to share the first few rows of your import here so that we can take a look.

Thanks,

Ross