Changes between Version 15 and Version 16 of SpreadsheetImporter

Timestamp:

01/25/10 02:01:09 (15 years ago)

Author:

mattb

Comment:

Status updates.

SpreadsheetImporter

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