SambaPOS Forum
English Boards => Requests => Topic started by: cnttech on April 11, 2012, 08:26:24 am
-
hi,
in united kingdom there is lots of takeaway shop , they all need sambapos but they need to find costumer address without asking to customer is there any change sambapos can find the uk adrees from postcode database?
with out internet connection ?
best regards
-
Hi,
Postcode is copyrighted by the post office and the database is licensed but I am not sure of the cost (I am now!).
See here http://postcodedb.sourceforge.net/ (http://postcodedb.sourceforge.net/)
A copy of the post office database was leaked on the internet a while ago.
Edgar
PS and here http://www.freethepostcode.org/ (http://www.freethepostcode.org/)
-
Hi,
thanks for info but who will integrate in SambaPos :) definitely not me :)
but I can supply post codes somehow,
Regards
-
So you want to find someone's address by their phone number? Is that right?
-
if it possible to do that of course , that will be great
Regards
-
As I learned from Wikipedia:
Full PostCode database contains 27.5 million delivery points.
It is copyrighted
4,000 postcodes added each month and 2,000 existing postcodes terminated.
Can be licensed with updates by paying between £3,750 and £75,000. (thanks Edgar)
The correct question should be:
"How can we republish a copyrighted database for free with an open source application?"
-
Hmmmm , good point,
can you use something like this http://www.microsoft.com/mappoint/en-us/home.aspx# (http://www.microsoft.com/mappoint/en-us/home.aspx#)]
just the idea :)
regards
-
What about
http://www.geonames.org/ (http://www.geonames.org/)
-
I think I have missed the point ???
-
me too
-
me three :D
Normally, for new customer, you ask the phone number and address.
Then if s/he order again, you will know the address by the phone number.
Even if you already have the address in the database, I would strongly suggest to confirm again the address because there is still a small chance that the customer moved.
Now, let's say you can integrate the post office database into samba pos!
I would say, most of the time the phone number would be the land line and not cellular phone number that's why the number would be 90% correct (10% would be if the customer change a new number if they moved, for this case those who live in apartment)
Thus, most probably you won't have their cellular number. And how many people using cellular phone now?
Even let's say, the post office get their cellular number. How accurate is their location when they make the order?
They can order for the office, or their friend (if they were watching let's say soccer together at friend's house), or if they stay in hotel?
Thus, their address can change!
So, assuming their address never change would be a mistake!
It would be wise to double check their address again!
Just my two cents!
Regards,
Leon.
-
@oda: Exactly
With the delivery and takeout system I'm used to, you have the option of importing 'Melissa Data'. It's not LIVE like the systems suggested previously. The customer makes a one time purchase that has all the current information, at that time, but it's up to them to keep it up to date by purchasing new maps every year. The maps can be purchased by zipcode or radius so the system can readily tell you if a customer's address is within a certain delivery area. Which is handy for giving quick responses concerning availability. It's always disappointing to sit on hold for 5 minutes only to be told your not in the coverage area. It also provides address verification and maps for delivery drivers. It doesn't however have any phone number associations due to the reasons previously mentioned by oda. Honestly while I think the feature is really cool. In the 200+ installs I've done, MANY of them pizza, I've only used that feature 2x. Eventually it will be an 'in demand' feature so I'd be looking towards it but for right now I'm not seeing a huge need.
-
@EricAllen
If we all just want to know the location.
The simple way is to use google maps I think.
Now, it would be good if samba pos can hook it up with google maps for the delivery order.
Maybe like:
1. Answer the phone and ask the phone number
2. Enter the customer address if it is the first time order, if not next step
3. There will be a pop up or maybe something similar to the table with google calendar thing, where we can see the location. (would be best if in can input automatically like the direction to go there from the restaurant. thus we will know the distance and time, also we will now if it is in our area of delivery)
4. Take the order if it is in our area.
5. Ticket Print along with the direction to go there.
Now that would be something, but then again. For repeat customer, our driver should know the address already :P
Thus, this would mean a waste of paper. Unless, we can make the option to print the direction or not.
Just my two cents!
Regards,
Leon.
-
@oda Yes! That would be the most internationally friendly way to go about it. I think Melissa Data only covers the U.S. and Canada. There's address verification for a lot of other countries but I don't think most people need just that. The only reason I like Melissa Data right now is because once you buy the map, which is only about $100, it's yours. You don't have to worry about license renewals or anything like that.
Google Maps API Licensing
https://developers.google.com/maps/licensing
-
yes you all right but we were talking about: where can we get postcode databese united kingdom/?
SambaPos needs to use a caller id and postcode database, thats all
whoever calling hone no pop up on screen and you will ask what is the post code (if its new cusumer) if its existing customer his or her address will pop up automatically.
-
Sorry didn't mean to hijack your post. I just thought the question had already been answered so I was commenting on what I knew of similar features...
-
hi every one this is my very first post first of all thank you very much emre for a fine looking software i am slowly getting to grips with it.
i have a similar problem to the original post that i am in the uk and would like to use the suggested method of checking someones address by their post code (i think this is what the person was trying to say.yes as emre mentioned the uk post code file is very expensive but the point you guys missed is that
each restaurant does not need the whole post code of the uk as the file is about 2 gigs or more i think also i don't know a restaurant that can deliver food to the whole of the united kingdom.
how commercial software that integrates this works is you can buy only the post code that relates to you area or the area you want to deliver at most this will be between 3 to 5 post codes that way the file is very small at most about 10 mb also cost effective as you pay about 100 pounds for the first code then 5 pounds for each after that and there are many companies that sell this on the web.
now my question is i have such post code file in my possession for the area my restaurant delivers to how would we integrate this to sambapos as programming goes i am a completely incompetent also i would like to add i am turkish living in the uk if any one need help with translation of the site i would like to help again thanks for every ones anticipated help.