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 ..

[budisatrio85]

Looks like the version of cypher was updated, the function is not worked as of now

Edit: Thank you for the quick action, it is now solved. Works perfect

[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!

[budisatrio85]

Hello, I'm afraid this issue happened again. I have dropped the sandbox and recreate again then importing the csv, but the result is still error "Unexpected token"

[elaine_rosenber]

Sorry for the inconvenience!

The sandboxes for our courses have been upgraded to Neo4j 5.4 which caused this problem.

We have updated the course and it should now work for you.