# Mass importing Contact Notes

**URL:** <https://forum.mautic.org/t/mass-importing-contact-notes/18859>\
**Category:** Product Support\
**Tags:** development, mautic-3\
**Created:** [April 6, 2021, 8:48am UTC](https://forum.mautic.org/t/mass-importing-contact-notes/18859 "2021-04-06T08:48:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cilmion](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cilmion/32/956_2.png) [@cilmion](https://forum.mautic.org/u/cilmion)\
**Post date:** [April 6, 2021, 8:48am UTC](https://forum.mautic.org/t/mass-importing-contact-notes/18859/1 "2021-04-06T08:48:16Z")

</div>

**Your software**  
My Mautic version is: 3.3.2  
My PHP version is: 7.4.16  
My Database type and version is: MariaDB 10.5

**Your problem**  
My problem is:

My client is migrating from a home-brew CRM which has Contact Notes feature (very similar to Mautic’s Contact Notes). However, upon exporting the data into CSV, those notes are exported as a column in the CSV.

As far as I understand, Mautic stores Contact Notes in lead\_notes database table, and Contact Import process will not import the notes. The only thing I could do was to import the notes in a textarea custom field, but this is not an ideal solution.

Does anyone have any other solutions for this? Contact Notes are essential to this client and we need it to be uploaded.

These errors are showing in the log:

Steps I have tried to fix the problem:

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 6, 2021, 1:14pm UTC](https://forum.mautic.org/t/mass-importing-contact-notes/18859/2 "2021-04-06T13:14:34Z")

</div>

Hi,

Option #1:

You can import stuff into the DB if you have phpmyadmin, or you can use adminer.  
This is how the table structure looks like:

![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/97c730d9343026ad4ef414222adc7358f449e871.png)

type can be ‘call’, ‘general’, ‘meeting’ or ‘email’  
You’d need to make sure you are using the right contact ID.

Option #2:  
use the API:

> <https://github.com/moskoweb/developer-documentation/blob/6189f51c8e9b5fc741ff0fac47ea77004cad164a/source/includes/_api_endpoint_notes.md>

Joey