CLI import CSV into suiteCRM

convert from windows-1250 to UTF8

iconv -f WINDOWS-1250 -t UTF-8 customer.csv > customer.u.csv

inspired by this web

http://www.jsmackin.co.uk/suitecrm/large-imports-in-suitecrm/

LOAD DATA INFILE '/tmp/customer.u.csv' INTO TABLE contacts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (id,description,department,first_name,last_name,primary_address_street,primary_address_city,primary_address_postalcode,phone_home,phone_work,phone_other,phone_fax,phone_mobile,description,alt_address_street,alt_address_street,salutation,alt_address_street,title,primary_address_country,primary_address_state);

REBUILD INDEX DB

ALTER TABLE contacts DROP KEY idx_cont_last_first;
ALTER TABLE contacts DROP KEY idx_contacts_del_last;
ALTER TABLE contacts DROP KEY idx_cont_del_reports;
ALTER TABLE contacts DROP KEY idx_reports_to_id;
ALTER TABLE contacts DROP KEY idx_del_id_user;
ALTER TABLE contacts DROP KEY idx_cont_assigned;
ALTER TABLE contacts ADD INDEX idx_cont_last_first (last_name,first_name,deleted), ADD INDEX idx_contacts_del_last (deleted,last_name), ADD INDEX idx_cont_del_reports (deleted,reports_to_id,last_name), ADD INDEX idx_reports_to_id (reports_to_id), ADD INDEX idx_del_id_user (deleted,id,assigned_user_id), ADD INDEX idx_cont_assigned (assigned_user_id);