Find Jobs
Hire Freelancers

Comparing uploaded Excel file to database table

$30-100 USD

Cancelled
Posted almost 16 years ago

$30-100 USD

Paid on delivery
I am using Rational Application Developer 7.0.0.7 to develop a web application that allows the user to read/write to a table (let's call it Table X) on a server-side database. I am not a Java programmer (I come from the C++ world), but I have completed the part described above by adapting the tutorial that came with RAD's documentation, "Display dynamic information on web pages with JavaServer Faces", for my purposes. Here's my problem. As of now, the data administrators update Table X manually by comparing it against an Excel file that the administrators periodically receive. If there is a record in the Excel file that isn't in Table X, they add it to Table X. My problem is I need to automate this process. Therefore, I need to have a JSP in my web app that does this: (1) uploads an Excel file, then (2) checks the Excel file's contents against Table X in my database, and then (3) displays on a JSP the records in that Excel file that are not in Table X, and (4) for each displayed record, provides a check box next to it, such that the user can check it if they want to add that record to Table X, or leave it unchecked if they don't want to add that record; (5) finally, provides a button that adds all the checked records to Table X. I imagine that Jakarta POI (or possible JExcel?) will be used to read the Excel spreadsheet. Now comes the unusual part. I don't simply want to receive the completed project from you. I want you to describe to me, step by step (rather in the style of the tutorials that come with RAD), how to do this. Even though Java isn't my area of expertise, I would like to learn it eventually, and this is a good opportunity. (The tutorials and how-tos I've seen online that might've helped me with this problem have presumed more Java experience than I have, and therefore I have been at a loss.) This should be a piece of cake for an experienced user of RAD.
Project ID: 3044861

About the project

5 proposals
Remote project
Active 16 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
5 freelancers are bidding on average $80 USD for this job
User Avatar
See private message.
$80.75 USD in 2 days
5.0 (68 reviews)
5.9
5.9
User Avatar
See private message.
$76.50 USD in 2 days
4.8 (9 reviews)
3.8
3.8
User Avatar
See private message.
$127.50 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$51 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$63.75 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Jul 10, 2008

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.