Written by sackgesicht on

i get an error message while installing .. but it installs ... see attachment

Attachment: 1269919366_zip.zip (Size: 9 Kb | Hits: 428)

Written by Ainsworth Web on

Does everything work fine?

Written by maikkaune on

Interesting! Maybe a german ZIP database would come in handy ;-)

Written by sackgesicht on

Yes and No.

The installation will work, but the functionality (at least for me) not.

Since your australian database does not carry the towns behind the geographical information, there is almost no sense in the zip radius search. The filter will not work properly.

After installing the table in the database, i made a test with 2 postcodes close to each other.
I selected 2732 and 2733 (ID 4404 to 4414) from the table.

2732      NS      -35.630474      144.130417  Barham
2732     NS     -35.342175     144.399750  Burraboi
2732     NS     -35.451023     143.864746  Cobramunga
2732     NS     -35.473526     143.963654  Gonn
2732     NS     -35.329029     143.936371  Noorong
2732     NS     -35.702801     144.443619  Thule ?
2732     NS     -35.377071     144.205994  Tullakool

2733     NS     -35.194233     144.155273  Dhuragoon
2733     NS     -35.114021     143.792587  Mallan
2733     NS     -35.089134     144.036636  Moulamein
2733     NS     -35.245987     144.212845  Niemur

Here a list of distances between the towns:

Mallan - Noorong       27.24 km
Mallan - Cobramunga    38.04 km
Mallan - Gonn          42.88 km
Mallan - Tullakool     47.59 km
Mallan - Burraboi      60.70 km
Mallan - Barham        65.09 km
Mallan - Thule         88.13 km


Dhuragoon - Tullakool  20.85 km
Dhuragoon - Noorong    24.89 km
Dhuragoon - Burraboi   27.63 km
Dhuragoon - Gonn       35.59 km
Dhuragoon - Cobramunga 38.86 km
Dhuragoon - Barham     48.56 km
Dhuragoon - Thule      62.29 km


Moulamein - Noorong    28.19 km
Moulamein - Tullakool  35.52 km
Moulamein - Cobramunga 43.16 km
Moulamein - Gonn       43.25 km
Moulamein - Burraboi   43.36 km
Moulamein - Barham     60.79 km
Moulamein - Thule      77.57 km


Niemur - Tullakool     14.59 km
Niemur - Burraboi      20.05 km
Niemur - Noorong       26.74 km
Niemur - Gonn          33.92 km
Niemur - Cobramunga    38.94 km
Niemur - Barham        43.40 km
Niemur - Thule         54.93 km

Distances are from 14.59 to 88.13 between the 2 postcodes.

If i use the filter with 2733 and 20km it will not show any article with 2732 in it. When using it with 21km, all records with a 2732 as postcode will be displayed (even if they are more than 50km away).
As a radius search, where i would like to show restaurants or other points of interrest nearby, the error margin is to big.
Worst case scenario here would be, if i have Mallan in mind and use 21km as distance, i would get articles associated with Thule, which is 88.13 km away.

See attached picture for better appreciation.

As always, it depends on what you want to achieve ....

Attachment: 1269943053_zipcode.zip (Size: 203 Kb | Hits: 373)

Written by Ainsworth Web on

@ maikkaune

Can you get a db to me?

@ sackgesicht

The problem is, Mighty Resources use the postcodes strictly to perform the search. Ideally the component should use an address base (such as you described) to get a much more accurate figure.

Using the postcode is fine for main cities, but as you've shown in your example... fails in remote areas.

Sorry mate...

Written by maikkaune on

Only found this commercial link. download commercial, free list and table online.

http://www.geopostcodes.com/de/index.php

If i find something else, i will come back to you.

Written by sackgesicht on

@maikkaune

Try this .... http://download.geonames.org/export/zip/DE.zip

@ Ainsworth Web

It would be good if it would check for individual locations ... to make it more general, it could compute the center of the same postcodes and use this as a refererence point for the distance computation to all nearby points.

Written by Ainsworth Web on

@ sackgesicht

I've updated the plugin and the Australian database to search via suburb as opposed to Postcode. You can set it to allow users to enter in both, or just one or the other.

Could you let me know how it goes?

Written by sackgesicht on

Filter installation:

still get the XML Parsing Error at 1:1. Error 4: Empty document

SQL Installation:
I get following MySQL error:

MySQL said:

#1146 - Table 'testing.wcv3_juser_postcode_aus' doesn't exist

and the table jos_juser_postcode_aus is empty .....

Written by Ainsworth Web on

Must have uploaded the wrong file... will get it it fixed up mate

Written by Ainsworth Web on

Updated file... SHOULD work... let me know

Written by astoryan on

please can you gtell me how can i do with french database

please thank you