Re: [web2py] Reading a text file after uploading in a form

2012-11-01 Thread Johann Spies
On 31 October 2012 17:45, praveen krishna praveenchitne...@gmail.comwrote: Hi, For my task I have to upload a text file in form with out zipping it ,I have prepared the form as: form = FORM(TABLE(TR(TD('Upload File:', INPUT(_type='file', name='myfile', id='myfile',

Re: [web2py] Reading a text file after uploading in a form

2012-11-01 Thread praveen krishna
Nol there is no such requirement.Actually I am able to upload and read a text file by zipping it but for my task I have upload a text file . On Thu, Nov 1, 2012 at 7:24 AM, Johann Spies johann.sp...@gmail.com wrote: On 31 October 2012 17:45, praveen krishna praveenchitne...@gmail.comwrote:

[web2py] long load time for scipy package

2012-11-01 Thread lucas
hello one and all, i am trying to load the scipy package into one of my apps under web2py 2.2.1 on centos 6.3. when i load it, like via from scipy import optimize, under pure python command line, it loads very quickly. however, when i try to load it under a web2py controller it takes a huge

[web2py] Re: Unescaped single quotes break my json

2012-11-01 Thread dlypka
I used this code in my controller: result = '{ IsLoggedIn: %s, resmsg: %s}' % (retIsLoggedIn, resmsg) response.headers['Content-Type'] = 'application/jsonp' response.view = 'generic.jsonp' # Using python code in file init/views/generic.jsonp to leave data unescaped return result On

Re: [web2py] Reading a text file after uploading in a form

2012-11-01 Thread Jim S
This is working for me. I have a similar requirement. Select a text file to be processed and pass it to a separate routine to process the file: form = SQLFORM.factory( Field('brillXf1', 'upload', uploadfolder=os.path.join(request.folder,'uploads'), label='Brill XF1 File')) if

[web2py] Re: Unescaped single quotes break my json

2012-11-01 Thread villas
Hi dlypka, Not sure I was clear. I need to maintain the escaping. My point was this: my data was escaped OK in the controller, but when it arrived in the view, it was not escaped. Something broke the escaping of single-quotes passing between the two. Double quotes are a bit of problem

Re: [web2py] page min height

2012-11-01 Thread villas
Hi Richard, I presume you already saw this? http://twitter.github.com/bootstrap/examples/sticky-footer.html --

Re: [web2py] Reading a text file after uploading in a form

2012-11-01 Thread praveen krishna
where can I download the 'reports' module? I am getting error while calling that module. On Thu, Nov 1, 2012 at 1:12 PM, Jim S j...@qlf.com wrote: This is working for me. I have a similar requirement. Select a text file to be processed and pass it to a separate routine to process the file:

[web2py] Re: long load time for scipy package

2012-11-01 Thread Massimo Di Pierro
Unless you enabled track_changes(True) this should not be the case. The package should only be loaded once. Where did you put the package? On Thursday, 1 November 2012 06:32:28 UTC-5, lucas wrote: hello one and all, i am trying to load the scipy package into one of my apps under web2py

[web2py] Re: How to create long running tasks?

2012-11-01 Thread Richard Penman
Would be great to use the new scheduler but doesn't seem applicable in this case. I have no difficulty starting these processes. As described in OP, the problem is these are child processes which makes them dependent on the main web2py process. So I was wanting these to be independent

[web2py] Re: How to create long running tasks?

2012-11-01 Thread Niphlod
I don't get the it's not applicable in this case part. The way you start them on web2py is the same one you can use with the scheduler Starting child processes from webserver main process is never safe because of the problem you're facing. The second you kill the webserver process (or, in

Re: [web2py] page min height

2012-11-01 Thread Richard Vézina
hmm, interresting... I will have a look, thanks. Richard On Thu, Nov 1, 2012 at 8:31 AM, villas villa...@gmail.com wrote: Hi Richard, I presume you already saw this? http://twitter.github.com/bootstrap/examples/sticky-footer.html -- --

[web2py] Re: Reading a text file after uploading in a form

2012-11-01 Thread Paolo Caruccio
a simple skeleton code (please check for errors): def page_controller(): form = FORM( TABLE ( TR( TD(LABEL('Upload File:')), TD(INPUT(_type='file', name='myfile', id='myfile', requires=IS_NOT_EMPTY())) ), TR( TD(INPUT(_type='submit',_value='Submit')) ) ) ) txt_content[] if

Re: [web2py] Re: How to create long running tasks?

2012-11-01 Thread Richard Baron Penman
I don't get the it's not applicable in this case part. The way you start them on web2py is the same one you can use with the scheduler Does not seem applicable because does not address the problem of dependent child processes. Starting child processes from webserver main process is

[web2py] Are there known problems of SQL Server with the built in wiki

2012-11-01 Thread Patrick Büchler
Dear All, I plan to use web2py for an internal wiki. I wanted to use SQL Server as database, however, when I try to run my application I get: pyodbc.ProgrammingError: ('42000', [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint

[web2py] Re: mail.send transposing to and subject ; can anybody explain this?

2012-11-01 Thread Gustavo Pereira
Guys I figured out how to solve this bug ... in my version of web2py 1.99.2 changed in the file db.py line: email = auth.settings.mailer to: mail = Mail () Em sexta-feira, 17 de agosto de 2012 18h25min44s UTC-3, Cliff Kachinske escreveu: The simple controller says this: record =

Re: [web2py] Re: Reading a text file after uploading in a form

2012-11-01 Thread Jim Steil
Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory name. The important part is this: '%s/%s' % (os.path.join(request.folder,'uploads'), fileName)

Re: [web2py] Re: Reading a text file after uploading in a form

2012-11-01 Thread Jim Steil
Whoops, sent that before completing: Should have been... Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory name. The important part is this:

[web2py] Re: Are there known problems of SQL Server with the built in wiki

2012-11-01 Thread Massimo Di Pierro
Not a solution but for reference: http://stackoverflow.com/questions/851625/foreign-key-constraint-may-cause-cycles-or-multiple-cascade-paths On Thursday, 1 November 2012 09:39:47 UTC-5, Patrick Büchler wrote: Dear All, I plan to use web2py for an internal wiki. I wanted to use SQL Server

Re: [web2py] Re: How to create long running tasks?

2012-11-01 Thread Niphlod
I don't get the it's not applicable in this case part. The way you start them on web2py is the same one you can use with the scheduler Does not seem applicable because does not address the problem of dependent child processes. Let's not get lost: you have something to start and

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Lamps902
I've followed Jim's model in creating my search filter, and it appears to be working beautifully! Just have some questions that I would like to ask. First - I slightly modified the selector code so that entries show up as unique, by adding the distinct clause and ordering alphabetically by

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Jim Steil
Lamps Wish I could be more help with your questions. Here is my take. 1. If you are thinking about having a large list, I would try to avoid that. Maybe your DISTINCT keyword will keep the list small. My thoughts are that a long list (25 entries or more) is not very user friendly and if I

[web2py] zero='select a value' no longer shows

2012-11-01 Thread Annet
I defined the following validator: nodeSocialMedia.nodeID.requires=[IS_IN_DB(db,'socialMedia.id','%(name)s',zero=T('select a value')),IS_NOT_IN_DB(db(db.nodeSocialMedia.nodeID==request.vars.nodeID),'nodeSocialMedia.socialMediaID',error_message=T('combination node and social media already in

[web2py] Re: session[id]=Storage(id=id) between controllers

2012-11-01 Thread Annet
Hi, Thanks for providing me with a solution. request.args(0,default=0, cast=int, otherwise=URL(...)) PS: if it's recurrent I wonder why you aren't normalizing it already as with try: arg0 = int(request.args(0)) except: redirect() Because there are exceptions, at the moment

[web2py] Re: long load time for scipy package

2012-11-01 Thread lucas
On Thursday, November 1, 2012 8:43:12 AM UTC-4, Massimo Di Pierro wrote: Unless you enabled track_changes(True) this should not be the case. The package should only be loaded once. Where did you put the package? hey massimo, i didn't have track_changes(True) anywhere, but your last question

[web2py] CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
Hi, I did small changes to the example in the book (ajax search), @auth.requires_login() def searchtalab(): an ajax wiki search page return dict(form=FORM(INPUT(_id='keyword',_name='keyword', _onkeyup=ajax('callbacktalab', ['keyword'], 'target');)),

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread Richard Vézina
Not sure, but the request.vars.VAR is text type even if your value is integer, so maybe there is a check to do there. Richard On Thu, Nov 1, 2012 at 1:25 PM, apps in tables ad...@aqar-riyadh.comwrote: I got the same error with VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57,

[web2py] Re: long load time for scipy package

2012-11-01 Thread Massimo Di Pierro
I believe the session problem is solved. I cannot completely exclude problems with retrieving sessions created with early/different web2py versions. On Thursday, 1 November 2012 12:03:19 UTC-5, lucas wrote: On Thursday, November 1, 2012 8:43:12 AM UTC-4, Massimo Di Pierro wrote: Unless you

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread Massimo Di Pierro
I do not know. Anyway, you are using 2.0.9. Can you upgrade to 2.2.1? On Thursday, 1 November 2012 12:07:41 UTC-5, apps in tables wrote: Hi, I did small changes to the example in the book (ajax search), @auth.requires_login() def searchtalab(): an ajax wiki search page return

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
I got the same error with version 2.2.1 Ashraf --

Re: [web2py] emmet

2012-11-01 Thread Richard Vézina
It nice, but the shortcut are not well choosed I think... They seems to conflict will Linux desktop shortcut. Richard On Thu, Nov 1, 2012 at 2:38 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: http://docs.emmet.io/ in case you do not know. This has been in admin stable for a

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Lamps902
Regarding the first point, the concern is not that the selector (as defined in the DB model) is instantiated with a huge variety of fields. If I'm not mistaken, if the distinct keyword in the select() function is left out, the program literally goes through every entry in the DB that matches

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
I only made the query based on more than one table, and that caused the problem. --

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
I only made the query based on more than one table, and that caused the problem. --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread Richard Vézina
Does it works if you remove one table from you query? Richard On Thu, Nov 1, 2012 at 3:21 PM, apps in tables ad...@aqar-riyadh.comwrote: I only made the query based on more than one table, and that caused the problem. -- --

[web2py] Is there a way to put a grid's search form beneath the column headers of a grid?

2012-11-01 Thread Lamps902
In a previous threadhttps://groups.google.com/forum/#!searchin/web2py/filter/web2py/oH7eMYNHt6Y/Izss3tRfTOkJ, we discussed how to implement multiple search filter fields for a grid. That being done, I'm curious if there's a reasonable way to put the filters (all currently part of a single

[web2py] jQuery UI Bootstrap

2012-11-01 Thread Richard
I was starting to notice some conflict using bootstrap.js and jQueyr UI at the same time and fall on this doing little research... http://addyosmani.github.com/jquery-ui-bootstrap/ Richard --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
Hi Richard, yes, the search is working perfect for query based on one table. I am trying to include the details tables in the search. Any special format for the query that is based on more than one table? Regards, Ashraf On Thursday, November 1, 2012 10:28:50 PM UTC+3, Richard wrote:

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Niphlod
only on the db part. select(distinct=...) sends a different query to the db than select(). It's not web2py that uniquify the sets of the record returned to make it distinct. Then. It's true that doing a distinct on a million rows table forces the db to scan through a million of rows but

[web2py] Re: session[id]=Storage(id=id) between controllers

2012-11-01 Thread Niphlod
Because there are exceptions, at the moment your solution solves the problem, in a next iteration I'll probably solve it differently. What exceptions ? request.args(0, default=0, cast=int, otherwise=something) does exactly the same thing I described try: int(request.args(0)) except:

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
Hi, why is 'contains()' working fine for one table query? and not working for more than one table query? Any ideas. Regards, Ashraf --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread Richard Vézina
Try to isolate a dummy query the one that pass and the one that not pass... I don't have much time to read all your code... Richard On Thu, Nov 1, 2012 at 4:13 PM, apps in tables ad...@aqar-riyadh.comwrote: Hi, why is 'contains()' working fine for one table query? and not working for more

[web2py] Import error with 2.2.1

2012-11-01 Thread Neil
I just upgraded from 2.1 to 2.2.1, and I can no longer import matplotlib. I get the following error: ImportError: Cannot import module 'matplotlib' Is this related to the custom import? Perhaps it is the same as issue 1125? --

[web2py] Proposal: Explicit mapping of None values in Field object

2012-11-01 Thread Joe Barnhart
This proposal solves a problem I have when formatting Field values. I created a custom Validator class which maps the value None into a string (such as N/A or NT), but the mapping was ignored because the current Field processing provides an early exit if the value of the Field is None, i.e.

[web2py] bootstrap modal and web2py LOAD()

2012-11-01 Thread Richard
Hello, Anyone get work bootstrap modal with web2py LOAD() without having the whole page reloaded on embedded form (load component contain a form) submit?? Thanks Richard --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

2012-11-01 Thread apps in tables
The code is very simple. @auth.requires_login() def searchtalab(): an ajax wiki search page return dict(form=FORM(INPUT(_id='keyword',_name='keyword', _onkeyup=ajax('callbacktalab', ['keyword'], 'target');)), target_div=DIV(_id='target'))

[web2py] Re: Geolocation

2012-11-01 Thread Jacinto Parga
I think I have a silly misunderstood with jQuery.post I'm trying to store the latitude and longitude in a db.events table. I haven't found the right way to do this simple thing, This is my view: {{left_sidebar_enabled,right_sidebar_enabled=False,True}} {{extend 'layout.html'}} h3View

[web2py] Re: Import error with 2.2.1

2012-11-01 Thread Massimo Di Pierro
Where is matplotlib installed? On Thursday, 1 November 2012 15:51:14 UTC-5, Neil wrote: I just upgraded from 2.1 to 2.2.1, and I can no longer import matplotlib. I get the following error: ImportError: Cannot import module 'matplotlib' Is this related to the custom import? Perhaps it is

Re: [web2py] How to implement multiple filter for grid?

2012-11-01 Thread Lamps902
Hi, Niphlod. If I understood correctly, you're saying that .select(distinct=True) on a large db does indeed require a lot of resources, but all of the heavy work is done by the server, rather than the client's computer, and that web2py doesn't have an inbuilt way around it. That sort of heavy

[web2py] how to remove an install plug -- wiki

2012-11-01 Thread patrick moon
i'm having a problem with just trying to get web2py to with mssql on the latest version and the welcome comes with the wiki pluggin insdtalled as a default. Is there a way to delete this? there seem to be no delete button. 127.0.0.1.2012-11-01.16-48-29.12584d3d-101f-4883-a762-2a9ed0f109d4

[web2py] Re: how to remove an install plug -- wiki

2012-11-01 Thread Massimo Di Pierro
Unless you use it (auth.wiki()) it is disabled. On Thursday, 1 November 2012 18:55:54 UTC-5, patrick moon wrote: i'm having a problem with just trying to get web2py to with mssql on the latest version and the welcome comes with the wiki pluggin insdtalled as a default. Is there a way to

Re: [web2py] Re: delete on GAE

2012-11-01 Thread howesc
so it turns out that GAE itself fails when i pass an iterator over a large list to gae.delete(). so i've tweaked the implementation to not call count, but to still count the number of entries deleted and it seems to be working. suggested patch included in