Terminé

VB.Net Application - Move CSV to SQL Server

NOTE: This will take a little more automation than simply moving columns into a table.

Attached are a couple of good example files with definitive 'markers' that will require processing differently.

Main Requirements:

* VB.Net Forms Application

* Push to a pre-created SQL Server DataTable (that you define based upon the columns)

* Ability to process all CSV Files in a folder (easy - recursive)

Datatables needed:

1. Node Database with Unique Identifier and all information in the first 2 rows (see example spreadsheet)

2. Tags Database will use the Unique Identifier for the node to determine which CSV file the 'tags' came from.

CSV Specific Requirements:

* Node Database

a. Uses the first row information (example: NodeName : MORSELS). MORSELS would be stored in the NodeName field of a row with a unique Node Identifier.

b. Uses the second row information to determine the AMOUNT of each type of tag. (Example: AI3605, AO2, DI3889, DO2, DR8, TX145). AI would be the type, 3605 would be the number of tags. AO would be the type, 2 the number of tags. DI type type, 3889 the number of tags, and so on.

c. The Node Database should look similar to this:

Node_UID, NodeName, AI Tags, AO Tags, DI Tags, DO Tags, DR Tags, TX Tags, {xxxx} Tags, AI Tags Imported, AO Tags Imported, DI Tags Imported, DO Tags Imported, DR Tags Imported, TX Tags Imported, {xxxx} Tags Imported

*** Where {xxxx} is defined by whatever tags are in the CSV Files (above is not a complete list, there should be the ability to add fields during import.

* Tags Database

a. Each TYPE of tag is defined by a row that beings with [BLOCK TYPE. It is important to note that the column headers are different for each TYPE. There should be enough columns in the datatable to cover each column (otherwise they will need to be created).

b. The end of the CSV File is delineated by '[----------------------End of Block List---------------]'

* Final Processing

a. When the file is processed, there should be a 'count' for each TYPE of tag that can be pushed into the Node Database import fields.

FINALLY: If you have not read all of this, looked at the files, and understand the simple tasks - you will NOT be selected. Please put: *!CSVMerge!* in your bid response if you want to be considered. This is not a significant development effort project and should be completed quickly.

Should read:

DataTables Needed:
1. Node Datatable....
2. Tags Datatable...

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

en voir plus : vb net sql bulk insert from csv, vb.net import csv file into sql server, vb net import text file to sql database, csvdatareader, vb.net read csv file, vb net sql query to csv, vb.net export to csv, import data from csv to sql server using c# in asp net, dts csv sql server 2005, move field sql server, net client code connect sql server database, vbs script import csv sql server, import csv sql server 2005, dts import csv sql server 2000, import csv sql server express, import csv sql server express 2005, visual basic csv sql server, insert csv sql server bulk, script csv sql server, import csv sql server express 2005 table

Concernant l'employeur :
( 49 commentaires ) Green Bay, United States

Nº du projet : #17520326

Décerné à:

Ahmed818

*!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!*

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(25 Commentaires)
4.7

25 freelance font une offre moyenne de $150 pour ce travail

sumon355

*!CSVMerge!* Hello, As an experienced VB.Net developer and having sound knowledge in ms sql server, i am very much interested to do this project. Looking forward to have a positive response from you. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(251 Commentaires)
7.5
customizedata

*!CSVMerge!* I have gone through the attached files as well as the given requirements. Here are my understandings 1-Browse a folder having CSV files. 2-Loop through each CSV file and do processing. 3- Node Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(176 Commentaires)
6.9
solucionesnet

*!CSVMerge!* Hi, maybe we can use only only 2 tables by database, main table for Node Database with rows for each node using something like this: select data,value from table_main NodeName MORSELS AI Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(29 Commentaires)
5.4
Gangsong

Hi I will do it perfectly in a short time. I have rich experience in SQL db and csv processing. Hope to work for your project. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
4.8
jayamsoft

*!CSVMerge!* Hi, We are the team of IT professionals, with experience of 7+ years in Web technologies/Mobile Application development, software development. We have successfully worked with Asp.Net MVC, Laravel, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
4.8
dungforever

*!CSVMerge!* Greetings! Thanks for your kind job suggestion. I am an experienced and skillful VB.NET developer, who have over 5-years experiences. I have read your project description very carefully, so tha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
4.4
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
4.3
bienatwork

Hello I would be pleasure to help you to do the job. I have worked for 12 years in software development using .net technologies such as VisualBasic, VB.NET, C#, Winform, ASP.NET (Webform, MVC), .NET Core, JQuery, Knock Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
3.7
JohnTang

*!CSVMerge!* Sir, All csv files are put on the same folder and we need to process one by one? And csv files also having the same format? The sql server is already existing from your side, and it's need to connec Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
3.3
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
2.4
sm2mafaz

Hello There, *!CSVMerge!* I am a Software Developer with more than 10 years of experience in .NET and SQL Server related projects. I have couple of questions regarding the requirements: 1) You have mentioned t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(2 Commentaires)
1.9
lightingdavid

Hello. I have rich experiences in VB, C#, .NET, SQL, Excel, etc. I have read your project description carefully and i can do it. Contact me please. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
0.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.8
vtechsolutionsof

Well Experience and Expert .NET, C# Programming, ASP.NET, SQL, Web Developer. Microsoft Certified Solution Developer. Please ping me detail and work for you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
1.4
pablogvivo

*!CSVMerge!*

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
crocodile305

Hi.. How are you? I saw your description carefully your project. Owing to my rich experience in CSV , SQL serve , VB.net , i can say i can do this perfectly. I have many top skills like .NET, Microsoft SQL Server Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(0 Commentaires)
0.0
yulin777

*!CSVMerge!* Hello I have understood your request almost. I have a lot of experience with VB.NET over 7 years. I have developed many applications and websites using VB.NET. I have also developed a tool to upload Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
wbeckles

*!CSVMerge!* I have more than a decade of experience with Visual Basic and will be able to complete the project. It was quite a bit of reading and there were some points that I would need clarified. Here are my notes Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0