# Import List **URL:** \ **Category:** General Discussion\ **Created:** [February 11, 2015, 12:17pm UTC](https://forum.mautic.org/t/import-list/1522 "2015-02-11T12:17:01Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![emailready](https://avatars.discourse-cdn.com/v4/letter/e/49beb7/32.png) [@emailready](https://forum.mautic.org/u/emailready)\ **Post date:** [February 11, 2015, 12:17pm UTC](https://forum.mautic.org/t/import-list/1522/1 "2015-02-11T12:17:01Z")
When using the Manage Leads List import function… I am experiencing a few issues The system seems to merge all the data together when you try and map the fields, I would assume that it should only show the first row. ![all-fields.png](http://images.emailready.com/external/all-fields.png) Secondly the last record and the csv list and the first record of the next row seem to get merged together. I.e.: If the last field was Surname and the next field is email address it pulls it back Surname [mylead@something.com](mailto:mylead@something.com) ![merging-records.png](http://images.emailready.com/external/merging-records.png) So I assume the reason it doesn’t import any data is the reason for the above. I says success 0 created, 0 merged, 0 ignored ---
**Author:** ![emailready](https://avatars.discourse-cdn.com/v4/letter/e/49beb7/32.png) [@emailready](https://forum.mautic.org/u/emailready)\ **Post date:** [February 11, 2015, 12:17pm UTC](https://forum.mautic.org/t/import-list/1522/2 "2015-02-11T12:17:01Z")
When using the Manage Leads List import function… I am experiencing a few issues The system seems to merge all the data together when you try and map the fields, I would assume that it should only show the first row. ![](http://images.emailready.com/external/all-fields.png) Secondly the last record and the csv list and the first record of the next row seem to get merged together. I.e.: If the last field was Surname and the next field is email address it pulls it back Surname [mylead@something.com](mailto:mylead@something.com) ![](http://images.emailready.com/external/merging-records.png) So I assume the reason it doesn’t import any data is the reason for the above. I says success 0 created, 0 merged, 0 ignored ---
**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\ **Post date:** [February 11, 2015, 7:54pm UTC](https://forum.mautic.org/t/import-list/1522/3 "2015-02-11T19:54:11Z")
Hey Lance, What system are you using to export the data? Could you provide a snippet of your CSV file? It seems that something is off causing PHP to not parse it correctly. You can either delete sensitive data or email me a copy so I can look at it. Thanks, Alan ---
**Author:** ![emailready](https://avatars.discourse-cdn.com/v4/letter/e/49beb7/32.png) [@emailready](https://forum.mautic.org/u/emailready)\ **Post date:** [February 15, 2015, 10:09am UTC](https://forum.mautic.org/t/import-list/1522/4 "2015-02-15T10:09:32Z")
PHP 5.4 ---
**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\ **Post date:** [February 16, 2015, 4:42am UTC](https://forum.mautic.org/t/import-list/1522/5 "2015-02-16T04:42:11Z")
Hey Lance, I added delimiter, escape and enclosure settings to the form in case the csv uses something other than PHP’s defaults. [https://github.com/mautic/mautic/commit/9ace53c91eed4c34d3d8fad34b28a76f4cdeeff2](https://github.com/mautic/mautic/commit/9ace53c91eed4c34d3d8fad34b28a76f4cdeeff2) I wonder if that will help your CSV file issue? I did a successful import using PHP 5.4 of the sample you sent me so also wondering if there is possibly a encoding issue somewhere in the file. If you look through the results, do you see any odd characters? Thanks, Alan ---
**Author:** ![emailready](https://avatars.discourse-cdn.com/v4/letter/e/49beb7/32.png) [@emailready](https://forum.mautic.org/u/emailready)\ **Post date:** [February 16, 2015, 6:04am UTC](https://forum.mautic.org/t/import-list/1522/6 "2015-02-16T06:04:16Z")
Hi Alan That was one piece of integration 🙂 No it didn’t work I opened the csv file in an text editor there is honestly nothing weird in there, everything is only text delimited ---
**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\ **Post date:** [February 16, 2015, 9:20pm UTC](https://forum.mautic.org/t/import-list/1522/7 "2015-02-16T21:20:10Z")
Just to have a resolution to this, we found the issue is fixed by this line: [https://github.com/mautic/mautic/commit/633ad2afe4f5dac41ed7f1e22767fbedd7c55bba#diff-65f84a55356ff9543792f6863a07900bR807](https://github.com/mautic/mautic/commit/633ad2afe4f5dac41ed7f1e22767fbedd7c55bba#diff-65f84a55356ff9543792f6863a07900bR807) Thanks! Alan ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [February 2, 2020, 11:00pm UTC](https://forum.mautic.org/t/import-list/1522/8 "2020-02-02T23:00:41Z")