Java Applet - Read from SQL, User Edits the List, Generates CSV file

IN PROGRESS
Bids
34
Avg Bid (CAD)
$470
Project Budget (CAD)
$250 - $750

Project Description:
Application will:
- Read a list of orders from a Microsoft SQL database using a stored procedure which returns a table (I have already written the stored procedure; it supplies order #'s and various details about the order)
- Display the results in a table. All of the columns being displayed are text and will be read-only, except for one which needs to be a drop-down list
- The options in the drop-down are different for each order (the options are provided in columns in the original SQL table, although during development we can decide if it makes more sense for these options to come from a second table)
- The user will scroll through the list and may decide to change the selected option in the drop-down list for various orders. You need to track which orders are modified, so that only the modifications are picked up in the next step.
- When the user is done, they will click a button which triggers the application to go through each order that was modified. For each order that was modified, you need to get additional data from the SQL database using another stored procedure which returns two tables (or two stored procedures that return their own tables, whichever is easier.) The parameters for this stored procedure is the order # and code # based on the selection in the drop-down list for that order.
- The application will then generate two CSVs file to a predetermined folder and file names (the user is not allowed to change these, but we should be able to change it in some sort of configuration file/interface.) The contents the CSV file are simply the results from the tables in the second stored procedure

At that point the program is complete. The user will take that CSV and import it to our ERP system.

Skills required:
Java, Software Architecture, Software Testing, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 550
in 5 days
$ 368
in 5 days
$ 515
in 7 days
$ 421
in 5 days
$ 515
in 10 days
Hire mabdelmonem
$ 744
in 7 days
$ 250
in 3 days
Hire poornachand
$ 333
in 7 days
$ 300
in 6 days
$ 1250
in 21 days