# Graph Academy: Importing CSV Data : Data Importer **URL:** \ **Category:** Graph Academy\ **Tags:** migrated\ **Created:** [October 23, 2022, 1:15pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574 "2022-10-23T13:15:50Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![sharamam](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sharamam/32/34160_2.png) [@sharamam](https://community.neo4j.com/u/sharamam)\ **Post date:** [October 23, 2022, 1:15pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/1 "2022-10-23T13:15:50Z")
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](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 ---
**Author:** ![darciosavilela](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/darciosavilela/32/27786_2.png) [@darciosavilela](https://community.neo4j.com/u/darciosavilela)\ **Post date:** [October 24, 2022, 6:36pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/2 "2022-10-24T18:36:30Z")
Something similar in my case. Not possible to validate results after importing. Queries are ok. Tks ![Screen Shot 2022-10-24 at 15.21.10.png](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/7/2/7282a6294c8a42ff9163899a2809a2337eafcc2d.png "Screen Shot 2022-10-24 at 15.21.10.png") ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [October 24, 2022, 12:06pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/3 "2022-10-24T12:06:20Z")
I can reproduce the problem. We are looking into it. Elaine ---
**Author:** ![ethan-wax](https://avatars.discourse-cdn.com/v4/letter/e/848f3c/32.png) [@ethan-wax](https://community.neo4j.com/u/ethan-wax)\ **Post date:** [October 24, 2022, 12:00pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/4 "2022-10-24T12:00:52Z")
I'm having this issue as well ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [October 25, 2022, 7:51pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/5 "2022-10-25T19:51:47Z")
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. ---
**Author:** ![darciosavilela](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/darciosavilela/32/27786_2.png) [@darciosavilela](https://community.neo4j.com/u/darciosavilela)\ **Post date:** [October 25, 2022, 7:41pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/6 "2022-10-25T19:41:14Z")
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 ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [October 25, 2022, 7:19pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/7 "2022-10-25T19:19:24Z")
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 ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [October 25, 2022, 5:31pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/8 "2022-10-25T17:31:21Z")
The issue with "Unexpected token" has been fixed. Elaine ---
**Author:** ![darciosavilela](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/darciosavilela/32/27786_2.png) [@darciosavilela](https://community.neo4j.com/u/darciosavilela)\ **Post date:** [October 25, 2022, 8:46pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/9 "2022-10-25T20:46:58Z")
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 ---
**Author:** ![sharamam](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sharamam/32/34160_2.png) [@sharamam](https://community.neo4j.com/u/sharamam)\ **Post date:** [October 25, 2022, 7:38pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/10 "2022-10-25T19:38:54Z")
Thank you , for me the function worked correctly and i am able to complete the section. Thank you again .. ---
**Author:** ![darciosavilela](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/darciosavilela/32/27786_2.png) [@darciosavilela](https://community.neo4j.com/u/darciosavilela)\ **Post date:** [October 25, 2022, 6:47pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/11 "2022-10-25T18:47:41Z")
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 ![Screen Shot 2022-10-25 at 15.46.41.png](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/9/6/967a0bdd87e8092528c1257e43abee8e2321e659.png "Screen Shot 2022-10-25 at 15.46.41.png") ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [October 26, 2022, 11:29am UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/12 "2022-10-26T11:29:40Z")
Excellent! (migrated from khoros post [Solved: Re: Graph Academy: Importing CSV Data : Data Impor... - Neo4j - 61380](https://community.neo4j.com/t5/graphacademy-discussions/graph-academy-importing-csv-data-data-importer/m-p/61469#M1577)) ---
**Author:** ![budisatrio85](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@budisatrio85](https://community.neo4j.com/u/budisatrio85)\ **Post date:** [February 2, 2023, 8:38am UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/13 "2023-02-02T08:38:42Z")
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" ---
**Author:** ![elaine\_rosenber](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/elaine_rosenber/32/27409_2.png) [@elaine\_rosenber](https://community.neo4j.com/u/elaine_rosenber)\ **Post date:** [February 2, 2023, 3:15pm UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/14 "2023-02-02T15:15:17Z")
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. ---
**Author:** ![budisatrio85](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@budisatrio85](https://community.neo4j.com/u/budisatrio85)\ **Post date:** [February 2, 2023, 8:47am UTC](https://community.neo4j.com/t/graph-academy-importing-csv-data-data-importer/58574/15 "2023-02-02T08:47:44Z")
Looks like the version of cypher was updated, the function is not worked as of now ![budisatrio85_0-1675327647427.png](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/d/5/d569021204b3786cc5c4ed3754d1d7444413cd36.png "budisatrio85\_0-1675327647427.png") Edit: Thank you for the quick action, it is now solved. Works perfect