Thanks for your timely reply, but unfortunately I get the same
"(500)Internal Server Error" Message after modification of my code to
like following:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
StreamReader sr1 = new StreamReader("test.xls");
String xlsStrData = sr1.ReadToEnd();
ASCIIEncoding encoding = new ASCIIEncoding();
String postBodyStr = xlsStrData;
byte[] postBodyData =
encoding.GetBytes(postBodyStr);
HttpWebRequest req =
(HttpWebRequest)WebRequest.Create(url);
req.Method = "POST";
req.ContentLength = postBodyData.Length;
req.ContentType = "application/vnd.ms-excel";
String op = "Authorization: GoogleLogin ";
op += token;
req.Headers.Add(op);
req.Headers.Add("Slug: test.xls");
Stream postbody = req.GetRequestStream();
postbody.Write(postBodyData, 0,
postBodyData.Length);
postbody.Close();
WebResponse result = req.GetResponse(); // still
get the same exception in this statement
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Any suggestions?
Best Regards
On Oct 23, 5:32 am, "Jeff Fisher (Google)" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> There have been some recent changes to the way the Documents List API
> handles file uploads. Instead of writing a MIME entry to the server,
> try just sending the raw bytes of the XLS file and changing the
> Content-Type of the POST itself to be 'application/vnd.ms-excel'.
> Whatever is provided in the Slug header will be the title (and it
> shouldn't have to end in .xls).
>
> The documentation will be updated soon to reflect this.
>
> Cheers,
> -Jeff
>
> On Oct 22, 3:37 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
>
>
> > hi, guys,
> > I tried to upload a xls file to google documents from a windows
> > mobile device, but I always get the following error:
> > ==> "The remote server returned an error: (500) Internal Server
> > Error."
>
> > I am sure that I get a correct authenticating because I can
> > sucessfully get the document list. I make the post content identical
> > to the tutorial.
> > I tried the java library, it works great. Then I capture the ip
> > packet and fill in my post body as it does, still get the 500 error.
> > the main part of java library sent to upload a new xls looks like
> > following:
> > ---------------------------------------------------------------------------
> > -----------------------------------------------
> > <entry xmlns='http://www.w3.org/2005/Atom'>
> > <category scheme='http://schemas.google.com/g/2005#kind'
> > term='http://schemas.google.com/docs/2007#spreadsheet'
> > label='spreadsheet'>
> > </category>
> > <title type='text'>test.xls</title>
> > <content type='application/vnd.ms-excel'>
> > </content>
> > </entry>\r\n"
>
> > while the guide's main part looks like
> > ---------------------------------------------------------------------------
> > ---------------------------------------------------
> > <?xml version='1.0' encoding='UTF-8'?>
> > <atom:entry xmlns:atom="http://www.w3.org/2005/Atom";>
> > <atom:category scheme="http://schemas.google.com/g/2005#kind";
> > term="http://schemas.google.com/docs/2007#spreadsheet"; />
> > <atom:title>example spreadsheet</atom:title>
> > </atom:entry>
>
> > anyway both of them doesn't work for me, can any body give me an
> > working example?
>
> > And I paste my code if it helps
> > ==============================================================
> > StreamReader sr1 = new StreamReader("test.xls");
> > String xlsStrData = sr1.ReadToEnd();
> > ASCIIEncoding encoding = new ASCIIEncoding();
>
> > String postBodyStr =
> > "--END_OF_PART\r\n" +
> > "Content-Type: application/atom+xml\r\n" +
> > "\r\n" +
>
> > "<entry xmlns='http://www.w3.org/2005/
> > Atom'><category scheme='http://schemas.google.com/g/2005#kind'
> > term='http://schemas.google.com/docs/2007#spreadsheet'
> > label='spreadsheet'></category><title type='text'>test.xls</
> > title><content type='application/vnd.ms-excel'></content></entry>\r\n"
> > +
> > //"<?xml version='1.0' encoding='UTF-8'?>\r\n" +
> > //"<atom:entry xmlns:atom='http://www.w3.org/2005/
> > Atom'>\r\n" +
> > //"<atom:category scheme='http://
> > schemas.google.com/g/2005#kind' term='http://schemas.google.com/docs/
> > 2007#spreadsheet' />\r\n" +
> > //"<atom:title>example spreadsheet</atom:title>\r
> > \n" +
> > //"</atom:entry>\r\n"+
> > "--END_OF_PART\r\n" +
> > "Content-Type: application/vnd.ms-excel\r\n" +
> > "\r\n\r\n\r\n" + xlsStrData + "\r\n" +
> > "--END_OF_PART--\r\n";
>
> > byte[] postBodyData =
> > encoding.GetBytes(postBodyStr);
>
> > HttpWebRequest req =
> > (HttpWebRequest)WebRequest.Create(url);
> > req.Method = "POST";
> > req.ContentLength = postBodyData.Length;
> > req.ContentType = "multipart/related;boundary=
> > \"END_OF_PART\"";
> > //req.AllowAutoRedirect = true;
> > //req.AllowWriteStreamBuffering = true;
>
> > String op = "Authorization: GoogleLogin ";
> > op += token;
> > req.Headers.Add(op);
> > req.Headers.Add("Slug: test.xls");
>
> > //req.Headers.Add("Accept-Encoding: gzip");
> > //req.Headers.Add("Cache-Control: no-cache");
> > //req.Headers.Add("Pragma: no-cache");
> > //req.Accept = "Accept: text/html, image/gif, image/
> > jpeg, *; q=.2, */*; q=.2";
> > //req.Headers.Add("MIME-version: 1.0");
>
> > Stream postbody = req.GetRequestStream();
> > postbody.Write(postBodyData, 0, postBodyData.Length);
> > postbody.Close();
>
> > WebResponse result = req.GetResponse();
> > =======================================================================
> > thanks ahead- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Data API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/google-help-dataapi?hl=en
-~----------~----~----~----~------~----~------~--~---
