EU Countries (Out of date)
Posted: Thu Dec 08, 2011 7:51 pm
This most likely won't affect everyone but in the process of tweaking my KashFlow accounting module for ISC I discovered that it wasn't marking customers from EU states as actually living there.
It was only when I dug into the isc_countries db table that I realised that someone really didn't do their homework...
While Bulgaria (added to EU in 2007) was set with a countrycouregid value corresponding to the EU region, there were a slew who joined as early as 1973 that weren't.
Typical sloppy work but here's a fix for those where it matters...
Of course that fix relies on you not having messed with the countries table and the values not changing during some ISC update.
EDIT: Looking into this further it seems that some island states are also part of the EU, including places like Reunion, Gibraltar, Guadaloupe, etc... so there's further edits pending... I soooo love politics...
It was only when I dug into the isc_countries db table that I realised that someone really didn't do their homework...
While Bulgaria (added to EU in 2007) was set with a countrycouregid value corresponding to the EU region, there were a slew who joined as early as 1973 that weren't.
Typical sloppy work but here's a fix for those where it matters...
Code: Select all
UPDATE isc_countries SET countrycouregid = 1 WHERE countryid IN (33, 176, 193, 194, 21, 171, 103, 150, 225, 199, 58, 205, 57, 56, 105, 67, 83, 73, 132, 72, 117, 97, 80, 124, 123, 14, 172)EDIT: Looking into this further it seems that some island states are also part of the EU, including places like Reunion, Gibraltar, Guadaloupe, etc... so there's further edits pending... I soooo love politics...
