[web2py] Re: I am unable to change the hover background color in my menu. How do I do it?

[Sneka R]

You have to do it in bootstrap.min.css file
Find the line:
.navbar-default .navbar-nav > li > a:hover, .navbar-default .navbar-nav > 
li > a:focus {
color: #ff
background-color: transparent
}

Change the color to your choice of color.



On Saturday, June 18, 2016 at 1:08:16 AM UTC-5, Emmanuel Dsouza wrote:
>
> As you can see it becomes complete white. How to change it to say, 
> lightblue?
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Size of SQLFORM.grid items

[Sneka R]

Where do we set the maxtextlength?

On Tuesday, June 14, 2016 at 4:46:05 AM UTC-5, Jitun John wrote:
>
> Thanks a lot Anthony. Works like Charm.
>
> On Monday, June 13, 2016 at 8:42:16 PM UTC+5:30, Anthony wrote:
>>
>> As per the documentation:
>>
>>
>>- maxtextlength sets the maximum length of text to be displayed for 
>>each field value, in the grid view. This value can be overwritten for 
>> each 
>>field using maxtextlengths, a dictionary of 
>>'tablename.fieldname':length e.g. {'auth_user.email' : 50}
>>
>> Anthony
>>
>> On Monday, June 13, 2016 at 10:41:15 AM UTC-4, Jitun John wrote:
>>>
>>>
>>> 
>>>
>>>
>>> Above is a simple SQL.grid I have used.
>>> I added "headers={'store_log_stats.cluster_name' : 
>>> 'Cluster__Name'}," to make sure that the 
>>> column had enough space.
>>> But even with enough space, the data is concatenated.
>>> Actual names are "Cluster-LH-P4530-13-14", "Cluster-LH-P4530-11-12"
>>>
>>> Just wondering how to make sure the Cluster name is displayed in full.
>>>
>>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Size of SQLFORM.grid items

[Sneka R]

Thanks a lot.

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Size of SQLFORM.grid items

[Sneka R]

Thanks a lot.

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to export sqlform.grid with the labeled column names

[Sneka R]

I am new to web2py. Which file should I make these changes?
Thanks.

On Friday, July 15, 2016 at 10:45:01 PM UTC-5, Jordan Myers wrote:
>
> Hey everyone,
>
> so the default csv exporters for sqlform.grid will use the headers as the 
> 'database' names, but I would rather it use the field.label instead. For 
> example, take this table:
>
> db.define_table('my_table', Field('ugly_name', label='Pretty Name'))
>
> A sqlform.grid on my_table will display the column with the header Pretty 
> Name, but when exporting to csv, the header becomes my_table.ugly_name.  Is 
> there an easy way to export to csv with the columns "as seen" i.e. with the 
> labeled names? I tried writing my own exporter, but it does not preserve 
> the searching/sorting order. I suppose I could try to implement that 
> myself, but that is a last resort.
>
> 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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to export sqlform.grid with the labeled column names

[Sneka R]

Followed your instructions, but I am getting this Traceback
Traceback

1.
2.
3.
4.
5.
6.
7.

Traceback (most recent call last):
  File "/Users/sraveend/Documents/web2py/gluon/restricted.py", line 227, in 
restricted
exec ccode in environment
  File 
"/Users/sraveend/Documents/web2py/applications/ncmi/controllers/project_proposal.py"
 
,
 line 1, in 
from custom_exporter import ExporterCSVlabel
ImportError: cannot import name ExporterCSVlabel


On Friday, July 15, 2016 at 10:45:01 PM UTC-5, Jordan Myers wrote:
>
> Hey everyone,
>
> so the default csv exporters for sqlform.grid will use the headers as the 
> 'database' names, but I would rather it use the field.label instead. For 
> example, take this table:
>
> db.define_table('my_table', Field('ugly_name', label='Pretty Name'))
>
> A sqlform.grid on my_table will display the column with the header Pretty 
> Name, but when exporting to csv, the header becomes my_table.ugly_name.  Is 
> there an easy way to export to csv with the columns "as seen" i.e. with the 
> labeled names? I tried writing my own exporter, but it does not preserve 
> the searching/sorting order. I suppose I could try to implement that 
> myself, but that is a last resort.
>
> 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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: How to export sqlform.grid with the labeled column names

