public function postInsert($values)
{
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 = "******";
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 spreadsheet entry
$ssEntry = $service->getSpreadsheetEntry('https://spreadsheets.google.com/feeds/spreadsheets/' . $this->getSpreadsheetId());
// get worksheet feed for this spreadsheet
$wsFeed = $service->getWorksheetFeed($ssEntry);
// create new entry
$wsEntry = new Zend_Gdata_Spreadsheets_WorksheetEntry();
$title = new Zend_Gdata_App_Extension_Title($this->getQuestion());
$wsEntry->setTitle($title);
$row = new Zend_Gdata_Spreadsheets_Extension_RowCount('10');
$wsEntry->setRowCount($row);
$col = new Zend_Gdata_Spreadsheets_Extension_ColCount('3');
$wsEntry->setColumnCount($col);
// insert entry
$entryResult = $service->insertEntry($wsEntry, $wsFeed->getLink('self')->getHref());
$wsid = end(explode("/", $entryResult->id));
echo 'The ID of the new worksheet entry is: ' . $wsid;
$this->worksheet_id = $wsid;
$this->save();
//die('ok');
} catch (Exception $e) {
die('ERROR: ' . $e->getMessage());
}
}
function gdata_import($attrib)
{
if ($attrib["key"] == "" || $attrib["worksheet"] == "" || $attrib["user"] == "" || $attrib["pass"] == "") {
echo 'ERROR: SET ALL ATTRIBUTES i.e sheet, worksheet, user, pass and columns. ';
return;
}
// load Zend Gdata libraries
set_include_path(get_include_path() . PATH_SEPARATOR . WP_PLUGIN_DIR . "//gdata-importer//");
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
// set credentials for ClientLogin authentication
$user = $attrib["user"];
$pass = $attrib["pass"];
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 spreadsheet entry
$ssEntry = $service->getSpreadsheetEntry('https://spreadsheets.google.com/feeds/spreadsheets/' . $attrib["key"]);
// get worksheets in this spreadsheet
$wsFeed = $ssEntry->getWorksheets($attrib["worksheet"]);
} catch (Exception $e) {
echo 'ERROR: ' . $e->getMessage();
return;
}
$content = <<<HTML
\t<table>
HTML;
foreach ($wsFeed as $wsEntry) {
if ($wsEntry->getTitle() == $attrib["worksheet"]) {
//get title
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($attrib["key"]);
$id = $wsEntry->getId();
$arr = explode('/', $id);
$query->setWorksheetId($arr[sizeof($arr) - 1]);
$query->setMinRow(1);
$query->setMaxRow(1);
$cellFeed = $service->getCellFeed($query);
$content = $content . "<tr>";
foreach ($cellFeed as $cellEntry) {
$content = $content . "<td>" . $cellEntry->getCell()->getText() . "</td>";
}
$content = $content . "</tr>";
//get content
$rows = $wsEntry->getContentsAsRows();
foreach ($rows as $row) {
$content = $content . "<tr>";
foreach ($row as $key => $value) {
$content = $content . "<td>" . $value . "</td>";
}
$content = $content . "</tr>";
}
}
}
$content = $content . <<<HTML
\t\t</tbody>
\t</table>
HTML;
return $content;
}
//die("here");
// load Zend Gdata libraries
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata_Spreadsheets');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
// set credentials for ClientLogin authentication
$user = "******";
$pass = "******";
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 spreadsheet entry
die($ssEntry . "am there");
$ssEntry = $service->getSpreadsheetEntry('https://docs.google.com/a/kcn.unima.mw/spreadsheet/ccc?key=0AumyFvx6NCRWdHRsUTFLYnBRcThmQ0RpaGwtOU1BNUE#gid=0');
// get worksheet feed for this spreadsheet
$wsFeed = $service->getWorksheetFeed($ssEntry);
// create new entry
$wsEntry = new Zend_Gdata_Spreadsheets_WorksheetEntry();
$title = new Zend_Gdata_App_Extension_Title('Jan 2011');
$wsEntry->setTitle($title);
$row = new Zend_Gdata_Spreadsheets_Extension_RowCount('10');
$wsEntry->setRowCount($row);
$col = new Zend_Gdata_Spreadsheets_Extension_ColCount('10');
$wsEntry->setColumnCount($col);
// insert entry
$entryResult = $service->insertEntry($wsEntry, $wsFeed->getLink('self')->getHref());
echo 'The ID of the new worksheet entry is: ' . $entryResult->id;
} catch (Exception $e) {
die('ERROR: ' . $e->getMessage());
