Database / Mapping / Strong References Required / Specific to 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