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.
By dveos
#3249
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
By RussH
#3251
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!
By dveos
#3255
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
By RussH
#3257
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?
By dveos
#3258
Done :)

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

Thanks Russ
By dveos
#3821
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
By RussH
#3824
Hi Dveos,

Can you share the changes or are they quite extensive?
By dveos
#3868
Hey russ, quite extensive, mainly adding to sql db if can be of use let me know :)

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me