[web2py] Re: row.id with L after upgrading to

2013-06-19 Thread palomar
why I shouldn't convert it to an INT? It is the ID of my table and I need it as integer (as on the preview version) ... Il giorno martedì 18 giugno 2013 18:40:06 UTC+2, Derek ha scritto: If you aren't using google app engine, then that should be okay. However if you are, you shouldn't

Re: [web2py] Re: Web2py SOAP and local wsdl file

2013-06-19 Thread Michele Comitini
Barry, Massimo, SOAP is not part of my daily work anymore (very happy with that!) , but a few years ago I have been using ZSI a lot for creating web services from WSDL documents. It worked great and SOAP seems not evolved much since, I then suppose ZSI could be even better today. That was before

[web2py] Re: row.id with L after upgrading to

2013-06-19 Thread Niphlod
references and id got upgraded cause before with high id numbers you could end up with exceptions. In any case, you're relying on the default formatting as a string of a value for whatever value out there, especially if you need to pass it to javascript, always do EXPLICIT conversions in

Re: [web2py] Re: Web2py SOAP and local wsdl file

2013-06-19 Thread Mariano Reingart
Do you have the wsdl file? It would be relatively possible to create a server from the WSDL if it is not too complicated (at least using pysimplesoap) The trick would be read and parse the WSDL with the soap client to see the expected structures. You can se the client.services attribute, it

[web2py] web2pyslices down

2013-06-19 Thread Johann Spies
I get a 404 error (Not found) when I try to access web2pyslices.com Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups web2py-users group.

[web2py] Re: Ajax function and returning Row, not string

2013-06-19 Thread lesssugar
Yes, my assumption was incorrect. I thought ajax() would return a Row object to my ID target element, so then I could use it within the element. I have never been so wrong. Well, it works now: controller: def rank(): ranks = db(db.rank.department_id ==

Re: [web2py] web2pyslices down

2013-06-19 Thread Marin Pranjić
Works for me Marin On Wed, Jun 19, 2013 at 12:51 PM, Johann Spies johann.sp...@gmail.comwrote: I get a 404 error (Not found) when I try to access web2pyslices.com Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)

