In Progress

Database load from Excel file

Background

The DB load is for an Online Exam Simulator. The maintenance of the questions will be done in a Excel spreadsheet as the author of the questions may work from areas that do not have internet connection. Excel Spreadsheet could be saved in another format text, xml etc whatever is available from the "Save As" function in Excel. You let us know what the preferred format would be.

Requirements

A script to load in data from a data file into a MySQL database.

It should be possible to initiate the load script from a web form selecting what file to load into the database.

User to select from a dropdown what code the questions in the spreadsheet should be loaded under.

The script should dump the data for the specified code from the database before loading the data from the file.

Details about the database structure and file structure will be forwarded to the winning bid.

Skills: PHP, XML

See more: questions data structure, loading function php, excel xml online, data structure questions, excel database load, load excel background, mysql loading file database, excel script load database, database loading excel file, load excel file background, excel load database, load excel file, load excel database, load excel spreadsheet, online mysql database, n excel, format xml online, xml excel, us exam, save excel, php exam, online excel, load php, format excel, excel us

About the Employer:
( 10 reviews ) Dartmouth, Canada

Project ID: #217045