I'm in the UK where the postcode regions are - well not exactly designed for the digital age shall we say? I need to group everyone in our database into 7 regions that fit our organisation's needs but the list of postcodes per region is very diverse.
See below for an example of the postcodes from one of our regions.
I'm about to create smart groups via search builder for postcode regions like below, but I know it's going to have 20+ lines in the search builder.
So, I wondered before I start whether there is a better way of doing this? I don't want complicated smart group criteria slowing down our server, since we already have quite a few. Or would these queries not really be an issue?
I'm on Drupal 7.56 and Civi 4.6.24, and about to upgrade to 4.7. I could use Drupal Rules, Views or possibly Search Sorts if they're likely to yield better results.
Each of our regions have a list of postcodes like follows:
Postcodes beginning with: S 25, S 35, S 36, S 60 – 66, S 70 -75, LN 7, DL, YO, LS, DH, SR, TS, HG, HU, DN, WF, HX, HD, BD, NE 1-13, NE 15 – 47, NE 61 – 64, NE 99 (There’s no NE 14)
Thanks for any thoughts!