Help with Import, Then need a SOAP Connector built for Medicare API, Then Redir

This will be a fixed contract. Very simple.

First task.

I have my MySQL dump of our directories data thats reformatted for import. All the required columns are formatted and ready to import. The only issue I have is I’m having trouble escaping the post_content table’s HTML. It keeps exporting about 90% correct, but a few columns are not correctly escaping. Because of this, it messes the import up. There are around 35,000 listing. All the addresses are correctly formatted and each row has the proper geo LAT/LONG. I just need someone to take the DB and export it to a CSV, then get it properly imported into website. There are 4 custom fields, which are already created in the website as MultiLists and have matching data in the DB with the correct column names. You may have to check the data for improper characters such as ” or /. I removed most but now a few fields may not match.

Second Task.
MEDICARE API – Medicare Connect is a collection of SOAP API endpoints providing various data about US Nursing homes. I have 6 endpoints, that need to be connected to our listings.

The process is as followes. Take the address, use that to make a match to the Medicare endpoint and if a match is found, print results in new tab called medicare API. An example would be star rating. There are various star ratings held about US Nursing homes. The address would be queried and if a match is found you would display a Medicare Quality Tab with the relevent star rating. You would have to build the frontend HTML to display the results as well as the connector.

Here are the endpoints for more information
Deficiencies – https://data.medicare.gov/Nursing-Home-Compare/Deficiencies/r5ix-sfxw
Quality Measures – https://data.medicare.gov/Nursing-Home-Compare/Quality-Measures/djen-97ju
Star Ratings – https://data.medicare.gov/Nursing-Home-Compare/Star-Ratings/ax9d-vq6k
Staffing – https://data.medicare.gov/Nursing-Home-Compare/Staffing/aizv-8ir6
Quality Measures – Short Stay – https://data.medicare.gov/Nursing-Home-Compare/Quality-Measures-Short-Stay/u8my-ac5x
Quality Measures – Long Stay – https://data.medicare.gov/Nursing-Home-Compare/Quality-Measures-Long-Stay/iqd3-nsf3

Third Task.
Redirection Engine- Each listing contains the old listing id from our old website to match up the data if needed. Inside, the old website, you would have to create a script that inserts a PHP 301 redirect at the top of every listing to the new listings location in geodirectory

Please skype me at anthony.accetturo1 Be prepared to show past work!