Käynnissä

Upload Member Excel Sheet

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

Taidot: ASP.NET, jQuery / Prototype, JSON, Microsoft SQL Server, MVC

Näytä lisää: excel sheet cities world, find entry excel sheet, excel sheet indian states cities, share excel workbook office 365, how to share excel file for multiple users 2016, how do i share an excel file with multiple users?, dynamics crm import marketing list members, how to share an excel file online, office 365 excel collaborative editing, how to share excel sheet for multiple users, how to share workbook in excel 2016, excel sheet marketing research survey data entry, data excel sheet macro, league soccer system excel sheet, upload txt excel format, populating excel sheet pdf survey, convert pdf data excel sheet, import excel sheet sql data base, view excel sheet form example net, creating standalone excel sheet

Tietoa työnantajasta:
( 0 arvostelua ) punne, India

Projektin tunnus: #17774052

Myönnetty käyttäjälle:

vishalten

Have 6+ years of .Net Framework experience in Analysis, Designing, Development, Debugging and Maintenance of 3-tier Enterprise ASP.Net Developer,MVC Developer Has the ability to understand and transform complex bu Lisää

₹7777 INR 3 päivässä
(0 Arvostelua)
0.0

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

dotnetproject82

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 Lisää

₹12222 INR 3 päivässä
(4 arvostelua)
1.9
demossoft

I have reviewed your bid request and I am very interested in your project. I was trained overseas and have an extensive customer service record so contact me so we can discuss further or begin. Relevant Skills and Exp Lisää

₹14444 INR 10 päivässä
(0 arvostelua)
0.0
misraanu

Respected Sir/Madam, I am experienced ASP.NET developer with 8+ years of experience. I will like to pick up this job and deliver high quality and clean code in optimum time. Looking for positive response from your e Lisää

₹12222 INR 10 päivässä
(0 arvostelua)
0.0
AMARRKO

HI, I can work in your project in budget and will deliver my best work. - 5 years of Extensive experience in Development and Maintenance of Web, Windows, N-Tier Object Oriented applications. - Extensive programming Lisää

₹3000 INR 1 päivässä
(0 arvostelua)
0.0
₹11111 INR 5 päivässä
(0 arvostelua)
0.0