Discussion:
[schooltool] Importing lots of data
Gregor Jacobs
2008-11-30 08:24:31 UTC
Permalink
Hi there,
I am new to this mailing list, therefore just a quick info who I am: I
am a 38yr old German school teacher close to Hamburg, Germany. Nice to meet you :-)

Either the question I have hasn't been posted yet or I just didn't find a
satisfying answer in the archieves (which might mean that I overread
it in case it's there).

So if this was already talked about, please just give me a good link,
thanks :-)

My school has got about 1,000 students and about 80 teachers but is
still growing. Lower classes are organized in their classes for
teaching, and the higher ones use courses on differend levels. Now, I
wonder if I can create some config files that I import one by one to
schooltool's database, like
term duration, timetables, teachers and their courses. Once this is
done and all courses have their course IDs, I'd like to import a data
file with all students, like:
studentID, FirstName, LastName, Class, German course, Maths Course,
English Course, Geography course, etc.

This data could be available as .xls or .cvs or whatever. I saw
importing persons via that import function only allows a few fields,
and clicking for each of the 1,000 students once for each course they
have looks like work ;-)

So, is there a possibility for importing lots of data with only a bit
of work?
Btw, (what might be interesting to know) I am running SchoolTool
2008.10 on a ubuntu 2.6.24-22.

Enjoy your Sunday,
Gregor
Tom Hoffman
2008-12-01 14:11:46 UTC
Permalink
Hi Gregor,
Great to hear from you.

Actually, importing large sets of data from (and exporting to) spreadsheets
is *exactly* what we're working on right now, and will be included in an
updated release very soon... hopefully this week.

--Tom
Post by Gregor Jacobs
Hi there,
I am new to this mailing list, therefore just a quick info who I am: I
am a 38yr old German school teacher close to Hamburg, Germany. Nice to meet you :-)
Either the question I have hasn't been posted yet or I just didn't find a
satisfying answer in the archieves (which might mean that I overread
it in case it's there).
So if this was already talked about, please just give me a good link,
thanks :-)
My school has got about 1,000 students and about 80 teachers but is
still growing. Lower classes are organized in their classes for
teaching, and the higher ones use courses on differend levels. Now, I
wonder if I can create some config files that I import one by one to
schooltool's database, like
term duration, timetables, teachers and their courses. Once this is
done and all courses have their course IDs, I'd like to import a data
studentID, FirstName, LastName, Class, German course, Maths Course,
English Course, Geography course, etc.
This data could be available as .xls or .cvs or whatever. I saw
importing persons via that import function only allows a few fields,
and clicking for each of the 1,000 students once for each course they
have looks like work ;-)
So, is there a possibility for importing lots of data with only a bit
of work?
Btw, (what might be interesting to know) I am running SchoolTool
2008.10 on a ubuntu 2.6.24-22.
Enjoy your Sunday,
Gregor
_______________________________________________
Schooltool mailing list
Schooltool at schooltool.org
http://lists.schooltool.org/mailman/listinfo/schooltool
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.schooltool.org/pipermail/schooltool/attachments/20081201/e1dcf427/attachment.htm
Loading...