Hi Guys,
I have a grid with two more columns with computed fields using below
implementation -
links = [{'header':'column1','body':lambda row: function1(row.id)}]
It displays as I expected, but when I tried to export to csv (csv=True
parameter is set) that column is missing.
Am I missing
Thanks for the tip, sorry it took me so long to say that. I must have
switched off notifications from Google Groups some time in the past.
Hmm, okay so we should probably let existing users know that they can make
that fix and then try the upgrade. By default we will be installing the
latest
If you request a page that doesn't exist, then you are directed to
_create. It would be nice to be able to suppress that behaviour. You have
to be logged in to go on and create the page.
If you call a wiki page inside a view with auth.wiki(slug='mywrongpage') it
does not always redirect
Excellent, thanks very much Nico. Greatly appreciate your work.
On Wednesday, 17 October 2012 22:25:35 UTC+1, Nico Zanferrari wrote:
Hi Hansel.
I've just changed a single line of code in the default PA installation,
following rochacbruno suggestion on
I looking at web2py book here:
http://web2py.com/books/default/chapter/34/05
Tha A helper takes a special argument called cid. It works as follows:
{{=A('linked page', _href='http://example.com', cid='myid')}}
div id=myid/div
and a click on the link causes the content to be loaded in the
hi
Thank you for your explanation. It is really helpful
The address of the chapter in the book is Efficient search by tag and i
choose this approach because i thought that search would be the most
important thing of the application (that was right)
The table tag is similar like in your
I was working for the last few hours on supporting appadmin's queries into
web2admin and these are my conclusions:
- executing queries and displaying them in the same smartgrid table would
complicate the code very much (smartgrid already supports smart queries and the
possibility of using
please check that your link is rendered to something like
a onclick=web2py_component(/app/default/view/1,puppa);return false;
href=/app/default/view/1title/a
If that's the case, and it's not working, then something is off with the
javascript (this functionality relies on web2py.js loaded).
Just noticed that records won't get updated when I call update_or_insert
from scheduler, unless I include commit. Should it be like that?
tbl_a.update_or_insert(...)
tbl_b.update_or_insert(...)
db.commit()
--
Hello,
I have a production application that uses MS SQL Server in a UNIX
environment, running web2py version 1.99.4.
the connection is: dal unixodbc freetds sqlserver.
I'm trying to migrate to web2py version 2.1.1, but fails to connect to the
database:
type
in any external process when you use dal you should commit to save changes.
web2py commits at the end of the request by default, but in the scheduler
(it is an external process, after all) you should do it manually.
You must think to the scheduler as a web2py shell (launched with web2py.py
-M
Links are not included in the csv export. The proper way to do it would be
to use computed fields or virtual fields. Yet the grid must be improved to
support it. Please open a ticket.
massimo
On Friday, 19 October 2012 04:33:37 UTC-5, k0aun9 wrote:
Hi Guys,
I have a grid with two more
I found this [1] that I had asked. I see that the same error occurred with
version 1.99.7
[1] https://groups.google.com/forum/?fromgroups=#!topic/web2py/OlUTguqcqpw
Jose
--
I looked up source and pasted it wholesale here:
a href=/testapp/view/2?_signature=55b3689d7a3d25c3607631da547ad3139b3e47af
onclick=web2py_component(quot;/testapp/view/2?_signature=55b3689d7a3d25c3607631da547ad3139b3e47afquot;,quot;post1234quot;);return
false;Title Title Title/a
It looks
yep, indeed there seems to be a problem in your rendered link. Can you see
if removing user_signature the link works ?
On Friday, October 19, 2012 3:41:24 PM UTC+2, lyn2py wrote:
I looked up source and pasted it wholesale here:
a
Thank you Niphlod!
Every day I thank you, Massimo and everyone who contribute, for a
scheduler, and web2py in general :) The scheduler is now on autopilot,
simulating a workflow and works like a charm... Just loading large data
through it, and will see how will app behave once all is in... We'll
I answer myself
db = DAL http://127.0.0.1:8001/examples/global/vars/DAL(
mssql://CAPC;UID=user;PWD=pwd)
must explain the dsn:
db = DAL http://127.0.0.1:8001/examples/global/vars/DAL(
mssql://dsn=CAPC;UID=user;PWD=pwd)
Jose
--
I upgraded to the newest web2py (2.1.1)
Launch it with:
./web2py.py -i xxx.xxx.xx.xx -p 8000 -c /etc/ssl/certs/cert-file.crt -k
/etc/ssl/certs/key-file.key -a apassword -K applicationName
When I run the -K application (ie scheduler) I am then unable to access the
admin or front end of the
Thanks, worked perfectly. Great work.
--
-K starts the scheduler. Scheduler and webserver are meant to be executed
on different processes.
So, web2py.py -i -p 8000 -a apassword in one shell and web2py.py -K
applicationName in another one.
From 2.0.0 onwards, there is the possibility to start two separate
processes from one
Thanks for that Niphlod.
On Friday, 19 October 2012 11:10:17 UTC-4, Niphlod wrote:
-K starts the scheduler. Scheduler and webserver are meant to be executed
on different processes.
So, web2py.py -i -p 8000 -a apassword in one shell and web2py.py -K
applicationName in another one.
If you request a page that doesn't exist, then you are directed to
_create. It would be nice to be able to suppress that behaviour.
You have to be logged in to go on and create the page.
That could be easily fixed by adding an auth.is_logged_in() check, but what
would be the correct
Python2 is also installed by default, and importantly, /usr/bin/python is
still a symlink to python2.7
--
Is there any advanced documentation on auth.wiki similar to the
plugin_wiki chapter in the book?
AFAIK it's an experimental feature yet which would explain the lack of
documentation. There are some examples posted at this group. We could build
some docs out of the source code, although
I'm working with web2py 2.1.1 and I have the same problem with PowerGrid
What is then __init__.py solution?
Thanks
El martes, 9 de agosto de 2011 11:45:52 UTC+2, peter escribió:
I found the problem, it was caused by having something in _init_.py
Thanks
On Aug 8, 4:10 pm, peter
I am having trouble with manage_group=True, when I enable it i am
getting Invalid Login but without it logins work. Does AD Group
Management in web2py work?
Kind regards,
--
Well it seems that after a lot of research and specially after posting this
question that I found the solution.
I've tried facebook-sdk module and had to modify just one line to make it
work:
facebook.py, line 49:
# Find a JSON parser
try:
import simplejson as json
To
# Find a JSON
Not sure if web2py has anything with this. Could be.
First issue is that CPU jumps up to 100%. I am watching it with htop and
it happens every few minutes, 'apache2' process is using it.
Site becomes unresponsive.
I tried to restart apache several times but it didn't help.
However, after
El viernes, 20 de julio de 2012 14:22:36 UTC-3, Dave escribió:can't get
to the website today
Me neither
--
Ok, now I understand... That should work.
About the suggestion, I have no single key for table and field tuple... The
database table is not normalized and the only way I found so far is to use
a composed pk formed with table and field to refer to unique field entry.
If I had not identical field
Nice!
It works!
Thanks Bruno.
Richard
On Thu, Oct 18, 2012 at 5:54 PM, Bruno Rocha rochacbr...@gmail.com wrote:
Try this:
db.table.field.label = *CAT(*T(dblabels[concat]),
A(I(_class='icon-info-sign'), _href=##, _id=example1, _rel=popover,
**{'_data-content': 'Help comment here!',
I just tried to perform a select() on a mysql table with 700k records. All
available memory on my mac was consumed to the point that I had to kill the
process.
I reduced number of fields just to id, and got the results after some time,
but wondering if there is some better approach in order
_last_id = 0
_items_per_page=1000
for row in db(db.table.id_last_id).select(limitby=(0,_items_per_page),
orderby=db.table.id):
#do something
_last_id = row.id
--
Thank you Vasile for your quick response. This will be perfect.
On Friday, October 19, 2012 2:02:41 PM UTC-4, Vasile Ermicioi wrote:
_last_id = 0
_items_per_page=1000
for row in db(db.table.id_last_id).select(limitby=(0,_items_per_page),
orderby=db.table.id):
#do something
Traceback (most recent call last):
File /home/www-data/test-web2py/gluon/main.py, line 561, in wsgibase
session._try_store_on_disk(request, response)
File /home/www-data/test-web2py/gluon/globals.py, line 703, in
_try_store_on_disk
cPickle.dump(dict(self), response.session_file)
Why is this not working :
CAT(T(dblabels[concat]), *' ',* A(I(_class='icon-info-sign'), _href=##,
_id=example1, _rel=popover, **{'_data-content': T(dbtooltips[concat]),
'_data-original-title': 'Titre du commentaire d\'aide'}) if
dbtooltips[concat]!='' and dbtooltips[concat]!=None else None)
I
doesn't happen here. What are you storing into session ?
On Friday, October 19, 2012 8:26:09 PM UTC+2, Marin Pranjić wrote:
Traceback (most recent call last):
File /home/www-data/test-web2py/gluon/main.py, line 561, in wsgibase
session._try_store_on_disk(request, response)
File
With a SPAN(' ') it get away.
Richard
On Fri, Oct 19, 2012 at 2:30 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Why is this not working :
CAT(T(dblabels[concat]), *' ',* A(I(_class='icon-info-sign'), _href=##,
_id=example1, _rel=popover, **{'_data-content': T(dbtooltips[concat]),
Are you talking about ldap_auth?
On Friday, 19 October 2012 02:38:39 UTC-5, software.ted wrote:
I am having trouble with manage_group=True, when I enable it i am
getting Invalid Login but without it logins work. Does AD Group
Management in web2py work?
Kind regards,
--
So, is the issue closed?
On Friday, 19 October 2012 09:51:40 UTC-5, Jose wrote:
I answer myself
db = DAL http://127.0.0.1:8001/examples/global/vars/DAL(
mssql://CAPC;UID=user;PWD=pwd)
must explain the dsn:
db = DAL http://127.0.0.1:8001/examples/global/vars/DAL(
As in the object
Richard
--
the set returned by select is always a full result set, because it is
extracted and parsed alltogether.
Slicing with limits is good (and recommended, if possible). Just remember
that you can save a lot of time and memory passing cacheable=True to the
select() function. References will be
confirm, web2py.com is down
On Friday, October 19, 2012 7:48:25 PM UTC+1, Richard wrote:
As in the object
Richard
--
Do you have a lazy virtual fields in a table and then store records with
the lazy virtual field in the session?
On Friday, 19 October 2012 13:26:09 UTC-5, Marin Pranjić wrote:
Traceback (most recent call last):
File /home/www-data/test-web2py/gluon/main.py, line 561, in wsgibase
in your code, macaddr is a resultset of your query. Basically it's a list
of Rows objects, done like this
[ {'mac_addr' : value}, {'mac_addr':value1}, {'mac_addr' : value2}]
you should reduce the list of dictionaries to a list of values.
def get_macaddr():
# Grab distinct MAC addresses
I have virtual and lazy fields on auth_user table and I store them in auth
on each request.
Lazy field is the the issue because I store lambda in auth.
I just tried to remove it and it works without it.
So, I have:
if auth.user:
auth.user.something = lambda: ...
And this fails.
I can live
Look like a memory leaks...
Maybe you could profile your app with web2py included profiler...
You just need to add -F profileroutputfile.txt at the end of the
initialization web2py string
Richard
On Fri, Oct 19, 2012 at 1:24 PM, Marin Pranjić marin.pran...@gmail.comwrote:
Not sure if
The problem is that auth stores itself in session (session.auth = auth)
Now sure why this worked before.
Massimo
On Friday, 19 October 2012 14:02:35 UTC-5, Marin Pranjić wrote:
I have virtual and lazy fields on auth_user table and I store them in auth
on each request.
Lazy field is the
What web2py version? What Python version? What apache version? Do you get
the leak running with rocket?
On Friday, 19 October 2012 12:24:07 UTC-5, Marin Pranjić wrote:
Not sure if web2py has anything with this. Could be.
First issue is that CPU jumps up to 100%. I am watching it with htop
I'm afraid, limitby will not work, since it returns limited set, and I
guess it's not possible to dynamically change the limit, so I'll have to
sort of loop through some kind of subqueries, or use the original query
with limited set of fields (takes 60secs for 700k records, not ready to
test on
_last_id = 0
_items_per_page=1000
for row in db(db.table.id_last_id).select(limitby=(0,_items_per_page),
orderby=db.table.id):
#do something
_last_id = row.id
have you tried it and it doesn't work?
do you understand the logic?
--
increase _items_per_page to 20 000
--
It was pointed out by our friend Andriy that web2py has poor pep8
compliance.
So we made a huge number of changes to make it more compliant. We changed
every .py file in web2py using an automated tool (autopep8) except
feedparser, simplejson, fpdf and pyrpf (third party modules).
It now passes
Yes Vasile, I tried, and understand the logic... May change it slightly and
use it as subquery with an offset. The problem is that I'm dealing with
legacy tables that go up to 3 million rows, and have lot of columns that
need to be checked, so your solution will work, and I will be loading data
in
_last_id = 0
_items_per_page=1000
for row in db(db.table.id_last_id).select(limitby=(0,_items_per_page),
orderby=db.table.id):
#do something
_last_id = row.id
you don;t need to change anything to load all data, this code is loading
everything in slices as you need,
all records
should i use
.select(..., cacheable=True)
or
cache.disk('games',lambda:games
what is the difference?
andrej
On Friday, October 19, 2012 1:20:08 PM UTC+2, andrej burja wrote:
hi
Thank you for your explanation. It is really helpful
The address of the chapter in the book is Efficient
El viernes, 19 de octubre de 2012 15:48:26 UTC-3, Massimo Di Pierro
escribió:
So, is the issue closed?
Yes.
Jose
--
My app was working fine with Version 1.99.2. I upgrade to Version 2.1.1 and
it shows this error.
I'm using DB2 for my database. PDTFF is new table defined by web2py so it
has id field but the others are existing and doesn't have id field.
*Traceback (most recent call last):*
File
I dropped the user_signature. Now it looks like:
a href=/testapp/view/2
onclick=web2py_component(quot;/testapp/view/2quot;,quot;post1234quot;);return
false; Title Title Title /a
Still doesn't work.
I'm on Version 2.0.9 (2012-09-17 21:37:10) stable.
On Friday, October 19, 2012 9:51:52 PM
It looks this line failed. Here I simply edit the record provided by user's
select.
form = SQLFORM(db.PDTFF,record)
On Friday, October 19, 2012 3:27:53 PM UTC-5, Omi Chiba wrote:
My app was working fine with Version 1.99.2. I upgrade to Version 2.1.1
and it shows this error.
I'm using
i put it exactly as it is, but it stopped working after 1000 records...
will double check again.
On Fri, Oct 19, 2012 at 3:47 PM, Vasile Ermicioi elff...@gmail.com wrote:
_last_id = 0
_items_per_page=1000
for row in db(db.table.id_last_id).select(limitby=(0,_items_per_page),
also _last_id = row.id after your code inside the loop is required
--
it's missing the outer loop.
_last_id = 0
_items_per_page=1000
while True:
rows = db(db.table.id_last_id).select(limitby=(0,_items_per_page),
orderby=db.table.id)
if len(rows) == 0:
break
for row in rows:
#do something
_last_id = row.id
Should work.
On Friday,
Right now I can't switch to 2.0.9 . Can you try current trunk ?
On Friday, October 19, 2012 10:44:33 PM UTC+2, lyn2py wrote:
I dropped the user_signature. Now it looks like:
a href=/testapp/view/2
onclick=web2py_component(quot;/testapp/view/2quot;,quot;post1234quot;);return
false; Title
My results on the latest git clone,
Version 2.1.1 (2012-10-19 14:59:27) dev
--- The same as before. the quotation marks are still quot;
In addition, I have lost my dropdown menus (response.menu).
I thought maybe I created a new app on the trunk and ported over all my
controllers, models,
It worked when I specified single prymarykey. It's kind of make sense but
why it worked previously and not working current?
db.PDTFF.FFKNCD.requires=IS_NULL_OR(IS_IN_DB(db,db.TDMKNP00.KNKNCD,'%(KNKNNM)s'))
*After*
# Area 2 Master
db.define_table('TDMKNP00',
Field('KNCTCD', length=3),
.select(..., cacheable=True)
does not cache anything. It just generates a simpler Rows object without
methods and without a link to db.
.select(, cache=(cache.ram,3600))
does the caching.
On Friday, 19 October 2012 15:06:06 UTC-5, andrej burja wrote:
should i use
.select(...,
I upgraded to v 2.1.1 and now see problems with module name conflicts due
to the custom importer. Previously I used v2.0.9 without problems.
I have a custom application module named utils.py. This appears to conflict
with the gluon.utils module. I was able to simulate using the basic web2py
I may be slow to catch up on this, since I have *just* upgraded to 2.1.1
(trunk)... but I had to say it!
The admin mobile interface is very cool!
I haven't played with all the features yet though. Working great as far as
I can see.
Thank you guys!
--
On this point, can we have a button on the mobile interface to 'switch'
back to the web interface?
On Saturday, October 20, 2012 6:02:16 AM UTC+8, lyn2py wrote:
I may be slow to catch up on this, since I have *just* upgraded to 2.1.1
(trunk)... but I had to say it!
The admin mobile
something is off with your controller. Try to post a minimalist app to
reproduce the problem, I can't simulate your issue.
On Friday, October 19, 2012 11:35:51 PM UTC+2, lyn2py wrote:
My results on the latest git clone,
Version 2.1.1 (2012-10-19 14:59:27) dev
--- The same as before. the
Seems up for me
On Saturday, October 20, 2012 2:52:15 AM UTC+8, Francisco Costa wrote:
confirm, web2py.com is down
On Friday, October 19, 2012 7:48:25 PM UTC+1, Richard wrote:
As in the object
Richard
--
The issue says fixed, so am I to understand there's now a way to customize
the auth.navbar Welcome message that hasn't been documented yet or was this
simply a fix for the breakage issues?
On Monday, January 30, 2012 6:51:45 AM UTC-8, Anthony wrote:
On Sunday, January 29, 2012 7:36:07 PM
for this url,
http://127.0.0.1:8000/fermer/default/user/login
but works fine with 1.99.4
--
Good catch. Fixed in trunk
On Friday, 19 October 2012 16:54:54 UTC-5, Jim Karsten wrote:
I upgraded to v 2.1.1 and now see problems with module name conflicts due
to the custom importer. Previously I used v2.0.9 without problems.
I have a custom application module named utils.py. This
I assume you mean in the mobile admin demo. I just added as you suggested.
Good idea.
On Friday, 19 October 2012 17:20:28 UTC-5, lyn2py wrote:
On this point, can we have a button on the mobile interface to 'switch'
back to the web interface?
On Saturday, October 20, 2012 6:02:16 AM UTC+8,
It was down but probably a network issue since I could not connect with ssh
either.
On Friday, 19 October 2012 18:07:46 UTC-5, Luther Goh Lu Feng wrote:
Seems up for me
On Saturday, October 20, 2012 2:52:15 AM UTC+8, Francisco Costa wrote:
confirm, web2py.com is down
On Friday, October
Definitely clearer ! ... Thanks a bunch guys ! ...
in conclusion :
whenever one decides to do the conditional model approach for performance
concerns or else ...
database tables better be defined first ! even more so if there are
reference fields in the tables involved! in which case a table
Things appear alright after a quick test drive of trunk here.
~Brian
On Friday, October 19, 2012 2:31:31 PM UTC-5, Massimo Di Pierro wrote:
It was pointed out by our friend Andriy that web2py has poor pep8
compliance.
So we made a huge number of changes to make it more compliant. We changed
Does work. Thank you both very much!
Now that I have thousands of queued/backlogged tasks in a scheduler, I
noticed that my regular tasks, which are of higher priority will be on hold
until everything else gets processed. Maybe, it would be a good idea to
have a field for a priority of a task?
Hi Niphlod,
Thanks for the suggestion, I finally figured out what's wrong. I had the
code $(document).ready(function()... when that was removed, it worked.
On Saturday, October 20, 2012 6:27:01 AM UTC+8, Niphlod wrote:
something is off with your controller. Try to post a minimalist app to
I can't find them in my database...
--
Yes that's one am referring to. The moment I introduce the parameter
manage_groups users fail to login against AD...this is my sample code:
from gluon.contrib.login_methods.ldap_auth import ldap_auth
auth.settings.login_methods = [ldap_auth(mode='ad', manage_groups= True,
bind_dn =
83 matches
Mail list logo