# Viewing csv file in kibana

**URL:** <https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492>\
**Category:** Kibana\
**Created:** [August 27, 2017, 10:28pm UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492 "2017-08-27T22:28:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bm1391](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@bm1391](https://discuss.elastic.co/u/bm1391)\
**Post date:** [August 27, 2017, 10:28pm UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/1 "2017-08-27T22:28:57Z")

</div>

Hi all,

I have successfully loaded a csv file into logstash but I'm having problems visualizing it in Kibana. Here is my configuration:  
I believe it is a problem with the filter section obviously...

```
> input {
> file {
> path => "/home/bm1391/reports/report-0c0ed529-ceda-4a2f-a9a6-6abad6d3ee05.csv"
> start_position => beginning
> # to read from the beginning of file
> sincedb_path => "/dev/null"
> }
> }
> 
> filter {
> csv {
> separator => ","
> columns => ["IP", "Hostname", "OS", "Scan Start", "Scan End", "CVSS", "Severity", "High", "Medium", "Low", "Log", "False Positive", "Total"]
>         
> }
> mutate {
> convert => ["High", "integer"]
> convert => ["Medium", "integer"]
> convert => ["Low", "integer"]
> }
> }
> 
> output {
> elasticsearch {
> action => "index"
> hosts => "10.100.1.16:9200"
> index => "testing"
> workers => 1
> }
> stdout {}
> }

```

Here is a sample of my csv file:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/6/4689d724685fafc30817e4170ddb77044a42c8fb.png)IP Hostname OS Scan Start Scan End CVSS Severity High Medium Low Log False Positive Total  
192.168.1.1 Wireless\_Broadband\_Router.home cpe:/o:linux:linux\_kernel:2.6 2017-08-27T14:12:25Z 2017-08-27T14:31:46Z 6.8 Medium 0 23 1 42 0 66

I Would like to basically map the values based on the IP address, for example, a simple bar graph (x axis: IP, and different bars for Low, Medium, High etc...).  
Any help to point me in the right direction would be great.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 28, 2017, 12:07am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/2 "2017-08-28T00:07:03Z")

</div>

What problems are you having?

---

<div class="post-metadata">

**Author:** ![bm1391](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@bm1391](https://discuss.elastic.co/u/bm1391)\
**Post date:** [August 28, 2017, 12:09am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/3 "2017-08-28T00:09:25Z")

</div>

I believe the problem occurs when I try to map the results and all the "types" are strings. The convert to integers that you see above does not happen

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [August 28, 2017, 12:11am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/4 "2017-08-28T00:11:16Z")

</div>

What does the mapping look like?

---

<div class="post-metadata">

**Author:** ![bm1391](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@bm1391](https://discuss.elastic.co/u/bm1391)\
**Post date:** [August 28, 2017, 12:17am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/5 "2017-08-28T00:17:03Z")

</div>

![kibana2](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b6910c33d2a0832c0651448f5051a6986815f55a.png)

---

<div class="post-metadata">

**Author:** ![bm1391](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@bm1391](https://discuss.elastic.co/u/bm1391)\
**Post date:** [August 28, 2017, 12:18am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/6 "2017-08-28T00:18:40Z")

</div>

Well, actually now the pipeline is being started fine and there are no errors in the logs but looking at my fields, they aren't appearing.. Look here

 ![testing](https://us1.discourse-cdn.com/elastic/original/3X/6/5/65b8c5a829cebd5e11015c36c6095eef37404ff1.png)

Here is a better picture of csv file:

 ![report3](https://us1.discourse-cdn.com/elastic/original/3X/c/1/c1338d6f725594cdc0afa19dba94af5c0d4fc6be.png)

---

<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:** [September 25, 2017, 12:18am UTC](https://discuss.elastic.co/t/viewing-csv-file-in-kibana/98492/7 "2017-09-25T00:18:58Z")

</div>

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