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

• Lock obtain timed out: NativeFSLock@/Users/despoina/Documents/Indexes/DbIndex/write.lock:
  • Use SimpleFSLockFactory. The default, NativeFSLockFactory, doesn't play well with NFS.
  • ​http://lucene.472066.n3.nabble.com/Lock-obtain-timed-out-td825516.html *

Bbmri @ gcc on vm

​http://vm7.target.rug.nl:8080/bbmri_gcc

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