php project worth 50usd
Posted: Sun Nov 09, 2008 8:49 am
I need your help concerning a project of mine.
This is the scenerio.
There is a website where I normally download pricelist in excel format.
I normally save the excel pricelist as a .csv and use a php script to write the .csv file into mysql databse.
My website automatically gets refreshed by the new info from the newly converted .csv into mysql
Now all this is somehow time consuming.
My Question:
1) Is it possible to have a php script automatically download this excel file. - the excel file has a constant name.
2) Save the downloaded excel file as a .csv
3) Have my already php script run the script for the insertion of the .csv into mysql
4) Finally, I want the pricelist to reflect on other websites once i give them access. - How would this be possible?
What variable will they put on thier website to have the information displayed there?
All this to be done automatically without any single manual work.
All this to be done at 3.00PM every day except saturdays and sundays.
This is the scenerio.
There is a website where I normally download pricelist in excel format.
I normally save the excel pricelist as a .csv and use a php script to write the .csv file into mysql databse.
My website automatically gets refreshed by the new info from the newly converted .csv into mysql
Now all this is somehow time consuming.
My Question:
1) Is it possible to have a php script automatically download this excel file. - the excel file has a constant name.
2) Save the downloaded excel file as a .csv
3) Have my already php script run the script for the insertion of the .csv into mysql
4) Finally, I want the pricelist to reflect on other websites once i give them access. - How would this be possible?
What variable will they put on thier website to have the information displayed there?
All this to be done automatically without any single manual work.
All this to be done at 3.00PM every day except saturdays and sundays.