Try this: LOAD CSV WITH HEADERS FROM "file:c:/Users/Jean/Downloads/CompaniesTEST.csv" AS line WITH line WHERE line.founded_year is null RETURN line
Does it return any rows? On 4 November 2014 09:39, Jean Villedieu <[email protected]> wrote: > Hi, > > I have already experimented with the CSV import and now I'm trying to use > it with the Crunchbase database > <http://info.crunchbase.com/2013/04/crunchbase-meets-excel/>. > Thanks to Michael Hunger's posts, I have managed to get started but I keep > getting this message : > > Cannot merge node using null property value for founded_year (Failure when > processing URL 'file:c:/Users/Jean/Downloads/CompaniesTEST.csv' on line 4 > (which is the last row in the file). No rows seem to have been committed. > Note that this information might not be accurate.) > > I think it has to do with null values. > > Here is what I used to do the importation : > create constraint on (a:Company) assert a.permalink is unique > create constraint on (b:Category) assert b.category_list is unique > create constraint on (c:MARKET) assert c.market is unique > create constraint on (d:STATUS) assert d.status is unique > create constraint on (e:COUNTRY) assert e.country_code is unique > create constraint on (f:STATE) assert f.state_code is unique > create constraint on (g:REGION) assert g.region is unique > create constraint on (h:CITY) assert h.city is unique > CREATE INDEX ON :Company(permalink) > USING PERIODIC COMMIT 1000 > LOAD CSV WITH HEADERS FROM > "file:c:/Users/Jean/Downloads/CompaniesTEST.csv" AS line > MERGE (a:COMPANY {permalink: line.permalink, funding_total: > line.funding_total_usd, funding_rounds: > toInt(line.funding_rounds), founded_at: line.founded_at, founded_month: > line.founded_month, founded_quarter: line.founded_quarter, founded_year: > toInt(line.founded_year), first_funding_at: > line.first_funding_at, last_funding_at: line.last_funding_at}) > MERGE (b:CATEGORY {name: line.category_list}) > MERGE (c:MARKET {name: line.market}) > MERGE (d:STATUS {name: line.status}) > MERGE (e:COUNTRY {name: line.country_code}) > MERGE (f:STATE {name: line.state_code}) > MERGE (g:REGION {name: line.region}) > MERGE (h:CITY {name: line.city}) > CREATE (a)-[:HAS_CATEGORY]->(b) > CREATE (a)-[:HAS_MARKET]->(c) > CREATE (a)-[:HAS_STATUS]->(d) > CREATE (a)-[:HAS_COUNTRY]->(e) > CREATE (a)-[:HAS_STATE]->(f) > CREATE (a)-[:HAS_REGION]->(g) > CREATE (a)-[:HAS_CITY]->(h) > > FYI when I create the COMPANY nodes with permalink as a single property, > it works. What am I doing wrong? > The csv file I'm using can be found here : > https://gist.github.com/jvilledieu/c3afe5bc21da28880a30 > > Thanks for your help! > > -- > 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.
