[web2py] Re: {{=response.toolbar()}}

Hi, I get following error when I include this in my default index view: Traceback (most recent call last): File "/Users/webdev/web2py/gluon/restricted.py", line 181, in restricted exec ccode in environment File "/Users/webdev/web2py/applications/test/views/default/ index.html", line 117,

Re: [web2py] Re: Cannot register or login a user

Nevermind. Thanks anyway. On Mon, May 30, 2011 at 10:23 PM, Jon Molesa wrote: > That line exists in default.py. > > On Mon, May 30, 2011 at 7:08 PM, Massimo Di Pierro > wrote: >> LOL. Make sure that you have >> >> def user(): return dict(form=auth()) >> >> If still does not work, show us your db

[web2py] Re: importing a db/model from other app

well then, not sure then is this helps, but I have 1 web app looking a db and a script (no web, just dal) that points to the same DB, both can select, update, insert from the same DB etc... as long as both know about the tables (and one has migrate=True). Changes on one side side can be seen by the

[web2py] Re: Thanks to all members for all you time and effort !!

Good for you on the course completion. There is a lot to learn especially if you have never done web development before of this type. For web development many people do HTML/CSS and to a lesser degree Javascript only so the server only pushes pages that are pre-canned. I worked with Java for man

[web2py] Re: ProgrammingError: there is no unique constraint matching given keys for referenced table "xuser"

Can I also see your databases/_xauth.table (unpickled)? On May 30, 10:34 pm, Carlos wrote: > Hi, > > I'm using latest trunk, with 'xuser' instead of auth_user (which is not the > issue because I was getting no errors up until very recently). > > Note that everything was working ok (no errors)

[web2py] Re: ProgrammingError: there is no unique constraint matching given keys for referenced table "xuser"

Can I see your model definition for table xauth? On May 30, 10:34 pm, Carlos wrote: > Hi, > > I'm using latest trunk, with 'xuser' instead of auth_user (which is not the > issue because I was getting no errors up until very recently). > > Note that everything was working ok (no errors) up until

[web2py] ProgrammingError: there is no unique constraint matching given keys for referenced table "xuser"

Hi, I'm using latest trunk, with 'xuser' instead of auth_user (which is not the issue because I was getting no errors up until very recently). Note that everything was working ok (no errors) up until 4 changesets ago, i.e. up until changeset # e33d3578be33 (fixed problem with load and string a

[web2py] Re: importing a db/model from other app

I believe you are thinking of appadmin which is a controller in each app.

[web2py] Re: importing a db/model from other app

What I want is not to clone a db or model but to be able to manage one DB from other app. I am trying to do a modified version of the admin app where you just have to chose an option to a target app and it will plug into it working as a backoffice for managers/administrators of that app. if I use

[web2py] Re: error: ('dict' object has no attribute 'startswith'), dal.py in migrate_table at line 703

you are right. good catch! On May 30, 8:34 pm, Carlos wrote: > Sorry, line # 698 (and maybe 699) ... > >   File "C:\web2py\gluon\dal.py", line 4212, in define_table >     polymodel=polymodel) >   File "C:\web2py\gluon\dal.py", line 641, in create_table >     fake_migrate=fake_migrate) >   File "

Re: [web2py] Re: Cannot register or login a user

That line exists in default.py. On Mon, May 30, 2011 at 7:08 PM, Massimo Di Pierro wrote: > LOL. Make sure that you have > > def user(): return dict(form=auth()) > > If still does not work, show us your db.py > > > On May 30, 5:41 pm, rjmolesa wrote: >> I've goofed up my application in some way

[web2py] Re: Postgresql database schema

You could always change the schema before executing the db commands: db.executesql("set search_path to 'schemaname,public';") If you could determine the name of the schema first that would be feasible. On May 30, 5:14 am, Massimiliano wrote: > Hi all, > > I've a legacy enterprise application th

Re: [web2py] Re: Cannot register or login a user

