Terminé

Import CSV to database with data validation in VB.NET and MSSQL

The project involves developing a VB.NET application to run on a windows machine as part of an inhouse backend application. The user will be able to select a CSV file with a predefined format and the application will validate the format and content before reporting if it is able to import the file.

Features Include

* Ability to select a CSV to be imported

* The code will identify rows which will be new and so will be imported

* The code will identify rows which will already exist and so will be updated

* The number fields will be validated

* As well as general validation on the field values including lookups of additional database tables for valid values.

* The application will report any validation issues on the screen and not process if there are issues.

* The application will confirm on the screen the number of records that will be updated and inserted before importing and provide an additional confirmation button.

* Once the import is complete the application will show a summary of the changes.

Compétences : .NET, Serveur SQL Microsoft, Architecture Logicielle, SQL, VB.NET

en voir plus : php import csv database mssql, vb net code import csv database, import xml data access vb net, sql server import csv into existing table, upload and read csv file in asp.net mvc, fastest way to insert data in sql server c#, c# import csv file to datatable, upload and read csv file in asp.net c#, import data from csv to sql server 2008 using query, import data from csv to sql server using c# in asp. net, bulk insert in sql server, data processing, sql, software architecture, .net, microsoft sql server, vb.net, import data tally vb net, import data fingerprint vb net, import csv file check sql vb net

Concernant l'employeur :
( 4 commentaires ) Brighton, United Kingdom

Nº du projet : #17117818

Décerné à:

rinsadsl

Hello I am specialised in vb.net and processing csv file. I can create you an application which will give you options to select the csv and distinguish between new and existing rows.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 10 jours
(584 Commentaires)
8.5

14 freelance font une offre moyenne de £487 pour ce travail

liangjongai

Hi! I'm interesting your project very well. I am a full time devloper. I am good at VB.NET and I'm a good Algorithmer. I have good experience and good skill about csv development and mssql developemnt. Let's go a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(259 Commentaires)
7.8
contact2phpsl

Your requirements are feasible including all the enlisted features so now ready to develop a VB.NET application to run on a windows machine. Please interact further with complete details and CHECK MY PROFILE REVIEWS. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(115 Commentaires)
7.3
luiswilliam

Hello, I am just an expert in .NET programming. Hello, I am just an expert in .NET programming. Hello, I am just an expert in .NET programming. Hello, I am just an expert in .NET programming. Hello, I am just an ex Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(20 Commentaires)
6.8
gangabass

I can provide you such VB.NET app that will allow user to select source CSV file, validate it, show validation report and next allow user to perform upload or cancel it. I can start today and complete it in next 48 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(299 Commentaires)
7.0
sherifamgadnabih

i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(96 Commentaires)
6.6
MaMingMing

Hello how are you ? I would like to bid your project. I am a experienced with more than 15+ years of experience. I have great track records with high quality of projects delivered in the short amount of time. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(19 Commentaires)
6.7
seefattechnologi

Hey!! I am highly interested in your project. I have 5+ Years experience in analysis and development of client/server, windows and web applications using Microsoft Visual [login to view URL] IDE using C#, ASP.NET, SQL Server Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(37 Commentaires)
6.0
ashikmahmud137

Hi, I am a professional .NET developer. I have gone through your requirements. I can do this job. If you are interested we can discuss

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(3 Commentaires)
4.7
Sivamurugan13

Hi Sir, ************************************************************************************ I have exp in importing csv in to [login to view URL] ping me i can show demo i did before. **************************************** Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(19 Commentaires)
3.9
suniljoshi151

Hello, I have 8+ years in web designing & development with good experience in following skills ... CSS, CSS3 & LESS JS ( AngularJS, Backbone JS,React JS, node.js, expresss JS, Gulf JS) JavaScript & JQuery Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(14 Commentaires)
4.8
huzefa5247

I have more than 7 years of experience in application development including windows desktop applications. I have worked on various number of applications that require export and import of data. Apart from that I have f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(0 Commentaires)
0.0