# Export to IR issue\_datafield not being exported

**URL:** <https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252>\
**Category:** GBVIMS\
**Tags:** v1-5\
**Created:** [September 11, 2019, 8:51am UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252 "2019-09-11T08:51:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ekormawa](https://support.primero.org/forum/letter_avatar_proxy/v4/letter/e/6f9a4e/32.png) [@ekormawa](https://support.primero.org/forum/u/ekormawa)\
**Post date:** [September 11, 2019, 8:51am UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252/1 "2019-09-11T08:51:26Z")

</div>

Hello,

When exporting the list of incidents for monthly reports (i.e. copy/paste into excel based Incident Recorder) one data field related to legal assistance (y/no/undecided) is not being exported properly i.e when exported to excel sheet only ‘undecided’ shows. Survivors that answered ‘yes’ or ‘no’ have blank cell.

Help!

---

<div class="post-metadata">

**Author:** ![irlawrence](https://support.primero.org/forum/user_avatar/support.primero.org/irlawrence/32/8_2.png) [@irlawrence](https://support.primero.org/forum/u/irlawrence)\
**Post date:** [September 16, 2019, 9:19pm UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252/2 "2019-09-16T21:19:12Z")

</div>

This is likely a bug in the excel export on v1.5.  
A work around is to export to CSV (and then open that in Excel) and you can see the values are maintained. You can then copy the column into the original excel file

---

<div class="post-metadata">

**Author:** ![community](https://support.primero.org/forum/user_avatar/support.primero.org/community/32/1_2.png) [@community](https://support.primero.org/forum/u/community)\
**Post date:** [November 17, 2019, 1:37pm UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252/3 "2019-11-17T13:37:12Z")

</div>

## Helpdesk issue was created by Ian Lawrence: Export to IR issue

When exporting the list of incidents for monthly reports (i.e. copy/paste into excel based Incident Recorder) one data field related to legal assistance (y/no/undecided) is not being exported properly i.e when exported to excel sheet only ‘undecided’ shows. Survivors that answered ‘yes’ or ‘no’ have blank cell.

---

<div class="post-metadata">

**Author:** ![community](https://support.primero.org/forum/user_avatar/support.primero.org/community/32/1_2.png) [@community](https://support.primero.org/forum/u/community)\
**Post date:** [November 20, 2019, 1:05pm UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252/5 "2019-11-20T13:05:14Z")

</div>

## New public comment was posted to Helpdesk by [rodrigo@jozian.com](mailto:rodrigo@jozian.com)

Fix pushed to [https://github.com/primeroIMS/primero/pull/15](https://github.com/primeroIMS/primero/pull/15).

---

<div class="post-metadata">

**Author:** ![community](https://support.primero.org/forum/user_avatar/support.primero.org/community/32/1_2.png) [@community](https://support.primero.org/forum/u/community)\
**Post date:** [November 20, 2019, 1:17pm UTC](https://support.primero.org/forum/t/export-to-ir-issue-datafield-not-being-exported/252/6 "2019-11-20T13:17:56Z")

</div>

## New public comment was posted to Helpdesk by [rodrigo@jozian.com](mailto:rodrigo@jozian.com)

The value of legal\_couseling was coming as string but code was expecting boolean.