Find Jobs
Hire Freelancers

CSV File to MySQL

$100-500 USD

Closed
Posted about 17 years ago

$100-500 USD

Paid on delivery
1. I have a dashboard product that uses Apache Jetspeed, jfree chart and our own code. It can access any JDBC data source. I want to create a hosted solution - but I want it to be self service. This needs to be easy to do. Customers would transfer and build their own tables that they could use. 2. FTP is not required - just a file transfer to a directory - so web upload is fine. 3. CSV from excel is fine as well. Uploading excel files and intrepreting them would be difficut. 4. The application needs to perform the following: * Allow customers to upload csv files * * Intrepret the first line of the csv file and do the following: * 1. build a create table statement based upon the filename (ie [login to view URL] = customers table) create column attributes (ie last name becomes an attribute in the customers table) and data types (string, integers and real numbers need to be supported) 2. build the table - in a database that will be specified based on login - for example if Apple is a customer than the database name would be apple. This can be hardcoded for now. 3. Once the table is built - insert the data in the csv file into the new table * Provide messages or process status to the user - so the know that the process is ongoing or completed. for example - uploading file - creating table - loading data - * * provide the cabability to upload more than 1 file. Could be done by asking if more files need to be uploaded - or could be uploaded all at once and processed in a batch. 5. The application can be php or java. It will be accessed behind a secure section of the our web site or be a part of the jetspeed portal - this needs to be determined. 6. I'm interested in continuing to expand this capability - so there is a very good chance of additional work in 2007 if successful. 7. Let me know if you have additional questions. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Needs to be on a web platform. I would prefer that you build on a site accessible to the internet so I can test and confirm that all requirements are met. I can provide a test server if needed.
Project ID: 3970293

About the project

28 proposals
Remote project
Active 17 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
28 freelancers are bidding on average $1,790 USD for this job
User Avatar
See private message.
$340 USD in 45 days
4.9 (220 reviews)
8.1
8.1
User Avatar
See private message.
$1,700 USD in 45 days
4.6 (315 reviews)
7.5
7.5
User Avatar
See private message.
$1,189.15 USD in 45 days
5.0 (45 reviews)
7.1
7.1
User Avatar
See private message.
$4,250 USD in 45 days
4.8 (64 reviews)
7.0
7.0
User Avatar
See private message.
$212.50 USD in 45 days
4.9 (147 reviews)
6.5
6.5
User Avatar
See private message.
$6,800 USD in 45 days
4.7 (10 reviews)
6.4
6.4
User Avatar
See private message.
$212.50 USD in 45 days
4.6 (87 reviews)
6.3
6.3
User Avatar
See private message.
$127.50 USD in 45 days
5.0 (78 reviews)
6.2
6.2
User Avatar
See private message.
$637.50 USD in 45 days
4.9 (100 reviews)
6.1
6.1
User Avatar
See private message.
$4,250 USD in 45 days
5.0 (82 reviews)
5.9
5.9
User Avatar
See private message.
$85 USD in 45 days
4.9 (61 reviews)
5.5
5.5
User Avatar
See private message.
$127.50 USD in 45 days
4.9 (47 reviews)
5.5
5.5
User Avatar
See private message.
$85 USD in 45 days
5.0 (67 reviews)
5.5
5.5
User Avatar
See private message.
$680 USD in 45 days
4.9 (13 reviews)
5.5
5.5
User Avatar
See private message.
$382.50 USD in 45 days
4.8 (19 reviews)
4.9
4.9
User Avatar
See private message.
$340 USD in 45 days
5.0 (16 reviews)
4.8
4.8
User Avatar
See private message.
$153 USD in 45 days
4.8 (25 reviews)
4.8
4.8
User Avatar
See private message.
$110.50 USD in 45 days
4.9 (19 reviews)
4.4
4.4
User Avatar
See private message.
$170 USD in 45 days
4.2 (10 reviews)
4.4
4.4
User Avatar
See private message.
$102 USD in 45 days
5.0 (19 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Dec 29, 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.