This utility allows the (IT admin) user to iterate through any UK based
customers (tb_SUPSupplier) which have no mapping coordinates (SUPMapLat and
SUPMapLong) and if they have a postcode that is more than 4 characters it will
look in the postcode database (tb_PSCPostcodeOS) to see if the postcode exists.
If it does, it takes the coordinates from this table and updates the customer.
The routine could run for hours in the early days when we have many
customers without coordinates. For this reason you may experience a 'time out'.
If you do and aren't sure if it worked then you can also run the stored
procedure directly in query analyser (if you have permission). The sp is call
sp_MappingCoordinateBatchUpdate. |
