Differences
This shows you the differences between two versions of the page.
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**__ | ||
- | {{: | + | |
+ | {{: | ||
+ | |||
+ | {{: | ||
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 : | ||
- | < | + | |
- | | + | < |
- | < | + | < |
- | < | + | |
- | . | + | |
- | . | + | |
- | . | + | |
- | . | + | |
- | . | + | |
- | | + | |
- | | + | </ |
- | | + | < |
- | | + | . |
- | | + | . |
- | | + | . |
- | | + | . |
- | | + | . |
- | </ | + | . |
+ | </ | ||
+ | | ||
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. | ||
+ | |||
+ | {{: | ||
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. | ||
+ | |||
+ | {{: | ||
__**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, | If the number of columns in the Eden db is less than the number of columns in the spreadsheet, | ||
- | {{: | + | {{: |
__**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 " | Duplicates are now identified, and are flagged for the user. I intend to use the levenshtein function in s3vita.py to calculate the " | ||
- | //" | + | __//" |
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:// | Please see http:// | ||
+ | |||
+ | __Note: | ||
+ | |||
+ | 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 | version | ||