# Problem Setting up Drug data using CSV import

**URL:** <https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877>\
**Category:** Ask OpenMRS\
**Tags:** refapp-2․6, metadata-sharing, cohort-builder\
**Created:** [August 14, 2017, 1:02pm UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877 "2017-08-14T13:02:10Z")\
**Posts on this page:** 9\
**Page:** 2

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [August 16, 2017, 9:22am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/21 "2017-08-16T09:22:19Z")

</div>

Did you take a look at how to connect to the standalone database using this? [https://wiki.openmrs.org/display/docs/OpenMRS+Standalone](https://wiki.openmrs.org/display/docs/OpenMRS+Standalone)

---

<div class="post-metadata">

**Author:** ![upendo](https://talk.openmrs.org/user_avatar/talk.openmrs.org/upendo/32/5288_2.png) [@upendo](https://talk.openmrs.org/u/upendo)\
**Post date:** [August 16, 2017, 9:27am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/22 "2017-08-16T09:27:45Z")

</div>

Yes I did and the openers user does not exist nor does the database name.

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [August 16, 2017, 9:44am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/23 "2017-08-16T09:44:52Z")

</div>

What exact steps and commands did you try?

---

<div class="post-metadata">

**Author:** ![millicent](https://talk.openmrs.org/letter_avatar/millicent/32/5_5575768a8748004e209b776fc1b2916d.png) [@millicent](https://talk.openmrs.org/u/millicent)\
**Post date:** [August 16, 2017, 10:07am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/24 "2017-08-16T10:07:35Z")

</div>

@upendo Please use ./mysql -u openmrs -p --port=3317 --host=127.0.0.1 command and specify the port you are using

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [August 16, 2017, 10:17am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/25 "2017-08-16T10:17:22Z")

</div>

@millicent you are so awesome!!! 😄

---

<div class="post-metadata">

**Author:** ![upendo](https://talk.openmrs.org/user_avatar/talk.openmrs.org/upendo/32/5288_2.png) [@upendo](https://talk.openmrs.org/u/upendo)\
**Post date:** [August 16, 2017, 11:41am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/26 "2017-08-16T11:41:27Z")

</div>

@milicent Thanks for the help. That works. Data has been successfully updated.

---

<div class="post-metadata">

**Author:** ![millicent](https://talk.openmrs.org/letter_avatar/millicent/32/5_5575768a8748004e209b776fc1b2916d.png) [@millicent](https://talk.openmrs.org/u/millicent)\
**Post date:** [August 16, 2017, 12:18pm UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/27 "2017-08-16T12:18:08Z")

</div>

😄 Thanks @dkayiwa

---

<div class="post-metadata">

**Author:** ![upendo](https://talk.openmrs.org/user_avatar/talk.openmrs.org/upendo/32/5288_2.png) [@upendo](https://talk.openmrs.org/u/upendo)\
**Post date:** [August 16, 2017, 12:51pm UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/28 "2017-08-16T12:51:29Z")

</div>

I have edit [this wiki](https://wiki.openmrs.org/display/docs/Getting+and+Using+the+MVP-CIEL+Concept+Dictionary) with examples on how to make the import, with @millicent 's working Implementation too. Thank you @darius @dkayiwa @mksd

---

<div class="post-metadata">

**Author:** ![hmouhtar](https://talk.openmrs.org/user_avatar/talk.openmrs.org/hmouhtar/32/17425_2.png) [@hmouhtar](https://talk.openmrs.org/u/hmouhtar)\
**Post date:** [November 20, 2022, 3:28am UTC](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877/29 "2022-11-20T03:28:58Z")

</div>

Hello,

I’m trying to upload a CSV file with a list of drugs. How can I use the metadata sharing module to achieve this? I understand I’m supposed to import a “package”, but I’m not sure what that is.

@dkayiwa @upendo

 ![OpenMRS (2)](https://talk.openmrs.org/uploads/default/original/3X/6/4/642f41dcb6f01e06a25c9cf90912c6b17ec5acf2.png)

[Previous page](https://talk.openmrs.org/t/problem-setting-up-drug-data-using-csv-import/12877.md?page=1)