New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Customer Import - Invalid data for insert #4291
Comments
@ilol please review |
Hi @zinittest Thank you for reporting. |
Hi @BaDos Any updates - i am facing same issue with importing customers-address data |
Hi @EL-Nazer We are working on this issue. |
Fixed issues: - MAGETWO-58457: Can not install Magento 2.1.1 EE via GUI from composer project - MAGETWO-58104: If custom text area attribute is created, you can't export bundle product. - for 2.2 - MAGETWO-58394: [Github] magento/framework depends on zendframework/zend-stdlib but it's missing from composer.json #6442 - MAGETWO-58316: [Github] Customer Import - Invalid data for insert #4291
This is still an issue in v2.1.3 |
Please add this fix in v2.1.4. This is critical! Original date reported is 25 Apr 2016. Fix was at 28 Sep 2016. Today 17 Jan 2017... #crying PS: Fix from @mmansoorebay is working. Edited the core... |
I'm still facing this issue in v2.1.3 (customer composite). |
@nntoan Both. |
@PieterCappelle You can choose only one commit. Because one of them add new lines to the if statement and the other one will delete the whole if statement... Both of them mean you add new line, then you delete the whole if => only 487ae24 |
Actually 487ae24 (removing the if statement) solved the issue for me. The question is why this commit hasnt been merged with the 2.1 branch. Therefore the fix is not live. |
The issue is still there in v2.1.5. Commit 487ae24 fixed the issue for me. |
This issue has already been fixed. Internal ticket for ver. 2.1. - MAGETWO-58760. |
@orlangur, I 'm not exactally getting your point. The question is which Section in commenting in code. |
@apshahi I don't see your comment I commented (or I commented in the wrong thread?). AFAIR, there was something like "still see this on 2.1.7" while 2.1.8 was already released. |
Using 2.2 This is still a problem. When uploading data matching the format of the sample file, get this error: M2 provides a sample file in the Import page, however, it provides an invalid file. |
Steps to reproduce
test_main.csv.zip
Expected result
Actual result
P. S. Error occurs because data rows which are going to be inserted have different keys (https://github.com/magento/magento2/blob/develop/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php#L1878). It happens because fields with empty values are discarded during data preparation step (https://github.com/magento/magento2/blob/develop/app/code/Magento/CustomerImportExport/Model/Import/Customer.php#L373). I was able to import data just commenting these lines, but obviously it requires more proper fix.
The text was updated successfully, but these errors were encountered: