### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [June 7, 2022, 12:51pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/4 "2022-06-07T12:51:10Z")
> [@selflabs](#):
>
> \
Can you check the file? This is saying that you have some issue with quotes.
---
### Author:  [@selflabs](https://discuss.elastic.co/u/selflabs)
#### Post date: [June 8, 2022, 2:18pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/5 "2022-06-08T14:18:35Z")
Hi, I have tried all possible formats/quotes but error remain persists.
Please suggest if there is any desired format for save.
below which i have tried.
## "Hostname","Value" "server\_1","Windows" "server\_2","Linux"
## "Hostname","Value" "server\_1","Windows", "server\_2","Linux"
## "Hostname", "Value", "server\_1", "Windows", "server\_2","Linux",
---
### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [June 8, 2022, 3:00pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/6 "2022-06-08T15:00:15Z")
Your dictionary should look something like this:
```auto
server_1,Windows
server_2,Linux
server_3,Unix
server_4,Windows
server_5,Linux
server_6,Unix
```
According to the [documentation](https://www.elastic.co/guide/en/logstash/current/plugins-filters-translate.html#plugins-filters-translate-dictionary_path) you only need quotes when using integers as keys, so you doesn't need to use it when your keys are strings.
Is your dictionary looking as the one I shared and you are still getting the exactly same error? Can you enable debug log to get more information?
---
### Author:  [@selflabs](https://discuss.elastic.co/u/selflabs)
#### Post date: [June 14, 2022, 6:51am UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/7 "2022-06-14T06:51:24Z")
Hi Leandro, I have tried all possible ways but can't do a lookup of a field in a csv file.
can you please suggest the translate plugin logic, herewith am pasting the error logs with debug mode.
```auto
input{
http{
host => "127.0.0.1"
port => " *****"
ecs_compatibility => disabled
type => "input"
}
}
filter {
json{ source => "message"
ecs_compatibility => disabled }
split { field => "result" }
mutate { add_field => {"ids" => "%{[result][server]}"} }
csv {
separator => ","
skip_header => "true"
columns => ["server", "os"]
ecs_compatibility => disabled
}
translate {
dictionary_path => "/etc/logstash/conf.d/myfilename.csv"
source => "[ids]"
target => "[os]"
fallback => "I'm a teapot"
}
mutate {remove_field => ["server","http","url","agent"] }
}
output {
stdout { codec => rubydebug }
}
```
---
### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [June 14, 2022, 3:15pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/8 "2022-06-14T15:15:57Z")
It is still giving the same error, that it is something wrong in your `csv` file, in the first line.
Do you have anything else in your file besides the key value pairs? A header, maybe? You can't have anything in the file that is not in the format:
`key,value`
Can you open your file in a terminal text editor and share a print of it?
---
### Author:  [@selflabs](https://discuss.elastic.co/u/selflabs)
#### Post date: [June 15, 2022, 5:34am UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/9 "2022-06-15T05:34:32Z")
Hi Leandro, PFA print of that csv file. i'm not using any header in the file.
---
### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [June 15, 2022, 11:56am UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/10 "2022-06-15T11:56:55Z")
It looks like a normal csv, I have no hints why Logstash would give you such error.
I would try to manually create a new file in the yml format.
```auto
"server_1": "Windows"
"server_2": "Linux"
"server_3": "Unix"
"server_4": "Windows"
"server_5": "Linux"
"server_6": "Unix"
```
And then use this file in your translate filter.
---
### Author:  [@selflabs](https://discuss.elastic.co/u/selflabs)
#### Post date: [June 15, 2022, 12:19pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/11 "2022-06-15T12:19:08Z")
Hi Leandro, We have tested with yaml and json format and it works perfectly fine. the problem occurs only on csv format. so can we conclude that csv format is not supported by translate plugin/within logstash.
---
### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [June 15, 2022, 12:24pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/12 "2022-06-15T12:24:49Z")
This is not entirely right, the csv format is supported, but for some reason your csv wasn't working, maybe there was something related on how it is created in your system or things like that.
But to know why it wasn't working you would need to open a bug report in the Logstash Github.
Particularly I prefer to use `yml` files in my dictionaries, so if you changed to `yml` and it worked, you should keep using `yml`.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 13, 2022, 12:25pm UTC](https://discuss.elastic.co/t/logstash-configuration-not-working-on-read-csv-file/306515/13 "2022-07-13T12:25:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.