topic Re: Not showing csv data in Getting Data In

Not showing csv data

dsiob — Tue, 29 Sep 2020 14:27:34 GMT

hi,
I uploaded csv file having a date field. This field has current week dates as well as future week dates.
CSV got uploaded successfully without any warning, but while searching on the csv it shows '0 events before 6/14/2017 8:51:00AM'. '6/14/2017 8:51:00AM' is current time.
I alreadyset MAX_DAYS_HENCE=30 in props.config

While uploading

On searching

Re: Not showing csv data

BlueSocket — Wed, 14 Jun 2017 14:24:21 GMT

I see what is going wrong - you have given the data in the future and so the data is indexed in the future. However, the search is by default in the past. Have you tried using the search:

source="New_Excel_B.csv" host="397AD-1A210036" sourcetype="csv" latest=+30d

Re: Not showing csv data

woodcock — Wed, 14 Jun 2017 14:48:02 GMT

You can do a search for All timeor, as @BlueSocket said, use latest=+30d or similar.

Re: Not showing csv data

dsiob — Thu, 15 Jun 2017 05:02:27 GMT

now the result is "0 events (before 7/15/17 12:01:38.000 AM)"

Re: Not showing csv data

dsiob — Tue, 29 Sep 2020 14:27:55 GMT

One thing I noticed that it is showing count as '1' in Data Summary for 'New_Excel_B.csv' but while uploading it displayed all events the csv has. !!!

Re: Not showing csv data

BlueSocket — Thu, 22 Jun 2017 15:37:39 GMT

I just had a thought., What happens when you do the following query?

sourcetype="csv" earliest=-10y latest=+10y

Do you get anything then?