[web2py] Re: web2py resources

2014-10-06 Thread Gael Princivalle
Hello. Is there a video tutorial that talk about the scheduler ? Thanks. -- 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 beca

[web2py] Re: PythonAnywhere linking with domain at Godaddy

2014-10-06 Thread Harry Percival
You need to use a CNAME, not a redirect. There's more info here: https://www.pythonanywhere.com/wiki/OwnDomains On Friday, 3 October 2014 03:42:14 UTC+1, Satya Kishore wrote: > > I created a web2py app. > I brought a domain at godaddy. > I even brought a hosting plan at pythonanywhere > How can I

[web2py] Re: web2py trunk is broken??

2014-10-06 Thread Jim S
Any chance of getting an estimate on when this is all going to be resolved? Pulling with hg from google code is still broken. -Jim On Tuesday, September 30, 2014 9:49:54 AM UTC-5, Jim S wrote: > > I just pulled/updated my code from code.google.com using hg. > > When I try to run web2py, I'm

[web2py] Re: web2py trunk is broken??

2014-10-06 Thread Niphlod
I'd seriously stop trying pulling from hg and start from github. That's the main repo now. On Monday, October 6, 2014 4:36:13 PM UTC+2, Jim S wrote: > > Any chance of getting an estimate on when this is all going to be > resolved? Pulling with hg from google code is still broken. > > -Jim > >

Re: [web2py] Re: web2py trunk is broken??

2014-10-06 Thread Anthony
Looks like for backward compatibility, the old dal.py had: DAL.Table = Table However, it appears this got dropped in the recent modularization. Perhaps it should be added back in (not sure if other backward compatibility assignments got dropped as well). Anthony On Monday, October 6, 2014 2:1

[web2py] Compare a list

