Page 1 of 1

Proximity Search

Posted: 25 Aug 2017, 17:00
by dveos
Hi all, does anyone know if the zipcode proximity filter works with any postal code?

I am currently exploring options to include UK postcodes. Even if I install US Postal codes the filter doesn't seem to "stick" like other filter options (even if there are 0 results).

Re: Proximity Search

Posted: 31 Aug 2017, 10:29
by RussH
Hi dveos,

I'm fairly sure this will need a complete re-write. it's not as scary as it sounds - just that at the time of creation, there was no freely available API for postcode lookups - so the original code is a USA-only fudge that uses some zipcode lookup database. Now we can convert postcodes (or addresses) to lat/log via a single free google query.. so it *should be simple* (he said!) for a developer to add a 'query candidates by distance' option bypassing the orignal code completely. This is largely what I did when we did the very simple addition of an 'autocomplete' address when adding a candidate or contact.

If you can sort that, please contribute it back to the github repo!

Re: Proximity Search

Posted: 31 Aug 2017, 10:52
by dveos
Hi Russ,

Thank you for your reply.

I tried installing a UK postcode database, including lat / log in the same format as the US version but surprisingly didn't work :D . I can't seem to get the filter working even through using the standard US install. I'll keep plugging away in the meantime, and have put out a couple of freelancer requests but get crazy quotes. If you know anyone that would be willing to look at this in the short term for monies please do let me know.

Of course more than happy to contribute anything, OpenCATS has been a saviour! (Next on the list is a query to include db information in outgoing emails i.e. candidate / company name, I received a quote of approx £1000 as apparently would need a large rewrite.)

Re: Proximity Search

Posted: 31 Aug 2017, 11:06
by RussH
dveos wrote:Hi Russ,

Thank you for your reply.

I tried installing a UK postcode database, including lat / log in the same format as the US version but surprisingly didn't work :D . I can't seem to get the filter working even through using the standard US install. I'll keep plugging away in the meantime, and have put out a couple of freelancer requests but get crazy quotes. If you know anyone that would be willing to look at this in the short term for monies please do let me know.

Of course more than happy to contribute anything, OpenCATS has been a saviour! (Next on the list is a query to include db information in outgoing emails i.e. candidate / company name, I received a quote of approx £1000 as apparently would need a large rewrite.)
Hey - if you want to email me I can give you the email addresses of the 2 x devs currently working on the codebase - you can contact them directly, see if they can help you out with the proximity search.

For the 'include db information in outgoing emails' I'm not entirely clear on what you're after?

Re: Proximity Search

Posted: 31 Aug 2017, 11:17
by dveos
Done :)

Tried to explain what I'm looking to achieve in email.

Thanks Russ

Re: Proximity Search

Posted: 24 Aug 2018, 07:35
by dveos
Just to keep posts complete I managed to achieve this and can run a proximity search for both candidates and contacts for UK, FI and DE postcodes.

Re: Proximity Search

Posted: 24 Aug 2018, 08:15
by RussH
Hi Dveos,

Can you share the changes or are they quite extensive?

Re: Proximity Search

Posted: 06 Oct 2018, 22:49
by dveos
Hey russ, quite extensive, mainly adding to sql db if can be of use let me know :)