Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
foundation:gsoc_kohli_specs [2010/06/05 11:27]
shikharkohli
foundation:gsoc_kohli_specs [2010/12/18 17:35] (current)
Line 81: Line 81:
 __**UI begins**__ __**UI begins**__
  
-{{:foundation:uimockups1.jpg?1170x500|}}+ 
 +{{:foundation:input.jpg|}} 
 + 
 +{{:foundation:spreadsheeturl.jpg|}}
  
 The data extracted from the spreadsheets is converted from list of lists format to an XML file. This is done for two reasons: The data extracted from the spreadsheets is converted from list of lists format to an XML file. This is done for two reasons:
Line 110: Line 113:
               .               .
               .               .
 +          </row>    
     </data>     </data>
  
Line 116: Line 120:
  
 The user will be able to modify each and every record in this view. Column headers can also be identified. Again, the column headers are editable. The user will be able to modify each and every record in this view. Column headers can also be identified. Again, the column headers are editable.
 +
 +{{:foundation:spreadsheet.jpg?1170x500|}}
  
  
Line 151: Line 157:
  
 Again, we will need a pre-generated XML file with table data which can be parsed to the view. Again, we will need a pre-generated XML file with table data which can be parsed to the view.
 +
 +{{:foundation:selectable.jpeg|}}
  
 __**Step 6**__ __**Step 6**__
Line 162: Line 170:
 If the number of columns in the Eden db is less than the number of columns in the spreadsheet, data can be appended in the comments column. If the number of columns in the Eden db is less than the number of columns in the spreadsheet, data can be appended in the comments column.
  
-{{:foundation:uimockups2_001.jpg|}}+{{:foundation:mapping.jpg|}} 
  
 __**Step 7**__ __**Step 7**__
Line 172: Line 181:
 Duplicates are now identified, and are flagged for the user. I intend to use the levenshtein function in s3vita.py to calculate the "distance" between the strings and then decide which strings are too similar. Duplicates are now identified, and are flagged for the user. I intend to use the levenshtein function in s3vita.py to calculate the "distance" between the strings and then decide which strings are too similar.
  
-//"Select characters to parse cell on"//+__//"Select characters to parse cell on"//__ 
 Sometimes, users separate different records by using characters such as ,(comma) . (dot) | (pipe). Sometimes, users separate different records by using characters such as ,(comma) . (dot) | (pipe).
  
Line 223: Line 233:
  
 Please see http://eden.sahanafoundation.org/wiki/S3XRC Please see http://eden.sahanafoundation.org/wiki/S3XRC
 +
 +__Note:__//Importing to multiple tables//
 +
 +One of the suggestions for this project was to enable importing to multiple tables. However, this is not currently supported by S3XRC.
  
 __**Step 9**__ __**Step 9**__
Line 229: Line 243:
  
 Records which could not be imported are shown again to the user in the view. After modifying those records, the user can attempt importing again. Records which could not be imported are shown again to the user in the view. After modifying those records, the user can attempt importing again.
- 
  
  
Line 260: Line 273:
  
 ^Version^Date^Comment^ ^Version^Date^Comment^
 +
 +
 +version 0.7| 5 June,2010| Clean up of the documents
 +
 version 0.6|3 June, 2010| Suggestions discussed in meeting(2 June) incorporated version 0.6|3 June, 2010| Suggestions discussed in meeting(2 June) incorporated
 +
 version  0.5|2 June, 2010|Introduced the cleaning after mapping step version  0.5|2 June, 2010|Introduced the cleaning after mapping step
  

QR Code
QR Code foundation:gsoc_kohli_specs (generated for current page)