I have the following sample data in a csv file.I am trying to import it but its unable to break the line and detect the timestamp.
"Jun18.104.22.168, LVVL@abc.LOCAL, InOctets, 557766140, OutOctets, 3462815293, Total MB used, 502.572679125"
"Jun22.214.171.124, ALU@abc.LOCAL, InOctets, 4238119433, OutOctets, 3683403330, Total MB used, 990.190345375"
"Jun126.96.36.199, RXGH@abc.LOCAL, InOctets, 233853544, OutOctets, 485536206, Total MB used, 89.92371875"
Assuming your timestamp is the first field, try setting your TIME_FORMAT to %b%d.%y.%H.%M
Having said that, what do dates with single digit days look like e.g. Jul01.22 or Jul 1.22 or Jul1.22?
I tried using %b%d.%H.%M.%S in TIME_FORMAT but it did not recognize the time.I am attaching the screenshot of how it looks when uploaded through UI.
[ csv ]
description=Comma-separated value format. Set header and other settings in "Delimited Settings"