# Configuring filebeat to transport csv

**URL:** https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655
**Category:** Logstash
**Created:** [November 13, 2019, 8:31am UTC](https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655 "2019-11-13T08:31:55Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Charles\_Yuliansen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charles_yuliansen/32/45664_2.png) [@Charles\_Yuliansen](https://discuss.elastic.co/u/Charles_Yuliansen)
#### Post date: [November 13, 2019, 8:31am UTC](https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655/1 "2019-11-13T08:31:55Z")

</div>

Im trying to learn using elastic,  
for my first case case im trying to push csv data to elasticsearch so i can read it in kibana.  
elasticsearch has been installed on the serverside.  
Im trying to push it with filebeat from my pc which is client side.  
i've downloaded filebeat on my pc.

here is my filebeat.yml file

filebeat.inputs:

- input\_type: log  
paths:
  - C:\Users\Charles\Desktop\DATA\BrentOilPrices.csv  
document\_type: test\_log\_csv  
output.logstash:  
hosts: ["10.64.2.246:5044"]

i've test it with : ./filebeat test config  
it return config ok

here is my logstash.conf file on the serverside  
input {  
beats {  
port =\>5044  
}  
}

filter {

if "test\_log\_csv" in [type]{  
csv {  
columns=\>["Date","Price"]  
separator=\>","  
}  
mutate{  
convert =\> ["Price","integer"]  
}  
date{  
match=\>["Date","d/MMM/yy"]  
}  
}  
}

output {  
if "test\_log\_csv" in [type]  
{  
elasticsearch  
{  
hosts=\>"127.0.0.1:9200"  
index=\>"test\_log\_csv%{+d/MM/yy}"  
}  
}

i thought everything is done,  
so i Start-Service filebeat on my pc client.  
nothing shown on kibana.  
did i missed anything?

edited my filebeat.yml into  
filebeat.inputs:

- input\_type: log  
paths:
  - 'C:\Users\Charles\Desktop\DATA\BrentOilPrices.csv'  
fields:  
document\_type: test\_log\_csv  
output.logstash:  
hosts: ["10.64.2.246:5044"]

nothing happened

---

<div class="post-metadata">

### Author: ![kkulkarni](https://avatars.discourse-cdn.com/v4/letter/k/4af34b/32.png) [@kkulkarni](https://discuss.elastic.co/u/kkulkarni)
#### Post date: [November 14, 2019, 6:36am UTC](https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655/2 "2019-11-14T06:36:08Z")

</div>

Hi There,

You have to import the index into kibana. Follow the below link.

[https://www.elastic.co/guide/en/kibana/current/index-patterns.html](https://www.elastic.co/guide/en/kibana/current/index-patterns.html)

---

<div class="post-metadata">

### Author: ![Charles\_Yuliansen](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/charles_yuliansen/32/45664_2.png) [@Charles\_Yuliansen](https://discuss.elastic.co/u/Charles_Yuliansen)
#### Post date: [November 14, 2019, 7:49am UTC](https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655/3 "2019-11-14T07:49:23Z")

</div>

Hi, thank you so much for your reply. But i've set the index name as test\_log\_csv and when i search it on create index pattern there is no such name.

---

<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: [December 12, 2019, 7:49am UTC](https://discuss.elastic.co/t/configuring-filebeat-to-transport-csv/207655/4 "2019-12-12T07:49:23Z")

</div>

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