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

From Anote2Wiki
Jump to: navigation, search
Line 2: Line 2:
 
[[Category:HOWTOs]]
 
[[Category:HOWTOs]]
  
−
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'''
+
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, the user right clicks in the lookup table object and selects '''Update From CSV File''' in the Lookup Table sub-menu: '''Resources - Lookup Table-> Update From CSV File'''.
  
 
[[File:Lookup_Table_Update_CSV_1.png|1500px|boarder|center]]
 
[[File:Lookup_Table_Update_CSV_1.png|1500px|boarder|center]]
  
−
Appears a graphical interface that allows the user to select the CSV file and option.
+
A graphical interface is launched that allows the user 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:
 +
* 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)
  
−
* File: pressing the File button the user can browse and select csv file on your computer.
+
Some examples :
−
* 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 '''
 
'''Example '''

Revision as of 16:04, 9 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, the user right clicks in the lookup table object and selects Update From CSV File in the Lookup Table sub-menu: Resources - Lookup Table-> Update From CSV File.

boarder

A graphical interface is launched that allows the user to select the file in the upper panel and define several loading options.

Lookup Table Update CSV 2.png

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: 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=1378"