436796 Upload XML or CSV to MySQL database

Completed Posted Aug 25, 2010 Paid on delivery
Completed Paid on delivery

I have a Drupal based website that has 2 seperate user groups: trainer and players. The trainer is able to create players as well as upload fitness testing results to the database via 2 separate pages (a create player page and create test result page). The problem is a lot of times the trainer will need to create 40+ players and upload all of their test results at one time taking hours of work.

What I need is

1) Trainer to be able to upload a .xml or .csv file (whichever is easier to do) to the database using a web based browse/upload form that will create multiple user accounts. The file will be created in excel and have each user on a separate row with all of their details in separate columns. See attached file playerupload.xml.

This form will need to create a password for that user and automatically send them a welcome email with their login details.

2)Another form on a separate page to again upload an .xml or .csv file that contains the fitness testing results for the players. The file will be created in excel and have each result on a separate row with each individual test detail in separate columns. See attached file .

I need this done ASAP would like to get started today. I can provide all necessary files including the database etc. Please see attached [url removed, login to view] for full details before bidding.

Thank you

Database Administration Drupal MySQL Odd Jobs XML

Project ID: #2182670

About the project

1 proposal Remote project Active Jul 11, 2012

Awarded to:

betateam

Drupal expert

$60 USD in 2 days
(10 Reviews)
3.9