[Google-Docs-Data-APIs] Re: Issue with Data Retrieval

[Mark.T]

Dear Devraj

Here is the code we are running....

function getsheet($client, $key, $ws) {
# Gets the contents of the selected worksheet
    $spreadsheetService = new Zend_Gdata_Spreadsheets($client);
    $query = new Zend_Gdata_Spreadsheets_ListQuery();
    $query->setSpreadsheetKey(SPREADSHEET_KEY);
    $query->setWorksheetId(USER_WORKSHEET_ID);
    $listFeed = $spreadsheetService->getListFeed($query);
    //$rowData = $listFeed->entries[1]->getCustom();

    //print_r($listFeed);

$xml='<?xml version="1.0" encoding="ISO-8859-1"?>';
$xml.='<CENTERS>';
   foreach ($listFeed->entries as $entry){
    $rowData = $entry->getCustom();

         if ($entry instanceof Zend_Gdata_Spreadsheets_ListEntry)
         {
             $centreName = $entry->getCustomByName('centre');

             $xmlD.='<'.$centreName->getText().'>';
             //$kml.='<Point><coordinates>'.$data->sheets[0]['cells']
[$i][2].','.$data->sheets[0]['cells'][$i][3].'</coordinates></Point>';
             $xmlD.='<name>'.$centreName->getText().'</
name><start>'.date('m/d/y',strtotime($entry->getCustomByName('start')-
>getText())).'</start>';
             $xmlD.='<end >'.date('m/d/y',strtotime($entry-
>getCustomByName('end')->getText())).'</end>';
             $xmlD.='<description>'.$entry->getCustomByName('code')-
>getText().'</description>';
             $xmlD.='<type>'.$entry->getCustomByName('type')->getText
().'</type><group>'.$entry->getCustomByName('group')->getText().'</
group></'.$entry->getCustomByName('centre')->getText().'>';
            //echo $entry->getCustomByName('start');
            //    echo $customEntry->getColumnName() . " = " .
$customEntry->getText()."<br>";

         }
    }
$xml.=$xmlD.'</CENTERS>';
$xml= null;
$xmlD= null;
$fp = fopen("timemap.xml","w+");
$fw = fwrite($fp,$xml);
fclose($fp);
$fp= null;
$fw= null;
$spreadsheetService = null;
$query = null;
}
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---