Perhaps something with field or line terminators?
I assume it blows up the field separation.
Try to run:
LOAD CSV WITH HEADERS FROM "file:/Users/pauld/Documents/Client.csv" AS c
RETURN { Id: toInt(c.Id), FirstName: c.FirstName, LastName: c.Lastname,
Address: c.Address, ZipCode: toInt(c.ZipCode), Email: c.Email, Phone:
c.Phone, Fax: c.Fax, BusinessName: c.BusinessName, URL: c.URL, Latitude:
toFloat(c.Latitude), Longitude: toFloat(c.Longitude), AgencyId:
toInt(c.AgencyId), RowStatus: toInt(c.RowStatus)} as data, c as line
LIMIT 3
On Thu, Jun 5, 2014 at 10:51 AM, Paul Damian <pauldamia...@gmail.com> wrote:
> I've tried using the shell and I get the same results: nodes with no
> properties.
> I've created the csv file using MsSQL Server Export. Is it relevant?
>
> About you curiosity: I figured I would import first the nodes, then the
> relationships from the connection tables. Am I doing it wrong?
>
> Thanks
>
> joi, 5 iunie 2014, 09:54:31 UTC+3, Michael Hunger a scris:
>>
>> I'd probably use a commit size in your case of 50k or 100k.
>>
>> Try to use the neo4j-shell and not the web-interface.
>>
>> Connect to neo4j using bin/neo4j-shell
>>
>> Then run your commands ending with a semicolon.
>>
>> Just curious: Your data is imported as one node per row? That's not
>> really a graph structure.
>>
>>
>>
>>
>> On Wed, Jun 4, 2014 at 6:56 PM, Paul Damian <paulda...@gmail.com> wrote:
>>
>>> Hi there,
>>>
>>> I'm experimenting with Neo4j while benchmarking a bunch of NoSQL
>>> databases for my graduation paper.
>>> I'm using the web interface to populate the database. I've been able to
>>> load the smaller tables from my SQL database and LOAD CSV works fine.
>>> By small, I mean a few columns (4-5) and some rows (1 million). However,
>>> when I try to upload a larger table (15 columns, 12 million rows), it
>>> creates the nodes but it doesn't set any properties.
>>> I've tried to reduce the number of records (to 100) and also the number
>>> of columns( just the Id property ), but no luck so far.
>>>
>>> The cypher command used is this one
>>> USING PERIODIC COMMIT 100
>>> LOAD CSV WITH HEADERS FROM "file:/Users/pauld/Documents/Client.csv" AS c
>>> CREATE (:Client { Id: toInt(c.Id), FirstName: c.FirstName, LastName:
>>> c.Lastname, Address: c.Address, ZipCode: toInt(c.ZipCode), Email: c.Email,
>>> Phone: c.Phone, Fax: c.Fax, BusinessName: c.BusinessName, URL: c.URL,
>>> Latitude: toFloat(c.Latitude), Longitude: toFloat(c.Longitude), AgencyId:
>>> toInt(c.AgencyId), RowStatus: toInt(c.RowStatus)})
>>>
>>> Any help and indication is welcomed,
>>> Paul
>>>
>>> --
>>> 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 neo4j+un...@googlegroups.com.
>>>
>>> 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 neo4j+unsubscr...@googlegroups.com.
> 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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
