topic Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending in Getting Data In

Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line endings"

Naa_Win — Thu, 04 Jan 2024 16:37:37 GMT

While I'm trying to upload my csv file as lookup, encountering the error like - "Encountered the following error while trying to save: File has no line endings"

I had tried by removing extra space and special characters from the header but still facing this issue. Along with that I had tried saving as different format of csv's line utf-8, csv-ms doc etc., but NO LUCK

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

richgalloway — Thu, 04 Jan 2024 19:47:31 GMT

How was the file created? Have you tried changing the line endings (notepad++ can do this, perhaps other editors can as well)?

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

Naa_Win — Thu, 04 Jan 2024 20:52:58 GMT

Basically we export from Airtable as a csv.

I changed in notepad++, view->show symbols-> show all characters, and edit->EOL Conversion->Windows Format. but that doesn't work.

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

richgalloway — Thu, 04 Jan 2024 22:09:09 GMT

Is the CSV file well-formatted? Missing quotes or unescaped embedded quotes (or commas) may affect how the file is loaded.

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

inventsekar — Fri, 05 Jan 2024 00:34:40 GMT

>>> Basically we export from Airtable as a csv.

Just after getting the above CSV file, Could you pls try to upload to Splunk(without notepad++ tasks).
if the above CSV file upload fails, open the file in notepad(hoping that the file is not big enough) and inspect manually, if all looks good, maybe pls try to upload once again.

maybe could you copy paste a screenshot of the error(after editing/masking/hiding sensitive details), thanks.

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

Naa_Win — Mon, 08 Jan 2024 16:57:29 GMT

I had tried the way you told but I got the same error as above.

These are the last two values of my csv file in notepad + +

Does every line should have CRLF ?

Re: Getting Error while upload CSV : "Encountered the following error while trying to save: File has no line ending

richgalloway — Mon, 08 Jan 2024 17:31:20 GMT

Rather than 2 events, I see 11. Eight of them contain a single value and the remainder contain different numbers of values.

A well-formed CSV file will have the same number of values in each event. Any values with embedded CRLFs must be enclosed in quotation marks.