[Sneka R]

Actually I added the following line on top of the custom_exporter.py file
import cStringIO

On Friday, July 15, 2016 at 10:45:01 PM UTC-5, Jordan Myers wrote:
>
> Hey everyone,
>
> so the default csv exporters for sqlform.grid will use the headers as the 
> 'database' names, but I would rather it use the field.label instead. For 
> example, take this table:
>
> db.define_table('my_table', Field('ugly_name', label='Pretty Name'))
>
> A sqlform.grid on my_table will display the column with the header Pretty 
> Name, but when exporting to csv, the header becomes my_table.ugly_name.  Is 
> there an easy way to export to csv with the columns "as seen" i.e. with the 
> labeled names? I tried writing my own exporter, but it does not preserve 
> the searching/sorting order. I suppose I could try to implement that 
> myself, but that is a last resort.
>
> 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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: cannot disable automatic login after registration

[Sneka R]

Yes. I have no success too.
Any help is appreciated.

On Saturday, October 24, 2015 at 7:30:52 PM UTC-5, Pierre wrote:
>
> Hi everyone,
>
> I tried to do it with no success with this:
>
> auth.settings.login_after_registration = False
>
> thanks for your help
>
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] show_if issue

[Sneka R]

Can I use show_if for 2 tables?
For example:
db.table2.field.show_if = (db.table1.box==True)

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: show_if issue

[Sneka R]

Is this possible at all?



