EasyPopulate 4.0 Support Thread

[Feznizzle]

Yes, it says latin1.

Internal Character Encoding says ISO-8859-1, same as before.

When I exported, imported, and then re-exported, the only difference between the export files is that the date/time changed to 0000-00-00 00:00:00. I don't think anything was truncated.

But when I opened the file to make some changes, I found garbage right away. I chose a category containing products with ™ symbols in the name. The symbols were replaced with: ô

Uggg.

[mc12345678]

Yes, it says latin1.

Internal Character Encoding says ISO-8859-1, same as before.

When I exported, imported, and then re-exported, the only difference between the export files is that the date/time changed to 0000-00-00 00:00:00. I don't think anything was truncated.

But when I opened the file to make some changes, I found garbage right away. I chose a category containing products with ™ symbols in the name. The symbols were replaced with: ô

Uggg.

So, there were two files exported. First, did both present the same "garbage" second, what encoding/viewer was used to view the file(s)?

Unusual that the date got set to 0000-00-00 instead of the database preferred 0001-01-01 style, but if the site itself could export and import the exported file without any character encoding issues, then that means that EP4 is doing its part just fine. The problem is in the next "tool" which is reading, expecting or converting the file to be utf8 which is then causing the observed "garbage" ie. looking at latin1 in utf8 can cause characters to look as junk.

[Feznizzle]

Yes, garbage in both files. I use Open Office. Can I switch CharSets in there?

[mc12345678]

Yes, garbage in both files. I use Open Office. Can I switch CharSets in there?

Of course.

When opening the file, you should be presented with an option to import text. The first box is the character set. Change that from unicode (utf-8) to Western Europe (ISO-8859-1) then follow the remainder of the settings to support import. I provide this information based on Apache Oppenoffice 4.1.3. I haven't updated or attempted to update recently to identify if/what differences might exist in the options to reach various features. That aspect is something that should be addressed through the tool of use's help/assistance.

[Feznizzle]

Doh! Can't believe I missed that. Well, the garbage is gone... but so is the trademark symbol.

[mc12345678]

Doh! Can't believe I missed that. Well, the garbage is gone... but so is the trademark symbol.

Did it remain between import/export of the original file and only disappear when loaded into open office?

I found this which suggests you may want to also adjust the font style in the process: https://wiki.openoffice.org/wiki/Doc...mark_symbol%3F

Otherwise I thought that there might be some differences that may help by using Libre?

[Feznizzle]

Same thing occurs in Libre.