OHDSI Home | Forums | Wiki | Github

Step by Step for loading concepts and vocabularies

Hi,

I am not sure, if there are step by step instructions available for loading concepts and vocabularies. I searched the git repository, I couldn’t find it. I followed the following steps for loading the concepts and vocabularies for the first time. Please let me know, if the following steps are not the right approach.

  1. Run DDLs in empty schema to create the tables.
  2. Run cpt.sh to import CPT to CONCEPT.CSV
  3. load CONCEPT.CSV
  4. loaded the other tables in the following order CONCEPT_ANCESTOR.csv,CONCEPT_RELATIONSHIP.csv, CONCEPT_SYNONYM.csv, VOCABULARY.csv, DOMAIN.CSV, RELATIONSHIP.CSV and DRUG_STRENGTH.CSV.

Thanks,
Priya

t