Comparing uploaded Excel file to database table

I am using Rational Application Developer 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.

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Veja mais: web programmer jakarta, web develop tutorial, web developer tutorials, web developer learn online, web app tutorials, web application tutorials, tutorial web developer, tutorial web application, table in web developer, spreadsheet to web application, side faces, rational tutorial, php programmer to java programmer, need of excel programmer, my excel online, learn web application, learn php step by step, learn java for web, learn cake php, java online programmer, java and excel, i want to learn php, i want to learn java, i want to develop a web application, i need online programmer to develop an app

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #3044861

5 freelancers estão ofertando em média $80 para esse trabalho


See private message.

$80.75 USD in 2 dias
(68 Comentários)

See private message.

$76.5 USD in 2 dias
(9 Comentários)

See private message.

$127.5 USD in 2 dias
(0 Comentários)

See private message.

$51 USD in 2 dias
(0 Comentários)

See private message.

$63.75 USD in 2 dias
(0 Comentários)