Changes between Version 15 and Version 16 of SpreadsheetImporter


Ignore:
Timestamp:
01/25/10 02:01:09 (12 years ago)
Author:
mattb
Comment:

Status updates.

Legend:

Unmodified
Added
Removed
Modified
  • SpreadsheetImporter

    v15 v16  
    105105 * (done) Attempt to match csv column names to model column names
    106106 * (done) Present list to user
    107  * allow them to change csv column <-> model column mapping
    108  * Once user confirms column mappings, set job state to 'processing'
    109  * Background cronjob picks up all import jobs in state 'processing', for each data row:
     107 * (done) allow them to change csv column <-> model column mapping
     108 * (done) Once user confirms column mappings, set job state to 'processing'
     109 * (done) Background cronjob picks up all import jobs in state 'processing', for each data row:
    110110   * Parse into dictionary of {'db_column': value, ..} using column name mapping in Job record
    111111   * Validate data using SQLFORM accepts method with dbio=False (no database activity)
     
    116116     * status (ignore, import, imported)
    117117     * data (pickled dictionary from above)
    118  * Background job status set to 'processed'
    119  * Ajax keeps the job page updated with the background job status, until completed
    120  * Display table of rows and validation status to user, default status to ignore for rows that fail validation, import for ones that pass.
     118 * (done) Background job status set to 'processed'
     119 * (done) Ajax keeps the job page updated with the background job status, until completed
     120 * (done) Display table of rows and validation status to user, default status to ignore for rows that fail validation, import for ones that pass.
    121121   * Future enhancements will most likely occur at this step
    122122     * Allow user to edit/fix fields that failed validation and re-validate
    123123     * Present list of likely duplicate entries alongside each imported entry
    124  * User can de-select any row to ignore it, !ImportLine status set to 'ignore'
    125  * Once user has checked all rows, click 'Import', set job state to 'import'
    126  * Background cronjob picks up all import jobs in state 'import', for each !ImportLine with status=import:
     124 * (done) User can de-select any row to ignore it, !ImportLine status set to 'ignore'
     125 * (done) Once user has checked all rows, click 'Import', set job state to 'import'
     126 * (done) Background cronjob picks up all import jobs in state 'import', for each !ImportLine with status=import:
    127127   * Insert data via SQLFORM.accepts method (dbio defaults to True this time, put into DB)
    128128     * pass special onvalidation method to accepts, to covert lat, long to wkt as shown above.
    129129   * Update !ImportLine status to imported.
    130  * Background job status set to 'completed'
     130 * (done) Background job status set to 'imported'
    131131
    132132=== Google Spreadsheets API ===