Difference between revisions of "Dictionary Import Element From CSV File"
Anote2Wiki (talk | contribs) |
|||
Line 2: | Line 2: | ||
[[Category:HOWTOs]] | [[Category:HOWTOs]] | ||
− | The user can import information from a CSV file (see examples below) to | + | The user can import information from a CSV file (see examples below) to add terms to a dictionary. For that purpose, the user must press the right button over the dictionary data-type and select the '''Update From CSV File''' option in the Dictionaries sub-menu. '''Resources - Dictionary -> Update From CSV File''' |
[[File:Dictionary_Update_CSV_1.png|1500px|boarder|center]] | [[File:Dictionary_Update_CSV_1.png|1500px|boarder|center]] | ||
− | Appears | + | A GUI Appears that allows the user to select the CSV file to load and select the options. |
[[File:Dictionary_Update_CSV_2.png|800px|center]] | [[File:Dictionary_Update_CSV_2.png|800px|center]] | ||
Line 12: | Line 12: | ||
Basic Options: | Basic Options: | ||
− | * File: pressing the File button the user can browse and select csv file | + | * File: pressing the File button the user can browse and select the csv file from the computer. |
− | * General Delimiter: The overall file delimiter | + | * General Delimiter: The overall file delimiter that separates the contents of the columns in the file |
− | * Text Delimiter: The delimiter to encapsulate | + | * Text Delimiter: The delimiter used to encapsulate individual text strings (if any) |
− | * Synonyms Delimiter: The delimiter for | + | * Synonyms Delimiter: The delimiter for separating synonyms within the list in the specified column |
− | * ExternalID Delimiter: The delimiter for | + | * ExternalID Delimiter: The delimiter for separating ExternalId instances within the list in the specified column. |
− | * ExternalID Source Delimiter: The delimiter for | + | * ExternalID Source Delimiter: The delimiter for separating ExternalIDs and Sources within the list in the specified column. |
− | + | There are also other advanced options. To access those the user must press ''Advance Options'' and a new panel will be shown. | |
[[File:Dictionary_Update_CSV_3.png|800px|center]] | [[File:Dictionary_Update_CSV_3.png|800px|center]] | ||
Advanced Options: | Advanced Options: | ||
− | * Default Value: Default value | + | * Default Value: Default value used to represent empty records; |
− | * Column Options: Select the column indices | + | * Column Options: Select the column indices for each information of interest (term, class, synonyms and external IDs) |
− | + | Next, we provide examples of csv files currently handled by @Note: | |
'''Example 1''' | '''Example 1''' | ||
− | |||
− | |||
''General delimiter:'' TAB ( \t ) | ''General delimiter:'' TAB ( \t ) | ||
Line 41: | Line 39: | ||
''ExternalID Delimiter:'' Vertical Bar (|) | ''ExternalID Delimiter:'' Vertical Bar (|) | ||
− | ''ExternalID Source Delimiter: | + | ''ExternalID Source Delimiter: Semi-colon (;) |
<pre> | <pre> |
Revision as of 14:17, 17 July 2012
The user can import information from a CSV file (see examples below) to add terms to a dictionary. For that purpose, the user must press the right button over the dictionary data-type and select the Update From CSV File option in the Dictionaries sub-menu. Resources - Dictionary -> Update From CSV File
A GUI Appears that allows the user to select the CSV file to load and select the options.
Basic Options:
- File: pressing the File button the user can browse and select the csv file from the computer.
- General Delimiter: The overall file delimiter that separates the contents of the columns in the file
- Text Delimiter: The delimiter used to encapsulate individual text strings (if any)
- Synonyms Delimiter: The delimiter for separating synonyms within the list in the specified column
- ExternalID Delimiter: The delimiter for separating ExternalId instances within the list in the specified column.
- ExternalID Source Delimiter: The delimiter for separating ExternalIDs and Sources within the list in the specified column.
There are also other advanced options. To access those the user must press Advance Options and a new panel will be shown.
Advanced Options:
- Default Value: Default value used to represent empty records;
- Column Options: Select the column indices for each information of interest (term, class, synonyms and external IDs)
Next, we provide examples of csv files currently handled by @Note:
Example 1
General delimiter: TAB ( \t )
text Delimiter: NONE
Synonym Delimiter: Vertical Bar (|)
ExternalID Delimiter: Vertical Bar (|)
ExternalID Source Delimiter: Semi-colon (;)
GRF1 Protein - KEGG;zma:542291|P49106;IntAct GRF2 Protein 14-3-3-like protein GF14-12|GRF2a Q01526;SMR ATPA Protein ATP synthase subunit alpha, mitochondrial - CYPLXXVIII Protein Cytochrome P450 78A1|CYP78A1|CYP78 -
Example 2
General delimiter: Semi-colon ( ; )
text Delimiter: QUOTATIONS MARK (")
Synonym Delimiter: Vertical Bar (|)
ExternalID Delimiter: Vertical Bar (|)
ExternalID Source Delimiter: WHITE SPACE ( )
Column number
- Term: 2
- Class: 1
- Synonyms: 4
- ExternalID: 3
Default Delimiter: HYPHEN (-)
"Protein";"GRF1";"KEGG" "zma:542291"|"P49106" "IntAct";- "Protein";"GRF2;"SMR" "Q01526" ;"14-3-3-like protein GF14-12"|"GRF2a" "Protein";"ATPA";-;"ATP synthase subunit alpha, mitochondrial" "Protein";"CYPLXXVIII";-;"Cytochrome P450 78A1"|"CYP78A1"|"CYP78"