Find Jobs
Hire Freelancers

.NET application to store text file info in MySQL

$30-100 USD

Completed
Posted about 14 years ago

$30-100 USD

Paid on delivery
I need to develop a .NET windows forms application in either C# or VB.NET (preferred) that has the following characteristics: 1. It will ask for the user to specify a file (txt, cvs, or other to be specified) 2. It will grab the information on that file (which may be comma delimited, or tab delimited, to be specified) 3. It will write that information into a MySQL table ## Deliverables Those are the general requirements. The specifics are: * It will have a typical menu on top (File|Settings|Help). <!-- --> * The File menu will have Open, and Exit. * When a file is browsed and selected, the application must read the contents from that file and store them in a DataSet so it can close the file and keep the DataSet in memory for a few operations before saving * The operations it must perform are the following: * It must scan the current MySQL table for duplicates based on a key or field * It must give the user the choice (based on the Preference selected) to replace the MySQL record with new info, to not replace, or to merge and complete missing info, or to merge and replace current info. * If no duplicates are found, just insert the info. * The file will most likely have an extra column just for the sake of telling the application how to behave when merging. For Example, if this column holds an "m" means merge missing info, if it holds "r" mean replace, etc. <!-- --> * The Settings Menu will have "Preferences" * It will need a setup area or menu item under Settings, that will open up a form to let the user enter their MySQL details (user, host, pass, port, and DB). * This form has to have a button that "tests" the connection before exiting. * It needs to show a radio select button, like Google Sync, that enables one of 3 default actions for duplicates when merging: "MySQL has preference", "File has preference" or "Ask me every time" * The Help menu has Help and About... * Help just needs to point to a help file that I will write, and put in the directory of the application. * About will say something like "App, v.1" * * *This broadcast message was sent to all bidders on Monday Mar 8, 2010 7:04:41 PM: I have been getting this question a lot, so in the spirit of clarification: 1. The CSV file is static, and will be made to match the table fields. 2. The thing I'm worried about is sync between file and db, because in file the ID won't match the database ID, so duplicate search must be made from other field, like Name of Passport Number. Sorry if you already got this answer from me before. Thanks
Project ID: 3222308

About the project

71 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$25.50 USD in 5 days
5.0 (3 reviews)
1.9
1.9
71 freelancers are bidding on average $72 USD for this job
User Avatar
See private message.
$55.25 USD in 5 days
4.9 (529 reviews)
7.5
7.5
User Avatar
See private message.
$97.75 USD in 5 days
4.9 (72 reviews)
6.3
6.3
User Avatar
See private message.
$42.50 USD in 5 days
4.8 (157 reviews)
6.2
6.2
User Avatar
See private message.
$76.50 USD in 5 days
4.9 (110 reviews)
5.9
5.9
User Avatar
See private message.
$68 USD in 5 days
4.9 (265 reviews)
5.9
5.9
User Avatar
See private message.
$85 USD in 5 days
4.9 (167 reviews)
6.0
6.0
User Avatar
See private message.
$84.15 USD in 5 days
4.9 (34 reviews)
6.0
6.0
User Avatar
See private message.
$85 USD in 5 days
5.0 (52 reviews)
5.6
5.6
User Avatar
See private message.
$15.30 USD in 5 days
5.0 (43 reviews)
5.6
5.6
User Avatar
See private message.
$46.75 USD in 5 days
5.0 (97 reviews)
5.3
5.3
User Avatar
See private message.
$84.15 USD in 5 days
4.9 (244 reviews)
5.4
5.4
User Avatar
See private message.
$127.50 USD in 5 days
5.0 (29 reviews)
5.1
5.1
User Avatar
See private message.
$37.40 USD in 5 days
5.0 (28 reviews)
4.5
4.5
User Avatar
See private message.
$59.50 USD in 5 days
5.0 (27 reviews)
4.6
4.6
User Avatar
See private message.
$34 USD in 5 days
5.0 (88 reviews)
4.7
4.7
User Avatar
See private message.
$63.75 USD in 5 days
5.0 (15 reviews)
4.5
4.5
User Avatar
See private message.
$25.50 USD in 5 days
5.0 (17 reviews)
4.0
4.0
User Avatar
See private message.
$51 USD in 5 days
4.9 (8 reviews)
4.1
4.1
User Avatar
See private message.
$42.50 USD in 5 days
5.0 (20 reviews)
4.1
4.1
User Avatar
See private message.
$63.75 USD in 5 days
5.0 (26 reviews)
4.2
4.2

About the client

Flag of ECUADOR
Quito, Ecuador
5.0
1
Member since May 17, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.