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:26]
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 93: Line 96:
 Proposed format is : Proposed format is :
  
-<data> +     <data> 
-     <row> +          <row> 
-          <column1>->Data in cell(1,1)<-</column1> +               <column1>->Data in cell(1,1)<-</column1> 
-          <column2>->Data in cell(1,2)<-</column2> +               <column2>->Data in cell(1,2)<-</column2> 
-          +               
-          +               
-          +               .  
-          +               
-          +               .  
-     </row> +          </row> 
-     <row> +          <row> 
-     +              
-     +              
-     +              
-     +              
-     +              
-     +              
-</data>+          </row>     
 +    </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 180: Line 190:
  
 Consider a spreadsheet of languages Consider a spreadsheet of languages
 +
 1. English 1. English
  
Line 189: Line 200:
  
 This can be broken up into This can be broken up into
 +
 1. English 1. English
  
Line 221: 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 227: 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 258: 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)