• test if search works .
  • in order to test I need data in my local version :
    • TODO : start data migration from vm7 to local
    • dowload at .txt , upload as csv . Works fine ! start from institutes,coordinators,topics,categories and the cohorts
    • But : [ CSV UPLOAD FAILED: Import of 'Biobank' objects failed: cannot find biodata_name='DNA'] (biobank_biodata not available as a form, is not an entity )
      • biobankbiodata is mref --> BiobankDataType
      • There is already a form for <form name="DataTypes" entity="BiobankDataType" />, which in vm7 seems empty, but the DB table Biobank_Biodata not Biobank_biodata is not empty .
    • ....<entity name="BiobankDataType" extends="OntologyTerm">
    • TODO : Add ontology term : <from name="OntologyTermExtendedFromBiodata" entity="OntologyTerm" />,
    • after 1 hour fighting with 404 and 500 error , with no obvious or obscure cause ....
    • the form cannot be shown, maybe OntologyTerm hidden for some reason???
      • NEXT TODO ????? in order to continue the import of Biobank in this way --> only through UI form NOT mysqlimport???
  • Alternative way : mysqlimport the missing Biodata table --> Ontology Term table import . ...
    • mysqldump bbmri OntologyTerm -u molgenis -p > bbmri_OntologyTerm.mysql
    • COPY - PASTE contents of bbmri_OntologyTerm.mysql into mysql prompt in localhost..TADA now we have ontology terms.
    • Also connection with Biobak : 
      • select * from Biobank_Biodata;
      • Empty set (0.00 sec)
      • * antonakd@vm7:~$ mysqldump bbmri Biobank_Biodata -u molgenis -p > bbmri_Biodata.mysql 
      • * Despoina-Antonakakis-MacBook-Pro:~ despoina$ scp    antonakd@vm7.target.rug.nl:bbmri_Biodata.mysql .    
      • COPY_PASTE in mysql .....now we have biodata!
  • try import in COHORT....[ CSV UPLOAD FAILED: Import of 'Biobank' objects failed: cannot find biodata_name='DNA']
  • BiobankdataType? must also be imported