Add demographics to database export & spreadsheet import

[Tom Hoffman]

I was able to recover much information from the file. I was hoping for a
little more details under the *person* tab. I only got the user name, first
name and Last name. All the other fields like gender, ethnicity, etc were
left blank. So our taks is now ahead of us to piece together the missing
data. However this help certainly makes the task much easier.

[Douglas Cerna (replaceafill)]

Looking at the code and after installing and testing SchoolTool 0.11.2-1 in my Edubuntu 5 VM, I only see the following attributes under "Details" for a person:

- Nickname (A short nickname for this person.)
- Primary Email
- Secondary Email
- Primary phone
- Secondary phone
- Mailing address
- Website

I can't find code in 0.11.4 referring to gender, ethnicity or any other demographics attribute useful to populate the "Persons" sheet in the generated XLS. I see no useful attributes there to import back to a recent version of SchoolTool.

Am I missing something? Should we just dump these "Details" attributes in an extra sheet like Justas suggested?

[Trevor Joefield (tjoefield)]

Hi Douglas,

You are correct. When I view the data.fs file in my earlier version of
school tool I see exactly the same fields as you are seeing. When I view the
information on the live system I see additionally fields. I conclude that
after installation, the application was customized to capture additional
data critical to the institute. When I run the export tool it generates the
heading for all these fields (see attached for reference).

As stated before, any help to obtain additional information is most welcome.
So if dumping the details attribute in an extra sheet does that, as
suggested by Justas, I'll be thankful.

In addition to the data that I already have, the other two critical fields
in the existing data set are: the *data of birth* and the *ID* fields which
I see on the live application. Like the many other fields these appear to be
customized fields and I'm not sure to what extent the tool can populate
them.

Thanks again for all the help

Trevor

On 16 November 2010 04:25, Douglas Cerna <email address hidden> wrote:

> Looking at the code and after installing and testing SchoolTool 0.11.2-1
> in my Edubuntu 5 VM, I only see the following attributes under "Details"
> for a person:
>
> - Nickname (A short nickname for this person.)
> - Primary Email
> - Secondary Email
> - Primary phone
> - Secondary phone
> - Mailing address
> - Website
>
> I can't find code in 0.11.4 referring to gender, ethnicity or any other
> demographics attribute useful to populate the "Persons" sheet in the
> generated XLS. I see no useful attributes there to import back to a
> recent version of SchoolTool.
>
> Am I missing something? Should we just dump these "Details" attributes
> in an extra sheet like Justas suggested?
>
> --
> Add demographics to database export & spreadsheet import
> https://bugs.launchpad.net/bugs/675662
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in SchoolTool: Triaged
>
> Bug description:
> I was able to recover much information from the file. I was hoping for a
> little more details under the *person* tab. I only got the user name, first
> name and Last name. All the other fields like gender, ethnicity, etc were
> left blank. So our taks is now ahead of us to piece together the missing
> data. However this help certainly makes the task much easier.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/schooltool/+bug/675662/+subscribe
>

[Tom Hoffman (tom-hoffman)]

OK. I think I understand what's going on. The database export script puts the data into the standard import spreadsheet for current SchoolTool, so those fields are not on the spreadsheet as any sort of indication that those fields were actually in your old database. Which presumably is why Douglas can't find them in his instance.

So, unless you have a very specific reason to think they were in your old database (e.g., you can fire up your old instance and show us), I think it is safe to conclude they were never entered (nor could they have been).

[Trevor Joefield (tjoefield)]

Hi Tom,

I am able to view the old instance of my data.fs file from two version of
Ubuntu

   1. When viewing it on Edubuntu I am able to see information in the
   following Details fields:
      - Nickname
   - Primary email
      - Secondary email
      - Primary phone
      - Secondary phone
      - Mailing Address
   2. When viewing the old application which is still up and running, I am
   able to view all of the above plus the following additional fields
      - Data of birth
      - Identification Number

I'm also able to see a photos of some of the students. There is also a
history link which provides some additional demographic information.

I realise that some customization was done prior to my time on this
application. Therefore any steps that can be taken to simply dump all of the
details present in the old data.fs file will be appreciated.

The birth date and ID number are critical for us to tell one student from
the other. The old version was probably customized to capture this
information. The new version of school tool now allow for this data to be
collected. Since we already have that information in the old data.fs file it
would be nice if we could access it.

Thanks much

Trevor

On 17 November 2010 10:48, Tom Hoffman <email address hidden> wrote:

> OK. I think I understand what's going on. The database export script
> puts the data into the standard import spreadsheet for current
> SchoolTool, so those fields are not on the spreadsheet as any sort of
> indication that those fields were actually in your old database. Which
> presumably is why Douglas can't find them in his instance.
>
> So, unless you have a very specific reason to think they were in your
> old database (e.g., you can fire up your old instance and show us), I
> think it is safe to conclude they were never entered (nor could they
> have been).
>
> ** Changed in: schooltool
> Status: Triaged => Invalid
>
> --
> Add demographics to database export & spreadsheet import
> https://bugs.launchpad.net/bugs/675662
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in SchoolTool: Invalid
>
> Bug description:
> I was able to recover much information from the file. I was hoping for a
> little more details under the *person* tab. I only got the user name, first
> name and Last name. All the other fields like gender, ethnicity, etc were
> left blank. So our taks is now ahead of us to piece together the missing
> data. However this help certainly makes the task much easier.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/schooltool/+bug/675662/+subscribe
>

