Database I/O Manager (DbIo) Plugin [Support Thread]

[Hasher]

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.xml��MNÃ0…¯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

[lat9]

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.xml��MNÃ0…¯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.

[Hasher]

Hi Lat9 ,

I changed to Latin1 and the import log does look better but I am now getting the message" "The current import-file is missing these (v_products_id) required columns; the import is disallowed." Uploaded a new log file if this helps. Do you use OpenOffice ?

https://yadi.sk/d/p9Ix-IZWuJ_FdA

[lat9]

Hi Lat9 ,

I changed to Latin1 and the import log does look better but I am now getting the message" "The current import-file is missing these (v_products_id) required columns; the import is disallowed." Uploaded a new log file if this helps. Do you use OpenOffice ?

https://yadi.sk/d/p9Ix-IZWuJ_FdA

That log doesn't tell me anything. Would you post a zip of the to-be-imported CSV?

[Hasher]

Sure, here is a link :)

https://yadi.sk/d/FGB5d8r9lVOfbw

[lat9]

The issue is that the .csv input is being stored with UTF-8 BOM encoding. I was able to import that CSV after opening it in Notepad++, clicking the "Encoding" tab, clicking Convert to UTF-8 and saving.

[Hasher]

Thanks Lat9 !

Excel is just being a bit*h ! Impressed with your work !

[lat9]

Thanks Lat9 !

Excel is just being a bit*h ! Impressed with your work !

Yep, it's a love/hate relationship! Thanks for the compliment.

[torvista]

Excel is just being a bit*h

Excel is prehistoric/useless when dealing with encodings.
If you use Libreoffice you have full control of this on import and export of csv, I use this for all my work regarding import/export.

[Hasher]

If I am adding a new product and the category I selected doesn't exist . Will it then be created ? I would try but I don't want to break anything