Upload Member Excel Sheet
₹1500-12500 INR
Pagado a la entrega
1 Point Save Data Flow
Bulk Member Upload
1. When we upload excel file if any error in excel then show alert message which excel column is wrong
2. If excel is improper as per format then upload in temp table
3. Create new list to disply uploaded data.
4. If wing and flat no same in other row then data is block and status is duplicate data
5. If FirstName, LastName typed in firstname block this data and data status is rejected and maintain the history of this excel sheet and this data will not save in main table.
6. If data is uploaded in main table and maintain the history for save successfully with excel file
...............................................................................................................................
Data Save in main table Flow
1. Wing column save in mstWing table . WingName is unique.
2. BHK column save in FlatType table . FlatTypeName is unique
3. FlatName column save in mstFlats table . FlatName is unique
4. SqFeet column save in mstFlats table . SqFeet is unique
5. FlatTypeID get from FlatType table and save in mstFlats column FlatType
6. WingId get from mstWingtable and save in mstFlats column WingId
7. Status column Get OccupiedId from mstOccupiedMaster and save in mstFlats column Tainentid
8. All information save in member table and Status Get OccupiedId from mstOccupiedMaster save in OccupiedId
2 Point Update Data Flow
1. From history list download the excel sheet which one uploaded in software .
2. Again we upload the excel sheet if flat no is same then update the data .
(only update flatName, SqFeet , BHK,Tainentid in mstflat table & all the information update in member table )
Otherwise flatname is not found in our mstflat table then save data same as structure
Note: If deadline is crossed then 500 Rs will be as a penalty
Nº del proyecto: #17774052
Sobre el proyecto
6 freelancers están ofertando un promedio de ₹10129 por este trabajo
Hi, I am DotNet And Angular Developer With 12 years of Experience. I have already some excel upload related utilities available with me. My technologies stack is: - Frontend [ javascript, jquery,JSON,Ajax,CSS Más