Need to code some rules to eliminate duplicates

We recently paid a freelancer to take a public real estate feed (available in XML and API format):

[url removed, login to view]

The freelancer sucessfully pulled from this feed by a cronjob daily and fed it into our personal database:

[url removed, login to view]

Although it works for the most part there are a lot of errors and A LOT of DUPLICATES.

We need a responsive and fast (looking to get this done in 2 weeks time, less is always better) to fix the freelancer's code or write their own that will:

1. Eliminate duplicates

2. Fix the feed to bring in apartments and buildings from Nestio daily

There is a section of the urbansherpany manager that shows active apartments for a specific building. An apartment is active is it is listed in the Nestio feed. Once the listing is removed from the feed, or it is not there the next time the cron runs, the apartment number should no longer be "Active" but should still live in the manager and database.

Some other rules:

- Ave, Av, Avenue all meant the same

- St, Street

- E, East

- W, West

- N, North

- S, South

- Management, mgmt

- regarding apartment numbers: #2L, 2-L, 2L all the same

- nothing case sensitive (i.e. BOLD New York and Bold New York should be treated as the same)

- regarding streets, 35th and 35 should be the same

- 8th and Eighth should be the same

- phone numbers, price, showing info, incentives etc within a listing should not result in a new listing, only if the address or apartment number are new should a new listing be made.

Once again I can not stress this enough: PLEASE BE RESPONSIVE AND GET THE JOB DONE IN A TIMELY MANNER.

We need a way to prevent duplicates from entering our database while still updating the information from nestio.

The work is 80% there but looking for someone to take us home that last 20%. The last freelancer I had became unresponsive and went way over schedule. Before you bid please make sure that you are available and can get this done within two weeks time. Before I am going to award a bid, I would like to talk to the new freelancer and go over everything so there is NO miscommunication.

Beceriler: Codeigniter, Veri İşleme, MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: work home job listing, work from home west, work from home rules, work from home new york, west work from home, to code, the last freelancer, talk to a freelancer, south l, new york freelancer, need a part time job from home, it freelancer new york, information architecture freelancer, i need a personal manager, i need a part time job from home, i need a manager's job, i need a job that i can work from home, get paid to write code, get paid to code, get listed as a freelancer, freelancer works from home, freelancer works for home, freelancer us phone number, freelancer software price, freelancer phone numbers

İşveren Hakkında:
( 3 değerlendirme ) Forest Hills, United States

Proje NO: #6496933



Hi, I can fix it, but doesn't seem to take 2 weeks to fix it unless the code is a mess, can you please show me the script? I have +4 years experience as web developer. If you have any question just let me know. Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(70 Değerlendirme)

3 freelancers are bidding on average $297 for this job


I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(636 Değerlendirme)

Hello, Myself Shirso from RSS Technologies,India. We always want this type of challenging task. I have gone through your project details. And we can surely deliver within 7-10 days. Please ping back and start Daha Fazla

in %bids___i_period_sub_35% gün içinde210%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

I'm currently working on an client application very similar to what you describe on this project. I have extensive knowledge with MLS, IDX feeds as well in web development. My strength are in PHP, Javascript , and thei Daha Fazla

in %bids___i_period_sub_35% gün içinde526%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)