Difference between revisions of "LookupTable Import Element From CSV FIle"
Anote2Wiki (talk | contribs) |
|||
| Line 4: | Line 4: | ||
The application allows a set of terms to be imported into a lookup table from a file in the CSV format. | The application allows a set of terms to be imported into a lookup table from a file in the CSV format. | ||
The format of this file is quite flexible allowing several different configurations (see definitions and examples below). | The format of this file is quite flexible allowing several different configurations (see definitions and examples below). | ||
| − | For that purpose, | + | For that purpose, right click in the lookup table object and select '''Load Lookup Table (CVS File)''' in the Lookup Table sub-menu: '''Resources - Lookup Table-> Load Lookup Table (CVS File)'''. |
| + | |||
[[File:Lookup_Table_Update_CSV_1.png|1500px|boarder|center]] | [[File:Lookup_Table_Update_CSV_1.png|1500px|boarder|center]] | ||
| − | A graphical interface is launched that allows | + | |
| + | A graphical interface is launched that allows to select the file in the upper panel and define several loading options. | ||
| + | |||
[[File:Lookup_Table_Update_CSV_2.png|800px|center]] | [[File:Lookup_Table_Update_CSV_2.png|800px|center]] | ||
| + | |||
Options: | Options: | ||
| Line 40: | Line 44: | ||
</pre> | </pre> | ||
| − | In the end of this operation | + | |
| + | In the end of this operation you can view a [[Resources_Update_Report| resources update report]] | ||
Revision as of 21:17, 16 January 2013
The application allows a set of terms to be imported into a lookup table from a file in the CSV format.
The format of this file is quite flexible allowing several different configurations (see definitions and examples below).
For that purpose, right click in the lookup table object and select Load Lookup Table (CVS File) in the Lookup Table sub-menu: Resources - Lookup Table-> Load Lookup Table (CVS File).
A graphical interface is launched that allows to select the file in the upper panel and define several loading options.
Options:
- General Delimiter: overall file delimiter to split the contents of different columns
- Text Delimiter: delimiter to encapsulate information
- ExternalID Delimiter: delimiter for splitting External Ids present in the respective column.
- ExternalID Source Delimiter: delimiter for splitting External ID and respective source database.
- Column Options: select the column indexes where the relevant information is provided (term, class, synonyms and external IDs)
Some examples :
Example
General delimiter: TAB ( \t )
text Delimiter: NONE
ExternalID Delimiter: Vertical Bar (|)
ExternalID Source Delimiter: ;
GRF1 Protein KEGG;zma:542291|P49106;IntAct GRF2 Protein Q01526;SMR ATPA Protein - CYPLXXVIII Protein -
In the end of this operation you can view a resources update report
