Re: Create spreadsheet in batch from mysql

2008-09-29 Thread Jochen Hartmann (Google)
Lasse, Glad that the converter is coming along. That sounds like a decent tool. Right now there is no API to add programmatically add graphics to spreadsheets. You may want to add a feature request here: http://code.google.com/p/gdata-issues/issues/list Thanks - Jochen On Sep 26, 3:48 am, Lass

Re: Create spreadsheet in batch from mysql

2008-09-26 Thread Lasse
Hi, I do not want to specify more than I need, and I didn't feel it was a good thing to hard code a URL in my code. So I tried, - $proxiedHttpClient = new Zend_Http_Client(NULL, $config); - and it works! The only reason to use NULL is to avoid hard coding a URL. I now have a working Mysql to Go

Re: Create spreadsheet in batch from mysql

2008-09-23 Thread Jochen Hartmann (Google)
Lasse, I am not sure about your code. How come you are passing NULL instead of the login URI as in my example: http://gdatatips.blogspot.com/2008/09/using-php-client-library-through-proxy.html - Jochen On Sep 20, 8:49 am, Lasse <[EMAIL PROTECTED]> wrote: > Hi Jochen, > Thanx for your efforts.

Re: Create spreadsheet in batch from mysql

2008-09-20 Thread Lasse
Hi Jochen, Thanx for your efforts. (I wrote this post one before but it disappeared, so I give it another try). I changed my code according to your example. I still have the same problems as before. So I 'trialed and errored' until i came up with this code: $config = array( 'adapter'=> 'Z

Re: Create spreadsheet in batch from mysql

2008-09-20 Thread Lasse
Hi, Jochen, thanx for your efforts. I changed my code according to your example. I still have a problem with the proxy. I 'trialed and errored' and finally come up with this code. I still have to specify the proxy twice, but now I do it in my code, and I specify NULL as URL in the 'new Zend_Http_C

Re: Create spreadsheet in batch from mysql

2008-09-17 Thread Jochen Hartmann (Google)
Hi Lasse, I had a few minutes to take a closer look at this. You don't need to modify the constructor of the service class. I wrote this up in a quick blog post. Let me know if that helps: http://gdatatips.blogspot.com/2008/09/using-php-client-library-through-proxy.html Thanks - Jochen On Sep

Re: Create spreadsheet in batch from mysql

2008-09-17 Thread Lasse
Hi Jochen, I can wait on the enhancements. My idea is to use Google Docs as an alternative report distribution system for a Business Intelligence application. This is a new feature which I do not know the value of, but I think the concept is cool. I do not wish to convert my Goole Docs to Excel.

Re: Create spreadsheet in batch from mysql

2008-09-16 Thread Jochen Hartmann (Google)
Lasse, I just realized that I forgot to answer your last question. It should not matter to your application or end users which datacenter the document is being server from. That's more of an issue that we need to worry about. Cheers, - Jochen On Sep 16, 12:39 am, Lasse <[EMAIL PROTECTED]> wrote

Re: Create spreadsheet in batch from mysql

2008-09-16 Thread Jochen Hartmann (Google)
Lasse, I think your includes look normal. You are using two APIs to run your app so it makes sense to load Gdata_Docs and Gdata_Spreadsheets. The proxy adapter should not be needed twice. I am not sure what the reason is for modifying the Zend_Gdata_Doc's classes constructor. I am not 100% sure w

Re: Create spreadsheet in batch from mysql

2008-09-16 Thread Lasse
Hi, Thanx for your answer :) I replaced my include with: require_once 'Zend/Loader.php'; Zend_Loader::loadClass('Zend_Gdata'); Zend_Loader::loadClass('Zend_Gdata_ClientLogin'); Zend_Loader::loadClass('Zend_Gdata_Docs'); Zend_Loader::loadClass('Zend_Gdata_Spreadsheets'); Zend_Load

Re: Create spreadsheet in batch from mysql

2008-09-15 Thread Jochen Hartmann (Google)
Hi Lasse, Glad that you got it working so far. Here are some answers to your questions: 1. Proxy adapter: At first glance this looks like correct usage. You may want to consult the Zend reference guide for more details on it: http://framework.zend.com/manual/en/zend.http.client.adapters.html#zen

Re: Create spreadsheet in batch from mysql

2008-09-13 Thread Lasse
Hi, I can sure do with some help :-| I need to go through a proxy. To do that I had to modify Zend_Gdata_Doc --- public function __construct($client = null, $applicationId = 'MyCompany-MyApp-1.0') { $this->registerPackage('Zend_Gdata_Docs

Re: Create spreadsheet in batch from mysql

2008-09-11 Thread Jochen Hartmann (Google)
Lasse, Great! And always feel free to post here if you run into trouble. Thanks - J On Sep 9, 8:04 am, Lasse <[EMAIL PROTECTED]> wrote: > Yes, I think your post helps. I will have a look at this coming > weekend. > Thank you very much |-_-| > > On 9 Sep, 16:58, "Jochen Hartmann (Google)" <[EMAI

Re: Create spreadsheet in batch from mysql

2008-09-09 Thread Jochen Hartmann (Google)
Hi, That definitely sounds feasible, though certain use-cases are not fully supported through the API yet. For instance you would need to actually upload some kind of a physical file to create your document. This of course could just be an empty csv file that you POST from your server. You would

Re: Create spreadsheet in batch from mysql

2008-09-09 Thread Lasse
Yes, I think your post helps. I will have a look at this coming weekend. Thank you very much |-_-| On 9 Sep, 16:58, "Jochen Hartmann (Google)" <[EMAIL PROTECTED]> wrote: > Hi, > > That definitely sounds feasible, though certain use-cases are not > fully supported through the API yet. For instance

Create spreadsheet in batch from mysql

2008-09-09 Thread Lasse
Hi, I do not know if this make sence or not. But I like to create Google Docs spreadsheets in batch mode from mysql data. I have a Linux server where I schedule PHP scripts that create and mail MS Excel sheets during the night. Now I like to start create and mail Google Docs spreadsheets. But I'm