News0 min ago
mysql Database auto update
I have a Mysql Data base for my website. I am wanting to create an automatice data feed from other websites on to mine. but I don't know where to start. It is a property portal sp I need it to update other estate agents properties to it.
Answers
Best Answer
No best answer has yet been selected by Hustle. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.One way is to generate an XML export file from the other databases. This file contains all the data and field names in a text format. MS Access will generate XML output very easily but theoretically a report can be written to generate XML from any database.
This data is then run through an XSL filter which generates a file of SQL queries containing the data that will add the information to your database.
This data is then run through an XSL filter which generates a file of SQL queries containing the data that will add the information to your database.
With the XML the other sites will have to export and you will have to run the importing routines.
With the ODBC you will have to run the queries in your database.
It is hard to work out what you need without knowing a lot more about what is available from the other sites. You will need their cooperation to set up a system.
With the ODBC you will have to run the queries in your database.
It is hard to work out what you need without knowing a lot more about what is available from the other sites. You will need their cooperation to set up a system.