Quote Originally Posted by Hasher View Post
Hi Lat9

I made what I think is a perfect copy of the import files. I have changed the encoding to UTF-8 , Office 365 version of only shows UTF8 encoding but no UTF8 BOM . So im not sure if it is saving to UTF8 BOM encoding without giving me an option . If its an encoding issue the I guess I need to get a different copy of a CSV editor.

I have tried chnaging the seperator and have included the logs in my files. Current error is "The current import-file is missing these (v_products_id, v_products_model) required columns; the import is disallowed."

Part in logs that worries me is "2019-08-21 10:19:56: importGetHeader, using headers:
Array
(
[0] => PK O} xl/workbook.xmlMN0…b 8uH‘$‹.@•@6Τ?q$<o›i._Νhjl飯r#`lphDLO
)
"


Which seems to be its not reading encoding right ! I could be wrong :)

https://yadi.sk/d/kHp37h4B4zHp8A



Thanks for any help !

Paul
Since you're using Excel, you can change DbIo's encoding to use latin1 instead of utf8 (the default). I believe that will correct your issues.