Database / Mapping / Strong References Required / Specific to description

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 3

Project Description

Sno Module Title Description

1 CSV export(Distrubution master)

Read CSV file 1. Upload form the file

2. Validations for the form

3. Check for CSV file(which will not allow all other files apart from CSV)

4. Read the file and get the contents of all fields along with header

Mapping 1. Get the database field names

2. Get the CSV header names

3. Screen to map the database fields and CSV haders

4. Null validation for mapping(which will not miss the match fileds)

5. If CSV headers and database fields are same then no need to ask for mapping

Save the format After mapping save the template with headers and the file with headers will be downloaded as csv file

Insert the data 1. After mapping generate sql query

2. check for the options in the upload form

3. If empty, delete all the records in the table and insert new records in the tabel

4. If append, insert the records read from CSV by adding new rows after the existing data

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online