Difference between revisions of "LookupTable Import Element From CSV FIle"

From Anote2Wiki
Jump to: navigation, search
Line 39: Line 39:
  
 
</pre>
 
</pre>
 +
 +
In the end of this operation the user can view a [[Resources_Update_Report]]

Revision as of 16:38, 17 July 2012


The user can import information from a CSV file (see examples below) to adding term to Lookup Table. For that user must press the right mouse button in dictionary data-type and select Update From CSV File option in Lookup Table sub-menu. Resources - Lookup Table-> Update From CSV File

boarder

Appears a graphical interface that allows the user to select the CSV file and option.

Lookup Table Update CSV 2.png

Options:

  • File: pressing the File button the user can browse and select csv file on your computer.
  • General Delimiter: The overall file delimiter to separate the contents of columns
  • Text Delimiter: The delimiter to encapsulate information
  • ExternalID Delimiter: The delimiter for separate ExternalId present in a column.
  • ExternalID Source Delimiter: The delimiter for separate ExternalID and Source.
  • Column Options: Select the column indices in which appears interest terms (term, class, synonyms and external IDs)

The .csv file examples :

Example

General delimiter: TAB ( \t )

text Delimiter: NONE

ExternalID Delimiter: Vertical Bar (|)

ExternalID Source Delimiter: WHITE SPACE (;) 


GRF1         Protein   KEGG;zma:542291|P49106;IntAct
GRF2         Protein   Q01526;SMR
ATPA         Protein   -
CYPLXXVIII   Protein   -

In the end of this operation the user can view a Resources_Update_Report

Retrieved from "http://anote-project.org/wiki/index.php?title=LookupTable_Import_Element_From_CSV_FIle&oldid=910"