You have several single quotes in your file, which cause our csv reader to continue to read until it finds the next quote.
You have to escape those by doubling them. Many of them are smileys like this ":) LOAD CSV FROM "file:///Users/mh/Downloads/thanhvien.csv" AS line return count(*); +----------+ | count(*) | +----------+ | 41881 | +----------+ 1 row On Fri, Jul 4, 2014 at 4:57 AM, Nguyen Minh Nhut < [email protected]> wrote: > Hi good guys! > My .csv file have 41879 nodes. When i run the load csv file it just create > 13415 nodes. > > This is my cypher command: > > USING PERIODIC COMMIT 1000 LOAD CSV FROM "file:E:/thanhvien.csv" AS line > create (u:ThanhVien { id: line[0], HoTen : line[1] , GioiTinh: line[2], > NgaySinh: line[3] , GioiThieuBanThan: line[4], DienThoai: line[5] , DiaChi: > line[6] , Email: [7] , NgheNghiep: line[7] , CoQuan: line[8] , SoThichKhac: > line[9] , Quan: line[10] , TinhTrangHonNhan: line[11] , HinhDaiDien: > line[12] } ); > > Don't know why! > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
