# error in uploading address-hierarchy

**URL:** <https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982>\
**Category:** Bahmni\
**Created:** [March 19, 2018, 3:31am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982 "2018-03-19T03:31:59Z")\
**Posts on this page:** 18\
**Page:** 2

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:06am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/21 "2018-03-19T05:06:37Z")

</div>

Do you have a tool like [Heidisql](https://www.heidisql.com/download.php)

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 5:08am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/22 "2018-03-19T05:08:14Z")

</div>

re-install is alright, if you can show me how. And no i don’t have that.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:11am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/23 "2018-03-19T05:11:44Z")

</div>

Where are you hosting your server ,windows or Centos?

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 5:12am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/24 "2018-03-19T05:12:35Z")

</div>

I am using Centos

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:13am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/25 "2018-03-19T05:13:49Z")

</div>

you may want to follow this guide [https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-7](https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-7)

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:14am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/26 "2018-03-19T05:14:33Z")

</div>

I may be out here for now but will keep in touch,on mail

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 5:15am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/27 "2018-03-19T05:15:33Z")

</div>

Thank you were so helpfu i try to re-install and post here for any issue

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 5:34am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/28 "2018-03-19T05:34:53Z")

</div>

Am blessed to have been of help 😀

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 19, 2018, 5:36am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/29 "2018-03-19T05:36:41Z")

</div>

Yes, I am learning now how to install mysql, it won’t be easy.

---

<div class="post-metadata">

**Author:** ![darius](https://talk.openmrs.org/user_avatar/talk.openmrs.org/darius/32/8082_2.png) [@darius](https://talk.openmrs.org/u/darius)\
**Post date:** [March 19, 2018, 7:26pm UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/30 "2018-03-19T19:26:35Z")

</div>

Just for context @tendomart, @ezechiel is using the Bahmni distribution of OpenMRS. Bahmni 0.90 would have openmrs-core 2.1.x

@ezechiel according to [https://bahmni.atlassian.net/wiki/spaces/BAH/pages/53837974/List+Of+Configurable+Installation+Variables](https://bahmni.atlassian.net/wiki/spaces/BAH/pages/53837974/List+Of+Configurable+Installation+Variables) the default mysql password if you didn’t set one is “password”.

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [March 19, 2018, 11:43pm UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/31 "2018-03-19T23:43:04Z")

</div>

@darius Thanks for the clarification. So @ezechiel should be home now,given that it’s there by default on that list of Bhamni Variables.

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 20, 2018, 5:47am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/32 "2018-03-20T05:47:54Z")

</div>

Yes the password worked, but I don’t see much about what is wrong here.

 ![2018-03-20](https://talk.openmrs.org/uploads/default/original/2X/5/585c8b34c5f154918ed8e41168e5fe7d207694b8.jpg)

I just don’t see much here.

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 20, 2018, 5:55am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/33 "2018-03-20T05:55:50Z")

</div>

As you can see i was able to login in, any hints of where i can go from here? I also tried to upload the example file from the bahmni website, it still gave an error but It worked in the demo. [address\_hierarchy.csv](https://talk.openmrs.org/uploads/default/original/2X/c/c6c928372e2b0d4e3726e7f9dd78ae21119a5f1e.csv) (10.2 KB) this is the file.

---

<div class="post-metadata">

**Author:** ![ezechiel](https://talk.openmrs.org/letter_avatar/ezechiel/32/6_449c533f586939b6e5f246632a46421f.png) [@ezechiel](https://talk.openmrs.org/u/ezechiel)\
**Post date:** [March 20, 2018, 8:08am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/34 "2018-03-20T08:08:26Z")

</div>

I thought this also might help. I tried to see the source of the problem.

 ![2018-03-20 (1)](https://talk.openmrs.org/uploads/default/original/2X/f/fb2ec62867ab2329771ff348b3bb993d9ac01d9c.png)

---

<div class="post-metadata">

**Author:** ![govind](https://talk.openmrs.org/user_avatar/talk.openmrs.org/govind/32/7233_2.png) [@govind](https://talk.openmrs.org/u/govind)\
**Post date:** [April 21, 2018, 11:55am UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/35 "2018-04-21T11:55:37Z")

</div>

How to upload patient CSV file with some aditional Field. Share me any template . I am using template .when I upload its giving me Error Adress does not exits

---

<div class="post-metadata">

**Author:** ![srimanasa](https://talk.openmrs.org/letter_avatar/srimanasa/32/6_449c533f586939b6e5f246632a46421f.png) [@srimanasa](https://talk.openmrs.org/u/srimanasa)\
**Post date:** [October 25, 2019, 12:59pm UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/36 "2019-10-25T12:59:12Z")

</div>

Hello, I am working on Customization of OpenMRS Module. I got an error in Address hierarchy module when i uploaded a csv file. I uploaded the csv file with an extra column. How can the error be resolved & have a chance to upload the correct csv file. Below is the error shown when i access address hirerachy

[address\_hirerachy\_error.pdf](https://talk.openmrs.org/uploads/short-url/6s37x2UrcNRdjPwwUPJd62oIYIn.pdf) (55.3 KB)

---

<div class="post-metadata">

**Author:** ![tendomart](https://talk.openmrs.org/user_avatar/talk.openmrs.org/tendomart/32/6753_2.png) [@tendomart](https://talk.openmrs.org/u/tendomart)\
**Post date:** [October 25, 2019, 1:19pm UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/37 "2019-10-25T13:19:34Z")

</div>

@srimanasa can you please drop the error at [https://hastebin.com/](https://hastebin.com/)

---

<div class="post-metadata">

**Author:** ![ravi991](https://talk.openmrs.org/letter_avatar/ravi991/32/6_449c533f586939b6e5f246632a46421f.png) [@ravi991](https://talk.openmrs.org/u/ravi991)\
**Post date:** [May 22, 2020, 12:50pm UTC](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982/38 "2020-05-22T12:50:10Z")

</div>

I am also getting error while uploading csv file. Could anyone please provide me with sample csv file which is working.

`No row with given identifier exists`

Also could anyone please provide me with CEIL dictionary csv as well.

[Previous page](https://talk.openmrs.org/t/error-in-uploading-address-hierarchy/16982.md?page=1)
