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)
• contacts_id (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
• contacts_id (required)
• size
• materials_name (required)
• GwaDataNum?
• GwaPlatform?
• GwaComments?
• description
• * paneltype_name (required)

• Missing from biobank (xls) (but doesn't seem a problem) :
  • publications_id (mref, required)
  • contacts_id (mref, required)

Existing in xls but not in the model

• person_lastName (Is this the xref to Contact/person Entity)?
• GWA data n =
• GWA platform
• GWA comments

Existing in model but not in the xls

• ontologyreference_name xref
• individuals_name mref
• species_name xref
• founderpanels_name
• mref publications_id mref YES (required)
• enum YES (required)
• contacts_id mref YES(required)
• lastupdate date

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

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 *