I have a real estate database driven website which does not appear to be working properly.
The script imports .ZIP files from a flat text database daily on a Cron, then these files are ported to a SQL database which then displays the data within my real estate website.
One programmer setup a script to download the data and unzip it every day. It works perfectly.
Another programmer successfully imported the flat text data (from the first script) and setup all the fields in the database etc... BUT for some unknown reason he failed to tell me how to make it import or make it so it does it automatically.
Today a lawsuit was filed against me by the client because the site was not self updating and the data was old (not updating). The data is updating everyday but not making it's way into the sql database to display on the website. I deleted the database data except for the data fields so now the website shows no homes in the search.
I ran the script which downloads the script data from the MLS and it worked perfectly, it downloads the data, unzips it unto the database directories. The SQL database is beign read by the website but the flat text data is not being ported into the sql database. It might be there is no script to port it and one needs to be made or maybe it's there and not linked up. I could not find it.
90% of the work was done but this last bit really needs to be completed. I need a programmer who can do it fast.
You should have a complete understanding of server scripting in perl and PHP as well as an understanding of cron, wget and other basic unix commands. You should have a complete understanding of mysql and PHP.
Your job is to examine the processes, identify the current work and fill in missing data or repair it.