[web2py] Re: IS_IN_SET(['Myriad, Trebuchet MS, sans-serif','Helvetica Neue, Helvetica' ...

2012-10-26 Thread Annet
Thanks for your reply. font-family: {{=XML(session.customtheme. bodyFontFamily)}}; ... solves the problem. Kind regards, Annet --

[web2py] SQLFORM.factory(db.table) date format problem.

2012-10-26 Thread Annet
In a table person I have the following validator on date of birth: isdate = dict(type='date',requires=IS_DATE(format='%Y-%m-%d'),represent = lambda v: v.strftime('%d/%m/%Y') if v else '') In appadmin and in form.crud.update(table=db.person, record=row) the date is represented correctly,

[web2py] on_define=set_requirement does not work

2012-10-26 Thread Annet
On a tabel tie: db.define_table('tie', Field('hubID','reference node',**isnode), Field('nodeID','reference node',default='',ondelete='CASCADE',notnull=True), ... on_define=set_requirement, migrate=False) I defined the following validator: def set_requirement(tie):

[web2py] Re: SQLFORM.factory(db.table) date format problem.

2012-10-26 Thread Niphlod
I am definitely missing something. appadmin and crud.update are ok (they are fine also in my environment). SQLFORM.factory(db.person) is fine too. I don't get when you say when I submit the update SQLFORM.factory has no database interactions. On Friday, October 26, 2012 8:19:45 AM UTC+2,

[web2py] Re: Is the Windows download meant to have a wsgihandler.py file

2012-10-26 Thread Niphlod
you need the source version to embed your app into apache. On Friday, October 26, 2012 4:18:56 AM UTC+2, Andrew W wrote: Trying to run the windows app with Apache, but it doesn't have the wsgihandler.py file. Can this version run with Apache, or do I need the source version. What should

[web2py] Re: downloading a synthetic csv

2012-10-26 Thread Niphlod
do you serve a StringIO instance ? for 2. you may try response.stream(yourcsvinstance, filename='foo.csv', attachment=True) On Friday, October 26, 2012 1:13:17 AM UTC+2, Jonathan Lundell wrote: I want to build a dataset (list of lists) in response to a user request and cause a csv of that

[web2py] GWT, CSS and Web2Py

2012-10-26 Thread Carl
Is anyone using GWT to build clients to work with Web2py server apps? I'm copying my GWT WAR directory into my Web2y's server's STATIC directory but what's the best way to manage GWT's CSS file? --

Re: [web2py] downloading a synthetic csv

2012-10-26 Thread José Luis Redrejo
2012/10/26 Jonathan Lundell jlund...@pobox.com I want to build a dataset (list of lists) in response to a user request and cause a csv of that dataset to be downloaded. I have a working but ugly implementation that uses @service.csv. If I access the URL

[web2py] Re: Geolocation

2012-10-26 Thread Jacinto Parga
Sorry, I didn't get it. Could you please write the controller? Thanks El domingo, 21 de octubre de 2012 00:52:24 UTC+2, Massimo Di Pierro escribió: You can try something like jQuery.post({'url':'{{=URL('youraction')}}','data':'a='+position.coords.latitude + b +

[web2py] Web2Py 2.09 now standard on PythonAnywhere

2012-10-26 Thread Hansel Dunlop
Hi everyone, Just a note to let you know that we have upgraded the default install of Web2py on PythonAnywhere https://www.pythonanywhere.com is now 2.09. It also upgrades to the 2.2.1 inside the admin interface which was impressive. Thanks to the devs for their assistance and advice during

Re: [web2py] page min height

2012-10-26 Thread Richard Vézina
I look at the demo and the footer is not at the bottom... I already wrote the code for sticky footer base on this tutorial (in french sorry) : http://fvsch.com/code/page-hauteur-100/ I will extract it and put it in a dummy app. Richard On Thu, Oct 25, 2012 at 8:58 PM, Paolo Caruccio

Re: [web2py] Re: downloading a synthetic csv

2012-10-26 Thread Jonathan Lundell
On 26 Oct 2012, at 2:46 AM, Niphlod niph...@gmail.com wrote: do you serve a StringIO instance ? for 2. you may try response.stream(yourcsvinstance, filename='foo.csv', attachment=True) I don't; I'm just returning a list of tuples to the Service wrapper (eventually I'd make it a generator, was

[web2py] Cant get Janrain working

2012-10-26 Thread Simon Carr
Hi All, I am trying to get Janrain work. I have signed up for a free account on their site. Here is my model code. ## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc. ## register with janrain.com, write your domain:api_key in private/janrain.key from

[web2py] Re: Formatter and values=None problem

2012-10-26 Thread Paolo Caruccio
In my opinion, you have mainly two options to bypass None value check that formatter function in DAL does: option 1 : store None in database, delete formatter from validator, use represent in table field (I prefer this approach) class IS_ELAPSED_TIME(object): def

Re: [web2py] Cant get Janrain working

2012-10-26 Thread Marco Túlio Cícero de M . Porto
on 0.py try something like this settings.login_method = 'janrain' settings.login_config = 'teste:a33eb64c93717b9e34d7ab018563c91a15f1baa2' settings.plugins = [] where teste is your domain on janrain (to get that,k you need to signup janrain engage - http://janrain.com/products/engage/ ). And the

Re: [web2py] Cant get Janrain working

2012-10-26 Thread Simon Carr
Thanks for the Response Marco. Can you explain what 0.py is? Are you saying that I should not configure Janrain in db.py? Simon On Friday, 26 October 2012 19:00:33 UTC+1, Marco Tulio wrote: on 0.py try something like this settings.login_method = 'janrain' settings.login_config =

[web2py] Manual upload to database fails to write blob

2012-10-26 Thread David Phillips
I am attempting to create and store a thumbnail image in a MySQL database. The source image comes from the same record and has already been stored in the database. When my code executes, the thumbnail name gets written to the thumb field, but the thumb_data field is null. My table is defined

[web2py] WIKI or plugin wiki?

2012-10-26 Thread Simon Carr
I notice in Web2Py 2.x the index function in Default offers the suggestion of returning auth.wiki I was assuming that this was just plugin wiki now built into the core. But I notice that there is no widget option and no WYSIWYG editor when creating a new page. Should I continue to plugin wiki

Re: [web2py] Web2py 2.1.1 csv import bug or ?

2012-10-26 Thread Tito Garrido
Just tested and it is still happening in 2.2.1 On Mon, Oct 22, 2012 at 8:21 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Fixed in 2.2.1 On Monday, 22 October 2012 18:02:29 UTC-5, Tito Garrido wrote: I have the same problem... is it a bug? On Wed, Oct 17, 2012 at 5:51 AM,

[web2py] Display a list of dictionaries as an html table

2012-10-26 Thread Daniel Gonzalez
Hello, I am generating some data on the fly (no database), which I would like to display using a controller / view. The data is organized as a list of dictionaries, like this: headers = [ 'header1', 'header2' ] data = [ { 'col1' : 'valA', 'col2' : 'valB' }, { 'col1' : 'valC', 'col2' :

[web2py] Re: how to hide the [wiki] menu option in auth.wiki

2012-10-26 Thread Andrew W
Looking at the change, it looks like a non logged in person can still see [Wiki]. Could I suggest that the append statement comes inside the if self.auth.user test: if self.auth.user: menu.append((current.T('[Wiki]'), None, None, submenu)) On Friday, October 26, 2012 2:22:36 AM UTC+13,

[web2py] Re: Display a list of dictionaries as an html table

2012-10-26 Thread Niphlod
not very tably as a table structure headers are not related to the data keys, and col1 and col2 aren't strictly ordered, then you have to force the order yourself. However, one of the following (exact same output) {{=TABLE( THEAD(TR([TH(h) for h in headers])),

Re: [web2py] downloading a synthetic csv

2012-10-26 Thread Jonathan Lundell
On 26 Oct 2012, at 6:40 AM, Jonathan Lundell jlund...@pobox.com wrote: On 26 Oct 2012, at 2:46 AM, Niphlod niph...@gmail.com wrote: do you serve a StringIO instance ? for 2. you may try response.stream(yourcsvinstance, filename='foo.csv', attachment=True) I don't; I'm just returning a list

[web2py] Re: WIKI or plugin wiki?

2012-10-26 Thread Niphlod
can't say if plugin_wiki is going to be updated further, but auth.wiki() is embedding quite a pack of features nonetheless. If you need more features, stick with plugin_wiki. PS: plugin_wiki never had a WYSIWYG editor, just an editor with shortcuts buttons for bold, italics, list, etc. Markmin

[web2py] Re: WIKI or plugin wiki?

2012-10-26 Thread HittingSmoke
I feel like I read Massimo say somewhere that plugin_wiki will be deprecated when auth.wiki is more complete and documented but don't quote me on that. On Friday, October 26, 2012 1:57:29 PM UTC-7, Niphlod wrote: can't say if plugin_wiki is going to be updated further, but auth.wiki() is

[web2py] Re: WIKI or plugin wiki?

2012-10-26 Thread Simon Carr
Many Thanks for the response, After doing more reading and trying both of them, I am starting to see the benefit of auth.wiki(). I would like to say thanks to everyone working on Web2Py for making it all so accessible and easy to use. I am looking forward to finding something I can do as a

[web2py] Re: Append to list:reference or list:string with update_record

2012-10-26 Thread howesc
i don't believe that it is possible. you need to read the list, append to it, and then update_record with the full list. On Thursday, October 25, 2012 4:05:11 PM UTC-7, Mark Li wrote: Is it possible to append to a database list (like list:reference or list:string) with update_record, as

[web2py] Getting an error in auth.wiki()

2012-10-26 Thread Simon Carr
I know I have already been talking about auth.wiki() in another thread but this is a different questions, so thought I should start a new thread. When I create a new page the following link to that page is created localhost/simoncarr/default/contactme when I click it I get the error invalid

Re: [web2py] Re: Image Tutorial and linked_tables

2012-10-26 Thread Jim Steil
Ok, I made a sample app from scratch. I added the db code to the default db.py and added the model to to default.py. Here is what I added to db.py: db.define_table('image', Field('title', unique=True), Field('file', 'upload'), format = '%(title)s') db.define_table('comment',

[web2py] Re: Getting an error in auth.wiki()

2012-10-26 Thread HittingSmoke
Default is your controller. You're running auth.wiki under the index function of the default controller. Your auth.wiki pages are called with auth.wiki so you need your index function which is where auth.wiki is. You could hide the function part of the URL using routing if you want. On Friday,

Re: [web2py] page min height

2012-10-26 Thread HittingSmoke
Sticky footers are not well supported in CSS. There are several popular implementations and are all hacked together workarounds, most of which use javascript and nearly all of which break very easily and have poor cross-browser compatibility. I wouldn't want to see something like this baked

Re: [web2py] Re: routes.py not working in 2.0.9

2012-10-26 Thread Massimo Di Pierro
Will check and fix this asap On Thursday, 25 October 2012 11:02:39 UTC-5, LightOfMooN wrote: Current pattern-based system is perfect. We made more than 20 projects with it. But it does not work on new web2py version (2.2.1). We used 1.99.7 before. четверг, 25 октября 2012 г., 18:23:13

[web2py] Re: BUG: appadmin cannot save to db

2012-10-26 Thread Massimo Di Pierro
Is this issue still open? If so, please open a ticket. On Thursday, 25 October 2012 10:01:32 UTC-5, lyn2py wrote: I'm on Version 2.2.1 (2012-10-22 18:50:13) stable This is specific to *database admin *in *appadmin.* I needed to change some data, but appadmin will not save the items,

Re: [web2py] Web2py 2.1.1 csv import bug or ?

2012-10-26 Thread Massimo Di Pierro
Please open a google code ticket. On Friday, 26 October 2012 14:32:35 UTC-5, Tito Garrido wrote: Just tested and it is still happening in 2.2.1 On Mon, Oct 22, 2012 at 8:21 PM, Massimo Di Pierro massimo@gmail.comjavascript: wrote: Fixed in 2.2.1 On Monday, 22 October 2012

[web2py] Re: WIKI or plugin wiki?

2012-10-26 Thread Massimo Di Pierro
auth.wiki is better because of integration with oembed, web2py components and group based permissions. It is not documented at all yet. On Friday, 26 October 2012 17:47:54 UTC-5, HittingSmoke wrote: I feel like I read Massimo say somewhere that plugin_wiki will be deprecated when auth.wiki

[web2py] Re: about editing database

2012-10-26 Thread alazar baharu
hello lyn2py can you help me go through this please? On Sunday, October 21, 2012 12:04:17 AM UTC-7, alazar baharu wrote: On Friday, October 19, 2012 11:50:20 PM UTC-7, alazar baharu wrote: hello every on e am developing a simple office space management information system using web 2py and i