Re: [web2py] Re: New feature in trunk: API tokens

2015-07-01 Thread Pablo Angulo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Just one more comment: I wrote hash(SALT+request.url+'#'+user_id) but meant hash(SUPER_SECRET_GLOBAL_PASSWORD+request.url+'#'+user_id) El 01/07/15 a las 00:06, Pablo Angulo escribió: > > This email was going to be a simple "Great!", but eventually

[web2py] Re: Help with MSSQL Connection

2015-07-01 Thread Massimiliano
Maybe could be useful to someone.. . I found that for my needs, I can got with python-tds, that is pure python. Thank you On Tuesday, June 30, 2015 at 2:49:40 PM UTC+2, Massimiliano wrote: > > Hello, > > I've a problem with odbc. > > I'm developing on OSX 10.10.3 and I found some problems conn

[web2py] Re: Google Application Engine return Hello world

2015-07-01 Thread Ramkrishan Bhatt
Yes even i experienced same with latest google cloud sdk and web2py one day before some docker problem was there, but it got resolve now , i guess there some change in configuration. Please correct me for same. Also need to update the web2py document as GAE modified the UI and services. On Wed

[web2py] Re: Google Application Engine return Hello world

2015-07-01 Thread Ramkrishan Bhatt
Correction , I was using old Google Cloud sdk 1.9.21 thats was having bug refer this Now its working fine with me i deployed http://peaceful-app-98605.appspot.com/ you can go

[web2py] Re: Help with MSSQL Connection

2015-07-01 Thread Jose
Hi Massimiliano I have the following in FreeBSD - unixODBC - FreeTDS - py-odbc Configuration: /usr/local/etc/odbcinst.ini [TDS] Description = FreeTDS Driver = /usr/local/lib/libtdsodbc.so UsangeCount = 1 DontDLClose = 1 CPTimeout = 60 Threading = 0 Pooling = Yes /usr/local/etc/odbc.in

[web2py] Re: Error in database giving 'NoneType' object has no attribute 'first_name'.

2015-07-01 Thread Sai Harsh Tondomker
Then What I need to do to solve the problem. And how to take data from XML file to data base. Waiting for your response Regards T.Sai Harsh -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

[web2py] How to insert data in data base by xml file

2015-07-01 Thread Sai Harsh Tondomker
My project is to make simple quizzing site. I have made data base in web2py. with Question, options and Correct answer. The data will be xml file. From XML file I need to take data and store in data base Please help me to solve the problem. Waiting for your response. Best Regards T.Sai Har

[web2py] Re: Easy way to make a functional table / grid / spreadsheet

2015-07-01 Thread Martti Lamberg
I guess always as a direct response to a user action. I'm not entirely sure as I can't think of an example of that so called server push. But I guess the game is static in that sense that it doesn't do anything unless the user makes it so. Well one thing comes in mind and that is login timeout,

[web2py] run time error - auth_user.table appears corrupted