2014-10-06 Thread Martin Weissenboeck
I have a Field("x", "list:integer") I want to find all rows where x==[1,2,3] (it's necessary to compare the whole list) and I tried: 1. db(db.table.x==[1,2,3]) 2. db(db.table.x=="|1|2|3|") 3. db.executesql("select * from mytable where x='|1|2|3|';") #​1 & #2 did not work (yes, I expect

Re: [web2py] Re: web2py trunk is broken??

2014-10-06 Thread Jim Steil
Any options to clone/pull using Mercurial? On Mon, Oct 6, 2014 at 11:19 AM, Anthony wrote: > Looks like for backward compatibility, the old dal.py had: > > DAL.Table = Table > > However, it appears this got dropped in the recent modularization. Perhaps > it should be added back in (not sure if o

[web2py] Re: Compare a list

2014-10-06 Thread Anthony
db.table.x.contains([1, 2, 3], all=True) Anthony On Monday, October 6, 2014 12:29:23 PM UTC-4, mweissen wrote: > > I have a Field("x", "list:integer") > I want to find all rows where x==[1,2,3] (it's necessary to compare the > whole list) and I tried: > >1. db(db.table.x==[1,2,3]) >2. d

[web2py] Supplied setup scripts for fedora and centos do not work under centos 7. Here is the updated script.

2014-10-06 Thread Dragan Matic
Because of the changes in apache configuration and in the way iptables are configured in centos 7 none of the automated scripts could install web2py. In the attachment is the updated script that will install web2py with apache on fresh install of centos 7. SELinux configuration is still missing

Re: [web2py] Which DB is best suited for many single entry to one table ?

2014-10-06 Thread Michele Comitini
Those numbers are easily handled by both databases using commodity hardware, real or virtual. Choose postgresql, it's good choice since it has support for geo spatial data management, while IMHO there is no reason to use mysql. mic 2014-10-06 6:30 GMT+02:00 arutti : > I have a geolocalisation ap

[web2py] Re: imap and google mail

2014-10-06 Thread Massimo Di Pierro
Please open a ticket. On Friday, 3 October 2014 16:12:17 UTC-5, mweissen wrote: > > Hi, > I have tried to use imap together with a gmail account: > > imapdb = > DAL("imap://the.n...@gmail.com:the.passw...@imap.googlemail.com:993", > pool_size=1) > imapdb.define_tables() > > > But there is no con

[web2py] Re: imap and google mail

2014-10-06 Thread Leonel Câmara
It's google blocking it. Go here and activate less secure apps access. https://www.google.com/settings/security/lesssecureapps That said, we may need to change how the login is done so this isn't necessary. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://git

[web2py] Re: Add Fields to tables using loops

2014-10-06 Thread Nurendra Choudhary
A calendar with flag for each user -- 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 Grou

[web2py] Asynchronous tasks

2014-10-06 Thread Nurendra Choudhary
Hi, I wanted to check for something at regular interval of a day or so. How can i do it. for example, everyday i want to check if(date==datetime(12,3,2014)) Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - http

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-06 Thread Narūnas Krasauskas
Hi, thanks for the reply. Yes you are right, users who can get to the search page ideally would be able to search/see all the records. However you are not right by saying that there is no performance impact on fetching first 50 and next 50, next 1000, etc. I did some benchmarking, so please hav

[web2py] web2py https and Codeanywhere

2014-10-06 Thread olivier hubert
Ave you already start web2py in https mode in Codeanywhere devbox ? I apply this method to generate certificate and apply the adequate command lines to activate https but my server don't send any pages. http://stackoverflow.com/questions/12834550/simplest-way-to-setup-remote-admin-access-to-a-web

[web2py] How would I add this to response.files...or would I?

2014-10-06 Thread Niels Jensen
Hi Guys, I'm trying to convert a html template for my first web2py app. I'm pretty new to Python and very new to Web2py. I've written a few Python scripts at work which hook into the API's of some of our services and pull back some useful data Eventually I'd like to make this information ava

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-06 Thread Pengfei Yu
Sorry, There is a typo in the previous question. In this sentence "In the data table scheduler_worker and scheduler_run I want to delete both entries", what I want to say is "scheduler_task" and "scheduler_run" tables. In my design, I linked a project with a task by adding an field called "proc

[web2py] Re: PythonAnywhere linking with domain at Godaddy

2014-10-06 Thread olivier hubert
Or you can use Cloudflare and take advantage of DDOS protection and other cool stuff freely. Le lundi 6 octobre 2014 12:27:41 UTC+2, Harry Percival a écrit : > > You need to use a CNAME, not a redirect. There's more info here: > https://www.pythonanywhere.com/wiki/OwnDomains > > On Friday, 3 O

[web2py] Re: Web2py on AWS Opsworks

2014-10-06 Thread Ion Caliman
Hi! I just created these recipes: https://github.com/icaliman/opsworks-web2py luni, 11 august 2014, 18:48:18 UTC+3, Rebecca Raguindin a scris: > > Is there anyone with Opsworks recipe available to install/deploy web2py > on an UBUNTU (14.04). Is it possible to install via Opsworks? > > Thanks

[web2py] Apostrophe causes new column in PYFPDF

2014-10-06 Thread Richard Warg
I am using the sample report from *https://code.google.com/p/pyfpdf/wiki/Web2Py#Sample_Report.* It works as expected until I have an apostrophe or ampersand in the string. ORIGINAL # create several rows: rows = [] for i in range(1000): col = i % 2 and "#F0F0F0" or "#FF"

[web2py] looking for a way to import big csv data file into the database.

2014-10-06 Thread kenny c
I've been trying to import big csv file into the database by running the private script, but the system kills it for running too long.. I am running postgresql and I have also tried COPY query. However, I don't have id column for over 10million rows and Excel just dies on me if I try to input i

[web2py] Doubt understanding custom db.table.insert date field format

2014-10-06 Thread Miquel Fontanals
Hi all, I've a simple model like this db.define_table("lot", Field('name', 'string', length=1024, required=True, unique=True), Field('start_date, 'date', required=True) ) db.lot.start_date.requires = IS_DATE(format=T('%Y-%m-%d'),error_message=T('must be -MM-DD!')) And I have a cus

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-06 Thread Narūnas Krasauskas
Also I wonder, why would you say something like this: 2014 m. spalis 4 d., šeštadienis 20:08:50 UTC+1, Niphlod rašė: > > The thing you posted > """ > Same story here. I like *grid*, I like pagination, however I'm missing > the feature of limiting the total number of rows in the output. > In my c

[web2py] Can't create app on Web IDE

2014-10-06 Thread Noel David
Hello, I am Noel. I was trying to create an app using the WebIDE but when I clicked the Create button, nothing happened and my app was not listed. Before, on this same day, I was unable to login. Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gith

[web2py] Re: SQLFORM uploads with uploadfs and Amazon S3

2014-10-06 Thread Massimo Di Pierro
you say "it is not removing". Do you expect it to delete the files? On Friday, 3 October 2014 16:31:28 UTC-5, Mark Graves wrote: > > Hey Everyone, > > Does anyone have experience using SQLFORM with Amazon S3 for upload fields? > > My standard SQLFORM(db.table,record) is not removing the S3 object

[web2py] Re: Where are attachments?

2014-10-06 Thread Massimo Di Pierro
and you if install pyfilesystem you can make them go anywhere else you want, including S3. On Saturday, 4 October 2014 13:38:18 UTC-5, Niphlod wrote: > > it depends. > By default, a Field('something', 'upload') stores files in the uploads > folder. > > You can choose to store them on the db but

[web2py] Re: Supplied setup scripts for fedora and centos do not work under centos 7. Here is the updated script.

2014-10-06 Thread Massimo Di Pierro
Thanks. I added it to trunk! :-) On Monday, 6 October 2014 15:22:42 UTC-5, Dragan Matic wrote: > > Because of the changes in apache configuration and in the way iptables are > configured in centos 7 none of the automated scripts could install web2py. > In the attachment is the updated script tha

[web2py] Re: Asynchronous tasks

2014-10-06 Thread Massimo Di Pierro
You should not. You should use the scheduler. On Sunday, 5 October 2014 06:29:23 UTC-5, Nurendra Choudhary wrote: > > Hi, > > I wanted to check for something at regular interval of a day or so. > How can i do it. > > for example, everyday i want to check if(date==datetime(12,3,2014)) > > Thanks. >

[web2py] Re: looking for a way to import big csv data file into the database.

2014-10-06 Thread Massimo Di Pierro
You should upload the file first then run a scheduler task that reads it and store into the database in background. On Sunday, 5 October 2014 17:49:16 UTC-5, kenny c wrote: > > I've been trying to import big csv file into the database by running the > private script, but the system kills it for

[web2py] Embed Tweets

2014-10-06 Thread Nate
How do I embed my tweets when I create a page in web2py? Many Thanks -- 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 yo