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.
