In short, the requirement is for a utility that can transfer data from an estate agents database to my website MySQL database; AND to transfer images from the estate agents image directory(s) to my FTP server.
This utility needs to run on the Internet within 4 HTML forms, which I shall call FORM A, FORM B, FORM C and FORM D, backed by appropriate PHP scripts. Note that these forms will be incorporated into my website, so you do not have to worry about login credentials or how the estate agent is identified.
The idea is that an estate agent can access ‘my website’ (from this point onwards the term ‘my website’ represents my system and its corresponding database). From my website the agent will be able to access 4 forms, which you will create as part of this project.
Form A will allow them to map the fields of the property tables from their own database (or Excel sheet) to my website’s property tables and specify certain information about the default location of image/drawing directories and field mapping information for where photo filenames may be stored.
Form B will allow them to upload the properties from their system to my website, at the press of a button.
Form C will allow them to upload photos/drawings (jpeg and pdf files) from their system (either local filesystem or Internet location, with FTP server details) to my website’s FTP server, at the press of a button. It is important to note that my system does not store cross reference information within its database to photos/images. Instead, it uses the unique property reference number it assigns to properties as a prefix to identify property images. Using alphanumeric suffixes on the property reference numbers – eg. 1,2,3 to identify a sequence of related images (with a common property reference number prefix on their filenames). This is because more than one image can be stored for a property on my system. Further details are provided below. This does mean that transferring files from the estate agents system to my system will also require renaming the physical files so that they have MY unique property reference number, plus a sequence number appended – so that my system is able to display the images on my website.
Due to the potentially large number of images that could be processed, I do not recommened using a Java applet that expects the user to drag and drop images to a ‘control’ on the applet. It is more complicated, because the images that are uploaded depend on the property data (from the estate agents database) that are uploaded, and the estate agent may not readily know the corresponding filenames on their filesystem. Instead, they should only have to deal with file directories, and if they have images stored on an FTP server, they can provide this additional information.
Form D will present an error log button, which opens a file that displays any transfer errors, with the date/time of the error and the property and/or photo that failed, with a reason.
Your focus for the entry of information by the estate agent, should be to make it as SIMPLE and PAINLESS for them as possible.
10 freelancers are bidding on average $609 for this job
We have seen all the details that you have discussed and our team is totally comfortable in doing it successfully. Let discuss all the details through PM. Regards, Lali, PHPXperts