Cancelado

Comparing uploaded Excel file to database table

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.

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

Ver 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 web developer, side faces, rational tutorial, learn web application, learn java web, learn cake php, java online programmer, want learn php, want learn java, want develop web application, like learn, learn programmer, develop web application java, develop web application php, write leave application, excel spreadsheet expertise, dynamic tutorials

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

ID do Projeto: #3044861

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

hoesoftware

See private message.

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

See private message.

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

See private message.

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

See private message.

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

See private message.

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