I have been trying not for 24hrs to get these CSV loaded with a relationship. However it keeps hanging on:
Neo.ClientError.Statement.SyntaxError: Invalid input 'S': expected 'n/N' (line 1, column 384 (offset: 383))
Initially when I wasn't using the " USING PERIODIC COMMIT" I was running into memory issues. After some research the USING PERIODIC COMMIT should solve the memory issue. which seems it did.
the import was written:
USING PERIODIC COMMIT LOAD CSV with headers from "file:///unit2.csv" as unitRow create (:rigs {UnitID: unitRow.Unit, Rigname: unitRow.Rigname, Region: unitRow.Region, Status: unitRow.Status, UnitType: unitRow.type, MaxInventoryValue: unitRow.MAX_ALLOWD_VAL, Client: unitRow.client, Regulations: unitRow.Local_Reg, Latitude: unitRow.latitude, Longitude: unitRow.longitude}); WITH * USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM "file:///masterinventory.csv" as ventRow create (riginventory:RigInventory {ItemID: ventRow.Item, LongDescription: ventRow.LongDescription, QtyOnHand: ventRow.QtyOnHand, UnitPrice: ventRow.UnitPrice, UsageQty: ventRow.UsageQty, Area: ventRow.Area, Lev1: ventRow.Lev1, Lev2: ventRow.Lev2, Lev3: ventRow.Lev3, Lev4: ventRow.Lev4, RigUnit: ventRow.Unit}) with riginventory Match (u:Rigs {UnitID : riginventory.RigUnit }) Create (u)-[:HOLDS_STOCK]->(riginventory)
I was hoping somebody can help in the right direction. Many thanks.