Import from CSV to MySQL table using "load data local" and the CSV has damn newlines in the data. Make sure all fields are enclosed correctly in quotes.

notes_from_act.sql

load data local infile '/Users/MKP01/Documents/Studio Center/Matt Import/notes_csv_fixed_quote/note.csv'
into table notes
fields terminated by ',' 
enclosed by '"' 
-- lines terminated by '\n'
ignore 1 lines
(contact_id,@date_entered,@created_by,@date_modified,modified_user_id,description,@bad_id,name)
set id = UUID(),
date_entered = STR_TO_DATE(@date_entered,'%m/%e/%Y %H:%i'),
date_modified = STR_TO_DATE(@date_modified,'%m/%e/%Y %H:%i'),
created_by = @created_by,
assigned_user_id = @created_by;