# Jmeter Dates are not showing correctly in ELS

**URL:** <https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311>\
**Category:** Elasticsearch\
**Created:** [November 4, 2019, 1:40am UTC](https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311 "2019-11-04T01:40:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trevorp](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@Trevorp](https://discuss.elastic.co/u/Trevorp)\
**Post date:** [November 4, 2019, 1:40am UTC](https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311/1 "2019-11-04T01:40:49Z")

</div>

I am putting Jmeter CSV file into ELK for reporting and analysis. How ever the dates I need to use are not being put in correctly

This is the data in ELK the time should be 2019/10/29 10:00:00 , that is in the message, The data shown is Oct 29, 2019 @ 18:00:00.000

**t** message **2019/10/29 10:00:00,28** 8,h\_bp08 General Browsing 2,200,OKHellocom\_General Browsing 2 20-26,true,42889,28,255,null,283,Servername,20001,28  
**t** responseCode 200  
**t** responseMessage OK  
**t** success true  
**t** tags beats\_input\_codec\_plain\_applied  
**t** threadName hellocom\_ General Browsing 2 20-26  
time Oct 29, 2019 @ 18:00:00.000

My config file is

# Read input from filebeat by listening to port 5044 on which filebeat will send the data

input {  
beats {  
type =\> "Jmeter\_test"  
port =\> "5044"  
}  
}

filter {  
csv {  
columns =\> [  
"timeStamp",  
"elapsed",  
"label",  
"responseCode",  
"responseMessage",  
"threadName",  
"success",  
"bytes",  
"grpThreads",  
"allThreads",  
"pathurl",  
"Latency",  
"SampleCount",  
"ErrorCount",  
"Hostname",  
"IdleTime",  
"Connect"  
]  
}

mutate{convert =\> { "elapsed" =\> "integer"}}  
mutate{convert =\> { "bytes" =\> "integer"}}  
mutate{convert =\> { "grpThreads" =\> "integer"}}  
mutate{convert =\> { "allThreads" =\> "integer"}}  
mutate{convert =\> { "Latency" =\> "integer"}}  
mutate{convert =\> { "SampleCount" =\> "integer"}}  
mutate{convert =\> { "ErrorCount" =\> "integer"}}  
mutate{convert =\> { "groupId" =\> "integer"}}  
mutate{convert =\> { "vuserId" =\> "integer"}}  
mutate{convert =\> { "Hits" =\> "integer"}}  
}

output {  
stdout {  
codec =\> rubydebug  
}

# Sending properly parsed log events to elasticsearch

elasticsearch {  
hosts =\> ["localhost:9200"]  
}  
}

The index Mappings shows

{  
"@timestamp": {  
"type": "date"

```
  },
  "time": {
    "type": "date",
    "format": "yyyy/MM/dd HH:mm:ss||yyyy/MM/dd||epoch_millis"
  },
  "type
```

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [November 4, 2019, 10:07am UTC](https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311/2 "2019-11-04T10:07:24Z")

</div>

can you share what the final document looks like before it is being indexed?

---

<div class="post-metadata">

**Author:** ![Trevorp](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@Trevorp](https://discuss.elastic.co/u/Trevorp)\
**Post date:** [November 4, 2019, 10:49pm UTC](https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311/3 "2019-11-04T22:49:15Z")

</div>

The CSV file looks like this

2019/10/24 08:30:37,244,PHI Private ,200,OK,xyzcom\_bp08 General Browsing 2 20-28,true,38166,1,2,[https://xyz.com.au/,239,1,0,ServerName,0,32](https://xyz.com.au/,239,1,0,ServerName,0,32)  
2019/10/24 08:30:37,68,GetQuote\_ Pge Load,200,OK,xyzcom\_bp08 General Browsing 2 20-28,true,4707,1,2,[https://xyz.com.au/,68,1,0,ServerName,0,21](https://xyz.com.au/,68,1,0,ServerName,0,21)  
2019/10/24 08:30:45,197,HHP [xyz.COM](http://xyz.COM) Home Page,200,OK,xyzcom\_bp06 [xyz.COM](http://xyz.COM) HP 18-25,true,52971,1,3,[https://xyz.com.au/,191,1,0,ServerName,0,18](https://xyz.com.au/,191,1,0,ServerName,0,18)

---

<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 2, 2019, 10:49pm UTC](https://discuss.elastic.co/t/jmeter-dates-are-not-showing-correctly-in-els/206311/4 "2019-12-02T22:49:17Z")

</div>

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