Random Things I Learned Today: March 2010

Friday, March 5, 2010

Python Application Configuration - Google App Engine - Google Code

Requiring Login or Administrator Status

Any URL handler can have a login setting to restrict visitors to only those users who have signed in, or just those users who are administrators for the application. When a URL handler with a login setting matches a URL, the handler first checks whether the user has signed in to the application with a Google account. If not, by default, the user is redirected to the Google sign-in page, and is redirected back to the application URL after signing in or creating an account. You can also configure the app to simply reject requests for a handler from users who are not properly authenticated, instead of redirecting the user to the Google Accounts interface.

If the setting is login: required, once the user has signed in, the handler proceeds normally.

If the setting is login: admin, once the user has signed in, the handler checks whether the user is an administrator for the application. If not, the user is given an error message. If the user is an administrator, the handler proceeds.

If an application needs different behavior, the application can implement the user handling itself. See the Users API for more information.

An example:
handlers:    - url: /profile/.*  script: user_profile.py  login: required    - url: /admin/.*  script: admin.py  login: admin    - url: /.*  script: welcome.py

via code.google.com

and here's now to lock my google app engine app ...

Posted via web from mabelrxu's posterous

Wednesday, March 3, 2010

finally, success! - struggles with google talk popout gadget ...

javascript:window.open('https://talkgadget.google.com/talkgadget/popout','gtalkgadget','status=0,toolbar=0,menubar=0,resizeable=1,scrollbars=0,height=450,width=300')

finally found blogger gadget by daniyal (Google Talk Button) that essentially uses the google talk button code from the other day, ... I added it to my blog then used Developer's Inspector to grab this code ... still haven't figured out how to get rid of the location bar though ...

Posted via web from mabelrxu's posterous

Tuesday, March 2, 2010

Cross-workbook references : Functions - Google Docs Help

Functions: Cross-workbook references

Print

Google Spreadsheets lets you reference another workbook in the spreadsheet that you're currently editing by using the ImportRange function. ImportRange lets you pull one or more cell values from one spreadsheet into another.

To create your own ImportRange formulas, enter =importRange(spreadsheet-key, range). For languages where comma is used for decimal separation, use a semicolon instead of a comma to separate arguments in your formula.

Spreadsheet-key is a STRING which is the key value from the spreadsheet URL.

Range is a STRING representing the range of cells you want to import, optionally including the sheet name (defaults to first sheet). You can also use a range name if you prefer.

Given that the two arguments are STRINGs, you need to enclose them in quotes or refer to cells which have string values in them.

For example:

=importrange("abcd123abcd123", "sheet1!A1:C10")
"abcd123abcd123" is the value in the "key=" atribute on the URL of the target spreadsheet and "sheet1!A1:C10" is the range which is desired to be imported.

=importrange(A1,B1)
Cell A1 contains the string ABCD123ABCD123 and cell B1 contains sheet1!A1:C10

Note: In order to use ImportRange, you need to have been added as a viewer or collaborator to the spreadsheet from which ImportRange is pulling the data. Otherwise, you'll get this error: "#REF! error: The requested spreadsheet key, sheet title, or cell range was not found."