public function postUpdate($values) { //clear cache #@exec("rm /var/frontend/web/cache/".str_replace("http://", "", $this->Asset->retriveUrl2())); set_time_limit(0); error_reporting(E_ALL); ini_set('display_errors', '1'); $clientLibraryPath = sfConfig::get('sf_lib_dir') . '/vendor/ZendGdata-1.11.11/library'; $oldPath = set_include_path($clientLibraryPath); // load Zend Gdata libraries require_once sfConfig::get('sf_lib_dir') . '/vendor/ZendGdata-1.11.11/library/Zend/Loader.php'; Zend_Loader::loadClass('Zend_Gdata_Spreadsheets'); Zend_Loader::loadClass('Zend_Gdata_ClientLogin'); // set credentials for ClientLogin authentication $user = "******"; $pass = "******"; //die($this->getSpreadsheetId()."<br>".$this->getWorksheetId()); try { // connect to API $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME; $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service); $service = new Zend_Gdata_Spreadsheets($client); // get worksheet entry $query = new Zend_Gdata_Spreadsheets_DocumentQuery(); $query->setSpreadsheetKey($this->getSpreadsheetId()); $query->setWorksheetId($this->getWorksheetId()); $wsEntry = $service->getWorksheetEntry($query); $title = new Zend_Gdata_App_Extension_Title($this->getQuestion()); $wsEntry->setTitle($title); // update entry $entryResult = $service->updateEntry($wsEntry, $wsEntry->getLink('edit')->getHref()); echo 'The ID of the updated worksheet entry is: ' . $entryResult->id; } catch (Exception $e) { die('ERROR: ' . $e->getMessage()); } }