![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn12-1024x627.jpg\")
<\/p>\nI had an excel sheet with some property data. I isolated it to one property for this exercise.<\/p>\n
<\/p>\n
The property has A Site, A block, A Unit and 8 rooms and 3 cupboards (denoted by room name they were in with a letter ‘a’ at the end)<\/p>\n
In the first part of the process I set up Nodes for all of these elements.<\/p>\n
In this exercise I wanted to take data from a CSV file to populate the Graph Database.<\/p>\n
I used this article<\/strong><\/a> as a resource for setting up my code. About half way down there is a video showing the process.<\/p>\n I have spent most of the day trying to get it to run on my machine.<\/p>\n I had a few issues on the setup. Trying to locate the CSV file.<\/p>\n I initially created a directory inside C:\\neo4j\\files\\site.csv, and used the string ‘file:\/\/\/C:\/node4j\/files\/site.csv’ in the code to test it. Lost of whirling inside http:\/\/localhost:7474\/browser\/ <\/strong>but it would not find it.<\/p>\n I put the path in Firefox browser and it found the file, no problem.<\/p>\n In the end I closed the browser down and re-started it and it couldn’t find the file. It was using a path something like file:\/\/\/C:\/node4j\/import\/<\/strong>C:\/node4j\/files\/site.csv which messed up the search path, so in the end I put the csv file in the C:\/node4j\/import directory and used the filepath in the code as:<\/p>\n FROM ‘file:\/\/\/C:\/<\/strong>r1.csv’ AS line<\/p>\n which worked. So now Cypher could find the file. I think it has the neo4j\/import in the PATH variable, I may have to check that sometime. Anyway, that worked.<\/p>\n I spent a massive time debugging and so decided that in the Excel File I would filter site, block, each individual room all separately and create a specific CSV file for each of these instances ( you have to start somewhere and I spent so long debugging the import that I thought I would simplify the process (but make it more tedious))<\/p>\n Next I kept on getting error after error in the original code that I had modified, but after constant debugging I have the following code that works:<\/p>\n Going through it:<\/p>\n Item 1. Match identifies the Note that I want to link all the data to. This is the specific site, block or room.<\/p>\n Items 2, 3 is the loading CSV (with headers and pointing to the file<\/p>\n Item 4. This held me up for ages, it creates a node, I think with 2 labels , Name & Id(this being the Guid in the excel sheet). I was trying to get all the data in here, but it would not let me. I then learned that I hat to use the SET command to bring all the other data into the node (going back to this Video<\/strong><\/a> in the previous post about neo4j<\/a><\/strong>).<\/p>\n Item 5. Hurray, the set command. I copied the original exercise too well and had [] square brackets in the lines e.baselifeLower =toInteger(line.BaselifeLower[1]<\/strong>),thinking the [1] was the number of digits in the integers (it wasn’t it was a reference to a broken up date element and the positions of the elements in the array). [several hours gone on that!!]\n Item 6. I also created the relationship between the new element nodes and the site\/block\/room the elements were to attach to.<\/p>\n Item 7. Just showing the relationships created.<\/p>\n <\/p>\n I think using Cypher rather than Python made sense for the learning and debugging. I was debugging neo4j and not python, so learning about the database rather than the relationsahip betweeen python and the database.<\/p>\n I can now test my code out from Python as the next step.<\/p>\n It took me a long time to get this the way I wanted it and I did a lot of deleting of the Element part of the schema.<\/p>\n The next step is to start writing queries on this data to see how it responds.<\/p>\n One last thing. There are these objects unattached to anything. They are gray, like the “elements” but only have an “id” from neo4j. I haven’t been able to get rid of them so far. I may need to find individual “id”s and get rid of them that way.<\/p>\n","protected":false},"excerpt":{"rendered":" I had an excel sheet with some property data. I isolated it to one property for this exercise. The property has A Site, A block, A Unit and 8 rooms and 3 cupboards (denoted by room name they were in with a letter ‘a’ at the end) In the first part of the process I […]<\/p>\n","protected":false},"author":1,"featured_media":3398,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[],"class_list":["post-3355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nosql-databases"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn11.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn11.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/3355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3355"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/3355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/3398"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
\ne.type = line.Type,
\ne.baselife = toInteger(line.Baselife),
\ne.baselifeLower =toInteger(line.BaselifeLower),
\ne.baselifeUpper =toInteger(line.BaselifeUpper),
\ne.c1 = toInteger(line.c1),
\ne.c2 = toInteger(line.c2),
\ne.c3 = toInteger(line.c3),
\ne.c4 = toInteger(line.c4),
\ne.c5 = toInteger(line.c5),
\ne.r1 = toInteger(line.r1),
\ne.r2 = toInteger(line.r2),
\ne.r3= toInteger(line.r3),
\ne.r4 = toInteger(line.r4),
\ne.r5= toInteger(line.r5),
\ne.unit=line.Unit,
\ne.unitRate= toFloat(line.Unit_Rate),
\ne.quantity= toFloat(line.Quantity)<\/li>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn11-1024x613.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn10-1024x620.jpg\")
<\/p>\nEnd comment<\/h3>\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imn13-1024x670.jpg\")
<\/p>\n