I just deleted all quotes and the emojii smileys ;) Sent from mobile device
Am 04.07.2014 um 17:10 schrieb Nguyen Minh Nhut <[email protected]>: > I have escaped all the single quotes by double them and delete all the > smileys like you said. Now when i count(*), it reuturns 30375 but not 41879 > nodes. > Could you tell me, what characters I should check that affect my results. > Sorry about my bad English. > > > > On Fri, Jul 4, 2014 at 5:28 PM, Michael Hunger > <[email protected]> wrote: >> 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 a topic in the >> Google Groups "Neo4j" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/neo4j/-S1Xdh4ZkrE/unsubscribe. >> To unsubscribe from this group and all its topics, 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. -- 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.
