Projectdb

From OLPC

The projectdb (alpha name) is a database designed to capture and track requests for XOs.

It is currently being used as our live contributors program/developers-program interface. Over the past week it has processed 100 applications from LinuxTag.

The code base was given over to OLPC including he database by Aaron Kaplan and Chris Hager, who were the main developers.

Todo: extend the curent data model to cover further aspects of projects, including the stage of completion, idea through implementation, initiatives and trials, as well as projects that require new hardware to get underway.

current use

A half-dozen people are reading data from the current interface and hand-parsing it into xls formats to satisfy a partly in-flux Brightstar process; this will eventually be done via xml (with xml export to B* and xml import from them for confirmation of receipt and shipping). This could be improved; see notes and bugs below:

roadmap

bug fixing

List the proposer's name on the proposer detail page

Make all tables sortable by column

Provide exports of any viewed table to csv (or xls?) as well as B*-xml

Show the date of application and of last update

Fix the apostrophe- and slash-escaping bug in form data

Zip code field in profile page can't be used for postal addresses of non-US countries. If a non-US country's postal address is entered, it places the project in North America on Google Maps.

features

Let admins create new admins or new accounts by email

Let admins see all users on the system; separate from the list of people who sign up and submit a project

Show users their own profile with more active focus on the status of their applications (or the fact that they haven't submitted one yet!) and a visualization of the timelines they suggest'