# Unable to load data HELP!

**URL:** <https://discuss.elastic.co/t/unable-to-load-data-help/211849>\
**Category:** Logstash\
**Created:** [December 13, 2019, 9:06pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849 "2019-12-13T21:06:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Antonio\_Ponce](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/antonio_ponce/32/47218_2.png) [@Antonio\_Ponce](https://discuss.elastic.co/u/Antonio_Ponce)\
**Post date:** [December 13, 2019, 9:06pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/1 "2019-12-13T21:06:38Z")

</div>

hi guys,

im attempting to run the following but received the error below not sure what is wrong, can someone shed some light?

input {  
file {  
path =\> "c:\users\administrator\downloads\chicago-food-inspection\food-inspection.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "/dev/null"  
}  
}  
filter {  
csv {

```
	separator => ","
	
	columns => [ "Inspection ID", "DBA Name", "AKA Name", "License #", "Facility Type", "Risk, Address", "City", "State", "Zip", "Inspection Date","Inspection Type", "Results", "Violations", "Latitude", "Longitude", "Location", 
}

mutate {convert => ["Inspection ID", "integer"] }
mutate {convert => ["License #", "integer"] }
mutate {convert => ["Latitude", "float"] }
mutate {convert => ["Longitude", "float"] }
mutate {
	rename => {
		"Latitude" => [location][lon]"
		"Longitude" => [location] [lat]"
	}
}	

output {
	
	elasticsearch {
	hosts => "locahost:9200"
	index => "food-inspections"
	}

ES Mapping:

Post/food-inspections
{
"settings":{
number_of_shards":1
},
},
"mappings" : {
	"food-inspections": {
    
		"properties" : {
     
	"location" : { "type": "geo_point"},
	"city":{"type":"string"},
	"country":{"type":"string"}
}
}

```

}

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/7/171d4c6c8896e86f73931853056ba1b03990e43e.png)

---

<div class="post-metadata">

**Author:** ![rugenl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rugenl/32/12887_2.png) [@rugenl](https://discuss.elastic.co/u/rugenl)\
**Post date:** [December 13, 2019, 10:33pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/2 "2019-12-13T22:33:25Z")

</div>

I think you have a syntax problem, at least as posted:

columns =\> [ "field", ... ,}

It looks like you have a comma after the last field and you close the "[" with "}"

---

<div class="post-metadata">

**Author:** ![Antonio\_Ponce](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/antonio_ponce/32/47218_2.png) [@Antonio\_Ponce](https://discuss.elastic.co/u/Antonio_Ponce)\
**Post date:** [December 14, 2019, 4:44am UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/3 "2019-12-14T04:44:13Z")

</div>

thanks, for the insight. I enclosed it with ] but now I'm getting an error below on line 23. Sorry been at this all day cant see where the error is

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/d/8d79222d1777df96295458e7d923948fcbefa0d3.png)

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [December 14, 2019, 2:55pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/4 "2019-12-14T14:55:00Z")

</div>

> [@Antonio\_Ponce](#):
>
> "Latitude" =\> [location][lon]"

Missing double quote before [location]

---

<div class="post-metadata">

**Author:** ![rugenl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rugenl/32/12887_2.png) [@rugenl](https://discuss.elastic.co/u/rugenl)\
**Post date:** [December 14, 2019, 3:38pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/5 "2019-12-14T15:38:34Z")

</div>

Validate the yaml with a tool like [http://www.yamllint.com/](http://www.yamllint.com/) before testing in logstash. That will catch some errors, probably not the one noted by the other responder.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 11, 2020, 3:38pm UTC](https://discuss.elastic.co/t/unable-to-load-data-help/211849/6 "2020-01-11T15:38:40Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.