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:24]
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 92: Line 95:
  
 Proposed format is : Proposed format is :
-<data> + 
-     <row> +     <data> 
-          <column1>->Data in cell(1,1)<-</column1> +          <row> 
-          <column2>->Data in cell(1,2)<-</column2> +               <column1>->Data in cell(1,1)<-</column1> 
-          +               <column2>->Data in cell(1,2)<-</column2> 
-          +               
-          +               
-          +               .  
-          +               
-     </row> +               .  
-     <row> +          </row> 
-     +          <row> 
-     +              
-     +              
-     +              
-     +              
-     +              
-</data>+              
 +          </row>     
 +    </data>
  
  
Line 115: 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 150: 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 161: 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 171: 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 179: Line 190:
  
 Consider a spreadsheet of languages Consider a spreadsheet of languages
 +
 1. English 1. English
 +
 2. Spanish 2. Spanish
 +
 3. French|1337 3. French|1337
 +
 4. Russian, Latin 4. Russian, Latin
  
 This can be broken up into This can be broken up into
 +
 1. English 1. English
 +
 2. Spanish 2. Spanish
 +
 3. French 3. French
 +
 4. 1337 4. 1337
-4. Russian + 
-5. Latin+5. Russian 
 + 
 +6. Latin
  
 Validation will have to be done via JavaScript validation functions. I think those functions are part of another GSoC project. Validation in the UI (ie JS validation) can only be done if JS validation functions are present. Validation will have to be done via JavaScript validation functions. I think those functions are part of another GSoC project. Validation in the UI (ie JS validation) can only be done if JS validation functions are present.
Line 212: 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 218: 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 249: 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)