Hi a client of mine has asked if I can display their current stock levels on a website. Here's the current situation...
They have about 5500 products, of which about 2000 are live at any one time. The database for products (name, description, price stock amount etc) is held in their offices. This is running on a Unix server, written in Cobol. (I think it's called 'Minster' ?). They want it to remain here for various reasons.
The want a way for buyers to check current stock levels online using a web browser. This is to be password protected so to view you have to request a password. (buyers are companies, not the general public). The suggestion has been made that make a program be created on the server to export out the current database and upload to a webserver. Another alternative is to have the website somehow connect directly to the office server (securely). Either way, they are happy to go with the online database being 'pretty much' up-to-date if 'totally live' isn't possible. Any suggestions/reccomendations appreciated.
Hits wise, they are expecting this to be only 10ish per day; no not heavy usage.
The project will require knowledge of the office/Unix end as well as creating an online database viewer (with the ability to search by category etc). Also, may require the setup of the webserver (though not the actual monthly cost for this!!)
A further extension to this project may be the dynamic creation of a PDF catalogue - pulling the data (minus stock levels), and creating a grid 5 x 5 per page of item, description, price and order code. (plus a front and back cover).
If this all seems interesting and doable, please email me.
Thanks for reading,