LookupTable Import Element From CSV FIle

Operation

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

Configuration

A graphical interface is launched that allows the user to select the file / view information about first lines and select General Delimiter,Text Delimiter, DefaultValue and column for add terms and for term class.

• General Delimiter: overall file delimiter to split the contents of different columns (in Blue)
• Text Delimiter: delimiter to encapsulate information (in green)
• Default Value: Default value used to represent empty records; ( in orange )
• Column Selection Options: select the column for terms and for term class (In violet)

Example

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   -

Result

In the end of this operation you can view a resources update report