Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

address lookup from postcode

Posted on 2013-11-06
6
Medium Priority
?
469 Views
Last Modified: 2013-11-30
Hi all,

I have been tasked with pulling address information into my till software from a postcode lookup.

I have been looking at the various types and offers out there and wanted to know which is best to interact from bespoke software.

I understand it will cost the company money and I want to get the best results for the least work but want to go down the more official route with house numbers and property names.

There are a few on the market but a lot seem to be either asp.net driven and price per lookup, or single computer license based in winforms, but I don't know how you then implement that into the software as it seems to be a program call rather than coding it into one of your forms.

Ideally I would like a solution that I could eventually roll out to the website when it is re-written (deadline march 2014), but right now I have a retail show I need to take my working till software in 2 weeks.... so the quicker the better, but ideally I would want to have it within my coding from form.

If I have to look at pricing per machine does anyone have an idea on pricing and what provider has the best interaction.

If we can go down a web service route calling from the application this would be probably the ideal solution if we could get this either on a per lookup or per month basis.

I have spent a few days looking into this and don't want to invest a lot of time on testing each possible solution as this will be a waste of development when I need to concentrate on passing the order data back to the office!!

Any input is appreciated, also any pointers to companies that you may have worked with personally would be good reflection for my next step.

Thank You

David
0
Comment
Question by:CEL_IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 46

Expert Comment

by:aikimark
ID: 39629069
Have you looked at the USPS offering?  They are very reliable.  Depending on the volume of look-ups you need to do and the response time, they should be among your finalists.
0
 
LVL 23

Expert Comment

by:Jens Fiederer
ID: 39629127
0
 

Author Comment

by:CEL_IT
ID: 39630502
Don't think I made the point that I am looking for UK based addresses.

I have been testing with PAF raw data and Data8 web service.

PAF seems quite good but is expensive, data8 again are good and just trying to speak it through with the boss.

He has just thrown a cat among the pigeons though.... does anywhere do postcode lookup with names of occupants??

Cheers

David
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 63

Expert Comment

by:☠ MASQ ☠
ID: 39636891
David
We use QAS Pro from Experian and have been for about 10 yrs as they have pretty good support and APIs for bespoke look-up links to their DB.
It's pretty much a PAF DB though although somehow we end up paying less for the licensing that if we had got through Royal Mail - doesn't use the public electoral roll data for resident names though.
0
 

Accepted Solution

by:
CEL_IT earned 0 total points
ID: 39674316
We ended up going with Royal Mail PAF CSV Raw Data.

The plan was to create our own lookup.

29 million records, indexed on Postcode on a local sql2012 express database, worked a treat through a stored procedure and was basically instant.

We are just us8ing on a stand alone system, but if you do want to use on a website it gets very expensive!!!

The file was obviously vary large and I initially struggled to get the data out, and had to work out how to pull the data from the file in vb.net, but got there after a couple of hours using a parser.

It took about 8 hours to import the data using my tool. I thought about importing it in sql direct, after I had already started the process... think it would have been much quicker to read in using a sproc of some kind, but I was already on my way before hand. If I want to create an ongoing annual import then I will look into it.

Cheers
0
 

Author Closing Comment

by:CEL_IT
ID: 39686563
This was a more suggestive question asking for advice on postal references.

I ended up going with the solution I had initially looked into.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Simple Linear Regression
Starting up a Project

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question