Suoritettu

C# Web app to take a CSV from file system or uploaded through App and add to SQL database

I am looking for a developer to assist in refactoring an existing application that is based in Powershell. The application is large and complicated but I would like to start with one part of the application and if the output is acceptable there will be several other development opportunities to complete.

The first phase of this project will be a simple application that takes a CSV file, performs some minor data data validation and data changes and then saves the output to a Microsoft SQL application. The CSV file will be sent to the application in 2 ways:

A user can upload the file using the web interface

The application will also need to monitor a folder on the system where a separate process will upload them. Alternatively an API could also be used to upload files instead of a file monitor.

The web application can be quite simple at this stage and will need to perform the functionality above and also perform a simple list query over the data in the database. Simple user authentication will be required with database details of users stored in the database and will eventually require a role-based access system in a future version of the app. For now someone needs to be able to log in, upload a file and see the details of other files that have been uploaded.

Each CSV file contains 2 lines consisting of a header and 1 record to import. The CSV file also has 178 columns and the database will have a similar number of columns required. The CSV files are generated by a third-party medical application and this cannot be modified.

The UI should be constructed in a modern front end, prefer Razor. The code should be to a high standard and include comments and be designed for extensibility. The CSV data should be stored in one object type (AXT_record) and will then be converted to a second object type for uploading to the database (ILO_record). Future projects will need to compare multiple database records and produce a new object type that will be inherited from the ILO_record.

Details of the schema and minor data validation and changes required to convert between object types will be provided to the successful freelancer. Ready to start straight away and the future projects will continue as soon as the first stage is delivered.

Taidot: C# -ohjelmointi, .NET, Microsoft SQL Server, SQL, tietojärjestelmäarkkitehtuuri

Näytä lisää: how to insert data in csv file using c#, how to import csv data into sql server table using c#, read data from csv file and store it in database c#, bulk insert in sql server from csv file using c#, upload and read csv file in asp.net core, c# upload csv file, how to update sql table with csv file using c# window application, upload and read csv file in asp.net c#, import large csv file into sql server c#, import data from csv to sql server using query, vb net upload csv file to sql server, import data from csv to sql server using c# in asp. net, complete csv file feed web developers webmasters, add format csv file, web site csv file, windows file creation app, add sql database joomla, desktop app save file web, sample app sdf file net app, create web page csv file

Tietoa työnantajasta:
( 1 arvostelu ) Brisbane, Australia

Projektin tunnus: #26800670

Myönnetty käyttäjälle:

ranjith83

Hello, After reviewing your project details which shows that existing application power-shell needs to be convert in to web application below are the set of tasks which is involved 1. CSV upload with validation from Lisää

$60 AUD 3 päivässä
(1 arvostelu)
1.6

36 freelanceria on tarjonnut keskimäärin 184$ tähän työhön

XeeChaun

hi. I have 7+ years of experience in C# and ASP. I have built similar portals for converting files, parsing data and save to DB. here is one of my recent project: ---( https://www.freelancer.com/projects/pdf/PDF-Page-S Lisää

$450 AUD 8 päivässä
(129 arvostelua)
7.3
schoudhary1553

Hello, I can help you to make c# web app. I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For Lisää

$250 AUD 6 päivässä
(87 arvostelua)
6.9
(18 arvostelua)
5.9
winittechnosoft

Hello, Dear Sir/Mam, I have read the complete project description for refactoring your existing components of your existing application which is based on power-shell which need to convert in to Web app, C# code in com Lisää

$200 AUD 2 päivässä
(23 arvostelua)
5.5
deepthi2889

Hi, I am a Full stack developer in Microsoft technologies.  My current job profile deals with projects that matches with most of the requirements of your post. Do give me a try before you make up your mind to offer th Lisää

$250 AUD 3 päivässä
(23 arvostelua)
5.4
nemanjadj20

Hello? I have worked on ASP.NET MVC/.NET Core(VB/C#) projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # Lisää

$155 AUD 3 päivässä
(22 arvostelua)
5.3
Darwish001

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am software developer with enough experiences on C#/.NET for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the pro Lisää

$150 AUD 7 päivässä
(11 arvostelua)
5.7
anandan1995

I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).

$167 AUD 5 päivässä
(34 arvostelua)
4.6
zmgroup

Hi, This is Zahid, I have 8+ years of extensive hands-on experience in Object Oriented Analysis & Design (OOAD) and Database Design and Implementation using Agile, UML, .NET Framework, C#, , , MVC, T-SQL and SQL Server Lisää

$140 AUD 7 päivässä
(32 arvostelua)
4.7
freelancepraful

I can create application as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the det Lisää

$140 AUD 7 päivässä
(1 arvostelu)
4.2
ihorkokhi8

Hello I have read your requirement very carefully so I am really interesting and confidence I have rich expereinecws with C#, .net, API, Asp.net, csv data uploading and processing, MS SQL, MySQL I have finished lots of Lisää

$150 AUD 3 päivässä
(2 arvostelua)
4.0
cmusman

Hi, I have seen your advertisement and gone through the requirements to upload CSV file and populate data in SQL Server. I can develop website for that purposes that will take the CSV file as an input and securely lo Lisää

$200 AUD 7 päivässä
(5 arvostelua)
3.8
subhra04

I have done similar project in past. I will be able to complete the project in 3 days , please connect to discuss further.

$200 AUD 3 päivässä
(1 arvostelu)
2.8
purushothamanb23

Hi I have experience all bulk upload using c# web application I can able to develop your application. regards B. Purushothaman

$222 AUD 2 päivässä
(3 arvostelua)
3.0
deepakkmrr

i can make a demo aplication with a sample csv file provided by you to show working. if you find it suitable we can go ahead.

$222 AUD 7 päivässä
(2 arvostelua)
1.9
Emiraza

hey how are you need asp.net mvc or [login to view URL] core developer em here for your assistant please ping me to discuss more on this and for front end #React js #angular js #angular

$140 AUD 7 päivässä
(1 arvostelu)
1.4
cyberhubert2

Hello I'm a passionate software developer/architect with more than 20 years of experience. I was involved in multiple projects in a broad range of businesses - metallurgy, printing, insurance, retail, marketing, digita Lisää

$200 AUD 7 päivässä
(0 arvostelua)
0.0
kthiruprakash18

A .Net Full stack professional with 8+ years of experience in the area of Software Developing & Programming.  Adaption in end-to-end development of software products from requirement analysis to system study, designin Lisää

$140 AUD 7 päivässä
(0 arvostelua)
0.0
zeynelabidin

I have 15 years experience and I have programming backgroound with C# and I have write a lot of powershell scripts as a system administrator.

$150 AUD 7 päivässä
(0 arvostelua)
0.0
nsivabose1987

Dear Sir/Madam, I must tell you that is a very clear requirements. I have 11 years of experience with web developement using C# and I am sure I can help you with this. please let me know your thoughts. Thanks

$111 AUD 2 päivässä
(0 arvostelua)
0.0