Re: [google-appengine] Exporting data from google cloud catastrophe to google sheets via api

2018-05-28 Thread Richard Bernstein 
Katayoon, thanks for the response. I guess I am getting confused due to the
many, many product offerings. I also see that Google also offers Bitnami
Launchpad for Google Cloud Platform . I have a
php app that runs with mysql on my xampp fine. Why would I just not use
Bitnami for GC? Is the the cost? The ability to handle many more users? Or
something else? Please tell me the disadvantage if I should just port my
app over to Bitnami?

On Mon, May 28, 2018 at 10:53 AM, 'Katayoon (Cloud Platform Support)' via
Google App Engine  wrote:

> I should add that Cloud SQL and Cloud Datastore are different products and 
> Datastore
> Emulator
>  is
> only applicable on Cloud datastore. Here
>  you may find different
> storage and database solutions and choose the best option for your project
> based on your application type. You may find a sample on Using Cloud SQL
> for MySQL in PHP
> 
> to get a good grasp of how to configure your app.yaml file
> 
> .
>
> Kindly note that Google Groups are reserved for general Google Cloud
> Platform-end product discussions and not for technical questions. For
> technical questions, I recommend that you post your full detailed question
>  to Stack Overflow
> .
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to google-appengine+unsubscr...@googlegroups.com.
> To post to this group, send email to google-appengine@googlegroups.com.
> Visit this group at https://groups.google.com/group/google-appengine.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-appengine/2b15d83c-4fba-44d9-ac7f-
> 4679e67c3bbd%40googlegroups.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/CAKXm1c1BzaJa2biLAa%2BTd1XNWLpAo9Jaxy5ti-5NP%3DvCTEqZdA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Exporting data from google cloud catastrophe to google sheets via api

2018-05-28 Thread 'Katayoon (Cloud Platform Support)' via Google App Engine 


I should add that Cloud SQL and Cloud Datastore are different products and 
Datastore 
Emulator  
is only applicable on Cloud datastore. Here 
 you may find different storage 
and database solutions and choose the best option for your project based on 
your application type. You may find a sample on Using Cloud SQL for MySQL 
in PHP 

 
to get a good grasp of how to configure your app.yaml file 

.

Kindly note that Google Groups are reserved for general Google Cloud 
Platform-end product discussions and not for technical questions. For 
technical questions, I recommend that you post your full detailed question 
 to Stack Overflow 
.

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/2b15d83c-4fba-44d9-ac7f-4679e67c3bbd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Exporting data from google cloud catastrophe to google sheets via api

2018-05-25 Thread Richard Bernstein 
Ani, thx. That was very helpful. The app as it is right now can export data to 
a csv file. So a user could download their data. At some point in the future I 
want to write some macros for sheets that will enable a specific type of 
statistical treatment on the data.

For right now I am trying to get my php app running on dev_appserver. I also 
used mysql in this app and hopefully can get the datastore emulator to run 
mysql. I am not sure if this is possible? This could be a big problem for me 
while trying to get this working app ported to run on app engine. Any 
suggestions on using cloud storage to run the mysql part of this?

I have dev_appserver running on my local machine but am having a little trouble 
setting up the app.yaml with this codeigniter based app.

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/db7e02a9-05e0-49b0-9d10-a5f90797327b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [google-appengine] Exporting data from google cloud catastrophe to google sheets via api

2018-05-25 Thread Ani Hatzis 
If I understand correctly, you want to export certain parts of your data
from Cloud SQL (MySQL 2nd generation) to Google Sheets, and users should be
able to manipulate the exported data in the sheets. I assume by
"manipulating" you refer to pivot tables, diagrams and so on. Do you want
to stream the data in realtime to Sheets? Or do you want to export the data
occasionally, e.g. manually, or just every few hours or days? Is the data
changed exclusively through your App Engine app or are there clients that
will write directly into your Cloud SQL database? And also, do you want to
export full sets of data, e.g. replacing an old sheet or exporting data to
a new sheet, or would it make sense to append new data to the sheet? Do you
need to re-export updated data into sheets? Do you need a strongly
consistent view of the data in the sheet? How much data is exported into
how many sheets and how often? And how should the access of users be
controlled? Do all Sheets users have the same permissions and do all of
them access the same data? And which programming language of the available
Google App Engine standard environments have you picked?

There are many ways to perform such exports, depending on the answers to
the above questions, and also your preferred programming language and tools.

   - One obvious of course is to manually export SQL data into a CSV file
    or
   similar and import the file into a spreadsheet. Also see Best Practices
   for Importing and Exporting Data
   .
   - If you are looking for an automated process: Inside your App Engine
   app, you could create background tasks that send the data to the Sheets API
   frequently or whenever data is changed or on a certain user request. This
   would consume GAE instance hours and is also subject to some GAE quotas and
   limits, e.g. for outbound requests. Also see Sheets API usage limits
   . The advantage is that
   task queues are integrated with your environment, so you can stick with
   your language and tools and test all pieces together on the local
   development server.
   - Or you could have a Google Apps Script web-app that pulls data
   directly from Cloud SQL and writes them into a spreadsheet. Most Google
   Apps Script quotas and limits are per user account. This route might make
   sense if you are already familiar with Google Apps Script or at least
   JavaScript, and if you want a deeper Google Drive integration.
   - Compared to a Google Apps Script *web-app*, Cloud Functions could be
   the better option, if you also plan to support export targets outside of
   Google Drive.
   - If you want to improve the user experience for Google Drive users: You
   also can integrate a Sheets add-on that users can install, that would pull
   the data from Cloud SQL into their current sheet. The add-on could have a
   sidebar with a form so the users could enter data filters before the data
   is pulled.
   - There are a few more options that come to mind though.

Ani



On Fri, May 25, 2018 at 3:08 PM Richard Bernstein 
wrote:

> Ok I am pretty much going to use the standard implementation rather than
> flexible. I will have a need to export certain parts of my data to google
> sheets to allow users to manipulate data. Is there any existing limitation
> on using standard/mysql/googlesheets api together?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to google-appengine+unsubscr...@googlegroups.com.
> To post to this group, send email to google-appengine@googlegroups.com.
> Visit this group at https://groups.google.com/group/google-appengine.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/google-appengine/c1d22698-477d-4765-b80a-9b9e569ff0aa%40googlegroups.com
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/google-appengine/CALdDuQ4KH%3DfvOG5MQULeZ%3D6L7iDMYo0XpzL9_sDT%2BhUnxoPn6A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.