Novice trying to import access database on Mac Os

Neo4j Graph Platform Import / Export
1

Please keep the following things in mind:

  1. did you search for what you want to ask before posting?
  2. please use tags for additional info
  3. use a self-descriptive title

Please format code + Cypher statements with the code </> icon, it's much easier to read.

Please provide the following information if you ran into a more serious issue:

  • neo4j version, desktop version, browser version
  • what kind of API / driver do you use
  • screenshot of PROFILE or EXPLAIN with boxes expanded (lower right corner)
  • a sample of the data you want to import
  • which plugins / extensions / procedures do you use
  • neo4j.log and debug.log
2

You forgot to put actual content into your question.
Please do that, and share what you want to do and what you've tried so far as well as any context.

3

I am new to neo4j and l have a Microsoft access database that l am trying to import to neo4j. I am struggling with how k should proceed

4

Access is interesting. Can you dump it to CSV files which then can be easily imported?

You might want to try out the Neo4j-ETL tool with a JDBC driver for access but I haven't tried that myself.

Using something like this: MS Access JDBC Driver -- Connecting MS Access with Java

5

I have dumped the data into CSV and tried to import it that way. However, l am on a Mac and the LOAD CSV command does not work, l am getting an error message, “command not found". Brew install and changing the Path to the Neo4j bin directory does not work.

Is this an error you have encountered before, if so, how can this be resolved.

Regards

6

LOAD CSV command not found? LOAD CSV is a cypher statement LOAD CSV - Cypher Manual . You need to run a LOAD CSV at a cypher prompt, for example thru bin/cypher-shell or through the browser.

7

I am have imported two separate CSV files into Neo4j, however, when I try to create edges between the nodes, these are not showing when when I run the CALL db.schema; command. Is there a reason why I would fail to create edges between nodes that have been imported from two CSV sheets?
Also, is it advisable to create dates nodes within Neo4j, if so, what is the best way to do this?

8

Call db.schema samples the database. This sample may/may not include said relationships

If you run match (n)-[r]-(n2) return n,r,n2; does this show the edges.

Note you may want to qualify n and n2 by including a label

9

Hi, I have imported some date into neo4j using the following:

LOAD CSV WITH HEADERS FROM "file:///tblDataPlant.csv" AS row
WITH row, SPLIT(row.Date,"-") AS date
CREATE (collector:Collector {name: UPPER(row. Collector), location: UPPER(row.Location), date:(row.Date)})
SET collector += apoc.map.clean(row, ['Location' , 'County', 'Latitude' , 'Longitude'], [])
CREATE (site:Site {name: coalesce(row.Location, ' '), county: coalesce(row.County, ''), location: point({latitude:toFloat(row.Latitude), longitude: toFloat(row.Longitude)})})
SET site.year = TOINT(date[0]),
site.month = TOINT(date[2]),
site.day = TOINT(date[1])
SET site += apoc.map.clean(row, ['Location','County', 'Latitude','Longitude'], [])
CREATE (collector)- [:VISITED]->(site)

However, we I try to run the following command:
MATCH (c:Collector)
WHERE Date('1826-05-17') < c.Date < Date('1827-04-23')
RETURN (c)

I am not getting any result, it is saying (no changes, no records) even though I can see that there are collectors with this date. Where could I be getting it wrong.

Also, do you do one to one telephone/face to face sessions where someone has multiple questions?

10

the LOAD CSV defines a property named date for nodes with a label of :Collector. and as evidence

CREATE (collector:Collector {name: UPPER(row. Collector), location: UPPER(row.Location), date:(row.Date)})

However your MATCH and WHERE clause is on a property named Date, as evidence

WHERE Date('1826-05-17') < c.Date < Date('1827-04-23')

change the WHERE clause to

WHERE Date('1826-05-17') < c.date < Date('1827-04-23')
11

Even after changing the the WHERE clause to the following does not resolve the issue, it is still coming up with (no changes, no records)
MATCH (c:Collector)
WHERE Date('1826-05-17') < c.date < Date('1827-04-23')
RETURN (c)

12

can you return the results of

MATCH (c:Collector)
RETURN c.name, c.location,c.date,id(c) limit 10;

to which this will return 10 nodes with a label named :Collector and return the nodes name, location, date and internal id properties

13

When I return the results for
MATCH (c:Collector)
RETURN c.name, c.location,c.date,id(c) limit 10;

All the dates are coming back as NULL, could this be a suggestion that there is something wrong with the way I have imported the date?

14

oh... interesting. but

I am not getting any result, it is saying (no changes, no records) even though I can see that there are collectors with this date. Where could I be getting it wrong.

where were you seeing collectors with dates?

15

24
Screen Shot 2019-10-29 at 11.29.24.png2584×584 47.9 KB
59
Screen Shot 2019-10-29 at 11.30.59.png1932×502 26.2 KB

16

34
Screen Shot 2019-10-29 at 11.33.34.png2314×520 27.9 KB

17

I have attached examples of the screenshots showing where I could see the dates, but the query returns no results

18

your example of

where DATE("1827") < c.data < Date("1827") ...... ....

DATE("1827") produces a value of 1827-01-01. and the where cause would suggest the properties date property is greater than 1827-01-01 and also less than 1827-01-01 so I would expect this would yield no results. No??

but further I suspect this is a matter of type conversions. If you run

match (n:Collector) where Date("1827-06-25") < Date(n.date) < Date("1827-06-28") return n;

do you get a result for JENYNS, LEONARD

19

I am loading some data using csv, I am parsing one of the columns as a date. I have some "na" within the data column and I am getting a message which says, " Text cannot be parsed to a Date
"na". How can I ignore these during the loading process? I have a similar problems with NULLS and I used the following the statement which worked
"WITH line WHERE not line.Date IS NULL", what would be an equivalent statement for n/a? I tried WITH line WHERE not line.Date IS "na' and it did not work
^

20

are you suggesting your load csv file has data similar to

Collector, Locations, Date
collector-A, locationA, 2019-08-01
collector-A, locationA, 
collector-A, locationA, n/a

and line 3 has a NULL for the Date property and line 4 has a value of n/a for the Date Property?
What is the expectation for line 3 and line 4. They not get loaded into Neo4j? they get loaded but the Date property be undefined?