wiki:DespoinaLog/2010/12/15

import xls data (bbmri into gcc) :

problem with unrecognized duplicate entries.:

Biobank table

model

  • name (required)
  • investigation_name
  • ontologyreference_name
  • individuals_name
  • species_name
  • paneltype_name (required)
  • founderpanels_name
  • acronym
  • institutes_name
  • publications_id (required)
  • category_name(required)
  • type (required)
  • person_lastname (required)
  • topics_name (required)
  • materials_name (required)
  • size
  • lastupdate
  • description
  • GwaDataNum?
  • GwaPlatform?
  • GwaComments?
  • investigation_name

xls

  • name (required)
  • type (required)
  • acronym
  • category_name(required)
  • topics_name (required)
  • institutes_name
  • person_lastname (required)
  • size
  • materials_name (required)
  • GwaDataNum?
  • GwaPlatform?
  • GwaComments?
  • description
  • paneltype_name (required)

Person table

there is another entity - contact :

  • address
  • phone
  • email
  • fax
  • tollfreephone

person:

  • model :
    • address
    • phone
    • email
    • fax
    • tollfreephone
    • firstname
    • midinitials
    • lastname (required)
    • affiliation_name
    • roles_name
  • xls:
    • lastname

Ontologyterm

model :

  • id
  • name (required)
  • ontology_id
  • termaccession
  • definition
  • termpath

xls :

  • name

Institute

model :

  • address
  • phone
  • email
  • fax
  • tollfreephone
  • name (required)

xls * name

observablefeature

model

  • name (required)
  • investigation_name
  • ontologyreference_name

xls * name

observablefeature

model

  • name (required)
  • investigation_name
  • ontologyreference_name

xls * name

observedvalue

model

  • investigation_name (required)
  • protocolapplication_name
  • feature_name (required)
  • target_name (required)
  • ontologyreference_name
  • value
  • relation_name
  • time
  • endtime

xls * target_name

  • feature_name
  • value
  • investigation_name

investigation

model

  • name (required)
  • start
  • end
  • description
  • accession

xls * name

observationelement

model

  • name (required)
  • investigation_name
  • ontologyreference_name

xls * name

  • investigation_name

Import successful !

Build index into gcc

Bbmri @ gcc on vm

http://vm7.target.rug.nl:6180/bbmri_gcc

http://wiki.gcc.rug.nl/wiki/TomcatManual

Last modified 13 years ago Last modified on 2010-12-15T15:54:40+01:00

Attachments (1)

Download all attachments as: .zip