No dice. Let me add that I get the registration and login forms, but that when I hit submit nothing happens. The form clears and reloads. I have 1 entry in auth_user table from when registration worked. Switching to janrain.com authentication also fails. My db.py can be found here http://pastie.tex

[web2py] Re: error: ('dict' object has no attribute 'startswith'), dal.py in migrate_table at line 703

Sorry, line # 698 (and maybe 699) ... File "C:\web2py\gluon\dal.py", line 4212, in define_table polymodel=polymodel) File "C:\web2py\gluon\dal.py", line 641, in create_table fake_migrate=fake_migrate) File "C:\web2py\gluon\dal.py", line 698, in migrate_table sql_fields[key].start

[web2py] Re: GROUP BY Date, Ignore Time

notice you can also do: post_date=db.posts.posted_date.year()|db.posts.posted_date.month()| db.posts.posted_date.day() set = db(db.posts.id).select(db.posts.posted_date, count,groupby=pos_date) in case you need it in more than once place. On May 30, 6:38 pm, Neodudeman wrote: > Awesome. Exactl

[web2py] Re: Email invitation

The problem is: import uuid def invitation(): uuid ... uuid = ... the interpreter thinks the uuid in the function is a local one and not the same uuid defined outside by the import. On May 30, 7:43 pm, Dwayne Blind wrote: > 1.  # coding: utf8 > 2.  import uuid > 3. > 4.  def invi

[web2py] Re: error: ('dict' object has no attribute 'startswith'), dal.py in migrate_table at line 703

I do not think you are running trunk. Do you have this code in dal.py? def fix(item): k,v=item if not isinstance(v,dict): v=dict(type='unkown',sql=v) return k.lower(),v ### make sure all field names are lower case to avoid conflic

[web2py] Re: Email invitation

1. # coding: utf8 2. import uuid 3. 4. def invitation(): 5. 6. form = FORM(INPUT(_name='email', requires=IS_NOT_EMPTY()), 7. INPUT(_type='submit')) 8. 9. if form.accepts(request.vars): 10. uuid=str(uuid.uuid4()) 11. db.invitation.insert(token = uuid) 12.

[web2py] Re: Email invitation

We need to see the code and the error message.

[web2py] Re: GROUP BY Date, Ignore Time

Awesome. Exactly what I needed, thank you. On May 29, 4:14 pm, Massimo Di Pierro wrote: > set = db(db.posts.id).select(db.posts.posted_date, count, > groupby=db.posts.posted_date.year()|db.posts.posted_date.month()| > db.posts.posted_date.day()) > > On May 29, 2:42 pm, Neodudeman wrote: > > > >

Re: [web2py] Thanks to all members for all you time and effort !!

congratulations for complete your course, happy web2py forever... \(^o^)/

[web2py] Re: Thanks to all members for all you time and effort !!

Thank you Resa. We hope to have more of your questions and suggestions on the list. On May 30, 6:24 pm, Resa wrote: > University of the West Indies > > On May 30, 4:05 pm, Massimo Di Pierro > wrote: > > > > > > > > > Can you tell us which school? > > > On May 30, 5:56 pm, Resa wrote: > > > > I`

[web2py] Re: Email invitation

I haved added "import uuid" at the top of myproject/controllers/ invitation.py, but it does not change anything. myproject/models/invitation.py looks like this : db.define_table('invitation',Field('token')) myproject/views/invitation.html looks like this : {{extend 'layout.html'}} {{=form}} Any

[web2py] error: ('dict' object has no attribute 'startswith'), dal.py in migrate_table at line 703

Hi, Running latest trunk, I get the following error (on any request): ('dict' object has no attribute 'startswith') File C:\web2py\gluon\dal.py in migrate_table at line 703 ... sql_fields[key].startswith('INT,') ... Maybe ['sql'] should be added to sql_fields[key] in line # 703 and to

[web2py] Re: Thanks to all members for all you time and effort !!

University of the West Indies On May 30, 4:05 pm, Massimo Di Pierro wrote: > Can you tell us which school? > > On May 30, 5:56 pm, Resa wrote: > > > > > > > > > I`d like to thank the web2py forum members  THANKS for all you > > assistance... finally im finished my course usuing web2py and this >

