laurent
12-22-2005, 12:56 PM
Hello All,
First of all, I would like to say I am delighted to be a member of Webdeveloper.com. With that being said, I will now dump my problems on you guys. :)
We have a static website here where I am employed and the owner has no interest in going to a dynamic site with DB connectivity. The huge problem this causes is--price changes.
In a dynamic set-up, all you need to do is change the prices in the database (DB) and the price is changed throughout the website for each item. Because we do not have a database-driven website, we have to change the prices manually for each item. And if the item appears on multiple webpages, that item's price has to be changed in those web pages as well. As you can see, this can be a cumbersome task and erroneous one as well.
I am trying to figure out the best approach to take to change prices without the implementation of a database. (urgghhhh!) ARE THERE ANY OPTIONS THAT YOU GUYS KNOW OF THAT CAN BE EMPLOYED TO CHANGE THE PRICES THROUGHOUT THE WEBSITE?
I came up with two possible options:
1) Since the new prices are given in an Excel spreadsheet, I thought there must be some way that I can take the spreadsheet and read that into maybe a database, like Access, where the item's price would be updated to the new one. Once this is done, a scripting language, such as MicroSoft ASP (and I'm not sure this can even be done) can read the new price into the static HTML page. (and can this be automated where I do not have to touch every web page that the product or item is on.)
the other option is:
2) Somehow using the Excel file and ASP in some way. Maybe code script into the "static" HTML pages (whew! there are so many) where a varible would be designated for the items on the web pages and it would look for the specific varible in the spreadsheet and make the changes, if any at all. I am not sure though that this can even be implemented between the two software programs. I am lead to think that since they both are Microsoft products, this would be possible.
In conclusion, I would like to know if there are any OTHER possibilities or ways to do this and are the two that I have concocted even possible? Please share.
Thanks,
Bewildered
First of all, I would like to say I am delighted to be a member of Webdeveloper.com. With that being said, I will now dump my problems on you guys. :)
We have a static website here where I am employed and the owner has no interest in going to a dynamic site with DB connectivity. The huge problem this causes is--price changes.
In a dynamic set-up, all you need to do is change the prices in the database (DB) and the price is changed throughout the website for each item. Because we do not have a database-driven website, we have to change the prices manually for each item. And if the item appears on multiple webpages, that item's price has to be changed in those web pages as well. As you can see, this can be a cumbersome task and erroneous one as well.
I am trying to figure out the best approach to take to change prices without the implementation of a database. (urgghhhh!) ARE THERE ANY OPTIONS THAT YOU GUYS KNOW OF THAT CAN BE EMPLOYED TO CHANGE THE PRICES THROUGHOUT THE WEBSITE?
I came up with two possible options:
1) Since the new prices are given in an Excel spreadsheet, I thought there must be some way that I can take the spreadsheet and read that into maybe a database, like Access, where the item's price would be updated to the new one. Once this is done, a scripting language, such as MicroSoft ASP (and I'm not sure this can even be done) can read the new price into the static HTML page. (and can this be automated where I do not have to touch every web page that the product or item is on.)
the other option is:
2) Somehow using the Excel file and ASP in some way. Maybe code script into the "static" HTML pages (whew! there are so many) where a varible would be designated for the items on the web pages and it would look for the specific varible in the spreadsheet and make the changes, if any at all. I am not sure though that this can even be implemented between the two software programs. I am lead to think that since they both are Microsoft products, this would be possible.
In conclusion, I would like to know if there are any OTHER possibilities or ways to do this and are the two that I have concocted even possible? Please share.
Thanks,
Bewildered