Wednesday, April 17, 2013

Re: Sync data from Google spreadsheet to Cloud SQL using Google Apps Script

Hi Sonal,

I have the example JDBC code running successfully, but the example does not show how to read data FROM a spreadsheet INTO Cloud SQL, only how to generate auto-incremented integers within the script and send them to SQL. However, it does show how to copy data from SQL into a spreadsheet.

Basically, I don't know how to modify the example code to extract a range from my spreadsheet.

The example code I'm using is from this page - https://developers.google.com/apps-script/jdbc. You will see that getActiveSpreadsheet only appears on the second example, not the first.

Many thanks,

Matt


On 17 April 2013 07:15, SonalB <sonal.bante@accenture.com> wrote:
Hi Matt,

Yes. I have written the functionality to read and write data from Cloud SQL to Google spreadsheet. The logic reads data dynamically and writes the output to Google Spreadsheet.

Please share what you are trying to accomplish or issues encountered. This would help me in suggesting how you can proceed further.

Regards,
Sonal


On Tuesday, April 16, 2013 11:39:29 PM UTC+5:30, Matt C wrote:
Hi Sonal,
How far have you got with your project? I want to do exactly the same thing. I have been experimenting with Google's example JDBC code and understand the general idea, but have now hit the limit of my abilities. I would be extremely grateful if you could offer some assistance.
Many thanks,
Matt

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment