Mass importing Contact Notes

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:

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

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:

Joey

1 Like