schooltool-developers team mailing list archive

[Tom Hoffman <tom.hoffman@xxxxxxxxx>]

---------- Forwarded message ----------
From: Jen Overgaag <jovergaag@xxxxxxxxx>
Date: Mon, May 24, 2010 at 5:30 AM
Subject: Re: Import xls error
To: Alan Elkner <aelkner@xxxxxxxxx>
Cc: Tom Hoffman <tom.hoffman@xxxxxxxxx>, gonzaloportal
<gonzaloportal56@xxxxxxxxxxx>, peter.walinkonde@xxxxxxxxx, misheck
mutuzana <mutuzana@xxxxxxxxx>


Hi Alan,

I hope you had a nice weekend.  Ours was lovely.  We celebrate Africa
Freedom Day on Tuesday so everyone is very excited for a day off.
Especially the students, as boarding scholars they don't get a lot of
excitement so they have been anxiously waiting for a day to sleep in
and a day of fun activities.

Thank you for all the great information. Attached is the import
spreadsheet with all of the students, teachers, groups, courses, and
adjusted school year.  We now have all of the data imported and the
database set up exactly as you have described below, waiting for the
package.

One issue I see; in FET we set up the timetable in terms of period
numbers, never actually entering start and end times for the different
periods.  So if we rely solely on the FET data for the timetable
creation we won't have start/end times to populate the calendar.
Maybe we can xls import or manually enter Day Templates then match FET
periods to those established periods?  I have also attached a
(previously exported) spreadsheet with our current timetable
information in case you need it.

Questions:
-What data can be imported more than once without causing an issue.
You have said that persons will just be updated with no problems, does
all the other information need to be clean and blank for import?
-To add members to a group, do you list the group information plus
members to ADD or all members.
-If for some reason I need to delete all the people, is there a way to
do that?  Last week I screwed up with the students and had to manually
delete all of them, it was very tedious.  Can I just delete some
database file somewhere to start over?

Thanks again,
Jen



On Mon, May 24, 2010 at 5:21 AM, Alan Elkner <aelkner@xxxxxxxxx> wrote:
>
> Hi Jen,
>
> I worked out all the changes that needed to made to your xls file to
> get it to import into schooltool, so I attached the updated file so
> that you can try it out again.  The following changes needed to be
> made:
>
> 1) removed the 'Sections' sheets as we will be generating the sections
> from the FET import
> 2) fixed the 'Groups' sheet to have IDs that match the titles, school
> years that are strings, and 'Members' instead of 'Names'
> 3) created a 'School Years' sheet that has the school year in it
> (start and end dates?  I chose begin and end of 2010.)
>
> If you try the file again, it will import, and then you will see the
> link at the top for school year, 2010.  When you click on that, you
> will see the view for the school year.  In that view you will see a
> Groups link.  Clink on that, and you will see the groups you defined
> in your xls file with all of the students as members.  Since you are
> using the standard schooltool package, you won't see anything about
> grade levels there, but you will in your custom package (more on that
> later).  Also, don't mind the presence of the other groups that you
> see there as they are created by schooltool by default for each school
> year.  We will be making use of them later.
>
> Getting back to the school year view (clicking on the 2010 at the
> top), I'd like to point your attention to the following:
>
> 1) There is a term set up that has the same start and end date as the
> school year.
> 2) Clicking on the Courses link shows that there are no courses set
> up.  You need to add lines to the Courses sheet, one per Subject in
> FET, with the school year being 2010 (make sure it's a string), the ID
> being the FET code for the Subject (apparently all caps) and any title
> and description you choose.  We will be using the course ID to match
> up with the FET import data later.
> 3) There are no timetables set up, again not until the FET import.

