Automate XML Insert into SQL
Posted: Mon Jun 01, 2009 3:13 am
Hello All,
Im struggling with were to start with a problem Im having...
Iv written a Job Board and I have a company that wants to publish lots of Jobs onto my board. Which is great... They have setup an XML feed, that I can pick up daily and then I simply convert into a CSV file using MS Access and upload into my database. Then I have some other SQL code that updates the correct Job Details so It becomes live on my board... This all works great, but I really need to automate the process. So it can pick up the xml file from a specific URL. Then to the upload into the SQL database and pass the data into the correct table...
Is there an easy way to do this? Im assuming i would need to run a Cron Job (but i have never actually used this... In pretty new to PHP).. I have googled lots of things, but I cannot find what im looking for...
Any help would be greatly appreciated or any guidance would be excellent.
Also If I can just simply not work it out, is there a company or individual I could pay to write the script for me. I know this sounds lazy, but Id rather get it 100% correct. As its information people are paying me to put on my site and id like to get it spot on.
Many thanks,
Steve
Im struggling with were to start with a problem Im having...
Iv written a Job Board and I have a company that wants to publish lots of Jobs onto my board. Which is great... They have setup an XML feed, that I can pick up daily and then I simply convert into a CSV file using MS Access and upload into my database. Then I have some other SQL code that updates the correct Job Details so It becomes live on my board... This all works great, but I really need to automate the process. So it can pick up the xml file from a specific URL. Then to the upload into the SQL database and pass the data into the correct table...
Is there an easy way to do this? Im assuming i would need to run a Cron Job (but i have never actually used this... In pretty new to PHP).. I have googled lots of things, but I cannot find what im looking for...
Any help would be greatly appreciated or any guidance would be excellent.
Also If I can just simply not work it out, is there a company or individual I could pay to write the script for me. I know this sounds lazy, but Id rather get it 100% correct. As its information people are paying me to put on my site and id like to get it spot on.
Many thanks,
Steve