CSV Report returning as binary data

Feel free to contact me for C# examples to process, I am using the ICSharpcode opensource project to inflate the report.
David

okiebugmv at 2007-9-3 >

I have the same problem here......all I get back is a load of junk ( )'#][3dnbdwq'#' etc..... )

Is this a new communication lang MS are working on ;)

I guess its due to the fact the files are zipped?

Justin-M at 2007-9-3 >

When you unzip the input stream, are you actually getting data out? I am getting an empty string. Here is the relevant code I am using.

private

static void extract(ZipInputStream in, OutputStream

out)

throws

IOException {
byte[]

buffer = new byte[32768];
for

(int length; (length = in.read(buffer, 0, buffer.length)) != -1; )

{

out.write(buffer, 0, length);

}

}

<CODE>

extract(new ZipInputStream(get.getResponseBodyAsStream()),

out);

String result =

out.toString("UTF-8");

</CODE>

fulish1 at 2007-9-3 >

Thanks,
Luke

fulish1 at 2007-9-3 >

Hi Guys,

//Here is the solution – works fine for us:

//Make connection:

// Open URL connection

URL u = new URL(url);

URLConnection conn = u.openConnection();

conn.connect();

//Set File:

String filename = "MSN_KeywordPerformanceReport.zip" + reportId + "_" + c.get(Calendar.YEAR) + "_" +

c.get(Calendar.MONTH) + "_" + c.get(Calendar.DATE) + "_" + c.get(Calendar.HOUR_OF_DAY) + "_" +

c.get(Calendar.MINUTE) + "_" + c.get(Calendar.SECOND) + ".zip";

File zipfile = new File(filename);

//Create an Output stream:

ByteArrayOutputStream baos = new ByteArrayO

File zipfile = new File(filename);

ByteArrayOutputStream baos = new ByteArrayOutputStream();

BufferedOutputStream bos = new BufferedOutputStream(baos);

//ByteArrayOutputStream is purely to read bytes from the downloaded file. Any slight change in byte will make the resultant file corrupted. This Class works fine for us.

//Reading file using Buffered Reader:

BufferedInputStream bis = new BufferedInputStream(conn.getInputStream());

byte[] buffer = new byte[1024 * 10];

int bytesRead = bis.read(buffer);

while ((bytesRead != -1))

{

bos.write(buffer, 0, bytesRead);

bytesRead = bis.read(buffer);

}

bis.close();

baos.close();

bos.close();

Note: As mentioned by Luke and Justin, we were facing the same problem with the resultant [downloaded] file. Use known API to un-zip the downloaded file.

FahadHanif at 2007-9-3 >