Cypher commands for importing data from CSV with null.

import.cypher

// Create subcontract info
// handling null fields from http://stackoverflow.com/questions/37081842/cant-merge-with-null-values-cannot-merge-node-using-null-property-value-in-n
USING PERIODIC COMMIT 100
LOAD CSV WITH HEADERS FROM "file:///subaward3.csv" AS row
MERGE (p:Primary {name: row.prime_awardee_parent_contractor_name, awardeeParentContractorName: row.prime_awardee_parent_contractor_name})
ON CREATE SET p.awardeeParentDUNS = row.prime_awardee_parent_duns
ON MATCH SET p.awardeeParentDUNS = row.prime_awardee_parent_duns
ON CREATE SET p.awardPrincipalNAICSCode = row.prime_award_principal_naics_code
ON MATCH SET p.awardPrincipalNAICSCode = row.prime_award_principal_naics_code
MERGE (s:Subaward {name: row.subawardee_name, DUNS: row.subawardee_dunsnumber, amount: row.subaward_amount})
ON CREATE SET s.principalNAICSCode = row.subaward_principal_naics_code
ON MATCH SET s.principalNAICSCode = row.subaward_principal_naics_code
ON CREATE SET s.DBAName = row.subawardee_dba_name
ON MATCH SET s.DBAName = row.subawardee_dba_name
ON CREATE SET s.principalNAICSDescription = row.subaward_principal_naics_desc
ON MATCH SET s.principalNAICSDescription = row.subaward_principal_naics_desc;

CREATE INDEX ON :Primary(primeAwardeeParentDUNS);
CREATE INDEX ON :Subaward(subDUNSNumber);

USING PERIODIC COMMIT 100
LOAD CSV WITH HEADERS FROM "file:///subaward.csv" AS row
MATCH (primary:Primary {awardeeParentDUNS: row.prime_awardee_parent_duns})
MATCH (subaward:Subaward {DUNS: row.subawardee_dunsnumber})
MERGE (primary)-[:Awards {primeAwardReportID: row.prime_award_report_id, subawardFiscalYear: row.subaward_fiscal_year, subawardReportYear: row.subaward_report_year, primeProjectDescription: row.prime_award_project_description, subawardProjectdescription: row.subaward_project_description}]->(subaward);