On Tue, Mar 16, 2010 at 4:11 PM, mdipierro mdipie...@cs.depaul.edu wrote:
I think what Vincent is asking is not so much importing capability but
an interface that can read an excel file (or a csv file) asks you the
names (guessing from the header) and types (guessing from data) of
columns and
I'm using web2py to create applications for competitive swimming. I have an
online meet entry website now for high school swim events and plan to add a
website that will actually run the meet poolside during the event. It's a
perfect application for web2py since it can be loaded and run from a
could you please tell me how to do/find a print statement?
or direct me to a chapter in the documentation or something?
On Mar 16, 4:07 pm, mdipierro mdipie...@cs.depaul.edu wrote:
can you add some print statements to determine which lines are
executed and which not? I suspect a logic problem.
Hi Mohammed,
I faced a problem like this one b4 and simply as mdipierro said it was
a logic problem
try the validation function with the minimal code that works then add
line by line and check whether it works or not
then you'll detect when it fails
Oh BTW
if form.accepts(request.vars,session,
I had actually used appadmin in production for a particular database
for several months. The users were the same as you are describing
(end-user, used to excel).
Now that it is time to give them the real app (as appadmin was just a
quick get us up and running)... they are actually sad to see us
- moulds and
- machinery management in manufacturing plant
On 17 Mar, 07:53, Joe Barnhart joe.barnh...@gmail.com wrote:
I'm using web2py to create applications for competitive swimming. I have an
online meet entry website now for high school swim events and plan to add a
website that will
there is no screenshot of working examplestrange from you mr. freeze!!
thanks for your slices
alex
El 17/03/2010 5:01, mr.freeze escribió:
Here's a simple example of getting jqGrid working with web2py. I'll be
improving it as I go along so feedback is welcome:
there is no screenshot of working examplestrange from you mr.
freeze!! :-P
thanks for your slices
alex
El 17/03/2010 5:01, mr.freeze escribió:
Here's a simple example of getting jqGrid working with web2py. I'll be
improving it as I go along so feedback is welcome:
There is now :)
On Mar 17, 4:40 am, Alex Fanjul alex.fan...@gmail.com wrote:
there is no screenshot of working examplestrange from you mr.
freeze!! :-P
thanks for your slices
alex
El 17/03/2010 5:01, mr.freeze escribi :
Here's a simple example of getting jqGrid working with web2py.
hahaha, I knew that you couldn't resist...thanks again for your excelent
work.
alex
El 17/03/2010 10:45, mr.freeze escribió:
There is now :)
On Mar 17, 4:40 am, Alex Fanjulalex.fan...@gmail.com wrote:
there is no screenshot of working examplestrange from you mr.
freeze!! :-P
thanks
Matt,
I have the exactly opposite problem, my appadmin (latest version) runs
on GAE but it does not run locally, it has a yellow triangle with a !
sign in it. Have you modified the app.yaml - please see my other post:
These links are a good resource. But I'll need to figure out if I can
get it working in my current application. Thanks for your wonderful
support. I'll keep you all posted if I get success.
Rahul.
On Mar 15, 8:19 pm, mdipierro mdipie...@cs.depaul.edu wrote:
For now look at the following links
i understand sqlite is not for heavy usage. i just want to know is
there any way to set the timeout for database file access before
returning database is locked error?
also is there any way to catch the error and return some busy error
page?
although i do not have problem with for eg. mysql,
thank you hamdy but it is irrelevant to the code.
BTW
mdipierro
do you mean print statement in the code itself? I thought it was s
special function..
ok even If I do these print statements were would it print to?
On Mar 17, 10:16 am, hamdy.a.farag hamdy.a.fa...@inbox.com wrote:
Hi Mohammed,
to your console.
On 17 Mart, 13:41, mohammed al-moustady mohd.moust...@gmail.com
wrote:
thank you hamdy but it is irrelevant to the code.
BTW
mdipierro
do you mean print statement in the code itself? I thought it was s
special function..
ok even If I do these print statements were would
@ls1 : Nice! That sounds quite cool. Can you give any more info?
On Wed, Mar 17, 2010 at 10:47 AM, ls1 ls1.luk...@gmail.com wrote:
- moulds and
- machinery management in manufacturing plant
On 17 Mar, 07:53, Joe Barnhart joe.barnh...@gmail.com wrote:
I'm using web2py to create applications
The appadmin can be run on GAE, but it cannot run on local GAE SDK.
(note: I have been thinking it might due to some basic settings, not
just my code, which I have overlooked, as running T3 and C.R.M
appliances have the same problem). I have customised myapp according
to the web2py manual to suit
web2py and other web frameworks all deal with concurrency in the same
way. They can run multiple threads and multiple processes. It works
well with multiple installation behind a load balancer such as pound
or haproxy.
The framework is built by avoiding use of modules that are not thread
safe and
I think this is more appropriate as a replacement for cache.ram than
db.
On Mar 16, 11:38 pm, Thadeus Burgess thade...@thadeusb.com wrote:
Interesting, though for integration with the DAL this would require...
some work! :) It seems that you will have to manually store lots of
metadata that a
What error do you get? What triggers it? I do not think it related to
timeout of database.
On Mar 17, 6:01 am, vince lapcc...@gmail.com wrote:
i understand sqlite is not for heavy usage. i just want to know is
there any way to set the timeout for database file access before
returning database
This is not a web2py issue.
File string, line 1, in bind
socket.error: (48, 'Address already in use')
You have some other server running using the same port.
I just tried appadmin and works file with me.
On Mar 17, 8:57 am, Al albertsec...@gmail.com wrote:
The appadmin can be run on GAE,
Hi - can someone (re)explain how to get appadmin running on GAE?
On non-GAE hosting I understand it requires SSH tunnel. But is there an
equivalent on GAE? Currently, when accessing appadmin on both local GAE and
GAE I get: Admin is disable because insecure channel. Does the app.yaml
file need to
replace http://... with https://
GAE has its own certificate. It works for me at
https://web2py-crm.appspot.com/init/appadmin
On Mar 17, 10:23 am, mat -- mat...@gmail.com wrote:
Hi - can someone (re)explain how to get appadmin running on GAE?
On non-GAE hosting I understand it requires
Does the GAE SSL certificate compatible with google checkout?
The snag with using plugin google checkout level 2 integration is the
need for a $80/year SSL certificate :(
-Thadeus
On Wed, Mar 17, 2010 at 11:10 AM, mdipierro mdipie...@cs.depaul.edu wrote:
replace http://... with
On Mar 17, 2010, at 9:10 AM, mdipierro wrote:
replace http://... with https://
GAE has its own certificate. It works for me at
https://web2py-crm.appspot.com/init/appadmin
Where's the best approximation of a cookbook approach for running web2py on
GAE? I looked at the deployment
I think this is more appropriate as a replacement for cache.ram than
db.
maybe. but there is more than caching there:
While all the data lives in memory, changes are asynchronously saved
on disk using flexible policies based on elapsed time and/or number of
updates since last save.
If you
Values in Redis can be Strings as in a conventional key-value store,
but also Lists, Sets, and SortedSets (to be support in version 1.1).
This data types allow pushing/poping elements, or adding/removing
them, also perform server side union, intersection, difference between
sets, and so forth
Hi,
I have an upload field in my database that looks like this:
db.define_table('page',
Field('book_id', db.book, required=True),
Field('number', 'integer', required=True),
Field('body', 'text', required=True),
Field('image', 'upload', autodelete=True),
)
db.page.image.requires =
You can do this also with cache.disk. You can cache any primitive
python structure including lists and dicts.
I am sure redis has richer apis and lots more features than cache.disk
but still its apis are closer to cache than dbs.
I think we can have a cache.redis (and I will make a patch for it
Can you post the complete traceback?
On Mar 17, 12:03 pm, Chris crflei...@gmail.com wrote:
Hi,
I have an upload field in my database that looks like this:
db.define_table('page',
Field('book_id', db.book, required=True),
Field('number', 'integer', required=True),
Field('body',
Massimo,
When I run web2py.exe -h I get nothing - it just goes back to the
prompt. I tried web2py -M -a 'recycle' -p 443 I get an error: the
system can't find the file specified. I have to just run web2py or
web2py and get the gui to run it.
-wes
--
You received this message because you are
I use it to develop research applications in biotechnology - eg.
discovering new bacteria, tracking scientific data, identifying
potential drugs. Web2py integrates beautifully with third-party tools
and scientific packages leading to efficient and agile product
development.
On Mar 12, 5:42 am,
Traceback (most recent call last):
File /Users/chris/Dropbox/workspace/chris/gluon/restricted.py,
line 173, in restricted
exec ccode in environment
File /Users/chris/Dropbox/workspace/chris/applications/init/
controllers/appadmin.py, line 410, in module
File
It seems you can return json/xml/etc. data by either decorating an
action with @service.json or by simply calling the action with a file
extension index.json. Is there a difference?
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to this
which one is the latest windows version 1.76.5 or 1.76.5.1.b?
On Mar 17, 12:07 pm, Wes James compte...@gmail.com wrote:
Massimo,
When I run web2py.exe -h I get nothing - it just goes back to the
prompt. I tried web2py -M -a 'recycle' -p 443 I get an error: the
system can't find the file
I was just looking back at your email it is this one:
http://web2py.com/examples/static/1.76.5.1.b/web2py_win.zip
-wes
On Wed, Mar 17, 2010 at 12:28 PM, mdipierro mdipie...@cs.depaul.edu wrote:
which one is the latest windows version 1.76.5 or 1.76.5.1.b?
On Mar 17, 12:07 pm, Wes James
On Mar 17, 1:09 pm, mr.freeze nat...@freezable.com wrote:
It seems you can return json/xml/etc. data by either decorating an
action with @service.json or by simply calling the action with a file
extension index.json. Is there a difference?
The extension uses the generic view templates - have
The use of decorators predates the generic.json and it is still
approrpriate for jsonrpc and xmlrpc, but for pure json output I'd use
the new generic.json also because you can customize it by giving
a .json to each action.
On Mar 17, 1:09 pm, mr.freeze nat...@freezable.com wrote:
It seems you
I am now able to indeed access appadmin via https :-)
Thank you!
On Wed, Mar 17, 2010 at 6:10 PM, mdipierro mdipie...@cs.depaul.edu wrote:
replace http://... with https://
GAE has its own certificate. It works for me at
https://web2py-crm.appspot.com/init/appadmin
On Mar 17, 10:23 am,
web2py.exe -h
should work but will look into it
web2py -M -a 'recycle' -p 443
you get the right error since you did not specify -S whichapp
On Mar 17, 12:07 pm, Wes James compte...@gmail.com wrote:
Massimo,
When I run web2py.exe -h I get nothing - it just goes back to the
prompt. I tried
Hi thadeus,
I'm trying to understand the blogitizor code, but I'm wasn't be able to
install it yet at all.
I'm using last version of web2py 1.76.1, and windows 7 with python 2.5.
1) I could install pygments with easy_install but couldn't install
guppy beacuse it requires python 2.6 and I
Massimo,
I just went and copied edit_area from an older web2py I had. It is
0.8.1.1 and the ctrl+s works there. I tried the sourceforge version
of edit_area, which you are probably are using too, 0.8.2 and ctrl+s
is does not work. Oddly my patch for making it work is not in the
same location
1. You don't have to do anything as long as you don't go to the ccache
function in admin. Otherwise, you can replace the ccache function in
controllers/admin.py with the ccache function in
controllers/appadmin.py (also found in web2py welcome trunk). It is
the same code, but the appadmin version
Here I am once again.
I've tried to find the explanation of the following fact but did not
manage.
I Have the following code in my controller:
def saisie():
...
CodeOF=request.vars.OF or request.vars.META_OF
Selection=FORM('Code OF:',
INPUT(_name='OF',_value=CodeOF,requires=IS_IN_DB(db,
This is interesting. If I take 0.8.1.1 from sourceforge, ctrl-s does
not work. If I take 0.8.1.1 from web2py 1.74.9 then ctrl-s works. Is
there some parameter that was set for ctrl-s to work and then was not
set for 0.8.2 in latest web2py?
-wes
On Wed, Mar 17, 2010 at 1:11 PM, Wes James
Odd, I see:
case s:
use = true;
eA.execCommand(save);
break;
in this older code - same as my patch. Why is it there and not in
other versions?
weeeiirrr
On Wed, Mar 17, 2010 at 2:18 PM, Wes James compte...@gmail.com wrote:
The problem is that doing a POST to a url with GET variables is
problematic since it is not in the html specs and different browsers
may behave in different ways. It should be avoided. The solution is to
pass request.vars.OF as a hidden form variable
FORM(,hidden=dict(OF=CodeOF))
On Mar 17,
LOL.
One of you added this to editarea long ago. I forgot so a few versions
ago I upgraded editarea without patching it. You told us. So I fixed
this in trunk (adding a credit to you).
Massimo
On Mar 17, 3:25 pm, Wes James compte...@gmail.com wrote:
Odd, I see:
case s:
I just found 1.68.1 and it is not in the 0.8.1.1 edit_area. Someone
along the line must have added the save and it just didn't make it
over with the 0.8.2 update.
-wes
On Wed, Mar 17, 2010 at 2:25 PM, Wes James compte...@gmail.com wrote:
Odd, I see:
case s:
use =
I think user CJ did. But my memory may fail. I am sure it is in the
bazaar logs, but not in the hg logs.
On Mar 17, 3:40 pm, Wes James compte...@gmail.com wrote:
I just found 1.68.1 and it is not in the 0.8.1.1 edit_area. Someone
along the line must have added the save and it just didn't make
On Mar 17, 2010, at 9:59 AM, mdipierro wrote:
There is no cookbook because there is nothing to be done other than:
0) register with gae and get an app_id
1) change the name in app.yaml (first line: replace web2py with your
app_id)
2) run it locally
dev_appserver.py web2py
3) make
ab -n 1 -c 1000 -k http://localhost/
If your website is slow, Rocket will only speed it up if you have lots
concurrent connections.
-tim
-Original Message-
From: Michael Toomim too...@gmail.com
Sent: Tuesday, March 16, 2010 5:32pm
To: web2py-users web2py@googlegroups.com
Subject:
In what was virtualfields development. Reviewing these threads was not
yet defined the syntax.
http://www.google.com/url?sa=Dq=http://groups.google.com/group/web2py/browse_thread/thread/c684346f13773f93usg=AFQjCNH_O8OPkwXqLw9TOndBiAJhLNxVWw
http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sqlalchemy_approach
-Thadeus
On Wed, Mar 17, 2010 at 5:41 PM, Jose jjac...@gmail.com wrote:
In what was virtualfields development. Reviewing these threads was not
yet defined the syntax.
On 17 mar, 23:25, Thadeus Burgess thade...@thadeusb.com wrote:
http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sql...
-Thadeus
Thank Thadeus, excellent.
Jose
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to this
Fails,
in model/db.py
db.define_table('sales',
Field('item'),
Field('item_total', 'double'),
Field('tax_percentage', 'double'),
Field('trans_date', 'datetime'),
)
class Sales():
def total(self):
return self.item_total * self.tax_percentage
def tax(self):
mrows = ((db(m.group_id == g.id))
(db(~(g.role.like('user_%').select(m.user_id, g.role)
TypeError: unsupported operand type(s) for : 'Set' and 'Set'
This doesn't seem right
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to
On 17 mar, 23:54, Jose jjac...@gmail.com wrote:
Fails,
in model/db.py
db.define_table('sales',
Field('item'),
Field('item_total', 'double'),
Field('tax_percentage', 'double'),
Field('trans_date', 'datetime'),
)
class Sales():
def total(self):
return
I use it to display results from my web scraping jobs.
Am also working on a legal document editor for a client and a language
learning app for myself.
Richard
On Mar 12, 8:42 pm, Giovanni Giorgi j...@objectsroot.com wrote:
Hi all,
in the attempt to better knowing web2py and its community,
to use appadmin on GAE I had to either use https or comment out the
security checks
On Mar 17, 12:16 pm, mattynoce mattyn...@gmail.com wrote:
hi, i've looked at some posts but can't seem to make this work. i can
get appadmin to work on my local version of gae launcher (on a mac),
but when i
Thanks Massimo,
So can you advice me - if i already make some projects on web2py (i
didn't test them on some productive tasks) it would be sufficient for
my job? Can I use web2py DAL on some relational aspects with object-
relational dbms (postgresql) - with object and nested tables?
The best
I think you need to do:
def sales():
rows = db(db.sales.id0).select()
rows = rows.setvirtualfields(sales=Sales())
return dict(rows=rows)
And remove this:
db.sales.virtualfields.append(Sales())
On Mar 17, 7:01 pm, Jose jjac...@gmail.com wrote:
On 17 mar, 23:54, Jose
Scratch that, I didn't realize that virtualfields had been added to
Table.
On Mar 17, 7:11 pm, mr.freeze nat...@freezable.com wrote:
I think you need to do:
def sales():
rows = db(db.sales.id0).select()
rows = rows.setvirtualfields(sales=Sales())
return dict(rows=rows)
And
On 18 mar, 00:11, mr.freeze nat...@freezable.com wrote:
I think you need to do:
def sales():
rows = db(db.sales.id0).select()
rows = rows.setvirtualfields(sales=Sales())
return dict(rows=rows)
And remove this:
db.sales.virtualfields.append(Sales())
works well, but what I
On Mar 17, 2010, at 4:58 PM, Jonathan Lundell wrote:
mrows = ((db(m.group_id == g.id))
(db(~(g.role.like('user_%').select(m.user_id, g.role)
TypeError: unsupported operand type(s) for : 'Set' and 'Set'
This doesn't seem right
Never mind; it's not that kind of Set.
--
You
Dope !
Thanks Jose.
-Thadeus
On Wed, Mar 17, 2010 at 7:23 PM, Jose jjac...@gmail.com wrote:
On 18 mar, 00:11, mr.freeze nat...@freezable.com wrote:
I think you need to do:
def sales():
rows = db(db.sales.id0).select()
rows = rows.setvirtualfields(sales=Sales())
return
Traceback (most recent call last):
File /home/web2py/gluon/main.py, line 518, in wsgibase
session._try_store_in_db(request, response)
File /home/web2py/gluon/globals.py, line 356, in _try_store_in_db
table._db(table.id == record_id).update(**dd)
File /home/web2py/gluon/sql.py, line
You are right. I will find a place.
On Mar 17, 4:36 pm, Jonathan Lundell jlund...@pobox.com wrote:
On Mar 17, 2010, at 9:59 AM, mdipierro wrote:
There is no cookbook because there is nothing to be done other than:
0) register with gae and get an app_id
1) change the name in app.yaml
I advice you use https and you do not remove the security checks.
https works out of the box on GAE anyway.
On Mar 17, 7:03 pm, Richard richar...@gmail.com wrote:
to use appadmin on GAE I had to either use https or comment out the
security checks
On Mar 17, 12:16 pm, mattynoce
This is probably obvious but I decided to try this myself:
Should one run web2py with Pound on multi-core server?
probably yes if you deal with concurrent connections..
This is my config:
2.6.31-19-generic-pae
Intel(R) Xeon(R) CPU E5410 @ 2.33GHz
Ubuntu 64bit
one processor with 4 cores
disk
I am not sure I understand the question. I can tell you how I proceed:
1) make a prototype that does what I want.
2) deploy and see what happens
3) when I start having lots of hits try to reduce the number of
queries using cache/memcache
4) eventually move some date or all data to a
I am pretty sure this is not a problem with sqlite timeout. It may be
a concurrency issue. Do you use the thread module explicitly or
multiprocessing or background processes? Can you post a minimalist app
that allows to reproduce the problem? If not can you tells us a little
more about the
Are you using multiple connections to the same database? db=DAL(...)
On Mar 17, 7:51 pm, vince lapcc...@gmail.com wrote:
Traceback (most recent call last):
File /home/web2py/gluon/main.py, line 518, in wsgibase
session._try_store_in_db(request, response)
File
Did you compile the app before running the benchmarks?
Can you say more about The most important thing: effects depend much
on what you import.
imports should be cached and should not make a difference.
Massimo
On Mar 17, 8:20 pm, Kuba Kucharski kuba.kuchar...@gmail.com wrote:
This is
Did you compile the app before running the benchmarks?
yes
Can you say more about The most important thing: effects depend much
on what you import.
imports should be cached and should not make a difference.
actually they don't, it is late, I was going to say extend/include not import
--
I was going to say extend/include not import
and even this is not true as I see now for small layout
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group,
maybe Im a bit ignorant, but what is pound?
alex
El 18/03/2010 2:20, Kuba Kucharski escribió:
This is probably obvious but I decided to try this myself:
Should one run web2py with Pound on multi-core server?
probably yes if you deal with concurrent connections..
This is my config:
http://web2py.com/book/default/section/11/12?search=pound
http://www.apsis.ch/pound/
kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes.
I didn't mentioned but I had also executed some sysctl and ulimit
tweaking before benchmarking.
I ran tests again with the same configuration
voice over ip data engine ( routing, billing, gui-backend, etc )
--
Kuba
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
I noticed that many vps hosting provide HAProxy these days.
On Mar 17, 9:26 pm, Kuba Kucharski kuba.kuchar...@gmail.com wrote:
http://web2py.com/book/default/section/11/12?search=poundhttp://www.apsis.ch/pound/
kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes.
I didn't
mutliprocess yes. i am running under mod_wsgi with single thread but
multi process.
i do assume the sqlite driver should try to acquire the database file
lock for a specific time instead of return error right away? or is
there any way to catch the error and return some busy page? it should
be
That should not be a problem. Do you get this regularly or
occasionally? Is this a long running thread?
On Mar 17, 10:15 pm, vince lapcc...@gmail.com wrote:
mutliprocess yes. i am running under mod_wsgi with single thread but
multi process.
i do assume the sqlite driver should try to acquire
Thanks Massimo.. very clear explaination
--
You received this message because you are subscribed to the Google Groups
web2py-users group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more
Sorry, hamdy, but I don't think you answered the question. I have read
the doc many times and understand how to operate groups, memberships,
and permissions. The question is about structure.
Consider the following situation. Users can register with the site.
Users can create common interest
84 matches
Mail list logo