# Import contact csv file failed

**URL:** https://forum.mautic.org/t/import-contact-csv-file-failed/34505
**Category:** Product Support
**Created:** [December 21, 2024, 6:13am UTC](https://forum.mautic.org/t/import-contact-csv-file-failed/34505 "2024-12-21T06:13:45Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![peterhai](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/peterhai/32/5803_2.png) [@peterhai](https://forum.mautic.org/u/peterhai)
#### Post date: [December 21, 2024, 6:13am UTC](https://forum.mautic.org/t/import-contact-csv-file-failed/34505/1 "2024-12-21T06:13:45Z")

</div>

**Your software**  
My Mautic version is: 5.2.1  
My PHP version is: 8  
My Database type and version is:

**Your problem**  
My problem is: Import contact csv file failed

These errors are showing in the log:  
Import 617 with 3078 rows is starting.  
1167/3078 [==========\>-----------------] 37%Import failed. Reason: There was a database error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘firstname’ at row 1. The import was set to delayed state and will be imported later.  
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: [December 24, 2024, 7:15am UTC](https://forum.mautic.org/t/import-contact-csv-file-failed/34505/2 "2024-12-24T07:15:17Z")

</div>

Make sure firstname is not longer then 192 characters in your import file.  
Joey

---

<div class="post-metadata">

### Author: ![peterhai](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/peterhai/32/5803_2.png) [@peterhai](https://forum.mautic.org/u/peterhai)
#### Post date: [January 4, 2025, 1:50am UTC](https://forum.mautic.org/t/import-contact-csv-file-failed/34505/3 "2025-01-04T01:50:58Z")

</div>

Thank you. i will try
