Howto: zip code proximity search using Location Module

I tried to repeat this 3 times without much success. The search doesn't throw any results. I did ensure the following as cautioned int the tute above:

1) Location data is the one collected through the Node Locations and not the one collected through CCK Location Field.

2) I did install the zip codes of US. I specifically ran the queries related to zip codes of Naples, FL only.

Even in the preview clicking Apply gets no results. However in the Distance if I Type 0 and den click apply den all locations unfiltered are listed. I have kept both the filters viz. Postal Code and Distance Optional still leaving them blank and clicking Apply doesnt give any results.

Also, I had tried to add the display as Block but the same wouldn't show.

Kindly help me understand where am I going wrong.

I'm getting the same problem as above.

If I type 0 into distance, I get a list of all the nodes but for each one the "Distance / Proximity:" field gives no value.

I have checked all the settings carefully and am using the latest versions of all modules.

I made this work, courtesy of someone else's post, since I didn't have a clue about how Drupal works, let alone views, gmap, and location nodes. When I get to my other computer, I will find the helpful link and add it to this thread. And I will thank the nice lady for posting it.

Here's my next problem though: zip codes are nice and all, but what I want to do is allow my users to search using City, Street, or Cross Street. Essentially, I want this to work anywhere in the world, and to be helpful when a person only knows either where they are currently, or what city they want to look at. Zip codes are kind of specialized. Let's not get into problems related to alternate alphabets and other languages. Let's assume Latin Alphabet, English Language for now.

Anyone done this? Like I said, I am new to Drupal.

Thanks

Would it be possible to also display the filtered results right under the map?

The SQL that is produced by my view with a distance/proximity filter always has a "WHERE 0" on the end, which is always returning no results. Any ideas what I am doing wrong, I have dumped my view export in below;

"SELECT location.lid AS lid,
node.title AS node_title,
node.nid AS node_nid
FROM location location
LEFT JOIN location_instance location_instance ON location.lid = location_instance.lid
LEFT JOIN node node ON location_instance.vid = node.vid
WHERE 0
"

$view = new view;
$view->name = 'mapsviewprops';
$view->description = 'mapsviewprops';
$view->tag = 'mapsviewprops';
$view->view_php = '';
$view->base_table = 'location';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
'address' => array(
'label' => 'Address',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'hide' => array(
'name' => 0,
'street' => 0,
'additional' => 0,
'city' => 0,
'province' => 0,
'postal_code' => 0,
'country' => 0,
'locpick' => 0,
'phone' => 0,
'province_name' => 0,
'country_name' => 0,
'map_link' => 0,
'coords' => 0,
),
'exclude' => 0,
'id' => 'address',
'table' => 'location',
'field' => 'address',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
'title' => array(
'label' => 'Title',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'distance' => array(
'operator' => 'dist',
'value' => array(
'latitude' => '',
'longitude' => '',
'postal_code' => '',
'country' => '',
'search_distance' => '100',
'search_units' => 'mile',
),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'distance_op',
'identifier' => 'distance',
'label' => 'Location: Distance / Proximity',
'optional' => 1,
'remember' => 0,
),
'type' => 'postal_default',
'identifier' => 'dist',
'id' => 'distance',
'table' => 'location',
'field' => 'distance',
'relationship' => 'none',
),
));
$handler->override_option('access', array(
'type' => 'none',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'maps1111');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));

I got the zipcode search working properly when I manually add locations however I'm having issues getting the search to see locations I've added through a batch import to the DB.

The batch imported successfully. I set source=4 in the location table and all locations appear under the search box before I attempt to narrow down the results by the proximity search.

I've found the search only works for a location after I manually follow the link to the Google Maps results for each individual location so it can catalog the actual longitude/latitude data into the database.

Is there any fix or workaround for this or am I missing something? I can't manually click each link for the 5000+ locations I have to import. It kind of defeats the purpose of a batch.