I own a computer company, and Im wanting to take my suppliers Excel Spreadsheets (which have many sheets in it), and extract all the layers of categories and then the product details, and insert it into my online MySQL Database for the website, which will be running OsCommerce shopping cart system.
It is just a simple 'take each line from the spreadsheet, insert it into the correct table (and correct category reference) in the database (or update the price if it exists).
Now, there are several layers of categories, and the only way that I know that we can distinguish the layers is by me going through and manually editing the spreadsheet and adding a column called "Category level", or something like that, and placing the category level number in it. This is fine for me to do each time I want to update the prices (unless you can thinking of a better way).
I know ASP quite well myself, but this is a hastle and I dont have the time to do it (however I still may end up doing it myself if Im not happy with the price).
I can supply the database scripts and excel spreadsheets.
It will only be working with 1 supplier at the moment.
I would prefer it to be written in ASP because that is easy for me to edit later if I need to.
It doesnt need to be secure as I will sort all the security out myself.
The code must be FULLY working and FULLY tested before being paid, as this is a project where it is either FULLY working, or not working at all.
NOTE: PLEASE download and have a look at the zip file attached to this. It contains more specific details about how it will all work, as well as a copy of the Excel Spreadsheet, and the scripts to create the MySQL Database.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Spreadsheet is Microsoft Excel
Database is MySQL
Written in ASP
Run in Internet Explorer 6
Windows XP