csv format files, zip problem!
>> Saturday, June 16, 2012
csv format files, zip problem!
Hi,
please provide any links or details about the plugin available that will allow to parse zipped files?
Because I have import a csv file which is on a website page in zip format. I have a piece of code thats supposed to work with winzip but I don't think the client has winzip available.
thanks
#2
22-10-2008
Benedict
Member
Join Date: Oct 2008
Posts: 132
Hi
Log Parser supports reading input data from the input stream, for example.
try using the following,
type filename.csv | LogParser "SELECT * FROM STDIN" -i:CSV
Perhaps you can output csv data to the I/O pipe since unzipping those data requires large disk space for storing before parsing.
regards
#3
22-10-2008
Otto
Member
Join Date: Oct 2008
Posts: 137
Can you tell How did you do it with winzip? Does winzip let you specify a website path? I thought you were using a separate method to download the file first?
Does it give the error that"File cannot support".
#4
22-10-2008
Norberd
Member
Join Date: Oct 2008
Posts: 119
I your problem related to the above mentioned problem then you need a method to download the file from the website. and just try to straight way copy file first and see if that works.
thanks
0 comments:
Post a Comment