[web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread peibol
Thanks Cristian. What I'm considering is use a export/import function in the app, only visible to the administrator. Because I want to develop a kind of wiki, with its content, on local. So I'll use export_to_csv_file and import_from_csv_file. The export process is working for me right now,

Re: [web2py] Re: Web2py SOAP and local wsdl file

2013-06-19 Thread Massimo Di Pierro
Can you provide a simple example? On Wednesday, 19 June 2013 04:18:16 UTC-5, Mariano Reingart wrote: Do you have the wsdl file? It would be relatively possible to create a server from the WSDL if it is not too complicated (at least using pysimplesoap) The trick would be read and parse

[web2py] Re: row.id with L after upgrading to

2013-06-19 Thread Anthony
Inside your XML(), you have a list of lists. XML() will ultimately call the __str__ method on each item in it, and the __str__ method of a list calls the __repr__ method of each item in the list. The __repr__ method of long appends an L to the integer value. So, as you have discovered, you must

[web2py] Re: Truncated Data on Migration

2013-06-19 Thread Chris
The main problem is that the failure is silent. It makes no sense that a developer declares a field to be length 1000, and DAL arbitrarily reduces that to 255 instead of providing an error message. I understand why 255 may be a safe default limit for MySQL; but if so then fail the field

[web2py] Re: Scheduler compatible with nginx/uwsgi?

2013-06-19 Thread Joe Barnhart
Hi Niphlod -- The culprit seems to be the handling of datetime in the function now in scheduler.py. If I import datetime within the scope of now it works fine. I could submit a patch once I get into a place that actually has internet. -- Joe On Monday, June 17, 2013 11:43:09 PM UTC+8,

Re: [web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread Christian Foster Howes
Are you using BigTable or Google Cloud SQL for data storage? i'm surprised that import to BigTable would give an integrity error. note that if you are import/export as a controller you will be limited by what you can do in 128MB of ram and 60 seconds of processing unless you use larger

[web2py] Re: row.id with L after upgrading to

2013-06-19 Thread palomar
thanks for your reply! -- --- 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

[web2py] problem with a date in a form

2013-06-19 Thread palomar
I have a form that I submit by ajax and I have a problem with a date field. in my db: db.define_table('fatture', Field('codice','string', length=10), Field('dataf', 'date')) in my form: input id=dataf name=dataf type=date input id=codice name=codice type=text ajax function:

Re: [web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread peibol
Bigtable. I don't have any other models but the standard auth ones and the builtin wiki ones and I'm using this code (just the one stated in the book): def import_and_sync(): form = FORM(INPUT(_type='file', _name='data'), INPUT(_type='submit')) if form.process().accepted:

[web2py] SmartGrid

2013-06-19 Thread tom
I have a smartgrid set up like this: def manage_patients(): grid = SQLFORM.smartgrid(db.patient, deletable=True, editable=True, create=True, linked_tables=['emergencycontacts','dependents']) return dict(grid=grid) It displays fine but only has a view button to the far right. How do I

[web2py] GAE 1.8.1 and logging doesn't work

2013-06-19 Thread José Manuel López
Hi!, I've change to GAE 1.8.1 and suddenly (before, with GAE 1.7.5 everything worked ok) the LOG is not working. None of my debugs lines are dump to console. Then I've see that my logging.conf was not being used. This is my log config: [loggers]

Re: [web2py] upgrading appengine has broken web2py

2013-06-19 Thread Christian Foster Howes
patch submitted here: https://code.google.com/p/web2py/issues/detail?id=1546 note that i had been using cache.ram.flush_all() for clearing GAE memcache, but that changed to using cache.ram.clear() in this version. i just updated my source. :) i also had to tweak my path configs for unit

Re: [web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread Christian Foster Howes
I haven't used that code in a long time as my tables are too big. :( what's the traceback that you get? On 6/19/13 7:23 , peibol wrote: Bigtable. I don't have any other models but the standard auth ones and the builtin wiki ones and I'm using this code (just the one stated in the book): def

Re: [web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread peibol
Here is what I get: Error ticket for myeducenterTicket ID 127.0.0.1.2013-06-19.17-34-43.e551a8f8-a45b-4b22-9e22-e76381dc5977 class 'sqlite3.IntegrityError' column title is not uniqueVersiónweb2py™Version 2.5.1-stable+timestamp.2013.06.11.08.00.05PythonPython 2.7.5: c:\Python27\python.exe

Re: [web2py] Re: How should we work to sync localhost development with GAE?

2013-06-19 Thread Christian Foster Howes
check your CSV file - that error looks to me like there are 2 columns with the name title and therefore the DB does not know what data to store where. On 6/19/13 8:38 , peibol wrote: Here is what I get: Error ticket for myeducenterTicket ID

[web2py] Firebird migrations bug

2013-06-19 Thread Alexei Vinidiktov
Hello, I'm using Firebird with my web2py powered app. I've come across what I think to be a bug in migrations, namely dropping columns migrations. If I create a table definition, for example, like this: db.define_table('card', Field('question', 'text', notnull=True),

Re: [web2py] Re: Web2py SOAP and local wsdl file

2013-06-19 Thread Mariano Reingart
This is the original webservice: https://wswhomo.afip.gov.ar/wsfev1/service.asmx?WSDL And this is the simulator made with web2py: http://www.sistemasagiles.com.ar/simulador/wsfev1/call/soap Attached is the web2py sample controller Steps: 1. Analyse the original web service description:

[web2py] Re: Nested JSON vs Single JSON dataset

2013-06-19 Thread John Payne
Thanks Alan, I'll give this a try and reply back. -- --- 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,

[web2py] Re: Nested JSON vs Single JSON dataset

2013-06-19 Thread John Payne
Alan, that did exacltly what i needed! This allows me to return a singular joined object that i can feed to slickgridhttps://github.com/mleibman/SlickGrid . Thanks! On Wednesday, June 19, 2013 8:50:18 AM UTC-8, John Payne wrote: Thanks Alan, I'll give this a try and reply back. -- ---

Re: [web2py] Re: Using a python module in web2py

2013-06-19 Thread Ricardo Pedroso
On Tue, Jun 18, 2013 at 3:15 PM, Joe Magaro joe.maga...@gmail.com wrote: Well, I didn't know I needed to restart Apache. Now I get a different error. I did the nltk download in python, but do I need to do something in web2py? Resource 'corpora/wordnet' not found. Please use the NLTK

[web2py] SQLFORM.factory and list:integer error

2013-06-19 Thread Martin Barnard
I'm trying to figure out why I get an error with the following code: def index(): ids=[] form=SQLFORM.factory( Field('employees', 'list:integer'), ) if form.process().accepts: if form.vars.employees: for v in form.vars.employees:

[web2py] Help on field default computed value

2013-06-19 Thread greenpoise
how come this returns null: Field('seriesnumber',compute=lambda r: '%s%s'% (r['id'],r['seriesname'][0:3])) -- --- 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

[web2py] Re: Firebird migrations bug

2013-06-19 Thread Niphlod
open an issue so it doesn't get lostsounds definitevely like a bug On Wednesday, June 19, 2013 6:28:48 PM UTC+2, Alexei Vinidiktov wrote: Hello, I'm using Firebird with my web2py powered app. I've come across what I think to be a bug in migrations, namely dropping columns migrations.

[web2py] Re: SmartGrid

2013-06-19 Thread Niphlod
are you logged-in ? For security reasons any modification to tables in grids is prevented on anonymous access. You can still give write permissions using user_signature=False, but it's highly discouraged On Wednesday, June 19, 2013 5:25:58 PM UTC+2, t...@caregointl.com wrote: I have a

[web2py] Re: problem with a date in a form

2013-06-19 Thread Niphlod
first of all: do you input the date with that format ? Date format is dependant on the representation of the date itself, that is managed by the T operator. If you scan your (supposedly) it.py and it-it.py you'll see that there's a translation for the string %Y-%m-%d that is the one used to

[web2py] Re: Scheduler compatible with nginx/uwsgi?

2013-06-19 Thread Niphlod
uhm. as long as in your modules don't do something like from datetime import datetime it should all be fine Scheduler just calls datetime.datetime.now() or datetime.datetime.utcnow() , so if you don't overwrite the datetime root module with the child one as in from datetime import

[web2py] Re: Help on field default computed value

2013-06-19 Thread Niphlod
null when ? can you give a full table definition and the operation you're trying to do that returns None ? On Wednesday, June 19, 2013 8:27:40 PM UTC+2, greenpoise wrote: how come this returns null: Field('seriesnumber',compute=lambda r: '%s%s'% (r['id'],r['seriesname'][0:3])) -- ---

[web2py] Re: SQLFORM.factory and list:integer error

2013-06-19 Thread Niphlod
it's a bug reproduceable only if you leave one empty field. BTW, you're parsing it wrong given a single field filled with 1234, you get [1,2,3,4] back. you should do vars = form.vars.employees if vars: if form.vars.employees: if On Wednesday, June 19, 2013 8:22:52 PM UTC+2, Martin

[web2py] Re: web2py 2.4.7 is Out

2013-06-19 Thread Aurelio Tinio
Hi Massimo, We've been able to track down the issue which appeared like a memory leak. It seems to be an issue with our use of routes.py. We've been able to reproduce the issue with the built-in web server, a smaller application (included 'welcome' app) that does not use cache. I've prepared

[web2py] Re: Truncated Data on Migration

2013-06-19 Thread Derek
It's not web2py's fault that MySQL silently truncates data. http://www.davidpashley.com/blog/databases/mysql/silently-truncated On Wednesday, June 19, 2013 5:52:26 AM UTC-7, Chris wrote: The main problem is that the failure is silent. It makes no sense that a developer declares a field to

[web2py] is like a 'kickstarter' clone...

2013-06-19 Thread samuel bonilla
this aplication is opensource built in web2py... i like http://chipincode.com/chipincode -- --- 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

Re: [web2py] Re: Firebird migrations bug

2013-06-19 Thread Alexei Vinidiktov
Done: http://code.google.com/p/web2py/issues/detail?id=1548 On Thu, Jun 20, 2013 at 4:24 AM, Niphlod niph...@gmail.com wrote: open an issue so it doesn't get lostsounds definitevely like a bug On Wednesday, June 19, 2013 6:28:48 PM UTC+2, Alexei Vinidiktov wrote: Hello, I'm using

Re: [web2py] Re: SmartGrid

2013-06-19 Thread Tom Russell
aha that would be it. On Wed, Jun 19, 2013 at 5:26 PM, Niphlod niph...@gmail.com wrote: are you logged-in ? For security reasons any modification to tables in grids is prevented on anonymous access. You can still give write permissions using user_signature=False, but it's highly

[web2py] Sending smartgrid search results to another controller

2013-06-19 Thread David
Hello, I am hoping that this is a simple question. I am looking for a way to send the results of a SQLFORM.smartgrid search results (or just a specific column) to another controller. Any insights on how to accomplish this? Thank you, David -- --- You received this message because you are

Re: [web2py] Re: Web2py SOAP and local wsdl file

2013-06-19 Thread Massimo Di Pierro
Thank you. Very useful. On Wednesday, 19 June 2013 11:27:34 UTC-5, Mariano Reingart wrote: This is the original webservice: https://wswhomo.afip.gov.ar/wsfev1/service.asmx?WSDL And this is the simulator made with web2py: http://www.sistemasagiles.com.ar/simulador/wsfev1/call/soap

[web2py] Re: web2py 2.4.7 is Out

2013-06-19 Thread Massimo Di Pierro
Thank you for letting us know. Others had reported a memory leak with routes.py but we had never been able to isolate it. Now you narrowed down the problem. We will try reproduce and fix it asap! On Wednesday, 19 June 2013 17:55:56 UTC-5, Aurelio Tinio wrote: Hi Massimo, We've been able to

[web2py] Re: is like a 'kickstarter' clone...

2013-06-19 Thread Massimo Di Pierro
Nice! On Wednesday, 19 June 2013 19:19:01 UTC-5, samuel bonilla wrote: this aplication is opensource built in web2py... i like http://chipincode.com/chipincode -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this