# Is there a way to export Contact level call notes?

**URL:** <https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986>\
**Category:** Product Support\
**Tags:** mautic-4\
**Created:** [December 11, 2021, 3:29pm UTC](https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986 "2021-12-11T15:29:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [December 11, 2021, 3:29pm UTC](https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986/1 "2021-12-11T15:29:12Z")

</div>

Is there a way to export Contact level “call notes”?

I mean the interaction Notes that you can enter under each contact; General, Email, Call, Meeting. They are not included when I export a report or segment data.

I use self-hosted Mautic 4.

---

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [December 12, 2021, 1:49pm UTC](https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986/2 "2021-12-12T13:49:14Z")

</div>

There doesn’t seem to be any built-in way to export call Notes - disappointing, please correct me if I’m wrong.

[Apparently you have to go into the database/phpmyadmin](https://forum.mautic.org/t/mass-importing-contact-notes/18859/2) and the Notes are stored in a database table lead\_notes by contact ID.

I guess I have to write a SQL query, something like ‘get Notes where ID is mylist of IDs’. Has anyone done this? What is the quickest, easiest way?

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [December 13, 2021, 8:08am UTC](https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986/3 "2021-12-13T08:08:07Z")

</div>

are you working in terminal or via cpanel ?

If you are in terminal it is pretty simple:  
mysql -u [db\_username] [db\_name] -p[password] -sN -e “select email, text, type, date\_time from leads, lead\_notes where leads.id = lead\_notes.lead\_id” \> all\_my\_notes.csv  
sed -e “s/\t/,/g” all\_my\_notes.csv

The above two commands will extract the email, text, type, date\_time of all your notes and create them inside a file that is comma separated.

---

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [December 17, 2021, 12:37pm UTC](https://forum.mautic.org/t/is-there-a-way-to-export-contact-level-call-notes/21986/4 "2021-12-17T12:37:29Z")

</div>

Thanks, but that terminal solution is not simple or practical at all. I was looking for a solution in the actual Mautic application.

I can go into the database with phpmyadmin and just export database table lead\_notes, a more straightforward way to get all\_my\_notes.

But I don’t see an easy way to get only the notes of a certain segment or notes by campaign etc. I’d have to write advanced SQL queries for that I guess. Has anyone done that? Examples how to do it? Or is there another way?

Feature request then? Is this on the roadmap, exporting notes with contacts in Reports or from Segments?