date:20120119

[web2py] Re: Too many redirects when trying to use interactive demo

2012-01-19 Thread Gerd

Hi!

I'm having problem with web2py.com/demo_admin. Tried it on a Windows XP SP3 
with FF 9.0.1 


and IE 8



regards
Gerd

[web2py] Re: new book now available in HTML (english, japanese, italian)

2012-01-19 Thread Stefan Scholl

Stefan Scholl ste...@no-spoon.de wrote:
 Johann Spies johann.sp...@gmail.com wrote:
 [-- text/plain, encoding 7bit, charset: ISO-8859-1, 8 lines --]
 
 It is working for me.  Perhaps you should try again.
 
 Nope, still gone. When I look at the response header I see it's a
 404 NOT FOUND.
 
 http://web2py.com/book/ instead of
 http://web2py.com/book
 
 See the additional /, which worked before.

I still think this is embarrassing.

[web2py] Re: [off topic] Announcement

2012-01-19 Thread Gour

On Wed, 18 Jan 2012 21:26:48 -0500
Richard Vézina
ml.richard.vez...@gmail.com wrote:

 Hello Everybody,
 
 I just would like to announce that Mathilde is born the 8 of january.
 
 I will be away from my computer a few more weeks...

Congratulation and enjoy your fathership- ;)


Sincerely,
Gour

-- 
As a strong wind sweeps away a boat on the water, 
even one of the roaming senses on which the mind 
focuses can carry away a man's intelligence.

http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810


signature.asc
Description: PGP signature

[web2py] Re: Postgres unknown reference field type

2012-01-19 Thread Simon Ashley

Fixed.

+1 to Massimo although it wasn't this error, but one lower down in the
list.
First error was failure to add a 'requires' constraint to pair with
the db.Client.

Thanks, was too tired to spot these.


On Jan 19, 1:58 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
 from the error looks like you have

 Field('Client', 'db.Client'),

 instead of

 Field('Client', db.Client),

 is that possible?

 On Jan 18, 6:25 pm, Simon Ashley gregs...@gmail.com wrote:







  Moving from SQLite to Postgres and when running Database
  Administration we're getting unknown field type errors when using a db
  reference i.e. Field('Client', db.Client)
  Any advice or work arounds?

  TIA,

  Traceback (most recent call last):
    File C:\web2py\gluon\restricted.py, line 204, in restricted
      exec ccode in environment
    File C:/web2py/applications/OAS/models/oa.py, line 358, in
  module
      Field('Interpretation_Type', db.Interpretation_Type))
    File C:\web2py\gluon\dal.py, line 5114, in define_table
      polymodel=polymodel)
    File C:\web2py\gluon\dal.py, line 624, in create_table
      (field.type, field.name)
  SyntaxError: Field: unknown field type: db.Client for Client

  Code listing:
                precision, scale = map(int,field.type[8:-1].split(','))
                  ftype = self.types[field.type[:7]] % \
                      dict(precision=precision,scale=scale)
              elif not field.type in self.types:
                  raise SyntaxError, 'Field: unknown field type: %s for
  %s' % \
                      (field.type, field.name)

  Model:
    db.define_table('Client',
        Field('Company', 'string'),
        Field('Address', 'string'),
        Field('Town', 'string'),
        Field('State', 'string'),
        Field('Zip', 'string'),
        Field('Activity', 'integer'),
        Field('Account', 'integer'),
        format='%(Company)s')

    db.define_table('Contact',
        Field('Client', db.Client),
        Field('Surname', 'string'),
        Field('First_Name', 'string'),
        Field('Position', 'string'),
        Field('Department', 'string'),
        Field('eMail', 'string'),
        Field('Mobile', 'string'),
        Field('Phone', 'string'),
        Field('Fax', 'string'),
        format='%(Surname)s - %(First_Name)s')

  Environment:
    Windows 7 64bit
    Current Postgresql (64bit) with psycopy2
    web2py source from trunk: (1, 99, 4, datetime.datetime(2011, 12, 31,
  4, 51, 15), 'stable')
    Python 2.7.2: C:\Python27\python.exe