[Tom Hoffman (tom-hoffman)]

OK... hm... actually you probably have that data then because it was in an OLDER version of SchoolTool. We'll look into this.

[Douglas Cerna (replaceafill)]

Trevor:

Could you please go to your Edubuntu and run the following commands in a terminal:

$ uname -a
$ cat /etc/issue
$ dpkg -l schooltool

and paste the results here?

That would let us know the exact versions you're using. From https://answers.launchpad.net/schooltool/+question/117206 I understand you're running version "0.11.4-1build1" of SchoolTool.

[Trevor Joefield (tjoefield)]

Hi Douglas,

As requested, see below

tjoefield@edubuntu:~$ uname -a
Linux edubuntu 2.6.15-26-386 #1 PREEMPT Thu Aug 3 02:52:00 UTC 2006 i686
GNU/Linux
tjoefield@edubuntu:~$ cat/etc/issue
bash: cat/etc/issue: No such file or directory
tjoefield@edubuntu:~$ dpkg -l schooltool
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
ii schooltool 0.11.4-1build1 common platform for school administration
tjoefield@edubuntu:~$

Trevor

On 17 November 2010 13:10, Douglas Cerna <email address hidden> wrote:

> Trevor:
>
> Could you please go to your Edubuntu and run the following commands in a
> terminal:
>
> $ uname -a
> $ cat /etc/issue
> $ dpkg -l schooltool
>
> and paste the results here?
>
> That would let us know the exact versions you're using. From
> https://answers.launchpad.net/schooltool/+question/117206 I understand
> you're running version "0.11.4-1build1" of SchoolTool.
>
> --
> Add demographics to database export & spreadsheet import
> https://bugs.launchpad.net/bugs/675662
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in SchoolTool: Incomplete
>
> Bug description:
> I was able to recover much information from the file. I was hoping for a
> little more details under the *person* tab. I only got the user name, first
> name and Last name. All the other fields like gender, ethnicity, etc were
> left blank. So our taks is now ahead of us to piece together the missing
> data. However this help certainly makes the task much easier.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/schooltool/+bug/675662/+subscribe
>

[Douglas Cerna (replaceafill)]

Trevor:

You missed a space:

$ cat /etc/issue

(space between the 't' and '/') :)

Thanks.

[Trevor Joefield (tjoefield)]

Douglas,

Sorry about that

The code returned the following result

Ubuntu 6.06.1 LTS \n \l

Trevor

On 17 November 2010 13:49, Douglas Cerna <email address hidden> wrote:

> Trevor:
>
> You missed a space:
>
> $ cat /etc/issue
>
> (space between the 't' and '/') :)
>
> Thanks.
>
> --
> Add demographics to database export & spreadsheet import
> https://bugs.launchpad.net/bugs/675662
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in SchoolTool: Incomplete
>
> Bug description:
> I was able to recover much information from the file. I was hoping for a
> little more details under the *person* tab. I only got the user name, first
> name and Last name. All the other fields like gender, ethnicity, etc were
> left blank. So our taks is now ahead of us to piece together the missing
> data. However this help certainly makes the task much easier.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/schooltool/+bug/675662/+subscribe
>

[Justas Sadzevičius (justas.sadzevicius)]

Trevor, can you try to locate the schooltool source code (of your old application) please, then archive it and send it to us? It might be in /usr/lib/python2.4/site-packages/schooltool and <...>/schoolbell (or similar). We need both schooltool and schoolbell.

[Trevor Joefield (tjoefield)]

Hi Justas,

I will make arrangements to get this to you a.s.a.p.
I'm out of office for one week, so if it cannot be located while I.m away, I
will attend to it first thing on my return to the office next week.

Thanks much

Trevor

2010/11/18 Justas Sadzevičius <email address hidden>

> Trevor, can you try to locate the schooltool source code (of your old
> application) please, then archive it and send it to us? It might be in
> /usr/lib/python2.4/site-packages/schooltool and <...>/schoolbell (or
> similar). We need both schooltool and schoolbell.
>
> --
> Add demographics to database export & spreadsheet import
> https://bugs.launchpad.net/bugs/675662
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in SchoolTool: Incomplete
>
> Bug description:
> I was able to recover much information from the file. I was hoping for a
> little more details under the *person* tab. I only got the user name, first
> name and Last name. All the other fields like gender, ethnicity, etc were
> left blank. So our taks is now ahead of us to piece together the missing
> data. However this help certainly makes the task much easier.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/schooltool/+bug/675662/+subscribe
>