# Importing does not work **URL:** \ **Category:** General Discussion\ **Created:** [September 23, 2016, 3:59pm UTC](https://forum.mautic.org/t/importing-does-not-work/5449 "2016-09-23T15:59:06Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![leadport](https://avatars.discourse-cdn.com/v4/letter/l/57b2e6/32.png) [@leadport](https://forum.mautic.org/u/leadport)\ **Post date:** [September 23, 2016, 3:59pm UTC](https://forum.mautic.org/t/importing-does-not-work/5449/1 "2016-09-23T15:59:06Z")
Whether I try to import 6,000 leads or 25, the result is the same: Code: Success! 0 created, 0 merged, 25 ignored 100% ``` (#2) (#3) (#4) (#5) (#6) (#7) (#8) (#9) (#10) (#11) (#12) (#13) (#14) (#15) (#16) (#17) (#18) (#19) (#20) (#21) (#22) (#23) (#24) (#25) (#26) No data found ``` 25 / 25 First try: left all rows unedited from exporting location (mismatched rows, but I selected the appropriate rows to match in the import window) = fail Removed unmatched rows, renamed existing rows to match the database = fail I edited the CSV to match all 45 rows in the database, same result. Sample from the CSV: Code: id,owner\_id,stage\_id,is\_published,date\_added,created\_by,created\_by\_user,date\_modified,modified\_by,modified\_by\_user,checked\_out,checked\_out\_by,checked\_out\_by\_user,points,last\_active,internal,social\_cache,date\_identified,preferred\_profile\_image,title,firstname,lastname,company,position,email,mobile,fax,address1,address2,city,state,zipcode,country,preferred\_locale,attribution\_date, attribution,website,facebook,foursquare,googleplus,instagram,linkedin,skype,twitter ,,,,,,,,,,,,,6,,,,,,,Firstname,,,,email@example.com,,,,,,,,,,,,,,,,,,, (only rows with content for this test are points, firstname and email) Only thing in the logfile: Quote: [2016-09-23 16:53:37] mautic.ERROR: Deprecation: The alias option of the form.type\_extension tag of service "fos\_rest.form.extension.csrf\_disable" is deprecated since version 2.8 and will be removed in 3.0. Use the extended\_type option instead. - in file C:xampphtdocsmauticvendorsymfonyframework-bundleDependencyInjectionCompilerFormPass.php - at line 67 [] [] From my system info: Quote: PHP Version 5.6.24 mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.11-dev - 20120503 mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ Directive Local Value Master Value mysql.allow\_local\_infile On On mysql.allow\_persistent On On mysql.connect\_timeout 3 3 mysql.default\_host no value no value mysql.default\_password no value no value mysql.default\_port 3306 3306 mysql.default\_socket MySQL MySQL mysql.default\_user no value no value mysql.max\_links Unlimited Unlimited mysql.max\_persistent Unlimited Unlimited mysql.trace\_mode Off Off mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.11-dev - 20120503 - Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 From app/config/local.php: Quote: 'db\_server\_version' =\> '5.5.5-10.1.16-MariaDB' I have tried this both on a Digitalocean droplet as well as my localhost; same result. ---
**Author:** ![leadport](https://avatars.discourse-cdn.com/v4/letter/l/57b2e6/32.png) [@leadport](https://forum.mautic.org/u/leadport)\ **Post date:** [September 23, 2016, 3:59pm UTC](https://forum.mautic.org/t/importing-does-not-work/5449/2 "2016-09-23T15:59:06Z")
Whether I try to import 6,000 leads or 25, the result is the same: [code] Success! 0 created, 0 merged, 25 ignored 100% ``` (#2) (#3) (#4) (#5) (#6) (#7) (#8) (#9) (#10) (#11) (#12) (#13) (#14) (#15) (#16) (#17) (#18) (#19) (#20) (#21) (#22) (#23) (#24) (#25) (#26) No data found ``` 25 / 25[/code] First try: left all rows unedited from exporting location (mismatched rows, but I selected the appropriate rows to match in the import window) = fail Removed unmatched rows, renamed existing rows to match the database = fail I edited the CSV to match all 45 rows in the database, same result. Sample from the CSV: `id,owner_id,stage_id,is_published,date_added,created_by,created_by_user,date_modified,modified_by,modified_by_user,checked_out,checked_out_by,checked_out_by_user,points,last_active,internal,social_cache,date_identified,preferred_profile_image,title,firstname,lastname,company,position,email,mobile,fax,address1,address2,city,state,zipcode,country,preferred_locale,attribution_date, attribution,website,facebook,foursquare,googleplus,instagram,linkedin,skype,twitter ,,,,,,,,,,,,,6,,,,,,,Firstname,,,,email@example.com,,,,,,,,,,,,,,,,,,,` (only rows with content for this test are points, firstname and email) Only thing in the logfile: [quote][2016-09-23 16:53:37] mautic.ERROR: Deprecation: The alias option of the form.type\_extension tag of service “fos\_rest.form.extension.csrf\_disable” is deprecated since version 2.8 and will be removed in 3.0. Use the extended\_type option instead. - in file C:xampphtdocsmauticvendorsymfonyframework-bundleDependencyInjectionCompilerFormPass.php - at line 67 [/quote] From my system info: > [@](#): > > PHP Version 5.6.24 > mysql > MySQL Support enabled > Active Persistent Links 0 > Active Links 0 > Client API version mysqlnd 5.0.11-dev - 20120503 > mysql > MySQL Support enabled > Active Persistent Links 0 > Active Links 0 > Client API version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ > Directive Local Value Master Value > mysql.allow\_local\_infile On On > mysql.allow\_persistent On On > mysql.connect\_timeout 3 3 > mysql.default\_host no value no value > mysql.default\_password no value no value > mysql.default\_port 3306 3306 > mysql.default\_socket MySQL MySQL > mysql.default\_user no value no value > mysql.max\_links Unlimited Unlimited > mysql.max\_persistent Unlimited Unlimited > mysql.trace\_mode Off Off > mysqli > MysqlI Support enabled > Client API library version mysqlnd 5.0.11-dev - 20120503 - > Active Persistent Links 0 > Inactive Persistent Links 0 > Active Links 0 From app/config/local.php: > [@](#): > > ‘db\_server\_version’ =\> ‘5.5.5-10.1.16-MariaDB’ I have tried this both on a Digitalocean droplet as well as my localhost; same result. ---
**Author:** ![blayzerstl](https://avatars.discourse-cdn.com/v4/letter/b/8baadc/32.png) [@blayzerstl](https://forum.mautic.org/u/blayzerstl)\ **Post date:** [February 24, 2017, 4:38pm UTC](https://forum.mautic.org/t/importing-does-not-work/5449/3 "2017-02-24T16:38:52Z")
Were you able to get this issue resolved? I’m having a similar problem.