Měsíc: Duben 2017

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 … Číst dál