# CSV file is not getting uploaded to Kibana

**URL:** <https://discuss.elastic.co/t/csv-file-is-not-getting-uploaded-to-kibana/122424>\
**Category:** Logstash\
**Created:** [March 5, 2018, 12:02am UTC](https://discuss.elastic.co/t/csv-file-is-not-getting-uploaded-to-kibana/122424 "2018-03-05T00:02:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prakash\_Punj](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@Prakash\_Punj](https://discuss.elastic.co/u/Prakash_Punj)\
**Post date:** [March 5, 2018, 12:02am UTC](https://discuss.elastic.co/t/csv-file-is-not-getting-uploaded-to-kibana/122424/1 "2018-03-05T00:02:16Z")

</div>

I am trying to upload a CSV file to Kibana using LogStash. I am not getting any error but data is not getting uploaded. Below is the output of logstash command:

```
    Sending Logstash's logs to /home/ppunj/logstash-6.1.1/logs which is now configured via log4j2.properties
[2018-03-04T18:54:48,353][INFO][logstash.modules.scaffold] Initializing module {:module_name=>"netflow", :directory=>"/home/ppunj/logstash-6.1.1/modules/netflow/configuration"}
[2018-03-04T18:54:48,388][INFO][logstash.modules.scaffold] Initializing module {:module_name=>"fb_apache", :directory=>"/home/ppunj/logstash-6.1.1/modules/fb_apache/configuration"}
[2018-03-04T18:54:49,373][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified
[2018-03-04T18:54:50,666][INFO][logstash.runner] Starting Logstash {"logstash.version"=>"6.1.1"}
[2018-03-04T18:54:51,573][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=>9600}
[2018-03-04T18:55:05,419][INFO][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://localhost:9200/]}}
[2018-03-04T18:55:05,442][INFO][logstash.outputs.elasticsearch] Running health check to see if an Elasticsearch connection is working {:healthcheck_url=>http://localhost:9200/, :path=>"/"}
[2018-03-04T18:55:05,862][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://localhost:9200/"}
[2018-03-04T18:55:05,966][INFO][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>nil}
[2018-03-04T18:55:05,973][WARN][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document _type {:es_version=>6}
[2018-03-04T18:55:06,007][INFO][logstash.outputs.elasticsearch] Using mapping template from {:path=>nil}
[2018-03-04T18:55:06,065][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage_template=>{"template"=>"logstash-*", "version"=>60001, "settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"_default_"=>{"dynamic_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"match"=>"*", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}}
[2018-03-04T18:55:06,186][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://localhost:9200"]}
[2018-03-04T18:55:06,287][INFO][logstash.pipeline] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>5, "pipeline.max_inflight"=>500, :thread=>"#<Thread:0x400a4df4 run>"}
[2018-03-04T18:55:07,117][INFO][logstash.pipeline] Pipeline started {"pipeline.id"=>"main"}
[2018-03-04T18:55:07,583][INFO][logstash.agent] Pipelines running {:count=>1, :pipelines=>["main"]}

```

My CONFIGURATION FILE IS:

```
input {
	file {
     path => "/home/ppunj/ranchland1.csv"
     start_position => 'beginning'
     sincedb_path => '/dev/null'
	}
 }
filter {
     csv {
     		separator => ","
     		columns => ["date_time", "ranch_land_ai_meter2p_mw3p_energy_kwh", "ranch_land_ai_meter2p_mw3p_energy_poi_ac_power_mw", "ranch_land_ai_meter2p_mw3p_cell_temp", "ranch_land_ai_meter2p_mw3p_ghi_w_m2", "ranch_land_ai_meter2p_mw3p_poa_w_m2", "ranch_land_ai_meter2p_pf3p_amb_temp", "ranch_land_ai_meter2p_pf3p_wind_vel", "ranch_land_ai_meter2p_pf3p_pf", "ranch_land_ws01_poa_irr_01", "ranch_land_ws01_poa_irr_02", "ranch_land_ws02_poa_irr_01", "ranch_land_ws02_poa_irr_02", "ranch_land_ws03_poa_irr_01", "ranch_land_ws03_poa_irr_02", "ranch_land_ws01_ghi_irr_01", "ranch_land_ws02_ghi_irr_01", "ranch_land_ws03_ghi_irr_01", "ranch_land_ws01_bom_01", "ranch_land_ws01_bom_02", "ranch_land_ws02_bom_01", "ranch_land_ws02_bom_02", "ranch_land_ws03_bom_01", "ranch_land_ws03_bom_02", "ranch_land_ws01_air_temp", "ranch_land_ws02_air_temp", "ranch_land_ws03_air_temp", "ranch_land_ws01_ws_act", "ranch_land_ws02_ws_act", "ranch_land_ws03_ws_act", "ranch_land_inv_01_phase_w", "ranch_land_inv_02_phase_w", "ranch_land_inv_03_phase_w", "ranch_land_inv_04_phase_w", "ranch_land_inv_05_phase_w", "ranch_land_inv_06_phase_w", "ranch_land_inv_07_phase_w", "ranch_land_inv_08_phase_w", "ranch_land_inv_09_phase_w", "ranch_land_inv_10_phase_w", "ranch_land_inv_11_phase_w", "ranch_land_inv_12_phase_w", "ranch_land_inv_13_phase_w", "ranch_land_inv_14_phase_w", "ranch_land_inv_15_phase_w", "ranch_land_inv_16_phase_w", "ranch_land_inv_17_phase_w", "ranch_land_inv_18_phase_w", "ranch_land_inv_19_phase_w", "ranch_land_inv_20_phase_w", "ranch_land_inv_21_phase_w", "ranch_land_inv_22_phase_w", "ranch_land_inv_23_phase_w", "ranch_land_inv_24_phase_w", "ranch_land_inv_25_phase_w", "ranch_land_inv_26_phase_w", "ranch_land_inv_27_phase_w", "ranch_land_inv_28_phase_w", "ranch_land_inv_29_phase_w", "ranch_land_inv_30_phase_w", "ranch_land_inv_31_phase_w", "ranch_land_inv_32_phase_w", "ranch_land_inv_33_phase_w", "ranch_land_inv_34_phase_w", "ranch_land_inv_35_phase_w", "ranch_land_inv_36_phase_w", "ranch_land_inv_37_phase_w", "ranch_land_inv_38_phase_w", "ranch_land_inv_39_phase_w", "ranch_land_inv_40_phase_w", "clipping_filter", "ranch_land_mpt_wind1temp", "ranch_land_ai_mpt_wnd2temp", "ranch_land_ai_mpt_oiltemp"]
     	}
	date {
		match => ["date_time", "MM/dd/yyyy HH:mm"]
		target => "date_time"
		locale => "en"
		}
	}

output {
     	elasticsearch {
     		         hosts => "http://localhost:9200"
     		         index => "ranchland"
     		        }
     		stdout {}
     }
```

---

<div class="post-metadata">

**Author:** ![tag\_v](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tag_v/32/47466_2.png) [@tag\_v](https://discuss.elastic.co/u/tag_v)\
**Post date:** [March 5, 2018, 8:58pm UTC](https://discuss.elastic.co/t/csv-file-is-not-getting-uploaded-to-kibana/122424/2 "2018-03-05T20:58:27Z")

</div>

try running logstash in debug mode ( append --debug to regular command). and print stdout using in output block to get more details regarding issue:  
stdout { codec =\> rubydebug }

---

<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:** [April 2, 2018, 8:58pm UTC](https://discuss.elastic.co/t/csv-file-is-not-getting-uploaded-to-kibana/122424/3 "2018-04-02T20:58:41Z")

</div>

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