[web2py] login with blank password:problem

2012-01-19 Thread Saurabh S

Hi , i am developing an online booking system in web2py on GAE.

The problem that i am facing is when i create an entity (client/
volunteer/employee) in my system , i store a random password in the db
(auth_random_password()) and 'pending' in the registration key
initially. but when i enable the login (registration_key = ) for an
entity. i can login the system without typing anything in the password
field.

also if i do request_reset_password then the login functionality is
working absolutely fine.(email as well as password is required after
request_reset_password )

is it neccessary that when ever an entity (client/employee/volunteer)
is created that we must do a request reset password in order for login
functionality to work properly (with email and valid password)

Is there any solution to avoid this ?

Please suggest on this


Thanks in advance.

[web2py] Re: string not recognized

2012-01-19 Thread davidjensen

Thank you for the reply.

I ran into the situation because I wanted to copy the raw wikipedia
markup of a wikipedia page, which does use {{. I had trouble copying
the browser formatted page. Possibly, there could be a special tag for
that. Since the view accepts Python code, there is probably a nice
work around. I will try some things and submit a hopefully clean
suggestion.

On Jan 18, 6:46 am, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
 Because the {{ }} operator have precedence over everything else.
 when web2py finds

 {{=PRE({{this is a string}}))}

 interprets it as

 OPEN{{  =PRE({{this is a string    CLOSE}}            ))}

 when you want to put  and  in HTML you have to escape them with lt;
 and gt;

 similarly if you want to put {{ and }} inside web2py views you have to
 escape them. In your case the simples solution is:

 {{=PRE({+{this is a string}+}))}

 On Jan 18, 7:59 am, davidjensen davidjensen...@gmail.com wrote:







  It bombs onPRE,CODE, and nowXML

  On Jan 18, 3:13 am, nils n...@olofsson.tv wrote:

   Hi,
   Could you not use {{=XML(string...)}}
   Regards,
   Nils
   On Jan 18, 2012 9:43 a.m., davidjensen davidjensen...@gmail.com wrote:

This is not recognized asa string:
{{this is a string}}     in:
{{=PRE({{this is a string}}))}    in a web page
but it works on the command line:
PRE({{this is a string}}).xml()

[web2py] Re: sqlhtml unicode error

2012-01-19 Thread Alan Etkin

I found that the Unicode errors are originated because of incompatible
encodings when web2py tries to read the raw message and render the
data for browser output. I solved it encoding the RFC822 raw text
before parsing the response data as Rows. Still i am not sure if this
is the correct way for processing the response text so it can be sent
safely (without misread characters) to the user interface. Anyway, it
seems to work well, without instensive testing.

On 18 ene, 18:40, Alan Etkin spame...@gmail.com wrote:
 I am trying to generate sqltables with the experimental IMAPAdapter
 select output, but with some rows, an exception is raised at the
 sqlhtml module. It has to do with unicode and charsets when sqlhtml
 processes the rows object returned by the adapter's select method, but
 I cannot find a proper way of solving it. Here is the error trace:

 Traceback (most recent call last):
   File /home/alan/web2py-hg/gluon/restricted.py, line 204, in
 restricted
     exec ccode in environment
   File /home/alan/web2py-hg/applications/queries/views/default/
 index.html, line 126, in module
   File /home/alan/web2py-hg/gluon/globals.py, line 181, in write
     self.body.write(xmlescape(data))
   File /home/alan/web2py-hg/gluon/html.py, line 114, in xmlescape
     return data.xml()
   File /home/alan/web2py-hg/gluon/dal.py, line 7442, in xml
     return sqlhtml.SQLTABLE(self).xml()
   File /home/alan/web2py-hg/gluon/sqlhtml.py, line 2197, in __init__
     ur = unicode(r, 'utf8')
   File /usr/lib/python2.6/encodings/utf_8.py, line 16, in decode
     return codecs.utf_8_decode(input, errors, True)
 UnicodeDecodeError: 'utf8' codec can't decode bytes in position
 1227-1229: invalid data

 I found a workaround to avoid the exception but I doubt it's the
 correct fix, because it just prevents web2py to create the unicode
 object and use the raw input instead.

 This is the workaround: (gluon/sqlhtml.py Line 2196)

                     try:
                         ur = unicode(r, 'utf-8')
                     except UnicodeDecodeError, e:
                         ur = r

 Replacing this line:
                     ur = unicode(r, 'utf8')

 When creating the Row objects at the adapter, I have to handle
 different encodings depending on the message. What would be an
 appropiate way of encoding data before creating the Row objects, so
 unicode errors can be avoided?

 This is the adapter method i am using to store the parse input for
 each text field

     def encode_text(self, text, charset, errors=replace):
          convert text for mail to unicode
         if text is None:
             text = 
         else:
             if charset is not None:
                 text = unicode(text, charset, errors)
             else:
                 text = unicode(text, utf-8, errors)
         return text

 Thanks

 I am using the last source hg version (1.99.4) with Python 2.6.5 on a
 Mandriva GNU/Linux machine.

[web2py] Integration with OpenID, Facebook

2012-01-19 Thread Web2Py Freak

Dear All,

I am using the Integration with OpenID, Facebook from the book , now
what i want to do is to get users images from facebook and anyother
accounts that use to register , so any ideas ?

[web2py] bitcoin

2012-01-19 Thread btcgriffin

I like to support web2py project with bitcoin (http://bitcoin.org/). Can I 
send you this currency ?
btcgriffin

[web2py] Re: Announcement

2012-01-19 Thread Cliff

Congratulations, Richard.

All the best to your family.

On Jan 19, 3:38 am, Gour g...@atmarama.net wrote:
 On Wed, 18 Jan 2012 21:26:48 -0500
 Richard Vézina

 ml.richard.vez...@gmail.com wrote:
  Hello Everybody,

  I just would like to announce that Mathilde is born the 8 of january.

  I will be away from my computer a few more weeks...

 Congratulation and enjoy your fathership- ;)

 Sincerely,
 Gour

 --
 As a strong wind sweeps away a boat on the water,
 even one of the roaming senses on which the mind
 focuses can carry away a man's intelligence.

 http://atmarama.net| Hlapicina (Croatia) | GPG: 52B5C810

  signature.asc
  1KViewDownload

[web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Cliff

Jim,

Grid has a parameter searchwidget

Doesn't that point to a custom search widget?

I would very much like to see your solution.

On Jan 18, 10:20 pm, Jim Steil j...@qlf.com wrote:
 Adnan

 I did not get this working, but that doesn't mean it has been resolved.
 I've given up on the search that is included in grid/smartgrid and have
 been working on a solution whereby you can override the default behavior
 and provide your own.  I've got a ticket open
 (http://code.google.com/p/web2py/issues/detail?id=523) and am just
 waiting for Massimo to look it over and get it in trunk.

 I've been using my mod'd sqlhtml.py for some time and it is working
 really well for me.  I'm hoping my mod can get into trunk.  If it does I
 will then write up a little demo of how it all works.  It is really
 quite simple then to provide your own search capabilities with the
 ability to easily customize it for different pages.

      -Jim

 On 1/18/2012 1:59 PM, Adi wrote:

  Hi Jim,
  Did you get this working, since I too don't see the referenced field
  in a query?

  Thanks,
  Adnan

  No virus found in this message.
  Checked by AVG -www.avg.comhttp://www.avg.com
  Version: 2012.0.1901 / Virus Database: 2109/4752 - Release Date: 01/18/12

 --
 Jim Steil
 VP of Information Technology
 Quality Liquid Feeds, Inc.
 608.935.2345 office
 608.341.9896 cell

[web2py] Re: Problem with DB2 and text field type when accessing db2 using ODBC ...

2012-01-19 Thread Omi Chiba

David,

I'm successfully using DB2 for internal web app. We used to use i595: O/S 
V5R3M0 and now we use  Power 770: O/S V7R1M0.

Yes, it will be created as 'CLOB' and I don't have the problem. (See 
attachment). 

Model

db.define_table('mytable',
Field('mystring'),
Field('mytext', 'text')
)

SQL

CREATE TABLE mytable(
id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY NOT NULL,
mystring VARCHAR(512),
mytext CLOB
);  


However, I'm also AS400 Developer and don't like to use the 'CLOB' field 
because it's not supported by DDS and I'm pretyy sure we can not read/write 
the field with RPG.  I prefer using VARCHAR. If you really want to use the 
text input field on the form, then I remember I tried something like this. 

1. Define new table with VARCHAR and let web2py create the table on AS400
You should also specify the length and IS_LENGTH

db.define_table('mytable',
Field('mystring'),
Field('mytext')
)

2. Specify migrate=False and change the field to 'text'
In this way, web2py show the field as 'text' but the field on DB2 is still 
VARCHAR.
db.define_table('mytable',
Field('mystring'),
Field('mytext', 'text'),
migrate=False
)

3. Try creating new record


attachment: Insert record.PNGattachment: AS400 Part1.PNGattachment: AS400 Part2.PNG

Re: [web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Adi


Even though users can navigate through a parent table's smartgrid to get 
to children, it would be very valuable to filter children records based 
on a referenced (parent) table criteria. 

Unfortunately, I'm not sure yet how to create my own search widget, but I 
saw a feature available...

[web2py] Re: TYMR - web2py social network - Invitations for this community

2012-01-19 Thread Francisco Costa

Thanks all for the feedback!

@Ovidio,
the code is not available.

@Marin,
you shouldn't be able to not select a place to host events at the
moment (that functionality is still in development).
I've already corrected it. Thanks

On Jan 18, 8:07 pm, Marin Pranjić marin.pran...@gmail.com wrote:
 I tried to create an event (just for testing) and got an error when tried
 to submit.
 Actually, I was redirected tohttp://tymr.com/event/draft/697which is
 e404-not found

 Marin

[web2py] Re: DAL IMAPAdapter

2012-01-19 Thread Alan Etkin

New features:
- set.update()
- set.delete()

I also fixed Unicode problems on parsing the complete RFC822 message

http://code.google.com/p/web2py/issues/detail?id=610#c5

On 17 ene, 13:05, Alan Etkin spame...@gmail.com wrote:
 The new version of the adapter with fixes and size queries

 http://code.google.com/p/web2py/issues/detail?id=610#c4

[web2py] Re: bitcoin

2012-01-19 Thread Massimo Di Pierro

Not yet sorry.

On Jan 19, 4:40 am, btcgriffin btcgrif...@gmail.com wrote:
 I like to support web2py project with bitcoin (http://bitcoin.org/). Can I
 send you this currency ?
 btcgriffin

[web2py] Re: login with blank password:problem

2012-01-19 Thread Massimo Di Pierro

This should absolutely not be the case. If this is a problem on the
web2py side than it is a security issue and it needs to be fixed
urgently. I am not convinced this is a web2py problem anyway. Can you
show use the code you use to pre-fill the random password?

On Jan 19, 6:27 am, Saurabh S ggtestlo...@gmail.com wrote:
 Hi , i am developing an online booking system in web2py on GAE.

 The problem that i am facing is when i create an entity (client/
 volunteer/employee) in my system , i store a random password in the db
 (auth_random_password()) and 'pending' in the registration key
 initially. but when i enable the login (registration_key = ) for an
 entity. i can login the system without typing anything in the password
 field.

 also if i do request_reset_password then the login functionality is
 working absolutely fine.(email as well as password is required after
 request_reset_password )

 is it neccessary that when ever an entity (client/employee/volunteer)
 is created that we must do a request reset password in order for login
 functionality to work properly (with email and valid password)

 Is there any solution to avoid this ?

 Please suggest on this

 Thanks in advance.

[web2py] Re: sqlhtml unicode error

2012-01-19 Thread Massimo Di Pierro

Is the page html header declaring the utf8 encoding or are using in a
layout that uses a different encoding?

On Jan 19, 7:21 am, Alan Etkin spame...@gmail.com wrote:
 I found that the Unicode errors are originated because of incompatible
 encodings when web2py tries to read the raw message and render the
 data for browser output. I solved it encoding the RFC822 raw text
 before parsing the response data as Rows. Still i am not sure if this
 is the correct way for processing the response text so it can be sent
 safely (without misread characters) to the user interface. Anyway, it
 seems to work well, without instensive testing.

 On 18 ene, 18:40, Alan Etkin spame...@gmail.com wrote:







  I am trying to generate sqltables with the experimental IMAPAdapter
  select output, but with some rows, an exception is raised at the
  sqlhtml module. It has to do with unicode and charsets when sqlhtml
  processes the rows object returned by the adapter's select method, but
  I cannot find a proper way of solving it. Here is the error trace:

  Traceback (most recent call last):
    File /home/alan/web2py-hg/gluon/restricted.py, line 204, in
  restricted
      exec ccode in environment
    File /home/alan/web2py-hg/applications/queries/views/default/
  index.html, line 126, in module
    File /home/alan/web2py-hg/gluon/globals.py, line 181, in write
      self.body.write(xmlescape(data))
    File /home/alan/web2py-hg/gluon/html.py, line 114, in xmlescape
      return data.xml()
    File /home/alan/web2py-hg/gluon/dal.py, line 7442, in xml
      return sqlhtml.SQLTABLE(self).xml()
    File /home/alan/web2py-hg/gluon/sqlhtml.py, line 2197, in __init__
      ur = unicode(r, 'utf8')
    File /usr/lib/python2.6/encodings/utf_8.py, line 16, in decode
      return codecs.utf_8_decode(input, errors, True)
  UnicodeDecodeError: 'utf8' codec can't decode bytes in position
  1227-1229: invalid data

  I found a workaround to avoid the exception but I doubt it's the
  correct fix, because it just prevents web2py to create the unicode
  object and use the raw input instead.

  This is the workaround: (gluon/sqlhtml.py Line 2196)

                      try:
                          ur = unicode(r, 'utf-8')
                      except UnicodeDecodeError, e:
                          ur = r

  Replacing this line:
                      ur = unicode(r, 'utf8')

  When creating the Row objects at the adapter, I have to handle
  different encodings depending on the message. What would be an
  appropiate way of encoding data before creating the Row objects, so
  unicode errors can be avoided?

  This is the adapter method i am using to store the parse input for
  each text field

      def encode_text(self, text, charset, errors=replace):
           convert text for mail to unicode
          if text is None:
              text = 
          else:
              if charset is not None:
                  text = unicode(text, charset, errors)
              else:
                  text = unicode(text, utf-8, errors)
          return text

  Thanks

  I am using the last source hg version (1.99.4) with Python 2.6.5 on a
  Mandriva GNU/Linux machine.

[web2py] Trouble with creating static file on the fly.

2012-01-19 Thread JoeCodeswell

Dear web2py folks,

I am having trouble creating a static file on the fly.

Here is the code in dnload_file/controllers/default.py.

def make_dl():
myurl = URL('static', 'excel.txt')
f = open(myurl,'w')
for i in range(20):
f.write('This is a test %2s\n'%(i))
f.close()
return  dict(myurl=myurl)

Here is the ticket Traceback.
Traceback (most recent call last):
  File E:\web2py\gluon\restricted.py, line 194, in restricted
exec ccode in environment
  File E:/web2py/applications/dnload_file/controllers/default.py,
line 80, in module
  File E:\web2py\gluon\globals.py, line 149, in lambda
self._caller = lambda f: f()
  File E:/web2py/applications/dnload_file/controllers/default.py,
line 21, in make_dl
f = open(myurl,'w')
IOError: [Errno 2] No such file or directory: '/dnload_file/static/
excel.txt'

Any ideas?

Thanks for the help in advance.

Love and peace,

Joe

Re: [web2py] Re: Implementing tornado chat server with web2py

2012-01-19 Thread Phyo Arkar

Websocket is not ready , it is just a draft protocol. i wont recommend any
serious use on it.

On Wed, Jan 18, 2012 at 6:57 AM, Abhishek Gupta 
abhishekgupta.i...@gmail.com wrote:

 I implemented a similar solution, but the user keeps on getting
 disconnected from the tornado server. This happens frequently with chrome.
 Any guesses, so as why the user is being disconnected so often (in every
 4-5 secs).

[web2py] Re: Trouble with creating static file on the fly.

2012-01-19 Thread Anthony



On Thursday, January 19, 2012 11:12:53 AM UTC-5, JoeCodeswell wrote:

 Dear web2py folks, 

 I am having trouble creating a static file on the fly. 

 Here is the code in dnload_file/controllers/default.py. 

 def make_dl(): 
 myurl = URL('static', 'excel.txt') 
 f = open(myurl,'w')


URL() generates a relative URL, but you need to generate a filesystem path, 
so try:

import os
myfile = os.path.join(request.folder, 'static', 'excel.txt')
f = open(myfile, 'w')

Anthony

[web2py] Re: DAL IMAPAdapter

2012-01-19 Thread LightDot

Sounds really good. I guess webmail application would also be an 
interesting web2py project.

Eh, if work days had about 49 hours, I'd be on it right now...

[web2py] Problem with .smartgrid on tables with links

2012-01-19 Thread Jim Steil


Hi

Just updated to the latest trunk this morning and now my smartgrids 
aren't working where the table being used has links.


Here is what I'm getting:

Traceback(most recent call last):
  FileC:\dev\web2py\gluon\restricted.py,line204,inrestricted
execccodeinenvironment
  FileC:/dev/web2py/applications/infocenter/controllers/administration.py  
http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/administration.py,line1816,inmodule
  FileC:\dev\web2py\gluon\globals.py,line172,inlambda
self._caller=lambdaf:f()
  FileC:\dev\web2py\gluon\tools.py,line2530,inf
returnaction(*a, **b)
  FileC:/dev/web2py/applications/infocenter/controllers/administration.py  
http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/administration.py,line457,inassetTypes
paginate=15,maxtextlength=45)
  FileC:\dev\web2py\gluon\sqlhtml.py,line1971,insmartgrid
user_signature=user_signature,**kwargs)
  FileC:\dev\web2py\gluon\sqlhtml.py,line1819,ingrid
iflink(row):
  FileC:\dev\web2py\gluon\sqlhtml.py,line1968,inlambda
args=request.args[:nargs]+[args0,row.id])))
  FileC:\dev\web2py\gluon\dal.py,line4996,in__getattr__
