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
> <javascript:>> 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 <javascript:>.
>> 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.
