Find Jobs
Hire Freelancers

VB.Net Application - Move CSV to SQL Server

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
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.
Ταυτότητα εργασίας: 17520326

Σχετικά με την εργασία

19 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
*!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!* *!CSVMerge!*
$60 USD σε 1 ημέρα
5,0 (64 αξιολογήσεις)
5,3
5,3
19 freelancers are bidding on average $154 USD for this job
Avatar Χρήστη
*!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
$140 USD σε 2 ημέρες
4,9 (346 αξιολογήσεις)
7,8
7,8
Avatar Χρήστη
*!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 Database -->First line will have node name that will be fetched by splitting semicolon (":"). -->2nd row will have information about "type" and "tag"; First 2 characters would be tag type and next characters are number of tags 4- Tags Database -->Type of tag would be determined by " [BLOCK TYPE." Question: --All columns next to "[BLOCK TYPE" will be the headers name for data table ? --Please clarify a bit about the next line after each "[BLOCK TYPE" line (will it be the headers ?) E.g. "TAG" is a column next to "[BLOCK TYPE" and "A_TAG" is the next line value" -->Data table columns in this case should be dynamic and would be comprised of values from each "[BLOCK TYPE" value. Looking forward to have a chat with you to discuss further.
$200 USD σε 3 ημέρες
4,9 (218 αξιολογήσεις)
7,3
7,3
Avatar Χρήστη
*!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 3605 AO 2 .... the same schema for the tags table and transpose the rows to columns or create dynamically one database with nodes table and one table by tag type for each file, also need a master table like index of all databases.
$155 USD σε 5 ημέρες
4,9 (49 αξιολογήσεις)
5,8
5,8
Avatar Χρήστη
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
$155 USD σε 3 ημέρες
5,0 (7 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
*!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 connect for development from my side? Is this is the small application for you use in the future to select the csv folder and converting automatically? Or this is only the converting from the prepared csv file to an existing database? Please leave the message to me sir. I will make a good delivery.
$166 USD σε 3 ημέρες
5,0 (9 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
*!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, Joomla and Core php with mysql and MongoDB. We have an expert team for HTML5, CSS3, JavaScript and JQuery, Ajax, Bootstrap V1, V2, V3, PSD to HTML. We have an excellent experience with industrial projects. We are also developing mobile apps in Native technologies for iOS, Android and Windows platform. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Thanks & Regards, JayamSoft
$222 USD σε 3 ημέρες
5,0 (21 αξιολογήσεις)
4,8
4,8
Avatar Χρήστη
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, SQL, VB.NET and so on. If you would like to choos me , i do my best. Thanks.
$155 USD σε 3 ημέρες
5,0 (3 αξιολογήσεις)
4,2
4,2
Avatar Χρήστη
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.
$155 USD σε 3 ημέρες
4,5 (10 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
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, KnockoutJs, AngularJs/ Angular... I am confident that could help you solve this task. Regards // Bien L.
$200 USD σε 3 ημέρες
5,0 (8 αξιολογήσεις)
3,7
3,7
Avatar Χρήστη
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 the columns for the 'Tags' database can be dynamic. Does this mean when the schema need to be altered when processing a new file, to support adding additional columns? If that is the case that would end up in a lot of redundant data (nulls too), instead we could cater a table where we have a 'column' field so any new column will be inserted as a row, along with the tag information. 2) Which are the columns for the above table? the ones in the '[BLOCK TYPE' row or '!A_NAME' row? 3) For the 'Nodes' database you have told to put the total count of tags to the import fields; can't this be extracted from the 2nd row??? : (Example: AI3605, AO2, DI3889, DO2, DR8, TX145) Hope to hear from you soon? Kind Regards, Mafaz
$222 USD σε 5 ημέρες
5,0 (2 αξιολογήσεις)
1,9
1,9
Avatar Χρήστη
I am a professional in Sql Server and hope to work with you and like my work thanks i will make professional project for you
$55 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
*!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: Points that I may have gotten wrong: • Each file in the directory updates the same 2 tables, a Node table and a Tags table. • The app will create these 2 tables if not already present. • The app will modify the tables if it finds that it needs additional columns based on the file contents. • The top 2 lines make one row in the Node table. • The remaining rows go into the Tags table. • The columns that are populated in the Tags table depends on the BLOCK_TYPE, the columns that do not pertain to the current BLOCK_TYPE will be left as null. For example, the records added for AI will have values in the INITIAL SCAN column, but the records with AO will not. Other observations and questions: • SQL will not allow the / character in the column name, so it will be substituted when creating the column. • “Ability to process all CSV Files in a folder (easy - recursive)” – recursive here means they are subdirectories? • “Node Database with Unique Identifier and all information in the first 2 rows (see example spreadsheet)” – There is no spreadsheet, just two CSV files. A couple other items needed clarification, but there's a limit to the Freelancer proposal, so if I'm selected we can go over the details, but it's definitely a quick project.
$160 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have done lots of automation using vb,C# and sql database. Having around 5+ yrs of Development experience and developed over 20+ Windows app till now. *!CSVMerge!*
$222 USD σε 5 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
*!CSVMerge!*
$150 USD σε 5 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Green Bay, United States
5,0
51
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Οκτ 26, 2005

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.