Google Summer of Code 2010: Spreadsheet importer
This project is a part of Sahana Eden Google Summer of Code2010.
Executive Summary
- Abstract: In the aftermath of a disaster, data about victims, survivors, aid organizations, relief camps etc is of crucial importance in relief operations. Mostly, it is seen that data is stored in spreadsheets. Data stored in spreadsheets has to imported to databases for easy querying and other data operations. This project seeks to extract data from spreadsheets, clean it and input the data to the database tables.
- Student: Shikhar Kohli
- Mentors: Mark Prutsalis, Michael Howden, Chamindra de Silva, David Bitner
Code
Progress
- Meetings at 1200 UTC every Wednesday
Timeline
| Midterm Evaluation Milestones: 24 May - 12 July | |||
|---|---|---|---|
| Goal | Measure | Due Date | Status |
| Implement file upload/extraction | User is able to upload files, and incorrect files are flagged | 9/6/2010 | Complete |
| Implement data extraction and mapping to a tree | Data is present in defined data structures | 15/6/2010 | Complete |
| Implement elementary data cleaning operations | Data is cleaned | 20/6/2010 | Complete |
| Start UI development | Elementary UI is in place | 25/6/2010 | Complete |
| Test that everything works | All tests pass and the application functions as it should. | 12/6/2010 | Not Yet Complete |
