Hello,
I'm using the version of de NEO4J desktop:
Neo4j Browser version: 5.6.0
Neo4j Server version: 5.3.0 (enterprise)
Neo4j Browser Changelog
Build number: 162
Build hash: 478b9b2c31f44dd05f
Build date: 3/21/2023
I hope you can see the image:
The error is on line 39 instead of line 33.
Code:
//10. Load Object from
// Make sure all data is removed.
MATCH (all) DETACH DELETE all;
//To improve the load of CSV files indexes and constraint are required.
CREATE CONSTRAINT Equipment_Id IF NOT EXISTS FOR (equipment:EquipmentData) REQUIRE (equipment.EqTAG) IS UNIQUE;
LOAD CSV WITH HEADERS FROM 'file:///EquipmentID.csv' AS row FIELDTERMINATOR ';'
MERGE (equipment:EquipmentData{EqTAG:coalesce(row.Eq TAG,"Unknown"),
REV:coalesce(row.REV.,"Unknown"),
SRCDocument:coalesce(row.Source Document,"Unknown"),
SRCDocumentRev:coalesce(row.Source Document Rev.,"Unknown"),
CheckCBD:coalesce(row.Check CBD,"Unknown"),
CheckGIP:coalesce(row.Check GIP,"Unknown"),
Level1System:coalesce(row.Level 1 System,"Unknown"),
Level2System:coalesce(row.Level 2 System,"Unknown"),
SystemOwner:coalesce(row.System Owner,"Unknown"),
OLDEqTAG:coalesce(row.OLD Eq TAG,"Unknown"),
System:coalesce(row.System,"Unknown"),
Code:coalesce(row.Code,"Unknown"),
No:coalesce(row.No.,"Unknown"),
Area:coalesce(row.Area,"Unknown"),
Deck:coalesce(row.Deck,"Unknown"),
Block:coalesce(row.Block,"Unknown"),
Areacolor:coalesce(row.Area color,"Unknown"),
AreaColorCompany:coalesce(row.Area Color Company,"Unknown"),
AreaName:coalesce(row.Area Name,"Unknown"),
ItemDescription:coalesce(row.Item Description,"Unknown"),
ItemSupplier:coalesce(row.Item Supplier,"Unknown"),
ItemMaker:coalesce(row.Item Maker,"Unknown"),
ItemModel:coalesce(row.Item Model,"Unknown"),
ItemPartCode:coalesce(row.Item Part Code,"Unknown"),
TechMatPropNo:coalesce(row.Tech. Mat. Prop. No.,"Unknown"),
Colourcode:coalesce(row.Colour code,"Unknown"),
Panelno:coalesce(row.Panel no.,"Unknown"),
Eekels3rdParty:coalesce(row.Eekels / 3rd Party,"Unknown"),
Remarks:coalesce(row.Remarks,"Unknown"),
Quantity:coalesce(row.Quantity,"Unknown"),
MainCategory:coalesce(row.Main Category,"Unknown"),
Sub-Category:coalesce(row.Sub-Category,"Unknown"),
PriceperItem:coalesce(row.Price per Item,"Unknown"),
PriceTotal:coalesce(row.Price Total,"Unknown"),
ToBePurchasedbyEekels:coalesce(row.To Be Purchased by Eekels(YES / NO),"Unknown"),
Purchaser:coalesce(row.Purchaser,"Unknown"),
Leadtime:coalesce(row.Lead time (Weeks),"Unknown"),
DatetobeOrdered:coalesce(row.Date to be Ordered (dd/mm/yyyy),"Unknown"),
DateOrdered:coalesce(row.Date Ordered (dd/m m/yyyy),"Unknown"),
ExpectedateShipyard:coalesce(row.Date expected at Shipyard (dd/mm/yyyy),"Unknown"),
DeliveryatShipyard:coalesce(row.Date of Delivery at Shipyard (dd/mm/yyyy),"Unknown"),
CurrentLocation:coalesce(row.Current Location,"Unknown"),
ReceivedBy:coalesce(row.Received By,"Unknown"),
TotalAmountOrdered:coalesce(row.Total Amount Ordered,"Unknown"),
TotalAmountNeeded:coalesce(row.Total Amount Needed,"Unknown"),
StillToBeOrdered:coalesce(row.Still To Be Ordered,"Unknown"),
Delivered:coalesce(row.% Delivered,"Unknown"),
Mountedonboard:coalesce(row.Mounted on board?,"Unknown"),
EPlanCheck:coalesce(row.E-Plan Check,"Unknown"),
Questioned:coalesce(row.Questioned,"Unknown")
}
)
Kind regard.