Ever just bang your head against a problem for an hour+ ?

[Jaymer]

ya know, I'm not an idiot.
I usually can type in field names CORRECTLY.
so when i get a error dialog box like this:

Screen Shot 2018-05-19 at 3.32.07 PM.png (12.17 KiB) Viewed 4239 times

I'm thinking to myself, "Come on, not again".
I wasted 30 minutes on a simple import.
I could have written a generate data program easier, but generating in Excel and importing a CSV SHOULD HAVE BEEN even faster.

So I make myself a 2-column CSV and it will not import.
Shows the above msg.
Just how many times can you check what you've typed and see that its identical? The field names and the header line of the import is correct.

Screen Shot 2018-05-19 at 3.33.13 PM.png (42.26 KiB) Viewed 4239 times

So I manually enter 1 row using "Standard menu/New Object" and then export the 1 row. Sure, header line is the same. OK, copy/paste Aware's header line over to my generated CSV line (which is foolish because your eyes tell you its already the same, yet you talk to yourself and convince yourself its the next logical step, so do it anyway). Guess what? Same Error.

BTW, the 1-row Aware-generated export file will re-import no problem. Sure, I tried that.
So I copy/paste some of my data lines to the bottom of that file, and they import.
Copy all my lines there and they import.
DONE

The image shows both files - the one from Excel (CSV) will not import, the one from aware will.
Whats the difference?

ANSWER:
Saved from Excel using the TOP CSV Option - UTF-8 screwed me.
Look how far down the "Normal" old-style CSV is. CRAZY waste of time!

Screen Shot 2018-05-19 at 3.45.54 PM.png (50.42 KiB) Viewed 4239 times

[BenHayat]

Man, you need to cut back on the Coffee...
Strong Coffee can make you "Trigger Happy".

[tford]

Thanks for sharing, Jaymer.