Graph Academy: Importing CSV Data : Data Importer

[sharamam]

I am in the section using the Neo4j Data Importer (https://graphacademy.neo4j.com/courses/importing-data/2-using-data-importer/2-c-importing-CSV/)and looks like the check database function is not working correctly. Even on an empty database its throws JSON.parse: unexpected character at line 1 column 1 of the JSON data. I have done the steps correctly multiple times and it does not validate. I have terminated the sandbox and started from an fresh one as well.

Any guidance is appreciated.

Thanks

Mil

[ethan-wax]

I'm having this issue as well

[elaine_rosenber]

I can reproduce the problem. We are looking into it.

Elaine

[darciosavilela]

Something similar in my case. Not possible to validate results after importing. Queries are ok.

Tks

[elaine_rosenber · Accepted solution]

The issue with "Unexpected token" has been fixed.

Elaine

[darciosavilela]

Tks for this, but I am facing another issue. Seems not possible to validate, even with queries ok.

I already run 2 times all steps.

Tks

[elaine_rosenber]

Does this code return True? If not then there is a problem with what you mapped for the import:

CALL apoc.meta.nodeTypeProperties( )  YIELD nodeType, propertyName, propertyTypes
WITH collect([ nodeType+'.'+propertyName, propertyTypes ]) AS nodeProperties
WITH
all (condition IN [
  // Renamed Properties
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.tmdbId' | pair[1] = ['Long'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.imdbId' | pair[1] = ['Long'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.poster' | pair[1] = ['String'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.url' | pair[1] = ['String'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Person`.tmdbId' | pair[1] = ['Long'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Person`.imdbId' | pair[1] = ['Long'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Person`.poster' | pair[1] = ['String'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Person`.url' | pair[1] = ['String'] ],
  // Converted Data Types
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.revenue' | pair[1] = ['Long'] ],
  [ pair IN nodeProperties WHERE pair[0] = ':`Movie`.budget' | pair[1] = ['Long' ]]
] WHERE condition[0] = true) AS nodes


WITH nodes
CALL apoc.meta.relTypeProperties( ) yield relType, propertyName, propertyTypes
WHERE relType = ":`RATED`"
  AND propertyName = "rating"
  AND "Long" in propertyTypes
WITH  nodes, count(*) as c
RETURN nodes AND count(*) = 1 as outcome

[sharamam]

Thank you , for me the function worked correctly and i am able to complete the section. Thank you again ..

[darciosavilela]

Hi Elaine. Returns null for me...

Don't see where is the error. Data importer shows everything in green, import results shows "import completed without errors"... any thoughts?

tks

[elaine_rosenber]

Is is possible that your db had nodes in it before you did the import?
Try:

create or replace database neo4j

before you do the import.

[darciosavilela]

My db didn't have any nodes, but I had to delete blank sandbox db and recreate another one. Then, after all steps I have succeed to go through validation in academy.

tks

[elaine_rosenber]

Excellent!