BUG. With import subscribers

hostbox

Member
When you try to import subscribers containing email union@domain.ru ALWAYS occurs error:
  • Your form has a few errors, please fix them and try again!
  • The file "part-1.csv" cannot be uploaded. Only files of these MIME-types are allowed: text/comma-separated-values, text/csv, application/csv, application/excel, application/vnd.ms-excel, application/vnd.msexcel, text/anytext, text/plain.

Perhaps this is due to the official word mysql engine union
But this is really a bug. It is necessary to check the filtered incoming text.

If you replace the word "union", for example, "un2ion" - the file is imported successfully.

File import.csv (utf-8):
Code:
EMAIL,MEMBERRATING,PHONE,FNAME,COMPANY,SOURCE,IP_ADDRESS,DATE_ADDED
union@domain.ru,2,,,,import,,"2016-04-26 13:28:55"
 

twisted1919

Administrator
Staff member
@hostbox - That has nothing to do with the sql keyword "union". The error says the file isn't valid csv.
From backend > settings > import/export disable mime type checking and you won't have this issue anymore.
Also, please renew your support here on the forums.
Thanks.
 
Top