[web2py] Re: Deploying with default web2py server?

Ok, that answers my question. Thanks alot! On May 30, 3:50 pm, "Sebastian E. Ovide" wrote: > from the book (http://web2py.com/book/default/chapter/11) > > web2py comes with an SSL21 >  enabled web server, the Rocket wsgiserver22

[web2py] Re: Cannot register or login a user

LOL. Make sure that you have def user(): return dict(form=auth()) If still does not work, show us your db.py On May 30, 5:41 pm, rjmolesa wrote: > I've goofed up my application in some way that prevents me from > registering or logging in. How do I fix this please?

[web2py] Re: Thanks to all members for all you time and effort !!

Can you tell us which school? On May 30, 5:56 pm, Resa wrote: > I`d like to thank the web2py forum members  THANKS for all you > assistance... finally im finished my course usuing web2py and this > forum added me in so many ways. what I found very funny was that > at the beginning of my web c

[web2py] Cannot register or login a user

I've goofed up my application in some way that prevents me from registering or logging in. How do I fix this please?

[web2py] Thanks to all members for all you time and effort !!

I`d like to thank the web2py forum members THANKS for all you assistance... finally im finished my course usuing web2py and this forum added me in so many ways. what I found very funny was that at the beginning of my web course when my lecturer told us(my class and I) that we would be using a

[web2py] Thanks to all members for all you time and effort !!

I`d like to thank the web2py forum members THANKS for all you assistance... finally im finished my course usuing web2py and this forum added me in so many ways. what I found very funny was that at the beginning of my web course when my lecturer told us(my class and I) that we would be using a

[web2py] Re: GAE for Dummies - again

Martin, i'm a little confused here, i think you are mixing the SDK with the production GAE. Yes, that error shows when deploying, but it's in reference to the fact that for the code upload to GAE you don't have SSL, nothing to do with ssl on GAE. For what it's worth, https is available on app

[web2py] Re: importing a db/model from other app

Have you tried Massimo's new script? I've been unexpectedly busy in the last few days, but I hope to have time to complete wrapping that script in argparse this evening (or tomorrow) which will have just a few more options that I have found useful (ie. truncate, delete db, copy model, etc.). With

[web2py] Re: Make user its own controller?

you can. def register(): return dict(form=auth.register()) On May 30, 2:12 pm, pbreit wrote: > Can I pull user out of default.py into its own controller? I'm guessing "no" > since things would switch from args to functions. Has anyone tried this?

Re: [web2py] Deploying with default web2py server?

from the book (http://web2py.com/book/default/chapter/11) web2py comes with an SSL21 enabled web server, the Rocket wsgiserver22 . While this is a fast web server, it has limited configuration capabilities. For this

[web2py] Re: Deploying with default web2py server?

depends on the requirements of your system, but in principle the web2py development server is sufficient On 30 mayo, 21:58, ra3don wrote: > I apologize if this has already been answered somewhere. > > Are there any disadvantages to deploying using the default server that > comes with web2py?

[web2py] Re: experimental... .pdf

I think we just need ANY html editor... the only issue are TABLEs. On May 30, 1:06 pm, Jason Brower wrote: > Me thinks of an HTML version in Javascript built into web2py. > Me faints. > --- > Jason > > On 05/30/2011 05:39 PM, Mariano Reingart wrote: > > > > > > > > > @mart: yes, the visual design

[web2py] Aw: Re: Input format "Year/Month"

Hi! Thank you, i'll give it a try ;) regards Gerd

[web2py] Re: drop down box content depends of another drop box

I have exactly the same problem, did you find any solution? On May 11, 3:26 am, pepe_eloy wrote: > Thanks for the answer. > > Yeah, I tried that solution, but when can I save in the table empresa > the fields category and subcategoria only the categoria field has > values. Why? > > Thanks

[web2py] GAE for Dummies - again

Hi, a similar problem After deployment to GAE I got: WARNING appengine_rpc.py:435 ssl module not found. Without the ssl module, the identity of the remote host cannot be verified, and connections may NOT be secure. To fix this, please install the ssl module from http://pypi.python.org/pypi/ssl .

[web2py] Deploying with default web2py server?

I apologize if this has already been answered somewhere. Are there any disadvantages to deploying using the default server that comes with web2py?

[web2py] Re: Email invitation

Nope I don't have import uuid :( Should I ? Where can I read more about uuid ? Thank you On 30 mai, 21:15, pbreit wrote: > Did you get that error before? Do you have "import uuid" in the file?

Re: [web2py] Re: Upload to Insert csv.

Yes I see it now. Thanks. def import_and_sync(): form = FORM(INPUT(_type='file', _name='data'), INPUT(_type='submit')) if form.accepts(request.vars): db.import_from_csv_file(form.vars.data.file,unique=False) # for every table for table in db.tables: #

Re: [web2py] Re: Upload to Insert csv.

Yes; But I was wondering if could be done in one step without saving the file first; just auto importing the uploaded file? On 5/30/11 2:20 PM, pbreit wrote: Something like this: http://web2py.com/book/default/chapter/06?search=csv#Exporting-and-Importing-Data

[web2py] Re: Email invitation

Did you get that error before? Do you have "import uuid" in the file?

[web2py] Make user its own controller?

Can I pull user out of default.py into its own controller? I'm guessing "no" since things would switch from args to functions. Has anyone tried this?

[web2py] Re: Email invitation

There are 15 lines in invitation.py. And line 9 is : "uuid=str(uuid.uuid4())". Thanks On 30 mai, 20:48, pbreit wrote: > Or line 9, rather.

[web2py] Purpose of is_active in auth.signature?

If I use auth.signature in my own tables, I get is_active. Can I use it or is it reserved for something else? I understand it is useful in place of deleting a record?

Re: [web2py] Re: Email invitation

On May 30, 2011, at 9:32 AM, pbreit wrote: > What's not working? One thing I noticed is that the URL in the email is not > going to work because URL() creates a relative URL (/register/uuid). You'll > need to do something like: URL() takes a host argument; that should do the trick. > > message

[web2py] Re: Email invitation

Or line 9, rather.

[web2py] Re: Email invitation

What does your code look like now? And line 16? Does it still include uuid=str(uuid.uuid4()) ?

[web2py] Re: Email invitation

Thanks for your help. This is the error message I get : Internal error Ticket issued: myproject/127.0.0.1.2011-05-30.20-27-41.46efa4bd- a623-4bb9-8a5d-3579d3693c8e Here is the traceback : Traceback (most recent call last): File "gluon/restricted.py", line 181, in restricted File "C:/U

[web2py] Re: importing a db/model from other app

I don't understand the question. Do you want to share the same DB from two different apps? I suppose you could copy the models and then set your DB connection strings to point to the same DB. In one app set migrate=False. You might even be able to symbolically link the models from one app to th

[web2py] Re: Upload to Insert csv.

Something like this: http://web2py.com/book/default/chapter/06?search=csv#Exporting-and-Importing-Data

Re: [web2py] Re: experimental... .pdf

Me thinks of an HTML version in Javascript built into web2py. Me faints. --- Jason On 05/30/2011 05:39 PM, Mariano Reingart wrote: @mart: yes, the visual designer requires only wxpython (and pyfpdf). I'm working on html conversion enhancements and there are some advance on utf-8 support, they w

[web2py] Upload to Insert csv.

I simply want to upload a csv file and then insert that data into the db; I am sure buried somewhere there is a template for a simple web upload to csv insert into DB. If not; Is it possible to load it directly from the web without saving the file on disk first? Thanks in advance for any g

[web2py] importing a db/model from other app

1) How can I import the db/model of one application for another? I've been reading threads like this, on sharing models and I've seen some suggestions on creating a module to export a DB from the source app and the use of the local_import() method. I've tried that, but couldn't make it work. Would

[web2py] Re: how to set a default image for an SQLFORM 'upload' field?

Perfect! Thanks!! These tidbit examples are invaluable! As I learn web2py, I am taking notes of where I get stuck, in order to eventually provide suggestions for improving the doc/manual from the novice's eyes (once you already know everything, it isn't as obvious what's missing). The docum

[web2py] Re: Email invitation

What's not working? One thing I noticed is that the URL in the email is not going to work because URL() creates a relative URL (/register/uuid). You'll need to do something like: message='click http://mysite.com/register/%s to register' % uuid or message='click http://mysite.com/register/%s>regi

[web2py] Re: Multiple tables: update/insert/delete: in one form

Can anybody toss his/her ideas on my code given in the previous post? ---Vineet

[web2py] Email invitation

Dear all, I am trying to implement an email invitation system. # coding: utf8 def invitation(): form = FORM(INPUT(_name='email', requires=IS_NOT_EMPTY()), INPUT(_type='submit')) if form.accepts(request.vars): uuid=str(uuid.uuid4()) db.invitation.ins

[web2py] Re: how to set a default image for an SQLFORM 'upload' field?

I agree. {{=IMG(_src=row.image and URL('download,args=row.image) or URL('static','dummy.png'))}} On May 30, 10:11 am, pbreit wrote: > In my views, I check for an image and if there isn't one, display a dummy. No > sense in storing that for each record.

[web2py] Re: how to set a default image for an SQLFORM 'upload' field?

In my views, I check for an image and if there isn't one, display a dummy. No sense in storing that for each record.

[web2py] Re: Default user.html

Thank you very much. Dwayne On 30 mai, 02:18, Massimo Di Pierro wrote: > You can disable actions if you use third party authentication. > > On May 29, 6:19 pm, Dwayne Blind wrote: > > > > > Hi, > > > The following lines are usual : > > > > > {{=form}} > > {{if request.args(0)=='login':}} > > {

Re: [web2py] Re: recursive tree views

Thanks Stefaan and Vasile for your answers!! I will try with the function :) El lun, 30-05-2011 a las 06:29 -0700, stefaan escribió: > sorry i sent by accident! i hadn't finished editing the code :( > > Since the views allow you to define functions, you I would expect you > can use a recursive

Re: [web2py] Re: experimental... .pdf

@mart: yes, the visual designer requires only wxpython (and pyfpdf). I'm working on html conversion enhancements and there are some advance on utf-8 support, they will be fixed soon. Best regards, Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com Mariano Reingar

[web2py] Re: how to set a default image for an SQLFORM 'upload' field?

Forgot to mention, I need this on google appengine. My hack so far: - create a new DB table, 'default images' db.define_table('default_images', Field('name', requires=IS_NOT_EMPTY()), Field('uploaded','upload', requires=IS_NOT_EMPTY())) - create a admin-only f

[web2py] Re: Input format "Year/Month"

Try this: Field('myfield','date',requires=IS_DATE(format='%Y/ %m'),widget=SQLHTML.wisgets.string.widget) On May 30, 7:24 am, Gerd wrote: > Hi! > > First i'd like to thank Massimo and all other developers/contributors for > the great framework, keep up the good work! > > Now to my question: How c

[web2py] template in crud

Hi all, I have been searching for a customizable way to select and deselect fields. i have found this way tempate_01 = {'myfiled':False, 'myscofield':True} read this values in the db defitionion. Field('myfield', type='text',readable=template_01'myfiled']), is this a good way to do this? Becau

[web2py] Re: Multiple Submits.

form.accepts(request,session) prevents double form submission UNLESS they are actually reloading the page a second time and submitting the newly realoaded page a second time. If this is what they are doing, perhaps the flash notification is not showing for them. Try embed the flash notifcation in t

[web2py] Re: recursive tree views

sorry i sent by accident! i hadn't finished editing the code :( Since the views allow you to define functions, you I would expect you can  use a recursive call to display the child items (warning the following code has never seen a python interpreter): define a function: {{def showtree(tree):}}

[web2py] Re: recursive tree views

Since the views allow you to define functions, you I would expect you can use a recursive call to display the child items (warning the following code has never seen a python interpreter): define a function: {{def showtree(tree):}} {{for i in tree.items:}} Displaying child {{=

Re: [web2py] recursive tree views

I am investigating this area for quite time https://docs.google.com/document/d/1ZOwRUJz4gRPI875rftTfwOBIera1JgZDPulooGjNyu0/edit?hl=en_US you can choose from a few models, but my idea is to preload all rows in controller then to pass them to view in controller: #OrderedTree rows = db(db.tree_ta

[web2py] Input format "Year/Month"

Hi! First i'd like to thank Massimo and all other developers/contributors for the great framework, keep up the good work! Now to my question: How can I create a field that allows input only in the format "/MM". And how should i store the value as date (i thought maybe in the format "/M

[web2py] Re: clarification of usage of auth

OK to answer my own second question: if not auth.has_permission("delete", "mytable"): crud.settings.update_deletable = False On May 29, 9:06 pm, apple wrote: > I have added auth to my application using crud. However there are a > couple of areas where it does not act as I was expecting. > >

Re: [web2py] Username field is editable on profile

Thanks! On Sat, May 28, 2011 at 11:41 PM, Bruno Rocha wrote: > def user(): > if request.args(0)=='profile': > db.auth_user.username.readable = db.auth_user.username.writable = > False > > return dict(form=auth()) > > > -- > Bruno Rocha > [ About me: http://zerp.ly/rochacbruno ] >

Re: [web2py] Postgresql database schema

On 30 May 2011 12:14, Massimiliano wrote: > Existing tables are divided on different database schemas (not only > public). > > Now I want to rewrite a single application that use existing tables on > schema "xyz". > > Does web2py support that? > > I could not get DAL to work with that(different

[web2py] recursive tree views

Hi everyone, I have a question about the views and their posibility to create "tree views" recursively. I want something like this in a view: {{for item in items:}} here goes the main item data. {{if item.childs:}} HERE GOES THE SAME STRUCTURE. {{pass}} {

[web2py] Multiple Submits.

I have noticed that users using mobile web browsers have been submitting forms multiple times; I think this is due to slower mobile networks. What is the best way to prevent multiple form submissions? Thanks.

[web2py] Postgresql database schema

Hi all, I've a legacy enterprise application that use postgresql as database. Existing tables are divided on different database schemas (not only public). Now I want to rewrite a single application that use existing tables on schema "xyz". Does web2py support that? Thank you -- Massimiliano

[web2py] Re: Required password

Thanks!

[web2py] how to set a default image for an SQLFORM 'upload' field?

Haven't been able to find any examples showing how to define a default image for an upload field of a db table (headshot for a person's profile). Is it possible? Does anyone know how? thanks! Luis.

cacheing query (was: Re: [web2py] Re: csv file name and other...)

On 27/05/2011 23:20, Manuele Pesenti wrote: On 27/05/2011 15:53, Anthony wrote: You could cache the query: http://web2py.com/book/default/chapter/06#Caching-Selects the controller I got define a join of some tables and let the user to customize some query parameter such as the filter and the

[web2py] Re: GAE and MySQL

"any suggestion for a free hosting to fully use web2py??? " Have you looked at Amazon EC2 any? You get a year free of a Micro computing instance. That would be a good 'free' hosting alternative. You'll have to set up your server on your own. Plenty of good advice in the web2py book though. On May