Also, the properties are not in the same order as in the csv file.. joi, 5 iunie 2014, 12:29:43 UTC+3, Paul Damian a scris: > > Well, for all properties it sets null values. The data is read well from > the file. Is it ok if I have NULL values in the file? Would that be a > problem? > > joi, 5 iunie 2014, 12:05:18 UTC+3, Michael Hunger a scris: >> >> 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 <paulda...@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+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.