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

From Anote2Wiki
Jump to: navigation, search
Line 1: Line 1:
 +
__TOC__
 
[[Category:HOWTOs]]
 
[[Category:HOWTOs]]
For Lookup Table is possible import element from a csv file.
 
  
Resources -> LookupTables -> Import From CSV file
+
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'''
  
[[File:LookupTAbles_Import_File.png|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.
  
The .csv file must have this format :
+
[[File:Lookup_Table_Update_CSV_2.png|800px|center]]
 +
 
 +
Basic 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.
 +
 
 +
Beyond these parameters there are other advanced options. To access advance option the user must press ''Advance Options'' and will appear in graphical interface a new panel with advanced options.
 +
 
 +
[[File:Dictionary_Update_CSV_3.png|800px|center]]
 +
Advanced Options:
 +
* Default Value: Default value for empty value;
 +
* Column Options: Select the column indices in which appears interest terms (term, class and  external IDs)
 +
 
 +
The .csv file examples :
 +
 
 +
'''Example '''
 +
 
 +
''General delimiter:'' TAB ( \t )
 +
 
 +
''text Delimiter:'' NONE
 +
 
 +
''ExternalID Delimiter:'' Vertical Bar (|)
 +
 
 +
''ExternalID Source Delimiter: WHITE SPACE (;)
  
 
<pre>
 
<pre>
entity,class
+
 
entiyy,class
+
GRF1        Protein  KEGG;zma:542291|P49106;IntAct
(...)
+
GRF2        Protein  Q01526;SMR
 +
ATPA        Protein  -
 +
CYPLXXVIII  Protein  -
 +
 
 
</pre>
 
</pre>

Revision as of 18:36, 20 June 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

Basic 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.

Beyond these parameters there are other advanced options. To access advance option the user must press Advance Options and will appear in graphical interface a new panel with advanced options.

Dictionary Update CSV 3.png

Advanced Options:

  • Default Value: Default value for empty value;
  • Column Options: Select the column indices in which appears interest terms (term, class 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   -