Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 10 of 18 total |
3 interesting tables 4 uk guys |
Thu, Jun 4 2009 3:40 PM | Permanent 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 Rita |
Fri, Jun 5 2009 3:23 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent 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 Rita |
Fri, Jun 5 2009 11:26 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent 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 PM | Permanent Link |
"Rita" | Try this its getting there.
Attachments: prefix.zip |
Mon, Jun 8 2009 2:10 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
I've just ordered a new copy of the book - a massive £4 Roy Lambert |
Mon, Jun 8 2009 8:39 AM | Permanent 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 I think I did see that yonks ago booklet it was a shity green or maybe khaki COLOUR got that American readers COLOUR In the current economic climate scan it for me Rita |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |