Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 18 total
Thread 3 interesting tables 4 uk guys
Thu, Jun 4 2009 3:40 PMPermanent Link

"Rita"
http://linuxbox.co.uk/

price is right all the hard work is done.
I fancy the IP one I have the postcode
already and hopefully Roy will tidy the
phone code one up Wink
Rita

Fri, Jun 5 2009 3:23 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


I found this http://www.stdwizard.co.uk/index.html yesterday which looks as though its worth downloading. Just a lot of screen capture and then parsing the pages.

Roy Lambert
Fri, Jun 5 2009 11:17 AMPermanent Link

"Rita"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:176DA101-3871-44C1-8F37-F7D46F9B4F24@news.elevatesoft.com...
> I found this http://www.stdwizard.co.uk/index.html yesterday which looks
> as though its worth downloading. Just a lot of screen capture and then
> parsing the pages.
>

Hello Roy thats where I grabbed them from in one of the uploads
to your thread Wink
Rita

Fri, Jun 5 2009 11:26 AMPermanent Link

"Rita"
Sorry the mobiles.txt file contains it all from that site
but its not standard STD it has the
0151 portions for Liverpool exchange ok but then
0151922 for Bootle it needs work such as move
the substring 1,4 to a new field i'am going to work
on it later this weekend.
Rita

Sun, Jun 7 2009 11:18 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


I had a look at it today and the phone code one isn't much use "each outcode has multiple towns associated with it". I think you either need to extend the code to where it reflects ONE location (eg 01933 = Wellingborough 01933 62 = Raunds) or stick with just the area designation (eg 01933 = Wellingborough). Having several locations all referred to by the same code is a disaster.

Roy Lambert
Sun, Jun 7 2009 3:13 PMPermanent Link

"Rita"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:4DBF5BB8-4FC9-4D43-93B0-4871ED685CB8@news.elevatesoft.com...
> Having several locations all referred to by the same code is a disaster.
>

I have parsed a lot of it out and added prefix for example
STD     AREA   TOWN          EXCHANGE
0151    922         BOOTLE      LIVERPOOL

There is a program out there that hooks up to caller i.d.
Written in Delphi with updates for under £100 , I cant
find it now grrrrrrrrrrr I could do with it but I will wait
and see how my phonebook works out.
I f u look in the front pages of your phonebook the
exchanges are listed there.
That got me thinking with the code from the stdwizard
site. What I did I created a field for 3 and 4 and 5 and 6
STD prefixes looking down the list the 6 character STD
was the smallest so I grabbed that 1st the 3 character
was next smallest then 4 easy peasy

update myphone
set std4 = '0151'
where code like '0151%'

All that took less than an hour.
Then to sort the STD5 field
extract from the code the
substring 1 5
where std3 and std4 and st6 = null

again easy peasey now the final job
using substring and length take the
std3 to std6 prefix away from the
code that left 922 as above.

All done needs tarting up.
Rita




Sun, Jun 7 2009 4:21 PMPermanent Link

"Rita"
Try this its getting there.





Attachments: prefix.zip
Mon, Jun 8 2009 2:10 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


Yonks ago, when I added STD codes into my app I bought a little book from BT, scanned it OCR'd it and used that. It went right down into detail but back then I stripped it back to exchange area. I've been trying to find out if they have something similar now but the "new improved" BT website and phone systems seem designed to confuse rather than help.

Roy Lambert
Mon, Jun 8 2009 4:48 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


I've just ordered a new copy of the book - a massive £4

Roy Lambert
Mon, Jun 8 2009 8:39 AMPermanent Link

"Rita"

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:6D542EAE-435E-4DA4-B1FC-EF10DF0D728B@news.elevatesoft.com...
>
> I've just ordered a new copy of the book - a massive £4
>

Wow claim it on your expenses Wink
I think I did see that yonks ago booklet
it was a shity green or maybe khaki
COLOUR got that American readers
COLOUR Wink
In the current economic climate scan
it for me Wink
Rita

Page 1 of 2Next Page »
Jump to Page:  1 2
Image