SchoolTool

scoresystem on skills importet by xls

Asked by Susanne

Hi!

I have resently installed schooltool on our ubuntu serrver. We are a small montessori school with kids from 6 to 13 years. Schooltool is just what we need, but after using a lot of time on registering skills and importing them with xls(saved me a lot of time! :) ), I discovered that i couldent change the scoresystem. Is this something I can do in the xls file? I tried to make a new scoresystem called competensy, and hide the old one, but the skills still have the original competensy scoresystem. Then I tried to change the skillsytem on the skill inside of schooltool, but that was not an option.. Its over 100 skillsets with more then 700 skills, so I would rather not have to input it manually in schooltool..

--
Susanne

Question information

Language:
English Edit question
Status:
Solved
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Solved by:
Tom Hoffman
Solved:
Last query:
Last reply:
Revision history for this message
Best Tom Hoffman (tom-hoffman) said : 		#1

Hi Susanne,

Ah, you're lucky. There is a "hidden" column for the score system to the right of the Deprecated column -- so column J. Does that match the layout of your sheet?

You designate the ID of the score system for each skill, so if it is all the same you can just paste into all 700 and reimport.

Let me know if that works for you.

Revision history for this message
Susanne (seb1987) said : 		#2

Perfekt! Thanks! this will save me hours of work :D
Yes, it accepts that I type in the J column. but I keep getting D2-4 has an invalid scoresystem(i have typed what i think is the scoresystem id in the column J2-4).. Where can i find the scoresystem id?

Revision history for this message
Tom Hoffman (tom-hoffman) said : 		#3

Ah, yes, that's a little bug too. Go to Score Systems (under School), click on the one you want, and look at the end of the url. It should look something like http://myschool.org/scoresystems/my-scores In this case "my-scores" would be the ID. Whatever is after the last / should go in column J.

Let me know if that works.

Revision history for this message
Susanne (seb1987) said : 		#4

That worked! Thank you so much! :D

Revision history for this message
Susanne (seb1987) said : 		#5

Thanks Tom Hoffman, that solved my question.