return self[key]
  FileC:\dev\web2py\gluon\dal.py,line4987,in__getitem__
returndict.__getitem__(self,key)
KeyError:'id'


If the table doesn't have any fields referencing other tables, then it 
works fine.


Is it just me?

-Jim

Re: [web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

2012-01-19 Thread Jim Steil

Cliff - I was getting a bunch of stuff together this morning to show you 
what I'm doing, but when I updated to the latest trunk most of my 
smartgrids quit working.  I will get a sample here for you once I get my 
installation working again.


-Jim

On 1/19/2012 8:34 AM, Cliff wrote:

Jim,

Grid has a parameter searchwidget

Doesn't that point to a custom search widget?

I would very much like to see your solution.

On Jan 18, 10:20 pm, Jim Steilj...@qlf.com  wrote:

Adnan

I did not get this working, but that doesn't mean it has been resolved.
I've given up on the search that is included in grid/smartgrid and have
been working on a solution whereby you can override the default behavior
and provide your own.  I've got a ticket open
(http://code.google.com/p/web2py/issues/detail?id=523) and am just
waiting for Massimo to look it over and get it in trunk.

I've been using my mod'd sqlhtml.py for some time and it is working
really well for me.  I'm hoping my mod can get into trunk.  If it does I
will then write up a little demo of how it all works.  It is really
quite simple then to provide your own search capabilities with the
ability to easily customize it for different pages.

  -Jim

On 1/18/2012 1:59 PM, Adi wrote:


Hi Jim,
Did you get this working, since I too don't see the referenced field
in a query?
Thanks,
Adnan
No virus found in this message.
Checked by AVG -www.avg.comhttp://www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4752 - Release Date: 01/18/12

--
Jim Steil
VP of Information Technology
Quality Liquid Feeds, Inc.
608.935.2345 office
608.341.9896 cell

[web2py] HOWTO: getting web2py to run on Android mobile devices

2012-01-19 Thread fpp

In response to a question in another thread, here is a summary of how
I got web2py running on my Android device (a Samsung Note), using
hints found here and there.

Maybe it can save some time for those wanting to do the same thing.

Note : I am just getting started with Android, so there are probably
better and/or easier ways to do it than what I describe here.

Please add to this thread if you see anything missing or incorrect.

First we need to get python running on the device, obviously.

This is done by installing SL4A (scripting layer for Android).
Get the the apk from http://code.google.com/p/android-scripting/ and
install it
(requires checking unknown sources in settings/applications)
SL4A was initially called ASE (Android scripting engine), so many
older Howtos use that instead.

Run the app, use menu/view/interpreters : by default there is only
shell.
Use menu again, add, choose Python.
This downloads the installer. Run python for android from your apps
list, install...

Whew, now we have Python on our device, but it only runs through the
SL4A interface.

Now we need to get it running from the command line.

I used the traditional adb method to connect from the PC to the
Android console, with the USB cable.
adb can be found in the Android SDK, and is also included in several
rooting kits, which are smaller (adb is just one executable and two
DLLs under Windows).
It also needs the USB drivers for the device, which means installing
vendor software (like Kies for Samsung).

(Users who already have an SSH daemon running on their device can use
ssh and scp and Wifi instead)

So, if all goes well, adb shell will connect you to a very basic
Linux console on your device.

On mine, the SL4A scripts folder is at : /sdcard/sl4a/scripts
I chose to do everything in there to be available also from inside the
app.

You can now verify that python does not run from the command line,
because no environment is set.

I found this ready-made script that does all the grunt work :
http://blog.anantshri.info/android-standalone-python/

Only it seems that paths move around a lot between Android versions
and/or devices, so I had to correct them for mine :

#! /bin/sh
PW=`pwd`
export EXTERNAL_STORAGE=/mnt/sdcard
export LANG=en
PYTHONPATH=/mnt/sdcard/com.googlecode.pythonforandroid/extras/python
PYTHONPATH=${PYTHONPATH}:/data/data/com.googlecode.pythonforandroid/
files/python/lib/python2.6/lib-dynload
export PYTHONPATH
export TEMP=/mnt/storage/com.googlecode.pythonforandroid/extras/python/
tmp
export PYTHON_EGG_CACHE=$TEMP
export PYTHONHOME=/data/data/com.googlecode.pythonforandroid/files/
python
export LD_LIBRARY_PATH=/data/data/com.googlecode.pythonforandroid/
files/python/lib
cd $PW
/data/data/com.googlecode.pythonforandroid/files/python/bin/python
$@

Let's save this to py.sh and copy that to the device :
adb push py.sh /sdcard/sl4a/scripts

Then connect back with 'adb shell' and try 'sh py.sh' : if the paths
are OK you should now be in the Python interpreter.
Whew again :-)

Now comes the web2py part. It's not as easy as it should be, due to
some shortcomings in the Android Python distribution.

First, you need version 1.97.1 at least (i used 1.99.4, latest as of
this writing).
Next, even then some things don't work, such as creating an app
directly on the device, because of cache problems :
https://groups.google.com/group/web2py/browse_thread/thread/461ca3eec3fde4e4/9ab612d9c21604ee?hl=frlnk=gstq=android#9ab612d9c21604ee

I worked around this by preparing the web2py environment on the PC
first, then copying it over.

These are the main steps :

* get latest web2py_src.zip
* unzip to temp dir on PC
* run once so that all initialization steps are done, check the admin
app
* stop
* copy your existing app(s) to the web2py applications folders
* (optional) reduce size by deleting example apps, test scripts,
errors etc.
* re-zip to web2py_a.zip
* push to device with adb push web2py_a.zip /sdcard/sl4a/scripts
* connect to shell again and unzip

Note: on my device 'unzip' would fail to extract the archive because
it could not set the permissions.
I had to use 'su' first for it to work (the device was already rooted)

So now we only need a way to start web2py as a daemon.
I created a new 'web2py.sh' shell script, which is the same as py.sh
except for the last two lines :

#! /bin/sh

PW=`pwd`
export EXTERNAL_STORAGE=/mnt/sdcard
export LANG=en
PYTHONPATH=/mnt/sdcard/com.googlecode.pythonforandroid/extras/python
PYTHONPATH=${PYTHONPATH}:/data/data/com.googlecode.pythonforandroid/
files/python/lib/python2.6/lib-dynload
export PYTHONPATH
export TEMP=/mnt/storage/com.googlecode.pythonforandroid/extras/python/
tmp
export PYTHON_EGG_CACHE=$TEMP
export PYTHONHOME=/data/data/com.googlecode.pythonforandroid/files/
python
export LD_LIBRARY_PATH=/data/data/com.googlecode.pythonforandroid/
files/python/lib
cd $PW
cd web2py
/data/data/com.googlecode.pythonforandroid/files/python/bin/python
web2py.py -l

[web2py] Re: Problem with .smartgrid on tables with links

2012-01-19 Thread Massimo Di Pierro

Do the tables have id fields called other than id?

On Jan 19, 10:45 am, Jim Steil j...@qlf.com wrote:
 Hi

 Just updated to the latest trunk this morning and now my smartgrids
 aren't working where the table being used has links.

 Here is what I'm getting:

 Traceback(most recent call last):
    FileC:\dev\web2py\gluon\restricted.py,line204,inrestricted
      execccodeinenvironment
    FileC:/dev/web2py/applications/infocenter/controllers/administration.py  
 http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/admin...,line1816,inmodule
    FileC:\dev\web2py\gluon\globals.py,line172,inlambda
      self._caller=lambdaf:f()
    FileC:\dev\web2py\gluon\tools.py,line2530,inf
      returnaction(*a, **b)
    FileC:/dev/web2py/applications/infocenter/controllers/administration.py  
 http://127.0.0.1:8000/admin/default/edit/infocenter/controllers/admin...,line457,inassetTypes
      paginate=15,maxtextlength=45)
    FileC:\dev\web2py\gluon\sqlhtml.py,line1971,insmartgrid
      user_signature=user_signature,**kwargs)
    FileC:\dev\web2py\gluon\sqlhtml.py,line1819,ingrid
      iflink(row):
    FileC:\dev\web2py\gluon\sqlhtml.py,line1968,inlambda
      args=request.args[:nargs]+[args0,row.id])))
    FileC:\dev\web2py\gluon\dal.py,line4996,in__getattr__
      return self[key]
    FileC:\dev\web2py\gluon\dal.py,line4987,in__getitem__
      returndict.__getitem__(self,key)
 KeyError:'id'

 If the table doesn't have any fields referencing other tables, then it
 works fine.

 Is it just me?

      -Jim

Re: [web2py] HOWTO: getting web2py to run on Android mobile devices

2012-01-19 Thread Vinicius Assef

Very nice. Really!

On Thu, Jan 19, 2012 at 2:56 PM, fpp fpp@gmail.com wrote: