| View previous topic :: View next topic |
| Author |
Message |
Oldboy
Pocket GPS Moderator
Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK
|
 Posted: Fri Dec 16, 2011 4:56 pm Post subject: |
 |
|
| Daggers wrote: | PGPSW could probably do even better if all the Somerfield branches were merged into the Co-op category, now that Somerfield has been taken over and all the branches reranded as Co-op!
Is there an easy way to merge two categories into one within the database? |
By the magic of database wizardry, it has now been done.
Thanks MikeB. 
_________________
Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120 |
|
| Back to top |
|
 |
Daggers
Lifetime Member
Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK
|
| Posted: Sat Dec 17, 2011 12:52 pm Post subject: |
|
|
Brilliant! Many thanks.
Now, if I could be so bold, can I suggest another one? Alliance Pharmacy was taken over by Boots a while ago, so this is another name that has disappeared from the High Street/local shopping parades. As it was a predominantly a pharmacy, I believe that Alliance should be merged into the Boots Dispensing category.
_________________
Garmin DriveSmart 50 LMT-D |
|
| Back to top |
|
|
Oldboy
Pocket GPS Moderator
Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK
|
| Posted: Sat Dec 17, 2011 1:29 pm Post subject: |
|
|
Did Boots re-badge all the Alliance pharmacies?
_________________
Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120 |
|
| Back to top |
|
|
Rick-uk
Lifetime Member
Joined: Apr 16, 2006
Posts: 320
Location: BS20, North Somerset
|
| Posted: Sat Dec 17, 2011 4:43 pm Post subject: |
|
|
| Oldboy wrote: | | Daggers wrote: | all the branches reranded as Co-op!
|
By the magic of database wizardry, it has now been done. |
Oh dear
Not all Somerfields were rebranded to Co-Op. Where there was already an existing Co-Op in the local area a decision had to be made which of the stores was to be retained. Many existing Somerfileds were sold to other retailers. Our Somerfiled became a Budgens.
OFT press release |
|
| Back to top |
|
|
Oldboy
Pocket GPS Moderator
Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK
|
| Posted: Sat Dec 17, 2011 5:14 pm Post subject: |
|
|
| Rick-uk wrote: | | Our Somerfiled became a Budgens. |
Hopefully there will be fewer changes to make this way round. 
Don't forget to submit a change for your local. 
_________________
Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120 |
|
| Back to top |
|
|
Daggers
Lifetime Member
Joined: Jun 20, 2005
Posts: 1096
Location: Solihull, UK
|
| Posted: Sat Dec 17, 2011 8:02 pm Post subject: |
|
|
| Rick-uk wrote: | | Not all Somerfields were rebranded to Co-Op. Where there was already an existing Co-Op in the local area a decision had to be made which of the stores was to be retained. |
There used to be around 775 Somerfields on the PGPSW database, all of which were wrong, because Somerfield doesn't exist any longer. In one fell swoop, around 640 of these have been corrected, leaving potentially 130 wrong - which were already wrong in the first place. I don't think it's a bad return for a relatively quick piece of work.
| Oldboy wrote: | | Did Boots re-badge all the Alliance pharmacies? |
If you Google Alliance Pharmacy, it takes you to the Boots web site. There is still an Alliance Store Locator, but it only takes you to Bing Maps (the Boots Store Locator works fine). There is a page listing all the different types of stores which goes into all the variations of Boots, but doesn't mention Alliance at all.
The OFT site that Rick-uk pointed to does indicate that 96 Alliances were sold off, but using the same argument as above, 96 wrong out of 925 that are already incorrect is a pretty good rate of return.
_________________
Garmin DriveSmart 50 LMT-D |
|
| Back to top |
|
|
Oldboy
Pocket GPS Moderator
Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK
|
| Posted: Sun Dec 18, 2011 8:36 am Post subject: |
|
|
| Daggers wrote: | | There used to be around 775 Somerfields on the PGPSW database, all of which were wrong, because Somerfield doesn't exist any longer. In one fell swoop, around 640 of these have been corrected, leaving potentially 130 wrong - which were already wrong in the first place. I don't think it's a bad return for a relatively quick piece of work. |
I agree. Submissions to correct Somerfields were almost non-existent anyway.
| Daggers wrote: | | The OFT site that Rick-uk pointed to does indicate that 96 Alliances were sold off, but using the same argument as above, 96 wrong out of 925 that are already incorrect is a pretty good rate of return. |
That's the information I like to hear. It's also a lot less work for me.
I'll put in a request accordingly.
_________________
Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120 |
|
| Back to top |
|
|
|
![]() Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Log in for private messages
Log in