2015-07-01 Thread reddyreddy
Can anyone help me? Iam getting runtime error auth_user.table appears corrupted. Iam not sure why it is appearing. Here are my not tables. db = DAL("sqlite://storage.sqlite") from gluon.tools import Auth auth = Auth(db) auth.define_tables(username=True) db.define_table('problem', Field('title',

[web2py] as_dict() on a row fails when connected to MySQL on Amazon RDS

2015-07-01 Thread Sean Ballow
We are connecting successfully to MySQL on RDS And when attempting to insert a new record it appears to properly insert into the database and we receive an ID back, for instance result = db.foo.insert(myfield='blah') print result >> 1 The problem occurs when performing the following after succ

[web2py] Re: Easy way to make a functional table / grid / spreadsheet

2015-07-01 Thread Anthony
On Wednesday, July 1, 2015 at 10:01:19 AM UTC-4, Martti Lamberg wrote: > > I guess always as a direct response to a user action. I'm not entirely > sure as I can't think of an example of that so called server push. But I > guess the game is static in that sense that it doesn't do anything unless

[web2py] Re: Error in database giving 'NoneType' object has no attribute 'first_name'.

2015-07-01 Thread Anthony
On Wednesday, July 1, 2015 at 10:01:19 AM UTC-4, Sai Harsh Tondomker wrote: > > Then What I need to do to solve the problem. > Your code refers to auth.user, which presumes there is a user logged in. If there is no user logged, in, it won't work, so maybe decorate the action in question with @au

[web2py] Re: How to insert data in data base by xml file

2015-07-01 Thread Anthony
You can parse the XML with something like ElementTree, lxml, or Beautiful Soup. Then you would have to write some code to extract the data for individual records (which will depend on the structure of the XML) and use the DAL to insert each record. Anthony On Wednesday, July 1, 2015 at 10:01:1

Re: [web2py] Re: Help with MSSQL Connection

2015-07-01 Thread Massimiliano
Thank you Jose On Wed, Jul 1, 2015 at 3:43 PM, Jose wrote: > Hi Massimiliano > > I have the following in FreeBSD > > - unixODBC > - FreeTDS > - py-odbc > > Configuration: > > /usr/local/etc/odbcinst.ini > > [TDS] > Description = FreeTDS > Driver = /usr/local/lib/libtdsodbc.so > UsangeCount = 1

[web2py] Oracle SQL/DAL Bug Issue on Alter Table

2015-07-01 Thread Boris Aramis Aguilar Rodríguez
Hi all, I'm currently working on web2py with an Oracle Database backend (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production) but I'm having an issue with the generated Oracle command for altering a table. I had a table definition as follows (in web2py): db.define_tab

[web2py] Re: export data to OOO and Excel

2015-07-01 Thread Massimo Di Pierro
i like handsontable. It displays data like excel and allows cut&paste to/from excel. It has a select all button On Tuesday, 30 June 2015 18:52:27 UTC-5, 黄祥 wrote: > > yes, i know that CSV files can be open with excel, i think it's enough, if > i need *.xls file i think, i can just open CSV files

[web2py] Re: How do I get rid design request response session db tables db stats buttons in a sqlform

2015-07-01 Thread jackson . read
Thanks that was it a typo in naming the respective view. On Tuesday, June 30, 2015 at 3:30:28 AM UTC-4, jackso...@quantachrome.com wrote: > > This what I have. I want to get rid of the row of buttons at the bottom > of the form that says 'design request response session db tables db stats' > >

[web2py] Re: Help with MSSQL Connection

2015-07-01 Thread JC
Hello I had a similar problem, causes by 2 things: 1- sql configuration was wrong. 2- I need to specify the path fro the pyodbc location. Hope this help you On Tuesday, June 30, 2015 at 1:49:40 PM UTC+1, Massimiliano wrote: > > Hello, > > I've a problem with odbc. > > I'm developing on OSX

[web2py] grid: get rid of view buttons

2015-07-01 Thread jackson . read
I have a sqlform.grid, I would like to get rid of the view buttons at the end of each row. Unfortunately the grid has no attribute 'viewable' that you can set to False. Does anyone know how to do this?? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] Re: GUI crossroads: Cappuccino and/or web2py

2015-07-01 Thread Phillip Veda
I should have clarified, in general, with web2py On Tuesday, June 30, 2015 at 2:37:55 AM UTC-5, Massimo Di Pierro wrote: > > I did not do it. Mariano (one of our oldest members) did it. > > On Tuesday, 30 June 2015 02:30:28 UTC-5, Phillip Veda wrote: >> >> I just happened accross gui2py last night

[web2py] Re: grid: get rid of view buttons

2015-07-01 Thread JorgeH
a quick example: form2 = SQLFORM.grid(((db.empaques.producto == producto) & (db.empaques.nuevo == True)), formname='form2', fields=fields2, details=False, editable=True, create=True, deletable=True, csv=False, user_signature=False, searchable=False, maxtextlength=30)

[web2py] Re: grid: get rid of view buttons

2015-07-01 Thread JorgeH
in other words: details = False On Wednesday, July 1, 2015 at 2:50:58 PM UTC-5, jackso...@quantachrome.com wrote: > > I have a sqlform.grid, I would like to get rid of the view buttons at the > end of each row. Unfortunately the grid has no attribute 'viewable' that > you can set to False.

[web2py] general concepts for creating user defined tables?

2015-07-01 Thread Alex Glaros
What is best concept for creating user-defined tables? Intent is for user to create small, simple, permanent tables. E.g., User wants inventory table. User says I need 3 columns: ItemName, Location, and SerialNumber. User should be able to add, delete, search, and edit records (maybe even

[web2py] Semantic 2.0

2015-07-01 Thread Michele Comitini
Better and better! -- 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-user

[web2py] Re: Semantic 2.0

2015-07-01 Thread Leonel Câmara
I'm guessing he's referring to this: http://www.semantic-ui.com/introduction/new.html -- 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 me

Re: [web2py] Re: Semantic 2.0

2015-07-01 Thread Michele Comitini
ops forgot to paste the link! thanks leonel! 2015-07-02 2:05 GMT+02:00 Leonel Câmara : > I'm guessing he's referring to this: > http://www.semantic-ui.com/introduction/new.html > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py

[web2py] Using datatables and web2py

2015-07-01 Thread Chris Guest
I have a very wide html table. I want to selectively hide groups of columns at a time using a list of . Someone suggested using Datatables.net. So I have developed a proof of concept and all looks well. http://jsfiddle.net/ChrisGuest/orgj7oL9/ Now when I drop this code into a web2py as below, I

[web2py] Re: pymysql gives Broken Pipe

2015-07-01 Thread Ben Lawrence
No, (Running on Apache/2.4.7 (Ubuntu), Python 2.7.6) On Tuesday, June 30, 2015 at 5:46:07 PM UTC-7, Derek wrote: > > are you on osx perchance? > > On Tuesday, June 30, 2015 at 3:59:07 PM UTC-7, Ben Lawrence wrote: >> >> I am seeing broken pipe errors like this on low volume site using pg8000 >> o

Re: [web2py] Multiple Uploads using jQuery-File-Upload: Javascript/CSS Conflict?

2015-07-01 Thread Sujata Aghor
My code( based on your mentioned solution) looks like this- if form.accepts(request.vars): if hasattr(request.vars, 'txn_doc'): #if len(request.vars.txn_doc) > 0: files = request.vars['txn_doc'] if not isinsta