[web2py] Modular application recipes

2016-12-21 Thread Andrea Fae'
Why this line {{=LOAD('default', 'list_items', ajax = True, target ='showitems')}} doens't work in the recipe Modular application in the cookbook web2py? Do you have the same problem? It's not showing the list of items. DO you know some easier tutorial og web2py, otherwise the Di Pierro book an

[web2py] Layout and CSS

2016-12-26 Thread Andrea Fae'
I'm new using web2py. I'd like to know: - where is possible to change the layout of a new applilcazion. What css I can change? There are minimun 3 in static folder! - where is possible to change table html settings in this css file...(you will tell me who will be...) Thank you -- Resources: - h

[web2py] Re: Layout and CSS

2016-12-27 Thread Andrea Fae'
zing:border-box;padding:0}input[type="number"]::-webkit-inner-spin-button,input[type="number"]::-webkit-outer-spin-button{height:auto}input[type="search"]{-webkit-appear How to do? Il giorno lunedì 26 dicembre 2016 20:10:09 UTC+1, Andrea Fae' ha scritto: > &g

[web2py] required=True

2016-12-28 Thread Andrea Fae'
Why if I use this option in Field table database but when I insert and I leave not typed this field the system accepted it? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (R

[web2py] Re: grid exportclasses not work in recent version

2017-01-03 Thread Andrea Fae'
What does it mean exactly? I have this but in the view export is exposed totally... why? grid = SQLFORM.smartgrid(db.sede,linked_tables=['uo'],fields=[db.sede.nome,db.uo.nome],headers={'sede.nome':'Nome Struttura'},details=True, editable=True, deletable=False, maxtextlength=40,csv=True, export

[web2py] Re: grid exportclasses not work in recent version

2017-01-04 Thread Andrea Fae'
Now only csv and xml export are visible. But I have another problemheaders not working Il giorno martedì 3 gennaio 2017 18:26:14 UTC+1, Anthony ha scritto: > > On Tuesday, January 3, 2017 at 11:02:22 AM UTC-5, Andrea Fae' wrote: >> >> What does it mean exactly? >>

[web2py] Smartgrid headers not working

2017-01-04 Thread Andrea Fae'
I have this situation: headers={'sede.nome':'Struttura','sede.is_active':'Attivo'} exportcls = dict(csv_with_hidden_cols=False, xml=True, html=False, json=False, tsv_with_hidden_cols=False, tsv=False) grid = SQLFORM.smartgrid(db.sede,linked_tables=['uo','pc'],fields=[db.sede.nome, d

[web2py] Re: Smartgrid headers not working

2017-01-05 Thread Andrea Fae'
7;: {'sede.nome': 'Struttura', 'sede.is_active': 'Attivo'}} > > Anthony > > On Wednesday, January 4, 2017 at 11:15:29 AM UTC-5, Andrea Fae' wrote: >> >> I have this situation: >> >> headers={'sede.nome':&#

[web2py] add_button to go to the previous page

2017-01-10 Thread Andrea Fae'
I have this situation form = crud.update(db.pc, pc, onaccept=crud.archive, deletable=False, next='lista_pc') form.add_button("Annulla",URL('lista_pc')) I want that button "annulla" go in the previus page, not in the 'lista_pc'. How to do? thank you -- Resources: - http://web2py.com - http:/

[web2py] mixing ldap Active Directory authentication and local authentication

2017-01-12 Thread Andrea Fae'
Hello, I want to use both local and domain AD authentication. I did the job but I want to see Profile and change password ONLY for local users and not for domain users. How to do? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

Re: [web2py] add_button to go to the previous page

2017-01-12 Thread Andrea Fae'
ton("Annulla",URL('default','index')) > > 2017-01-10 8:47 GMT-02:00 Áureo Dias Neto >: > >> with this: >> >> form.add_button("Annulla",URL( 'CONTROLLER' , 'FUNCTION_NAME' )) >> >> 2017-01-10 8:44 GMT-02:

Re: [web2py] add_button to go to the previous page

2017-01-12 Thread Andrea Fae'
gt; On Thursday, January 12, 2017 at 7:55:26 PM UTC+5:30, Andrea Fae' wrote: >> >> I don't know what is the previous page because this page can come from >> different pages...this is the problem...I want to reference the previous >> page... thank you >> >>

[web2py] Re: mixing ldap Active Directory authentication and local authentication

2017-01-14 Thread Andrea Fae'
No people answering? please... Il giorno giovedì 12 gennaio 2017 15:23:28 UTC+1, Andrea Fae' ha scritto: > > Hello, > I want to use both local and domain AD authentication. > I did the job but I want to see Profile and change password ONLY for local > users and not for domai

[web2py] 2012 R2 web2py installation

2017-01-16 Thread Andrea Fae'
Hello, I symply installed: - python 2.7.13 - web2py 2.14.6 from source code on Windows 2012 R2 with IIS installed If I type from cmd "python web2py.py" the GUI interface appears, it ask me the admin password, I type and all is working If I type from cmd "python web2py.py -a 'password' and I star

[web2py] Disable change password after login

2017-01-16 Thread Andrea Fae'
Only for users with a value in "registration_id" I want di disable the change password function. How to do? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] Re: Disable change password after login

2017-01-16 Thread Andrea Fae'
Yes, but how? Where? Il giorno lunedì 16 gennaio 2017 17:03:22 UTC+1, Leonel Câmara ha scritto: > > Append "change_password" to auth.settings.actions_disabled if the user has > a registration_id > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/we

[web2py] Re: 2012 R2 web2py installation

2017-01-18 Thread Andrea Fae'
I need to type "python web2py.py -a "password" with double quote! Il giorno lunedì 16 gennaio 2017 21:04:49 UTC+1, Dave S ha scritto: > > > > On Monday, January 16, 2017 at 2:48:20 AM UTC-8, Andrea Fae' wrote: >> >> Hello, I symply installed: >> -

[web2py] table auth_user already exists

2017-01-18 Thread Andrea Fae'
Why if I delete .table files and log file inside database folder sqlite I have this error? sqlite is or not a only one file? Is it something regarding migrate=true or false? Can I have a better explanation than the book? Thank you -- Resources: - http://web2py.com - http://web2py.c

Re: [web2py] table auth_user already exists

2017-01-19 Thread Andrea Fae'
to migrate=false and fake_migrate=True then set back > migrate=True between these change you have to make a page reload (any page) > of you app... It will force web2py to reanalyse and sync web2py with the > backend. > > Note: In production, you should set migrate to false.... &

Re: [web2py] table auth_user already exists

2017-01-19 Thread Andrea Fae'
morevoer I want to rename the name of auth tables files but this tables are totally standard...I have to modify db.py? Il giorno giovedì 19 gennaio 2017 15:07:38 UTC+1, Andrea Fae' ha scritto: > > It's not working. I want to rename the name of the tables but in > productio

[web2py] rename auth_* table files

2017-01-19 Thread Andrea Fae'
I have this situazione. The auth tables are named like c8b669d15150d7109e5f7ab36744a5b7_auth_user.table the other tables are named like sede.table pc.table etc. I would like to rename auth talbe like "auth_user.table", "auth_permission.table", etc. How to do? Thenks -- Resources: - http://web

[web2py] Re: rename auth_* table files

2017-01-19 Thread Andrea Fae'
Maybe I resulved in this way: auth.define_tables(username=..., signature=..., migrate='',fake_migrate=True) Il giorno giovedì 19 gennaio 2017 15:52:57 UTC+1, Andrea Fae' ha scritto: > > I have this situazione. > The auth tables are named like > c8b669d15150d7109e5f7

[web2py] new DAL

2017-01-19 Thread Andrea Fae'
Can anyone explain exatly this? db = DAL(myconf.get('db.uri'), pool_size=myconf.get('db.pool_size'), migrate_enabled=myconf.get('db.migrate'), check_reserved=['all']) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

[web2py] Conditional validation

2017-01-20 Thread Andrea Fae'
Hello guys, I need to have a dependent field in a table. If the field "is_active" = True then I cannot insert in the field "date" nothing. If the field "is_atvie" = False then I can or not insert something in the field "date". How to do in the definition of table? Or it's better to use "onvalidat

[web2py] Re: Conditional validation

2017-01-21 Thread Andrea Fae'
Where can I find conditional validation documentation? Il giorno venerdì 20 gennaio 2017 17:22:14 UTC+1, Andrea Fae' ha scritto: > > Hello guys, I need to have a dependent field in a table. > If the field "is_active" = True then I cannot insert in the field "dat

[web2py] pass arguments to menu item

2017-01-25 Thread Andrea Fae'
How to pass arguments to menu item? That can be retrieved by a function? Can I have a simple example? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Andrea Fae'
Thanks but it's not the question. I wanted to pass some arguments to function like this... ('Scanner operativi', False, URL('default', 'lista_asset', *args='SC*')), but when I use in the function the system told me in session.flash "Not authorized" and doesn't show me what I want...

[web2py] Re: pass arguments to menu item

2017-01-25 Thread Andrea Fae'
Thanks a lot, but nevertheless it's not working. flash tell me I'm not authorized The function modified is this def lista_asset(): if (request.args(0) == 'SC'): query = (db.asset.tipo=='SC') & (db.asset.is_active==True) else: query = (db.asset.is_active==True) db.a

[web2py] Re: pass arguments to menu item

2017-01-26 Thread Andrea Fae'
You are great! Thank you very much. Il giorno giovedì 26 gennaio 2017 01:06:48 UTC+1, Leonel Câmara ha scritto: > > Yes, I'm sorry Andrea, I don't use the grid much nowadays, that's because > you're using request.args(0) and the grid also uses args, when it sees your > arg it thinks it should be

[web2py] crud.create cancel button

2017-01-27 Thread Andrea Fae'
I tried this form = crud.create(db.ticket, next='lista_ticket',onaccept=lambda form,asset=asset:send_email_ticket(form,asset)) form[0][-1][1].append(TAG.BUTTON('Cancel',_onclick="document.location='%s';"%URL('index'))) But Cancel button doesn't appear. What is wrong? Thank you -- Resource

[web2py] button "share" social - how to delete

2017-01-27 Thread Andrea Fae'
How to don't show the button "share" in the right bottom part of a web2py application? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You rece

[web2py] menu separator line

2018-02-14 Thread Andrea Fae'
How to insert a separator line between 2 menu items? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are s

[web2py] download rows

2018-02-14 Thread Andrea Fae'
Hello, I need to create a page to download rows from a dataset to a file. Is there any automatic possibility (embedded download function is related?) without creating a function and relative view? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://githu

[web2py] Re: download rows

2018-02-14 Thread Andrea Fae'
2018 11:37:17 UTC+1, Andrea Fae' ha scritto: > > Hello, I need to create a page to download rows from a dataset to a file. > Is there any automatic possibility (embedded download function is > related?) without creating a function and relative view? > Thank you >

[web2py] accessing Exchange IMAP email

2018-02-21 Thread Andrea Fae'
I have an exchange server and usually I access to email using "domain\username" and password... using # Replace user, password, server and port in the connection string # Set port as 993 for SSL supportimapdb = DAL("imap://user:password@server:port", pool_size=1) what can I type in the user ?

Re: [web2py] Re: accessing Exchange IMAP email

2018-02-26 Thread Andrea Fae'
e no longer supporting imap as part of the DAL. Nobody was using it > and it is not the right abstraction. > > On Sunday, 25 February 2018 03:02:44 UTC-6, Andrea Fae' wrote: >> >> I'm sorry, but what are you telling me exactly? >> >> 2018-02-25 3:33 GMT

[web2py] Re: $.web2py.component

2018-03-03 Thread Andrea Fae'
_materia')); where is the complete syntax about this? Thanks Il giorno giovedì 18 gennaio 2018 23:59:08 UTC+1, Anthony ha scritto: > > On Thursday, January 18, 2018 at 2:58:47 PM UTC-5, Andrea Fae' wrote: >> >> Anthony, you are very good teacher. But can I have a c

[web2py] Re: $.web2py.component

2018-03-04 Thread Andrea Fae'
Thank you. If I will have time I will analyze the code. Il giorno sabato 3 marzo 2018 22:21:51 UTC+1, Anthony ha scritto: > > On Saturday, March 3, 2018 at 2:14:29 PM UTC-5, Andrea Fae' wrote: >> >> Anthony, what is the difference between >> >> $.web2p

[web2py] new style of welcome app

2018-03-04 Thread Andrea Fae'
I have different apps in my web2py environments. Web2py apps built before a certain date have a stile with "login" link in the right upper side of the web page, while the new apps, for example welcome app are with another style with login link anchor in the left side, just after the menus, and

[web2py] Re: new style of welcome app

2018-03-07 Thread Andrea Fae'
at 12:12:45 PM UTC-5, Andrea Fae' wrote: >> >> I have different apps in my web2py environments. Web2py apps built before >> a certain date have a stile with "login" link in the right upper side of >> the web page, while the new apps, for example welcome app a

Re: [web2py] Re: new style of welcome app

2018-03-09 Thread Andrea Fae'
This is working! Thanks...Why? Il giorno venerdì 9 marzo 2018 12:42:18 UTC+1, alex ha scritto: > > In layout.html, instead of > > > > you can try: > > > > > > > On March 9, 2018 at 05:12:50, Andrea Fae' (and...@gmail.com ) > wrote: > > Y

[web2py] auth.settings.actions_disabled.append('register')

2018-03-10 Thread Andrea Fae'
Sometimes problems arises. I need to eliminate "sign up" menu item from LOGIN but nevertheless I inserted this line auth.settings.actions_disabled.append('register') or this auth.settings.actions_disabled = ['register'] in the db.py I can see the item in the menu, and when I click I see "404

[web2py] Python 3

2018-03-11 Thread Andrea Fae'
Can I really use web2py with Python 3? I fell they are a lot of bugs...Is it better to stay in the version 2? thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Repor

[web2py] bootstrap very bad

2018-03-12 Thread Andrea Fae'
Hello, Why I have very bad format in the dialog and in the forms? label is not on the lef of the field and all is white colourhow to change? Look attached file... thanks you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: bootstrap very bad

2018-03-12 Thread Andrea Fae'
Il giorno lunedì 12 marzo 2018 20:04:57 UTC+1, Andrea Fae' ha scritto: > > Hello, Why I have very bad format in the dialog and in the forms? label is > not on the lef of the field and all is white colourhow to change? Look > attached file... > response.formstyle

[web2py] 'FieldVirtual' object has no attribute 'listable'

2018-03-12 Thread Andrea Fae'
I don't know because I'm sure mounths ago it was working... form = SQLFORM.grid(query, args=[studente], fields=[db.evento.titolo, db.evento.ricorrenza, db.evento.giorno_inizio, db.evento.inizio, db.evento.fine, db.evento.risorsa, db.evento.materia, db.evento.docente],headers=headers,create

[web2py] change button form style

2018-03-15 Thread Andrea Fae'
Can I have any examples about changing some style of form components, like for example buttons, text fields, labels,etc? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

Re: [web2py] auth.settings.actions_disabled.append('register')

2018-03-16 Thread Andrea Fae'
ecessarily complex. Any action could be disabled and that;s a > lot of if statements. > > On Saturday, 10 March 2018 21:34:49 UTC-6, alex wrote: >> >> What about removing this: >> >> > href="{{=URL('default','user/register')}}">{{

Re: [web2py] auth.settings.actions_disabled.append('register')

2018-03-16 Thread Andrea Fae'
In layout.html there is an error... wrong right {{=T('Lost Password')}} Il giorno venerdì 16 marzo 2018 20:07:27 UTC+1, Andrea Fae' ha scritto: > > Do you mean that, like in the other versions, it shoud be e

[web2py] button separation

2018-03-18 Thread Andrea Fae'
Hello, attached there is my login page. I'd like to separate a little bit the 2 buttons "log in" and "password smarrita". They belong to bootstrap btn-default class, but I don't know exactly where I have to change the properties of these class in the application files... Thanks -- Resources: -

[web2py] btn-default

2018-03-27 Thread Andrea Fae'
Where is the definition btn-default in any welcome clone application? I need to change the style...thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) ---

Re: [web2py] btn-default

2018-03-28 Thread Andrea Fae'
On Tue, Mar 27, 2018 at 4:02 PM, Andrea Fae' > wrote: > >> Where is the definition btn-default in any welcome clone application? I >> need to change the style...thanks >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book

[web2py] Login not working on smartphone - no the same menu layout

2018-04-18 Thread Andrea Fae'
this is my application https://andfae.pythonanywhere.com/tcf/default/index I can't login with android. I don't know. I see in the upper right of the smartphone 3 lines but when I click nothing happens...How to fix it? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Docume

[web2py] Re: Login not working on smartphone - no the same menu layout

2018-04-20 Thread Andrea Fae'
Please help me... Il giorno mercoledì 18 aprile 2018 20:31:38 UTC+2, Andrea Fae' ha scritto: > > this is my application > > https://andfae.pythonanywhere.com/tcf/default/index > > I can't login with android. I don't know. I see in the upper right of the >

[web2py] bootstrap.min.js:7 Uncaught Error: Bootstrap tooltips require Tether (http://tether.io/)

2018-04-22 Thread Andrea Fae'
what can I do to include tether in web2py project telling me that bootstrap 4 (worse than bootstrap 3) require tether? Where and what do I have to include? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - http

[web2py] Re: Login not working on smartphone - no the same menu layout

2018-04-22 Thread Andrea Fae'
r error in the console. Il giorno venerdì 20 aprile 2018 21:59:08 UTC+2, Dave S ha scritto: > > > > On Friday, April 20, 2018 at 11:15:52 AM UTC-7, Andrea Fae' wrote: >> >> Please help me... >> >> > I'm not going to be much help, but I can conf

[web2py] web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-22 Thread Andrea Fae'
If you try to use welcome application on web2py 2.16.1 login menu (hamburger icon) is not working. Clicking on it nothing happens...it's a bug. Am I right? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://co

Re: [web2py] web2py 2.16.1 and login menu on mobile systems NOT WORKING

2018-04-22 Thread Andrea Fae'
r bootstrap version, and make some fixes in the > layout bar. > > Testing the trunk I can see that is fixed, but there are some responsive > issues. Is there some issue open about this? If there is no one working I > can send some fixes. > > Greetings. > > El 22/0

[web2py] link to a grid

2018-05-10 Thread Andrea Fae'
Hello I have a grid with certain fields. In a filed there is a name of a pdf file that I have in the folder "static/Etichette". I have a lot of pdf file in this folder and I'd like, when I click this link, to open the related file... This is the grid grid = SQLFORM.grid(db.socio, links = [lambda

[web2py] Re: link to a grid

2018-05-11 Thread Andrea Fae'
gs=[row.etichetta]) > > 'static' is a special value for the controller. > > Anthony > > On Thursday, May 10, 2018 at 6:59:45 AM UTC-4, Andrea Fae' wrote: >> >> Hello I have a grid with certain fields. >> In a filed there is a name of a pdf file that

[web2py] web2py Requires gitpython module

2018-05-13 Thread Andrea Fae'
When I try to "push git " i See the error "requires gitpython module" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message becaus

[web2py] Re: web2py Requires gitpython module

2018-05-14 Thread Andrea Fae'
Yes I installed but it's not working showing me the message below. Il giorno domenica 13 maggio 2018 16:31:41 UTC+2, Andrea Fae' ha scritto: > > When I try to "push git " i See the error "requires gitpython module" > > Requires gitpython module,

[web2py] form fields

2018-05-30 Thread Andrea Fae'
Hello I have a SQLFORM but some of them I populate from other variables and I don't want to change. So I typed field.writable=False... But when I use a custom "onvalidation" function I want to have the content of all the form fields... In request.vars I see some fields but not all In form.vars I

[web2py] Re: form fields

2018-05-31 Thread Andrea Fae'
t;non-writable field values, and make that object available within the >onvalidation function (since those values are not changeable within the >form, there is no reason the values must come from the form submission). > > Anthony > > On Wednesday, May 30, 2018 at 4:28:

[web2py] Re: form fields

2018-06-01 Thread Andrea Fae'
UTC+2, Anthony ha scritto: > On Thursday, May 31, 2018 at 2:27:44 PM UTC-4, Andrea Fae' wrote: >> >> thanks Anthony. Could you give me simple example about second idea? It's >> noy possible to pass variables to a onvalidation funtion? i.e. onvalidation >> doesn

[web2py] remove seconds from datetime picker

2018-06-01 Thread Andrea Fae'
When I select from standard calendar a datetime value it adds :00 seconds! But I don't want, I don't need. How to remove from the datetime field? Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.go

[web2py] Re: remove seconds from datetime picker

2018-06-02 Thread Andrea Fae'
I solved with this var w2p_ajax_date_format = "{{=T('%d/%m/%Y')}}"; var w2p_ajax_datetime_format = "{{=T('%d/%m/%Y %H:%M')}}"; in web2py_ajax.html Il giorno venerdì 1 giugno 2018 23:37:48 UTC+2, Andrea Fae' ha scritto: > > When I sel

[web2py] change form field on the basis of another field

2018-06-02 Thread Andrea Fae'
I have 2 datetime fields in a SQLFORM I want that when I change the date in one the fields, the other field get the same date (not the same time) Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.g

[web2py] multiple conditional fields

2018-06-09 Thread Andrea Fae'
I have this table db.define_table('evento', Field('titolo', requires=[IS_NOT_EMPTY()]), Field('verifica', type='boolean', default=False), Field('inizio', type='datetime', requires=IS_DATETIME(format=T('%d/%m/%Y %H:%M'),error_message='deve essere DD

[web2py] Re: multiple conditional fields

2018-06-10 Thread Andrea Fae'
I tried, but it's not working with 2 fields to get hidden... Il giorno domenica 10 giugno 2018 02:41:12 UTC+2, 黄祥 ha scritto: > > perhaps you can use show_if for conditional field or jquery() > ref: > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#Conditional-fields > > http:

[web2py] fetching events from DB using fullcalendar javascript event calendar

2018-06-10 Thread Andrea Fae'
I'm using web2py and now I'm fetching all calendar events from db using this code in a view: events: [ {{for row in rowseventi:}} { title: '{{=row.evento.titolo}}', id: '{{=row.evento.id}}', resourceId: '{{=row.evento.risorsa}}', start

[web2py] managing latin characters

2018-06-18 Thread Andrea Fae'
How to manage latin character, like italian character like è,é, à, ò If I want to insert for example à it "translate" to “/xe0153" How to wotk with this type of charater...Do I need to change from utf-8 to? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

[web2py] Re: managing latin characters

2018-06-19 Thread Andrea Fae'
Thank you Leonel, but when I try to insert to db for example this name "Donà" in the username field (table auth_user) the system tells me that is not possible...So, what to do? Convert "Donà" in "Dona" without accent? Which characters can I use in the username field? In the book there is only d

[web2py] field username in auth_user

2018-06-19 Thread Andrea Fae'
What kind of characters can we use in this field? Can I use space character in this field? I think no. thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] searchable=True

2018-10-14 Thread Andrea Fae'
Hello, in a grid, if you type searchable=True default) you can search by EVERY field in the grid. But I want to use the search box not to all fields in te view, but only in some of them. Is it possible or I have to create a specific search form? Can you send me some example? Thank you -- Resou

[web2py] Re: searchable=True

2018-10-14 Thread Andrea Fae'
an example, see the default > search function: > https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L2043. > > Anthony > > On Sunday, October 14, 2018 at 4:05:43 PM UTC-4, Andrea Fae' wrote: >> >> Hello, in a grid, if you type searchable=True default) you ca

[web2py] Re: searchable=True

2018-10-15 Thread Andrea Fae'
the URL query string. > > Anthony > > On Monday, October 15, 2018 at 2:39:33 AM UTC-4, Andrea Fae' wrote: >> >> Thank you Anthony, but the code is not easy to understand. could you make >> me an easy example about to create a custom search function? Do I have to >

[web2py] Migrate from sqlite to mysql

2019-02-08 Thread Andrea Fae'
Hello everybody I have some questions about an appllication I want to migrate from SQLite db to MySql in windows: - what version of mysql do I have to install to my PC where I have 2.17 version of web2py? Where can I find? - is it necessary to install drivers or it is still included in my web2py

[web2py] Re: Migrate from sqlite to mysql

2019-02-09 Thread Andrea Fae'
Thank you guys! I will do a test and let you known. Thank you for now. Il giorno sabato 9 febbraio 2019 17:47:53 UTC+1, Ben Lawrence ha scritto: > > And turn off lazy-tables until mysql has built all the tables. > > On Friday, February 8, 2019 at 5:03:29 PM UTC-8, 黄祥 wrote: >> >> - what version o

[web2py] Re: Migrate from sqlite to mysql

2019-02-10 Thread Andrea Fae'
braio 2019 20:40:25 UTC+1, Andrea Fae' ha scritto: > > Thank you guys! > I will do a test and let you known. > Thank you for now. > > > Il giorno sabato 9 febbraio 2019 17:47:53 UTC+1, Ben Lawrence ha scritto: >> >> And turn off lazy-tables until mysql has built

[web2py] Re: Migrate from sqlite to mysql

2019-02-10 Thread Andrea Fae'
but, what happen if I install python 3.7 on windows? Does web2py still use 2.7? Or installinh mysql without this connector? What does you think? Other suggestions? I don't like to use different things because I need to publish my application to pythonanywhere... thanks Il giorno domenica 10 febb

[web2py] Re: Migrate from sqlite to mysql

2019-02-13 Thread Andrea Fae'
Hello! I followed the instruction you wrote me. But at that point:" load web2py app, ensure migrate is true, so that will create the tables defined in web2py" I have this error: Error ticket for "ga"Ticket ID 127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa4-42c2-b1a9-ab14a466e72e Failure to connec

[web2py] error connecting to mysql

2019-02-13 Thread Andrea Fae'
Hello. I have this error when I start application "ga" Error ticket for "ga" Ticket ID 127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa4-42c2-b1a9-ab14a466e72e Failure to connect, tried 5 times: Traceback (most recent call last): File "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init

[web2py] Re: error connecting to mysql

2019-02-14 Thread Andrea Fae'
PLEASE HELP ME THANK YOU Il giorno mercoledì 13 febbraio 2019 21:46:19 UTC+1, Andrea Fae' ha scritto: > > Hello. I have this error when I start application "ga" > > Error ticket for "ga" > Ticket ID > > 127.0.0.1.2019-02-13.20-49-28.fcc1a494-3aa

[web2py] Mysql 8.0.15

2019-02-14 Thread Andrea Fae'
Hello, I'm sorry but I'm not able to use web2py with this type of db. I just installed mysql version 8.0.15 on windows 10 pro and I have connector for Python 3.7 and 2.7 installed I created using mysql.exe a db named 'gadb', without any tables. with web2py I created a new "welcome" application

Re: [web2py] Re: Migrate from sqlite to mysql

2019-02-15 Thread Andrea Fae'
Yesterday night I solved the problem! It was a problem about python driver...with pip I updated and now I juste re-create the database in myslq But trying to import the csv I have now this problem >>> db.import_from_csv_file(open('c:\web2py\ga_export.csv','rb')) Traceback (most recent call last)

[web2py] Re: error connecting to mysql

2019-02-19 Thread Andrea Fae'
I solved the problem. It was a problem regarding foreign keys. I delete this binding and it worked. Thank you the same. Il giorno giovedì 14 febbraio 2019 19:50:21 UTC+1, Andrea Fae' ha scritto: > > This database gadb is without tables. > > Il giorno mercoledì 13 febbraio 20

[web2py] Re: Mysql 8.0.15

2019-02-19 Thread Andrea Fae'
Il giorno giovedì 14 febbraio 2019 20:09:22 UTC+1, Andrea Fae' ha scritto: > > Hello, I'm sorry but I'm not able to use web2py with this type of db. > > I just installed mysql version 8.0.15 on windows 10 pro and I have > connector for Python 3.7 and 2.7 installed

[web2py] Re: Migrate from sqlite to mysql

2019-02-19 Thread Andrea Fae'
nector.connect(host='localhost',database='mysql',user='root', > password='') > and it is success. > > What could be the reason of that error? > > Thanks. > > On Wednesday, February 13, 2019 at 10:55:32 PM UTC+3, Andrea Fae' wrote:

[web2py] mysql import from csv problem

2019-02-19 Thread Andrea Fae'
Hello, when I import with this procedure https://www.pythonanywhere.com/forums/topic/1288/ from csv to mysql, it alter the ids of some related tables and I have data not corresponding to the original exported csv. What can I do? What is my error? is it depending on charset or something related?

[web2py] creating tables with web2py console and mysql

2019-02-19 Thread Andrea Fae'
Hello, why I have this warning? c:\web2py>python web2py.py -S ga2 -M -P web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2019 Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 Database drivers available: pymysql, imaplib, sqlite3, pg8000, pyodbc, mysqlconnector C:\Python27\lib\

[web2py] custom search

2019-04-25 Thread Andrea Fae'
I create a custom search, so not standard field with "Search" and "reset" button standard. How to click the button "Search" programmatically? thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] custom widget search form

2019-04-25 Thread Andrea Fae'
Can anyone help me giving me an example of custom widget search form? Better with default values and if is it possible to click "Search" programmatically. Thank you very much -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source cod

[web2py] datepicker preserve selecred date after postback

2019-04-25 Thread Andrea Fae'
How to preserve datepicker selected date after postback using web2py in a javascript view... I think it's a javascript problem but I don't know how to fix it. thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - h

[web2py] Re: datepicker preserve selecred date after postback

2019-04-26 Thread Andrea Fae'
} else { > window.location.href = "{{ > url = 'https://' if request.is_https else > 'http://' > url += request.env.http_host + request.url + '/' > =url

[web2py] Re: custom search

2019-04-26 Thread Andrea Fae'
ns, but have a search button created by > you? > > > quinta-feira, 25 de Abril de 2019 às 15:21:41 UTC+1, Andrea Fae' escreveu: >> >> I create a custom search, so not standard field with "Search" and "reset" >> button standard. How to click the button

[web2py] How to intercept the click to the button "search"

2019-04-26 Thread Andrea Fae'
Hello, is it possible to intercept the event regarding click to the standard button search? thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You

[web2py] Re: datepicker preserve selecred date after postback

2019-04-26 Thread Andrea Fae'
Il giorno giovedì 25 aprile 2019 21:40:25 UTC+2, Andrea Fae' ha scritto: > > How to preserve datepicker selected date after postback using web2py in a > javascript view... I think it's a javascript problem but I don't know how > to fix it. > thank you > -

[web2py] response.files.append or insert syntax

2017-02-05 Thread Andrea Fae'
What is the meaning and syntax of lines like this? Where I can find? response.files.append(URL(r=request,c='static',f='myview.css') Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

[web2py] Fullcalendar questions

2017-02-05 Thread Andrea Fae'
I want to use this add-on with web2py https://fullcalendar.io/scheduler/ How to load resource data from a database, for example? I need scheduler information with web2py. Is there any person with experience using this add-on? Thank you -- Resources: - http://web2py.com - http://web2py.com/book

  1   2   3   >