# Issue with importing CVS file

**URL:** <https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690>\
**Category:** Logstash\
**Created:** [May 4, 2018, 11:11pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690 "2018-05-04T23:11:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![moe.kazemi](https://avatars.discourse-cdn.com/v4/letter/m/96bed5/32.png) [@moe.kazemi](https://discuss.elastic.co/u/moe.kazemi)\
**Post date:** [May 4, 2018, 11:11pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/1 "2018-05-04T23:11:28Z")

</div>

Hello all;

I am using the following config. to import CVS file using logstash but when I call it, it give me the error that I have listed in item number 2. I would appreciate your assistance.

Thanks

item #1  
input {  
file {  
path =\> "/users/mkazemi/desktop/elastic/data/cars.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "/dev/null"  
}  
}  
filter {  
csv {

```
	separator => ","

	columns => [ "maker", "model", "mileage", "manufacture_year", "engine_displacement", "engine_power", 
	"body_type", "color_slug", "stk_year" , "transmission", "door_count", "seat_count", "fule_type","date_created", 
	"date_last_seen", "price_eur"]
}

mutate {convert => ["mileage", "integer"] }
mutate {convert => ["price_eur", "float"] }
mutate {convert => ["engine_power", "integer"] }
mutate {convert => ["door_count", "integer"] }
mutate {convert => ["seat_count", "integer"] }

```

}  
output {  
elasticsearch {  
hosts =\> "localhost"  
index =\> "cars"  
document\_type =\> "sold\_cars"  
}  
stdout {}  
}

Item #2

C:\Users\mkazemi\Desktop\Elastic\logstash\bin\>logstash -f /users/mkazemi/desktop/elastic/data/logstash\_car.config

Sending Logstash's logs to C:/Users/mkazemi/Desktop/Elastic/logstash/logs which is now configured via log4j2.properties  
[2018-05-04T16:03:41,619][INFO][logstash.agent] No config files found in path {:path=\>"C:/users/mkazemi/desktop/elastic/data/logstash\_car.config"}  
[2018-05-04T16:03:41,624][ERROR][logstash.agent] failed to fetch pipeline configuration {:message=\>"No config files found: /users/mkazemi/desktop/elastic/data/logstash\_car.config. Can you make sure this path is a logstash config file?"}

---

<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:** [May 4, 2018, 11:18pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/2 "2018-05-04T23:18:59Z")

</div>

> [@moe.kazemi](#):
>
> C:\Users\mkazemi\Desktop\Elastic\logstash\bin\>logstash -f /users/mkazemi/desktop/elastic/data/logstash\_car.config

What happens if you include the drive letter in the path to the config?

---

<div class="post-metadata">

**Author:** ![moe.kazemi](https://avatars.discourse-cdn.com/v4/letter/m/96bed5/32.png) [@moe.kazemi](https://discuss.elastic.co/u/moe.kazemi)\
**Post date:** [May 4, 2018, 11:34pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/4 "2018-05-04T23:34:19Z")

</div>

Thanks Badger for Response, I add C: in the beginning of my path but I got the same message

C:\Users\mkazemi\Desktop\Elastic\logstash\bin\>logstash -f /users/mkazemi/desktop/elastic/data/logstash\_car.config  
Sending Logstash's logs to C:/Users/mkazemi/Desktop/Elastic/logstash/logs which is now configured via log4j2.properties  
[2018-05-04T16:32:32,019][INFO][logstash.agent] No config files found in path {:path=\>"C:/users/mkazemi/desktop/elastic/data/logstash\_car.config"}  
[2018-05-04T16:32:32,035][ERROR][logstash.agent] failed to fetch pipeline configuration {:message=\>"No config files found: /users/mkazemi/desktop/elastic/data/logstash\_car.config. Can you make sure this path is a logstash config file?"}

---

<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:** [May 5, 2018, 12:36am UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/5 "2018-05-05T00:36:45Z")

</div>

> [@moe.kazemi](#):
>
> C:\Users\mkazemi\Desktop\Elastic\logstash\bin\>logstash -f /users/mkazemi/desktop/elastic/data/logstash\_car.config

I do not see a drive letter in the path to the config. Can you try running

```
logstash -f C:/users/mkazemi/desktop/elastic/data/logstash_car.config

```

Please use appropriate markup when posting logs. Using an indent of 4 spaces is what I did there.

---

<div class="post-metadata">

**Author:** ![moe.kazemi](https://avatars.discourse-cdn.com/v4/letter/m/96bed5/32.png) [@moe.kazemi](https://discuss.elastic.co/u/moe.kazemi)\
**Post date:** [May 8, 2018, 5:43pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/6 "2018-05-08T17:43:13Z")

</div>

Thanks Badger for input this is what I did as you said but I got the following error message. Pls advise

C:\Users\mkazemi\Desktop\Elastic\logstash\bin\>logstash -f C:/users/mkazemi/desktop/data/logstash\_car.config

Sending Logstash's logs to C:/Users/mkazemi/Desktop/Elastic/logstash/logs which is now configured via log4j2.properties

[2018-05-08T10:32:22,965][ERROR][logstash.agent] failed to fetch pipeline configuration

{:message=\>"URI scheme not supported: C:/users/mkazemi/desktop/data/logstash\_car.config\n  
Either pass a local file path or "file|http://" URI"}

---

<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:** [May 8, 2018, 8:07pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/7 "2018-05-08T20:07:29Z")

</div>

Reading it again I think you had it correct the first time (without the drive letter). Is logstash\_car.config really in the data directory?

---

<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:** [June 5, 2018, 8:07pm UTC](https://discuss.elastic.co/t/issue-with-importing-cvs-file/130690/8 "2018-06-05T20:07:34Z")

</div>

Closed on June 5, 2018, 8:07pm UTC

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