Fermé

Build a web app where users import Excel spreadsheets and populates into an SQL Server

Technologies needed:

1. SQL Server

2. C#

Business Context:

1. A software needs to be built for the Human Resources unit of a Company located in Santiago, Chile.

2. What is herein described is Phase 1 of a project that should continue over several phases, and that will be posted separately as the business progresses.

High Level description:

1. A simple web platform needs to be built.

2. 2 types of users can login into it: an Administrator and a Contributor.

3. Those users should be able to upload 4 different kind of Excel files (that have predefined templates) , in a super simple form.

4. Those files need to be written against a DataBase.

5. Validation in the DataBase needs to be implemented to warn or halt the process if the Excel contains data that breaks data integrity, data types, etc.

6. If the validation process fails, then the front end web application should notify with a message the failure.

7. 1 of the 4 files (called "Anexos") , when uploaded by the Contributor, before being loaded into the DataBase, needs to be approved by the Administrator. There

In a document that's undergoing preparation, I'll provide you with:

1. DataBase model : Tables, Columns, Primary Keys, Foreign Keys, etc.

2. What column of the Excel needs to map against what field of what Table in the DataBase.

3. Mockups for all of the web pages, that I forsee to be the following ones:

a. Login page

b. Page where users upload the Excel.

c. Popups with messages that come back from the DataBase notifying how the load process finished.

d Page where Contributor uploads "Anexos" Excel.

e. Page where Administrator approves or rejects the "Anexos" uploadad by the Contributor.

Compétences : Programmation C#, Serveur SQL Microsoft, .NET, SQL, ASP.NET

Concernant l'employeur :
( 0 commentaires ) Santiago, Chile

Nº du projet : #21769730

105 freelance font une offre moyenne de $1059 pour ce travail

ask2itsolutions

Hello, We have good experience team in asp.net, angular, .net core. We have worked on many applications, portals, SaaS products in different domains like Finance & Accounting, Payroll, CRM, HR, Real Estate, Advertisin Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(68 Commentaires)
8.1
the13thwarrior

Hello Sir,  As you are looking for asp.net mvc developer to build a web based app which allow contributor type user to upload excel file to load into the db, I am please to offer my services for same. I have more then Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(293 Commentaires)
7.9
omsoftware

Dear Sir I understand your requirement for this project where you want to import Spreadsheet into a Database and that spreadsheet should work with all the validation from the database and store the information. Sys Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(26 Commentaires)
7.5
customizedata

I have already done a similar web app where user uploads excel file, validation is being performed and after approval that is imported from excel(pre defined column mapping) to SQL table. -->Will use openXML so that i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(238 Commentaires)
7.4
kalpesh2804

Hello, I have 15+ years of experience in C#, Vb.Net, MSSQL, MySQL, SQLite, Visual FoxPro 9. I reviewed your project requirement. I will provide Asp.net solution with Entity Framework. can we discuss about your projec Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(77 Commentaires)
7.2
ITservice

Hi, I have 15+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(116 Commentaires)
7.3
kenb080

Hello, I have read your project details carefully and would like to discuss my skills and plans with you. I am an c# expert and have been developing and experimenting with it for 7 years. Great things come from passion Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(31 Commentaires)
6.3
NewFuture338

Hello, dear. I see you want to make webapp that import Excel spreadsheets and populates into an SQL Server. That's what i specialized in. I am c#, ASP.Net, MSSQL, Excel Automation expert. alternatively, you can also Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(28 Commentaires)
6.1
AzzkaNoor

Greetings of the day. Hope this proposal finds you in the best of your health. It is my humble offer to present my services to you for this Web development project. I have passed 15 certifications here (& with a 5-sta Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
5.9
fastestJohn

Hello. I have just read your project. I have best skill with ASP.NET and Entity framework to manage the database I am really interested in your project now. Because my skills are suitable for your project. I like the " Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(45 Commentaires)
6.0
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(15 Commentaires)
5.7
intemo

Hi! I offer you my skills for your task. I will create your webApp as asp.net MVC project. Login processing (register new user, confirm and activating user account by email, password reset, activating/de-activating acc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(59 Commentaires)
5.7
KESHAVINFOTECH

Hi There, Thanks for your valuable time. :-) Please check below points : 1. Technologies needed: 1. SQL Server 2. C# Business Context: 1. A software needs to be built for the Human Resources unit of a C Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(20 Commentaires)
5.6
mkmomy

Dear client, I read the requirements and I can develop solution for you. I have rich experience in HRMS. I have more than 9 years of experience in software development and web development using Microsoft technolog Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(61 Commentaires)
5.7
ITPyramid85

Hello, I am software developer with enough experiences on C# for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(8 Commentaires)
5.7
iramrao

I understand what you are looking for. I’ve read your project and understood it. Because I’ve completed the done work before so I am sure it will not be a problem for me. I am a highly professional and skilled web desi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
5.8
RentAGuru

That sounds like a nice small project - I'm interested. What about import logs? Do you need to keep track of which user uploaded which data when? This could also help with showing the users if an Anexos upload was app Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(23 Commentaires)
5.3
SecureForYou

How are you, [login to view URL] for taking your valuable time for reviewing my proposal. I have read your project description. And I am pretty sure that you are looking for a developer to work for your job - 'Build a web app w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
5.1
winittechnosoft

Hello Dear Hiring Manager, Greeting for the Day... Dear Sir/Mam, I have studied complete project description including Business Context, High level description for building Human Resource unit for your company locate Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(17 Commentaires)
5.3
jatinsprajapati

Hi, I have gone through the project description carefully and I can deliver this application in 15 days including testing. I will use angular as front end and .net core webapi with SQL server as backend. Let me know Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(21 Commentaires)
4.8