>
> After the xls file is successfully imported, the FET data needs to be
> imported to complete the picture.  That brings me to the custom
> package that we are making for you.  It's called schooltool.zambia,
> and it contains the code to import the FET data into the school year
> you just set up.  When you click on the 2010 at the top, using the
> custom package, you will see an 'Import FET data' link with the
> actions links right below the solid red bar at the top.  Clicking on
> that will give you the opportunity to upload all of the timetable data
> to scbooltool which will result in the creation of the timetable and
> the classes (we call them sections) that are scheduled on that
> timetable, ready with the appropriate group of students enrolled.  I
> hope to get that to you for testing by the end of the week.
>
> In the meantime, please update the xls file I attached (and return to
> me) with the Courses sheet having all your Subjects.  Also, please add
> the teachers to the Person sheet.  I don't think it makes sense to
> force you to use all caps for the teachers' user names to get them to
> match the FET data.  It seems harsh to force teachers to use caps when
> logging in, so I will make sure the code matches FET teachers to
> schooltool teachers without regard to case.
>
> So, to summarize, the process will be as follows:
>
> 1) Start with no school year defined in schooltool.  This entire
> process can be repeated as many times as we need to get it right
> simply by removing the school year that is there from the last time we
> did these steps.
> 2) Import the xls file to create the school year, courses and student
> groups.  The person objects for the teachers and students will be
> created the first time you do this step, then just harmlessly updated
> any subsequent time.
> 3) Go to the school year view and import the FET data. More
> instructions will come with the custom package.
>
> I will keep you informed of the status of the custom package as the
> week progresses.
>
> Thanks,
> Alan
>
>
> On Thu, May 20, 2010 at 4:25 AM, Jen Overgaag <jovergaag@xxxxxxxxx> wrote:
> > Hello,
> >
> > I am trying to import students and I'm getting an error when I try to
> > specify groups. Below is the error message and attached is the file I'm
> > trying to import.  I assume that I have the layout wrong somewhere.
> >
> > Things I've tried:
> > -deleting all duplicate persons data
> > -removing references and functions and only hard coding names
> > -adding the group name by the web interface first
> >
> > Sorry for the direct question, I still haven't set up an IRC client.
> >
> >
> >
> >
> > Exception
> >
> >   KeyError: 2010.0
> >
> > Traceback
> >
> >   File "/usr/lib/python2.6/dist-packages/zope/publisher/publish.py", line
> > 134, in publish
> >
> >   result = publication.callObject(request, obj)
> > File
> > "/usr/lib/python2.6/dist-packages/zope/app/publication/zopepublication.py",
> > line 205, in callObject
> >
> >   return mapply(ob, request.getPositionalArguments(), request)
> > File "/usr/lib/python2.6/dist-packages/zope/publisher/publish.py", line 109,
> > in mapply
> >
> >   return debug_call(obj, args)
> > Extra information: <zope.browserpage.simpleviewclass.SimpleViewClass from
> > /usr/lib/python2.6/dist-packages/schooltool/export/templates/import.pt
> > object at 0xdf95e0c>
> >
> > File "/usr/lib/python2.6/dist-packages/zope/publisher/publish.py", line 115,
> > in debug_call
> >   return obj(*args)
> >
> > File "/usr/lib/python2.6/dist-packages/zope/browserpage/simpleviewclass.py",
> > line 44, in __call__
> >   return self.index(*args, **kw)
> >
> > File
> > "/usr/lib/python2.6/dist-packages/zope/browserpage/viewpagetemplatefile.py",
> > line 83, in __call__
> >   return self.im_func(im_self, *args, **kw)
> >
> > File
> > "/usr/lib/python2.6/dist-packages/zope/browserpage/viewpagetemplatefile.py",
> > line 51, in __call__
> >   sourceAnnotations=getattr(debug_flags, 'sourceAnnotations', 0),
> >
> > File "/usr/lib/python2.6/dist-packages/zope/pagetemplate/pagetemplate.py",
> > line 115, in pt_render
> >   strictinsert=0, sourceAnnotations=sourceAnnotations)()
> >
> > Template
> > "/usr/lib/python2.6/dist-packages/schooltool/export/templates/import.pt"
> > File "/usr/lib/python2.6/dist-packages/zope/tal/talinterpreter.py", line
> > 271, in __call__
> >
> >   self.interpret(self.program)
> > File "/usr/lib/python2.6/dist-packages/zope/tal/talinterpreter.py", line
> > 343, in interpret
> >
> >   handlers[opcode](self, args)
> > File "/usr/lib/python2.6/dist-packages/zope/tal/talinterpreter.py", line
> > 583, in do_setLocal_tal
> >
> >   self.engine.setLocal(name, self.engine.evaluateValue(expr))
> > File "/usr/lib/python2.6/dist-packages/zope/tales/tales.py", line 696, in
> > evaluate
> >
> >   return expression(self)
> > Template
> > "/usr/lib/python2.6/dist-packages/schooltool/export/templates/import.pt",
> > line 1, column 0
> >
> >   Expression: <PathExpr standard:u'view/update'>
> > File "/usr/lib/python2.6/dist-packages/zope/tales/expressions.py", line 217,
> > in __call__
> >
> >   return self._eval(econtext)
> > File "/usr/lib/python2.6/dist-packages/zope/tales/expressions.py", line 211,
> > in _eval
> >
> >   return ob()
> > File "/usr/lib/python2.6/dist-packages/schooltool/export/importer.py", line
> > 729, in update
> >
> >   imp.import_data(wb)
> > File "/usr/lib/python2.6/dist-packages/schooltool/export/importer.py", line
> > 108, in import_data
> >
> >   return self.process()
> > File "/usr/lib/python2.6/dist-packages/schooltool/export/importer.py", line
> > 688, in process
> >
> >   row = self.import_group(sh, row)
> > File "/usr/lib/python2.6/dist-packages/schooltool/export/importer.py", line
> > 668, in import_group
> >
> >   group = self.createGroup(data)
> > File "/usr/lib/python2.6/dist-packages/schooltool/export/importer.py", line
> > 643, in createGroup
> >
> >   gc = IGroupContainer(syc[data['school_year']])
> > File "/usr/lib/python2.6/dist-packages/zope/container/btree.py", line 88, in
> > __getitem__
> >
> >   return self._SampleContainer__data[key]
> >
> >

Attachment: persons_groups_courses_template.xls
Description: MS-Excel spreadsheet

Attachment: year_timetable_term_template.xls
Description: MS-Excel spreadsheet