进行中

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

技能: ASP.NET, jQuery / Prototype, JSON, 微软 SQL 服务器, MVC

查看更多: 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

关于此雇主:
( 0个评论 ) punne, India

项目ID: #17774052

授予:

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 更多

₹7777 INR 在3天内
(0条评论)
0.0

6 威客就此工作平均出价 ₹10129

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 更多

₹12222 INR 在3天内
(4条评论)
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 更多

₹14444 INR 在10天内
(0条评论)
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 更多

₹12222 INR 在10天内
(0条评论)
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 更多

₹3000INR 在1天里
(0条评论)
0.0
₹11111 INR 在5天内
(0条评论)
0.0