field mapping

[aaryan]

hi everyone,
i want to make something like...

display fields of a csv file on the jsp against fields from the database...

the user maps fields of csv and db... then data is transferred from csv, of those respective fields into the db..

can anybody help me!!

thanks

[Ben Souther]

What have you got so far?
Are you stuck on a particular aspect of this or are you looking for advice in getting started?

[aaryan]

i m looking for advice or help as to how can i approach this problem...

[Bear Bibeault]

Well, first you need to decide how the page will function to allow the mapping to be specified by the user. Do you have that?

[Ben Souther]

Originally posted by aziz saiyed:
i m looking for advice or help as to how can i approach this problem...

Without knowing something about your current skill levels, it's hard to know where to start when advising you.

Have you got any experience with JDBC, file handling in Java, string parsing in Java, file uploads, JSP, HTML?

[aaryan]

 
hi ben
 
sorry that i dint give any explanation about my problem... 
 
-basically there will be only one jsp... 
-the user will open a file browse window by clicking on a button.. 
-the user selects a csv or tsv file and presses okay
-the fields of the file (stored in first row of the file) will be displayed     on the jsp.. 
-in a second list box.. we display fields retrieved from mysql db that are pre-defined... 
-now the user will select which field from the csv or tsv file corresponds to the field in database
-similarly he will choose mapping for all the fields for its respective fields in db... 
-once he finishes mapping... and clicks submit button.. data from csv or tsv file is transferred to mysql... 
 
i will like to mention that i know jdbc n rest... but have little knowledge on file handling in java.. 
 
thanks for ur help.. waiting for a fast reply.. 

[Bear Bibeault]

Originally posted by aziz saiyed:
thanks for ur help.. waiting for a fast reply..

Here's a couple of tips to help you get the most out of the Ranch:

Only use CODE tags to enclose code, not text.

"ur" is not a word. Please use only real words like "your" when posting to the forums. Please read this for more information.

Phrases like "waiting for a fast reply" just tick people off. Avoid such phrases. Please read this for more information.

[Ben Souther]

"AK",
Please check your private messages.