wiki:DespoinaLog/2011/09/23
  • 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 
Last modified 13 years ago Last modified on 2011-09-23T15:17:30+02:00