Find Jobs
Hire Freelancers

Write text file parse / bulk import / insert routine in C#

$30-250 USD

Complété
Publié il y a environ 14 ans

$30-250 USD

Payé lors de la livraison
This is a simple project, read a text file import to sql. This is the sql code to copy the functionality of: BULK INSERT BLIS2.dbo.Loans_Periodic FROM '........txt' WITH ( BATCHSIZE = 10000, CODEPAGE = 'RAW', DATAFILETYPE = 'char', FIELDTERMINATOR ='\t', FIRSTROW = 2, ROWTERMINATOR ='\n', KEEPNULLS, TABLOCK, MAXERRORS=10000 ); GO Simple enough, right? If you don't understand so far then please don't bother to bid. I want this done in C#. There should be multiple threads and the .net worker threads will be utilized to process the data. Main thread: Open file, while !eof { string mydata = read 500 lines; add to worker thread pool - Process(myline); garbage collection; } - after the eof then make sure all threads are done and exit. Process thread: Parse out fields (\t) and use sql bulk insert to insert the row. the process thread should handle the parsing of the string and inserting into the table - THE TABLE STRUCTURE MAY CHANGE so please don't ask what the structure is - The bulk insert command doesn't care, it checks the table structure - you should do the same in your code. There's better threading ways to write this than I mentioned in my brief overview above, if you're reasonably priced bidder and explain in the PMB what could be improved in my example you'll win the bid over the guys that don't understand. if you have questions about how to do this please don't bid. Project may be awarded earlier than end of bid - If you can start immediately please say so in your PMB. This shouldn't take more than 1 day to deliver if you understand threading well, if you don't then this project isn't for you.
N° de projet : 627423

Concernant le projet

14 propositions
Projet à distance
Actif à il y a 14 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Please check PMB.
$80 USD en 2 jours
5,0 (3 commentaires)
2,7
2,7
14 freelances proposent en moyenne $150 USD pour ce travail
Avatar de l'utilisateur
I can deliver the project in C#
$120 USD en 2 jours
4,9 (99 commentaires)
7,1
7,1
Avatar de l'utilisateur
We can help in your project, please check PMB to see our related experience.
$225 USD en 4 jours
4,8 (26 commentaires)
5,9
5,9
Avatar de l'utilisateur
Hello, pls see PMB for details.
$200 USD en 1 jour
5,0 (8 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hi, I can do this project for you if you like.
$100 USD en 4 jours
5,0 (34 commentaires)
5,2
5,2
Avatar de l'utilisateur
Hi, I am having experiance of same kind of project earlier. please see my reviews. i will produce the C# application. thanks.
$110 USD en 4 jours
5,0 (3 commentaires)
3,1
3,1
Avatar de l'utilisateur
I have more than 4+ years of .net exp. I can do this.
$100 USD en 1 jour
4,5 (3 commentaires)
2,4
2,4
Avatar de l'utilisateur
This is exactly my last project. I would just need to refine bit. Its not only from text but also from other database types that i have used to Bulk insert.
$150 USD en 2 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am VERY experienced with parsing data. I also know more than enough about SQL to complete this project. My method, would be to have a universal file handler that each thread can access (with locks of course to prevent errors), and read the next line from, and then process, based on the format of the sql database/table, and the format of the text file. The only thing i don't yet understand, is how you would like the text files the program is parsing to be formatted, for example, some would use comma separated values, which i find most efficient for this scenario, example: database table: item1 item2 item3 item4 item5 file format: item1,item2,item3,item4,item5 item1,item2,item3,item4,item5 ... etc please send me a pm with further details on the format, other than that, i can provide a working solution within 1 day
$250 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi, I have 3+ yrs experience in C#.net. Please check my PM. thanks
$130 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello please see inbox for more information.
$200 USD en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
please chek me pm.
$250 USD en 30 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Washington DC, United States
4,8
25
Méthode de paiement vérifiée
Membre depuis févr. 16, 2007

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.