Export csv in servlets

[nida]

Hi,
i want to export data from database to csv file csv , which i have created successfully, but now i want to display a dialogue for taking input of filename and path and on the save button of dialogue (in jsp),i want to call my survlet controller;

can any one help me out??

Thanks

[RamyaSivakanth]

Hi Nida,
You can embed javascript and take the filename and filepath from the dialog and pass it to servlet as parameter values.

Ex:
var filename= prompt('Please enter your file name', ' ');
var filepath= prompt('Please enter your file path', ' ');
document.location.href = "servletpath?filename="+filename+"&filepath="+file path;

[nida]

Thanks Ramya it really helped me out..and cvs file is exported :).. is there any way to display prompt for user to select the file path/location instead of given by the user ,Before that i have used "document.execCommand('SaveAs',1,filename);" but i was facing some issues like, there was no option for .csv file in file type and secondly the calling of servlet controller on save button of dialogue ..

Thanks.

[nida]

hi again,
My problem of getting filename and path from dialog box is fixed , i have used FileDialogue , get filename ad directory and then call my Servlet controller, Thaaaaanx for all the ppl who considered my quries and guided me..:)
Thanx.