Hi Micheal!
I have a .tsv file. I clean all the characters ' and " in that file.
When i run the load csv command then the console load it, and then do not
thing :
USING PERIODIC COMMIT 100
LOAD CSV FROM "file:E:/binhluan.tsv" AS line FIELDTERMINATOR '\t'
MATCH ( a:`ThanhVien`{ id:line[4] } ), ( b:`DiaDiem`{ id:line[2] } )
CREATE (a)-[:BinhLuan{ NoiDung:line[1]}]->(b);
I don't know why, is this b/c content of line[1] is too big.
On Sat, Jul 5, 2014 at 7:45 AM, Nguyen Minh Nhut <
[email protected]> wrote:
> OK Thks!
>
>
>
> On Sat, Jul 5, 2014 at 3:25 AM, Michael Hunger <
> [email protected]> wrote:
>
>> 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 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.
