Proximity Search

General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules
Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
Post Reply
dveos
Posts: 73
Joined: 09 Jun 2015, 15:35
what is two(2) plus three(3) ?: 5

Proximity Search

Post by dveos » 25 Aug 2017, 17:00

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).

User avatar
RussH
Site Admin
Posts: 805
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Proximity Search

Post by RussH » 31 Aug 2017, 10:29

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!
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

dveos
Posts: 73
Joined: 09 Jun 2015, 15:35
what is two(2) plus three(3) ?: 5

Re: Proximity Search

Post by dveos » 31 Aug 2017, 10:52

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.)

User avatar
RussH
Site Admin
Posts: 805
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Proximity Search

Post by RussH » 31 Aug 2017, 11:06

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?
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

dveos
Posts: 73
Joined: 09 Jun 2015, 15:35
what is two(2) plus three(3) ?: 5

Re: Proximity Search

Post by dveos » 31 Aug 2017, 11:17

Done :)

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

Thanks Russ

dveos
Posts: 73
Joined: 09 Jun 2015, 15:35
what is two(2) plus three(3) ?: 5

Re: Proximity Search

Post by dveos » 24 Aug 2018, 07:35

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.

User avatar
RussH
Site Admin
Posts: 805
Joined: 12 Apr 2008, 08:28
what is two(2) plus three(3) ?: 5
Location: UK
Contact:

Re: Proximity Search

Post by RussH » 24 Aug 2018, 08:15

Hi Dveos,

Can you share the changes or are they quite extensive?
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues

Please CLICK THE TICK to accept the answer!

dveos
Posts: 73
Joined: 09 Jun 2015, 15:35
what is two(2) plus three(3) ?: 5

Re: Proximity Search

Post by dveos » 06 Oct 2018, 22:49

Hey russ, quite extensive, mainly adding to sql db if can be of use let me know :)

Post Reply