Database / Mapping / Strong References Required / Specific to description
$30-250 USD
In Progress
Posted over 10 years ago
$30-250 USD
Paid on delivery
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