I got it now. Ignore my previous post. Thanks!
On Jul 25, 8:06 pm, faninator <fanina...@gmail.com> wrote:
> Hi Eric,
>
> Thanks a lot for the help! It worked. Now I can download documents but
> not spreadsheets. I tried changing the scope to
>
> $scope = 'http://docs.google.com/feeds/%20http://
> spreadsheets.google.com/feeds/';
>
> but that didn't work. I also tried changing it to just spreadsheets to
> test spreadsheets. Do you know what could be wrong with this?
>
> Thanks,
> Fan
>
> On Jul 23, 1:03 pm, Eric Bidelman <api.e...@google.com> wrote:
>
> > Sounds definitely like an Auth issue, though I'm not surewhy you're having
> > problems.
>
> > Here's my full test page:
>
> > <?php
> > require_once 'Zend/Loader.php';
> > Zend_Loader::loadClass('Zend_Gdata');
> > Zend_Loader::loadClass('Zend_Gdata_AuthSub');
> > Zend_Loader::loadClass('Zend_Gdata_Docs');
>
> > try {
> > $docs = setupDocsClient(@$_GET['token']);
> > if ($docs) {
> > $feed = retrieveWPDocs($docs);
> > printDocumentsFeed($feed);
>
> > // export first doc
> > $contentLink = $feed->entries[0]->content->getSrc();
> > $fileContents = download($docs, $contentLink, 'txt');
> > echo 'Contents of document "' . $feed->entries[0]->title . '":<hr>';
> > echo "<pre>$fileContents</pre>";
>
> > } else {
> > exit(); // Just display the AuthSub link in setupDocsClient()
>
> > }} catch (Zend_Gdata_App_AuthException $e) {
>
> > echo "Error: Unable to authenticate. Please check your token.\n";
> > exit(1);
>
> > }
>
> > function download($client, $url, $format=null) {
> > $token = $client->getHttpClient()->getAuthSubToken();
> > $opts = array(
> > 'http' => array(
> > 'method' => 'GET',
> > 'header' => "GData-Version: 2.0\r\n".
> > "Authorization: AuthSub token=\"$token\"\r\n"
> > )
> > );
> > $context = stream_context_create($opts);
>
> > if ($url != null) {
> > $url = $url . "&exportFormat=$format";
> > }
>
> > return file_get_contents($url, false, $context);
>
> > }
>
> > function setupDocsClient($singleUseToken = null) {
> > $docsClient = null;
>
> > // Fetch a new AuthSub token?
> > if (!$singleUseToken) {
> > $next = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
> > $scope = 'http://docs.google.com/feeds';
> > $secure = 0;
> > $session = 1;
> > $permission = 1; // 1 - allows posting notices && allows reading
> > profile data
> > $authSubURL = Zend_Gdata_AuthSub::getAuthSubTokenUri($next, $scope,
> > $secure, $session);
>
> > echo '<a href="' . $authSubURL . '">Link your Google Docs Account</a>';
> > } else {
> > $httpClient = new Zend_Gdata_HttpClient();
> > $sessionToken =
> > Zend_Gdata_AuthSub::getAuthSubSessionToken(trim($singleUseToken),
> > $httpClient);
> > $httpClient->setAuthSubToken($sessionToken);
> > $docsClient = new Zend_Gdata_Docs($httpClient);
> > }
> > return $docsClient;
>
> > }
>
> > function printDocumentsFeed($feed, $html=true) {
> > if ($html) {echo "<ol>\n";}
>
> > // Iterate over the document entries in the feed
> > // and display each document's title.
> > foreach ($feed->entries as $entry) {
>
> > if ($html) {
> > // Find the URL of the HTML view of the document.
> > $alternateLink = '';
> > foreach ($entry->link as $link) {
> > if ($link->getRel() === 'alternate') {
> > $alternateLink = $link->getHref();
> > }
> > }
>
> > // Make the title link to the document on docs.google.com.
> > echo "<li><a href=\"$alternateLink\">$entry->title</a></li>\n";
> > } else {
> > echo "$entry->title\n";
> > }
> > }
>
> > if ($html) {echo "</ol>\n";}
>
> > }
>
> > function retrieveWPDocs($client, $html=true)
> > {
> > return $client->getDocumentListFeed(
> > 'http://docs.google.com/feeds/documents/private/full/-/document');
>
> > }
>
> > ?>
>
> > BTW, The reason you can cut and paste
> > the URL into a browser is because you have a validGoogle Docs cookie set.
> > If you tried the same after clearing
> > cookies things would turn out much different :)
>
> > Eric
>
> > On Wed, Jul 22, 2009 at 5:58 PM, faninator <fanina...@gmail.com> wrote:
>
> > > Hi Eric,
>
> > > Thanks for the reply. I'm not trying to download a spreadsheet. I also
> > > changed the feed URI to the correct one. However when I echo out the
> > > content, I still get the login page? This feels like some
> > > authentication issue. I copied your code verbatim, and tried many
> > > other tricks to get the file to download directly to the server using
> > > file_get_contents() followed by file_put_contents(). However, I keep
> > > getting a file containing the login page rather than the file I want.
> > > I can correctly retrieve everything else about the file, such as the
> > > name of the file, the link etc.
>
> > > Another observation is that when I copy and paste the file url I get
> > > from the response header and put that directly into browser address
> > > bar, I get the prompt to download the file without the login page.
> > > However, when I try to file_get_contents from that same url, I get the
> > > login page again. Could it be something wrong with the $opts array or
> > > session token?
>
> > > Thanks,
> > > Fan
>
> > > On Jul 22, 2:20 pm, "Eric (Google)" <api.e...@google.com> wrote:
> > > > Are you trying to download a spreadsheet? If so,
> > > > be sure to also obtain an AuthSub token good forhttp://
> > > spreadsheets.google.com/feeds.
>
> > > > Also, there's a mistake in that snippet I posted.
> > > > The feed URI should be
> > > > 'http://docs.google.com/feeds/documents/private/full/-/document'
>
> > > > Eric
>
> > > > On Jul 22, 6:00 am, faninator <fanina...@gmail.com> wrote:
>
> > > > > Hi Eric,
>
> > > > > I tried your method of using file_get_contents with the example code
> > > > > that you posted but I was unable to download the file to the server.
> > > > > If I echo the result from the download function, I get a broken google
> > > > > login page and then a prompt for download. However, when I'm trying to
> > > > > write the file content to a new file on my server (which is my
> > > > > ultimate goal here), it writes the google login page into the file. Do
> > > > > you know what could be causing the problem?
>
> > > > > Thanks,
> > > > > Fan
>
> > > > > On Jul 15, 4:32 pm, "Eric (Google)" <api.e...@google.com> wrote:
>
> > > > > > Posted a tip on this:
> > >http://gdatatips.blogspot.com/2009/07/download-google-doc-using-php-l...
>
> > > > > > On Jul 15, 1:13 pm, "Eric (Google)" <api.e...@google.com> wrote:
>
> > > > > > > Hi,
>
> > > > > > > You should be using the <entry>'s content src link
> > > > > > > and not the alternate (/View?docID=...) link that
> > > > > > > points to Google Docs. Having said that,
> > > > > > > you'll need to write a download method yourself
> > > > > > > b/c the Zend_Gdata_Docs component doesn't contain
> > > > > > > this latest API feature.
>
> > > > > > > Here's how you _could_ use file_get_contents() to
> > > > > > > export a doc as a .txt file. Note: to export
> > > > > > > spreadsheets, you'll need a valid AuthSub session
> > > > > > > token for scope=http://spreadsheets.google.com/feeds/
> > > > > > > as well.
>
> > > > > > > $feed = $gdClient->getDocumentListFeed(
> > > > > > > 'http://docs.google.com/feeds/documents/private/full/-document'
> > > );
>
> > > > > > > // download first entry
> > > > > > > $contentLink = $feed->entries[0]->content->getSrc();
> > > > > > > $fileContents = download($gdClient, $contentLink, 'txt');
>
> > > > > > > echo 'Contents of document "' . $feed->entries[0]->title .
> > > '":<hr>';
> > > > > > > echo "<pre>$fileContents</pre>";
>
> > > > > > > function download($client, $url, $format=null) {
> > > > > > > $token = $client->getHttpClient()->getAuthSubToken();
> > > > > > > $opts = array(
> > > > > > > 'http' => array(
> > > > > > > 'method' => "GET",
> > > > > > > 'header' => "GData-Version: 2.0\r\n".
> > > > > > > "Authorization: AuthSub token=\"$token\"\r\n"
> > > > > > > )
> > > > > > > );
> > > > > > > $context = stream_context_create($opts);
>
> > > > > > > if ($url != null) {
> > > > > > > $url = $url . "&exportFormat=$format";
> > > > > > > }
>
> > > > > > > return file_get_contents($url, false, $context);
>
> > > > > > > }
>
> > > > > > > Eric
>
> > > > > > > On Jul 14, 7:56 pm, infinitas <john.cia...@gmail.com> wrote:
>
> > > > > > > > $service = Zend_Gdata_Docs::AUTH_SERVICE_NAME;
> > > > > > > > $httpClient = Zend_Gdata_ClientLogin::getHttpClient($user,
> > > > > > > > $pass,
> > > > > > > > $service);
> > > > > > > > $gdClient = new Zend_Gdata_Docs($httpClient);
> > > > > > > > echo file_get_contents("http://docs.google.com/View?docID={$id}
> > > > > > > > &revision=_latest&hgd=1");
>
> > > > > > > > More or less, this is what I have *working* which raises three
> > > > > > > > questions.
>
> > > > > > > > 1. Is fopen/curl/file_get_contents the accepted method of
> > > > > > > > getting
> > > the
> > > > > > > > content or is there an API call I should be using?
> > > > > > > > 2. Does the document HAVE to be "published" for it to work?
> > > > > > > > 3. Is it necessary to have the "Google Docs -- Web word
> > > processing,
> > > > > > > > presentations and spreadsheets." in the footer? (I am assuming
> > > number
> > > > > > > > one is "no" and the correct method would probably have an option
> > > for
> > > > > > > > this).
>
> > > > > > > > On Jul 14, 12:11 am, Eric Bidelman <api.e...@google.com> wrote:
>
> > > > > > > > > What have you tried?
>
> > > > > > > > > On Mon, Jul 13, 2009 at 7:53 PM, infinitas <
> > > john.cia...@gmail.com> wrote:
>
> > > > > > > > > > I am using the PHP Zend_Gdata API. I have successfully been
> > > able to
> > > > > > > > > > retrieve a list of my documents and search through my
> > > documents, but I
> > > > > > > > > > have not been able to retrieve the actual content inside a
> > > document.
>
> ...
>
> read more »
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
