[Fixed]Storelocator with Gmap, Location and Views for the Netherlands

Hello all,

Im trying to make a drupalsite with a storelocator in it. With that i mean a googlemap with the store locations in it. Above that map there should be a filter where you can fill in your postcode so it give you the closest store back.

I found some diffirent tutorials on the net that discribe how this is done, like:

http://svendecabooter.be/blog/implementing-location-proximity-search-for...
http://drupal.org/node/359463

But when trying those i found out that i needed a postcode database. For that i went to:

http://kvdb.net/projects/6pp/downloads

and downloaded the 6pp database (format: 1234 AB). I made a python program to make an output for the drupal db. I might be handy for other users so here it is. use it like this:

./dbconverter.py >> zipcodes.nl.mysql

When your database is done, i imported it this way:

db # mysql -u root -p drupal < zipcodes.nl.mysql
Enter password:
db #

!/usr/bin/python#import sys
from os.path import exists

Q = list()##def addInsert(line):
    x = line.split(',')
    Q.append("INSERT INTO zipcodes VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');".format(x[1],x[0],'ZHO',x[6],x[7],1,1,'nl'))
    
csvfile = "/var/www/localhost/htdocs/ecolamp/db/6pp_zh.csv"
if not exists(csvfile):
    print "path doesnt exists noob"
    exit(-1)

try:
    f = open(csvfile,'r')#except Exception,e:
    print "Cant open {0}: {1}".format(file,e)

l = 1
for line in f:
    if l != 1:
        addInsert(line.rstrip('\r\n'))
    l += 1
    
for x in Q:
       print x

This is a short example how it came out:

INSERT INTO zipcodes VALUES('7705 PA','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PB','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PC','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PD','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PE','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PG','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PH','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PJ','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PL','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7705 PM','Drogteropslagen','DRE','52.61666700','6.50000000','1','1','nl');
INSERT INTO zipcodes VALUES('7740 AA','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7740 AD','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7740 AE','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7741 AB','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7741 AC','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7741 AD','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7741 AE','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');
INSERT INTO zipcodes VALUES('7741 AG','Coevorden','DRE','52.66666700','6.75000000','1','1','nl');

I'm using:

Location: 6.x-3.1-rc1
GMap: 6.x-1.x-dev
Views: 6.x-2.7

Okay, so far so good.

Next i made a new view with these settings:

http://img8.imageshack.us/img8/3980/locator1.jpg

That gave me this output in previewmode:

http://img195.imageshack.us/img195/9749/locator2.jpg

SELECT node.nid AS nid,
   'Unknown' AS location_distance_0,
   location.latitude AS location_latitude,
   location.longitude AS location_longitude,
   node.title AS node_title
 FROM node node 
 LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
 LEFT JOIN location location ON location_instance.lid = location.lid
 WHERE (node.type in ('shop')) AND (node.status <> 0) AND (0)

Im wondering about the:

 'Unknown' AS location_distance_0,

Is that correct?

Anywayz, my aim is to get this output:

http://svendecabooter.be/sites/svendecabooter.be/files/upload/proximity_...

but im getting this:

http://img195.imageshack.us/img195/8990/locator3.jpg

This thing is driving me crazy sinds i tried it over and over again. I don;t got a clue anymore where to look for :P The map nor the filters are working.

So, is there anyone that can help me get a working storelocator?

Thanks in advance :)

Grtz Remco