Last post Dec 09, 2008 05:18 AM by sriram_14880
Dec 04, 2008 08:03 AM|sriram_14880|LINK
I have some 50 csv files which has data exported from 50 SQL server tables (i.e 1 .csv file for each table). These files are generated from offline application. I want to write a code in VB.Net so that I can zip all the 50 files (i.e I want to write this
code in offline app.). Then I will upload it to the web server by accessing the web application, then unzip in the web server and import the records in csv files to centralized database. Can this be done? Kindly suggest a solution.
Thanks & Regards,
Dec 04, 2008 08:24 AM|Curt_C|LINK
I'll break this down into pieces...
1) Auto-Zipping the files on the Client: Can't be done natively.
2) Upload Zip: No problem. Just add the FileUpload control to a page and use that.
3) Auto-Unzip on the Server: Sure, but you'll need (I believe) a 3rd party command line utility (like pkUnzip) to un-zip the files.
4) Auto-Import the data: Sure. Once the step #2 & #3 are completed just parse the files.
P.S.... there really is no "offline" methodology for Asp.Net. I'm just saying this because you mentioned it. You'd have to look at a Windows, not Web, development path for that.
Dec 05, 2008 01:42 AM|sriram_14880|LINK
Thanks Curt, for taking time and replying to my post. Is there any other way to upload the csv files in one go? Otherwise it has to be done one by one which may be cumbersome for the user.
Dec 05, 2008 09:32 AM|Curt_C|LINK
They will still have to pick all the files, but if you look at the multi-file upload methods out there you can do it in "one" shot, but again, they still have to select each file to include. There is no native way (without opening holes in security or installing
components on the client) to auto-upload files.
Dec 09, 2008 05:18 AM|sriram_14880|LINK