On Sunday, July 24, 2016 at 5:32:43 PM UTC-5, Sneka R wrote:
>
> Can I use show_if for 2 tables?
> For example:
> db.table2.field.show_if = (db.table1.box==True)
>
> To be more clear:
> Model:
> db.define_table(’table1’,
>  Field('title’,label=‘Workshop title 
> :',requires=IS_NOT_EMPTY()),
>  Field(’help1’,’boolean’,label=’Need help?’))
>
>
> db.define_table(’table2',
> Field(’title', 'reference table1',label='Workshop title 
> :'),
> Field(‘help2’,’boolean’, label=’Need help?'))
>
> Controller:
> def register_workshop(): 
> workshop = db.table1(request.args(0))
> db.table2.help2.show_if = (db.table1.help1==True)
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: show_if issue

[Sneka R]

It worked initially and do not work now.
The field help2 is visible even if the field help1==False

How do I do this?
Please I need help in figuring this out.


On Sunday, July 24, 2016 at 5:32:43 PM UTC-5, Sneka R wrote:
>
> Can I use show_if for 2 tables?
> For example:
> db.table2.field.show_if = (db.table1.box==True)
>
> To be more clear:
> Model:
> db.define_table(’table1’,
>  Field('title’,label=‘Workshop title 
> :',requires=IS_NOT_EMPTY()),
>  Field(’help1’,’boolean’,label=’Need help?’))
>
>
> db.define_table(’table2',
> Field(’title', 'reference table1',label='Workshop title 
> :'),
> Field(‘help2’,’boolean’, label=’Need help?'))
>
> Controller:
> def register_workshop(): 
> workshop = db.table1(request.args(0))
> db.table2.help2.show_if = (db.table1.help1==True)
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Cannot access the Administrative interface

[Sneka R]

I have been using administrative interface(localhost) without any problem. 
I tried several password and I got locked out. 
Now it is giving this error:
admin disabled because unable to access password file

How do I fix this?
Any help is appreciated.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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Cannot access the Administrative interface

[Sneka R]

hosts.deny file is empty.



On Wednesday, July 27, 2016 at 9:32:56 AM UTC-5, Sneka R wrote:
>
> I have been using administrative interface(localhost) without any problem. 
> I tried several password and I got locked out. 
> Now it is giving this error:
> admin disabled because unable to access password file
>
> How do I fix this?
> Any help is appreciated.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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Cannot access the Administrative interface

[Sneka R]

Yes. There is.

On Wednesday, July 27, 2016 at 9:32:56 AM UTC-5, Sneka R wrote:
>
> I have been using administrative interface(localhost) without any problem. 
> I tried several password and I got locked out. 
> Now it is giving this error:
> admin disabled because unable to access password file
>
> How do I fix this?
> Any help is appreciated.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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: show_if issue

[Sneka R]

When I used the second choice, I got the following Traceback:
Traceback

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.

Traceback (most recent call last):
  File "/Users/SR/Documents/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/Users/SR/Documents/web2py/applications/myapp/controllers/events.py" 
<http://127.0.0.1:8000/admin/default/edit/ncmi/controllers/events.py>, line 
417, in 
  File "/Users/SR/Documents/web2py/gluon/globals.py", line 417, in 
self._caller = lambda f: f()
  File "/Users/SR/Documents/web2py/gluon/tools.py", line 4241, in f
return action(*a, **b)
  File "/Users/SR/Documents/web2py/applications/myapp/controllers/events.py" 
<http://127.0.0.1:8000/admin/default/edit/ncmi/controllers/events.py>, line 
220, in register_workshop
fields =['title','help2'])
  File "/Users/SR/Documents/web2py/gluon/sqlhtml.py", line 1288, in __init__
inp = self.widgets.boolean.widget(field, default)
  File "/Users/SR/Documents/web2py/gluon/sqlhtml.py", line 278, in widget
**attributes)
  File "/Users/SR/Documents/web2py/gluon/sqlhtml.py", line 160, in _attributes
trigger, cond = show_if(field.show_if)
  File "/Users/SR/Documents/web2py/gluon/sqlhtml.py", line 112, in show_if
base = "%s_%s" % (cond.first.tablename, cond.first.name)
AttributeError: 'Query' object has no attribute 'tablename'


On Sunday, July 24, 2016 at 5:32:43 PM UTC-5, Sneka R wrote:
>
> Can I use show_if for 2 tables?
> For example:
> db.table2.field.show_if = (db.table1.box==True)
>
> To be more clear:
> Model:
> db.define_table(’table1’,
>  Field('title’,label=‘Workshop title 
> :',requires=IS_NOT_EMPTY()),
>  Field(’help1’,’boolean’,label=’Need help?’))
>
>
> db.define_table(’table2',
> Field(’title', 'reference table1',label='Workshop title 
> :'),
> Field(‘help2’,’boolean’, label=’Need help?'))
>
> Controller:
> def register_workshop(): 
> workshop = db.table1(request.args(0))
> db.table2.help2.show_if = (db.table1.help1==True)
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: show_if issue

[Sneka R]

Thanks.
I am new to programming. 
I want to create a form based on the field selections from another table.
How can I accomplish this using web2py?
Thanks in advance.



On Sunday, July 24, 2016 at 5:32:43 PM UTC-5, Sneka R wrote:
>
> Can I use show_if for 2 tables?
> For example:
> db.table2.field.show_if = (db.table1.box==True)
>
> To be more clear:
> Model:
> db.define_table(’table1’,
>  Field('title’,label=‘Workshop title 
> :',requires=IS_NOT_EMPTY()),
>  Field(’help1’,’boolean’,label=’Need help?’))
>
>
> db.define_table(’table2',
> Field(’title', 'reference table1',label='Workshop title 
> :'),
> Field(‘help2’,’boolean’, label=’Need help?'))
>
> Controller:
> def register_workshop(): 
> workshop = db.table1(request.args(0))
> db.table2.help2.show_if = (db.table1.help1==True)
>

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] files vanished

[Sneka R]

Hi,
I have been using web2py for few days now. All the files I have created has 
vanished. What happened?

-- 
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 subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Uploaded new layout plugin in my app and the dropdown menu stopped working.

[Sneka R]

I downloaded a new layout plugin for my app. The dropdown menu stopped 
working after that. I am a newbie and need help.
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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: Uploaded new layout plugin in my app and the dropdown menu stopped working.

[Sneka R]

In the administrative interface there is a button "Download layout from 
repository". So I downloaded a layout and uploaded it to my app directory.
Before I uploaded I had the default layout that came with web2py and the 
dropdown menu worked but after the new layout upload the dropdown menu is 
not working.

On Friday, April 15, 2016 at 3:50:36 PM UTC-5, Sneka R wrote:
>
> I downloaded a new layout plugin for my app. The dropdown menu stopped 
> working after that. I am a newbie and need help.
> 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)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.