Postcode Auto Fill support thread

[pilou2]

Just submitted v1.3.1 for part 1, which is an update of SQL file for Japanese postal codes when no zone is defined for Japan.
Postcode auto fill Part 1
Part 2 does not need to be updated, please use v1.3.
Postcode auto fill Part 2

This release is probably the last one for Zen Cart 1.5.8a. A new version for ZC V2.0.0 will be there soon.

[pilou2]

New encapsulated v2.0.0 of this plugin for Zen Cart v2.1.0 has just been submitted to plugin section. Also availabkle on GitHub here.
Now renamed "Postal Code Automatic".
From now on, it should be easier than ever to install, update or uninstall.
If you have an older version, please uninstall it (you can let database tables as is). See documentation in index.html file for details.

Content of the plugin does not change. It includes postal codes data for following countries:
Australia
Austria
France
Germany
Italy
Japan
Spain
Suiss (including Liechstenstein)
United States of America

[allmart]

Has anyone used this for Canada?

[pilou2]

V2.0.2 of this encapsulated plugin has been submitted in plugin section and should be available soon.
It is available on Github here.

It corrects a bug in SQL queries where missing country zones will stop installation.
Some code cleaning was done too.

[OldNGrey]

I had v2.0.1 installed, uploaded v2.0.2 to zc_plugins, uninstalled V2.0.1, installed v2.0.2 and received warning on Plugin Manager screen only (no log files)

Unknown collation: 'utf8mb4_ja_0900_as_cs_ks'
Table 'zc220_exp.zones_to_post_code_jp' doesn't exist

and module is not installed.

ZC 2.2; PHP8.4, MariaDB

[pilou2]

I see you are using MariaDB. It does not seem to support the collation 'utf8mb4_ja_0900_as_cs_ks'.
It should be working by replpacing the collation utf8mb4_ja_0900_as_cs_ks by some MariaDB equivalent at the begining of the Japanese postal cade SQL file (lines 9 & 10).
Un fortunately I am not sure MariaDB as an equivalent, I don't have any MariaDB server at hand to test that.
If you do not need Japanese postal codes, you can although modify line 6 of ScriptedInstaller.php, removing 'jp' from the list.

But if version 2.0.1 was working fine there was probably a collation that can be used.

[OldNGrey]

Thanks. The collation for MariaDB is "uca1400_ai_ci" (based on Unicode 14.0) for versions 10.11+

When the postcode (zip code) is entered and the city list is returned in the pop-up window, are the city /towns names supposedto be selectable?