Version 13 (modified by 14 years ago) (diff) | ,
---|
import xls data (bbmri into gcc) :
problem with unrecognized duplicate entries.:
Biobank table
- 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
- fax
- tollfreephone
person:
- model :
- address
- phone
- 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
- 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 *
Attachments (1)
- __BBMRI-NL Biobank array_GCC_2.xls (213.5 KB) - added by 14 years ago.
Download all attachments as: .zip