Changes between Version 1 and Version 2 of BluePrintImporterFunctional

05/05/10 19:13:37 (14 years ago)
Shikhar Kohli



  • BluePrintImporterFunctional

    v1 v2  
    1 This is the wiki page for the Importer project.
     1= !SpreadSheet Importer Specifications =
     2The spreadsheet importer project is one of Sahana Software Foundation's GSoC 2010 projects. This project aims to import data from spreadsheets, develop a UI and develop functions to automatically cleanse data that is being imported from the spreadsheets. For the proposal [ click here]
     4'''Please note that this specification is currently a work in progress '''
     6== History ==
     8== Overview ==
     10=== Scenarios ===
     11A disaster has occurred in XYZ country 2 days ago. Local agencies and NGOs quickly got together to aid the victims of the disaster and have already started collecting data about the survivors and about the needs for an imminent relief mission. Although the data collected is comprehensive and complete, every agency has uploaded this data in the form of spreadsheets on their servers. Medicine Sans Frontier has stepped in and while it has the resources to alleviate the suffering of the disaster stricken, it has no data on the number of casualties and/or the number of survivors. The data stored by the local agencies is useful, but scattered and will have to be used if any effective relief operation is to be attempted. However, the data is so large and so diverse that manually going through each spreadsheet is a task that could take weeks.
     13=== Non goals ===
     14For now, the system will focus mainly on collating data stored in XLS files and Google spreadsheets. For the duration of GSoC, I intend to first implement methods for these formats and then for other files.
     16=== Definitions ===
     17<not decided yet>
     19=== Flowcharts ===
     21=== Menu ===
     23=== Screens ===
     25=== APIs ===
     26S3XRC framework.
     27<Shall I keep updating this page side by side with the project? I haven't decided the names of the functions yet>
     29=== Technologies ===
     31* pyExcelerator[[BR]]
     33* Google Docs
     35=== Comments ===