[web2py] We have released Censusgical,Census data visualization prototype for Myanmar.

Myanmar have released Census data in 30 years ,and we built a visualization for it . Powered by web2py, qooxdoo , d3js and uwsgi! http://www.censusgical.com:8800/Censusgical -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

Re: [web2py] We have released Censusgical,Census data visualization prototype for Myanmar.

Very nice stuff. Thanks for sharing. Do you have the code available on github, or any other open-source respository? Kiran Subbaraman http://subbaraman.wordpress.com/about/ On Tue, 23-06-2015 3:44 PM, Phyo Arkar wrote: Myanmar have released Census data

Re: [web2py] Upgrading to the latest version

Besides that, I would copy the files under static folder that comes with the welcome application. Sometimes there’s some update in web2py.js, etc. > On 23 Jun 2015, at 02:03, Joe wrote: > > Thanks very much Massimo, I will do that. BTW: when I upgrade, the files in > my applications are not

Re: [web2py] We have released Censusgical,Census data visualization prototype for Myanmar.

We have plan to release it opensource soon. On Tue, Jun 23, 2015 at 5:56 PM, Kiran Subbaraman < subbaraman.ki...@gmail.com> wrote: > Very nice stuff. Thanks for sharing. > Do you have the code available on github, or any other open-source > respository? > > __

Re: [web2py] We have released Censusgical,Census data visualization prototype for Myanmar.

+1 2015-06-23 13:48 GMT+02:00 Phyo Arkar : > We have plan to release it opensource soon. > > On Tue, Jun 23, 2015 at 5:56 PM, Kiran Subbaraman < > subbaraman.ki...@gmail.com> wrote: > >> Very nice stuff. Thanks for sharing. >> Do you have the code available on github, or any other open-source >>

Re: [web2py] We have released Censusgical,Census data visualization prototype for Myanmar.

Impressive! On 23 June 2015 at 13:49, Michele Comitini wrote: > +1 > > 2015-06-23 13:48 GMT+02:00 Phyo Arkar : > >> We have plan to release it opensource soon. >> >> On Tue, Jun 23, 2015 at 5:56 PM, Kiran Subbaraman < >> subbaraman.ki...@gmail.com> wrote: >> >>> Very nice stuff. Thanks for shar

Re: [web2py] Upgrading to the latest version

On Tuesday, June 23, 2015 at 1:28:11 PM UTC+2, Vinicius Assef wrote: > > Besides that, I would copy the files under static folder that comes with > the welcome application. > > Sometimes there’s some update in web2py.js, etc. > > IMHO, that's not a prudent advice, especially not to inexperienced

Re: [web2py] Upgrading to the latest version

Thanks very much for this advise. I will keep this in mind, but it sounds like I should download the newest version, as I mentioned in my earlier reply, and have both versions on my PC in two different folders. This way I can use the new version of web2py to develop new apps while I can keep m

[web2py] Re: Change position of edit button in SQLFORM

I'll take any ideas at this point lol On Monday, June 22, 2015 at 3:51:50 PM UTC-4, LoveWeb2py wrote: > > I'd really appreciate any help on this. I went through the SQLHTML.py code > and I can see where row_buttons are being assigned, but I'm not sure what I > can change to put the buttoms at th

[web2py] Expressions error in DAL query

Hi all I have a time field check_time that i want to check every day (ex. 13:40) and then do something if the check_time is close to the time I run the query. In other words I run the query every 10 minutes and want to select all the checkpoint records that their check_time is max 5 minutes (300

[web2py] Why MVC and not MCV

I understand from reading about the MVC model in the opening chapter that the Controller automatically calls the View so why isn't it called the MCV model? I want to understand what each of these modules contain and how they're connected, and I'm finding this confusing. Thanks David -- Resour

Re: [web2py] Re: sending email

thank you for your reply Stifan. Iam able to send it to the console. But when Iam trying to send it to gmail, its getting failed. This is the code I used. from gluon.tools import Mail mail = Mail() mail.settings.server = 'logging' mail.settings.sender = 'y...@example.com' mail.settings.login = 'No

[web2py] convert csv file to sqlite

Hi Is it possible to convert a csv file to sqlite quiclly 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 you ar

[web2py] subprocess.call output to a file

hello, I want to write the the output of subprocess.call to a file. How can I do that. Here is my code. #subprocess.call(["gcc","C:\web2py\hello.c","-o","x"]) subprocess.call(["./x"]) Here after executing c program I want to send the output to a file instead of console. -- Chaitanya Pochampa

[web2py] Re: PostgreSQL - Sort with NULLS FIRST

ok, thanks. Raw SQL is my friend then ;) On Wednesday, 17 June 2015 09:18:38 UTC+2, Niphlod wrote: > > nope. > > On Wednesday, June 17, 2015 at 8:57:45 AM UTC+2, pysab wrote: >> >> Hi there :) >> >> I'm using web2py 2.9.10 with a database PostgreSQL 9.4 for a new project >> and I have a question

[web2py] reference will not set value in table

When I display a grid of the table 'station_analysis_parameters' and edit either 'common_params_preset_file' or 'reference analysis_presets' a dropdown list with the rows from analysis_presets.filename' appears but choosing and entry from this list and clicking submit does not do save anythin

[web2py] Re: Autocomplete widgets and digital signatures

I guess the point here is why are you using requires_signature? Normally you do to make sure that only the intended party can access the intended controller function. In your case it is an autocomplete function. That means 1) you do not what the vars is, 2) it is not dangerous since it does not

Re: [web2py] Re: PostgreSQL - Sort with NULLS FIRST

you can try building the query with DAL like the following: sql = db(db.t1)._select(orderby=[db.t1.f1]) db.executesql(sql + ' NULLS FIRST') 2015-06-22 10:43 GMT+02:00 pysab : > ok, thanks. Raw SQL is my friend then ;) > > > > On Wednesday, 17 June 2015 09:18:38 UTC+2, Niphlod wrote: >> >> nope

[web2py] Re: Autocomplete widgets and digital signatures

I have a page which has a form which includes an autocomplete widget. There is a function within a controller to manage that page; this is the function that autocomplete widget uses. It is not an "autocomplete function", although it is being used ("magically", according to the documentation)

Re: [web2py] Why MVC and not MCV

See here: https://en.wikipedia.org/wiki/Model–view–controller > On 22 Jun 2015, at 17:27, David Myers wrote: > > I understand from reading about the MVC model in the opening chapter that the > Controller automatically calls

[web2py] does every controller function require a view?

some functions are not viewed by user; they just return data to another function. Do those need a view? I ask because if it crashes, then user may see the raw view thanks Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Download a file

Hello community I´m trying download a file from my database, I didn´t save the file in the folder 'uploads', I saved my file in a database external, How can I do if a user wanna download the file? For example, from a link. I hope you answer Best regards. -- Resources: - http://web2py.com

[web2py] how to use onupdate with grid

is onupdate like a redirect? How is it used? In example below, control stays with the grid and never goes to function called by the onupdate. No errors. grid = SQLFORM.grid(db.AuthorizedInstance.id==request.get_vars. specificAuthorizationID, editable=True, deletable=False, create=False, se

[web2py] Re: Change position of edit button in SQLFORM

On Tuesday, June 23, 2015 at 8:23:45 AM UTC-7, LoveWeb2py wrote: > > I'll take any ideas at this point lol > You may be the first to be trying it. /dps > > On Monday, June 22, 2015 at 3:51:50 PM UTC-4, LoveWeb2py wrote: >> >> I'd really appreciate any help on this. I went through the SQLHTM

[web2py] Re: Expressions error in DAL query

On Tuesday, June 23, 2015 at 8:43:01 AM UTC-7, icodk wrote: > > rows=db((todayseconds+db.checkpoint.check_time.epoch()>(nowseconds-300)&(todayseconds+db.checkpoint.check_time.epoch()<=nowseconds))).select() > > 5. The problem is that the DAL will not take the: > todayseconds+db.checkpoint.che

[web2py] Re: subprocess.call output to a file

On Tuesday, June 23, 2015 at 8:43:03 AM UTC-7, Chaitu P wrote: > > hello, > > I want to write the the output of subprocess.call to a file. How can I do > that. > Here is my code. > > #subprocess.call(["gcc","C:\web2py\hello.c","-o","x"]) > > subprocess.call(["./x"]) > > Here after executing c pr

[web2py] Re: convert csv file to sqlite

On Tuesday, June 23, 2015 at 8:43:03 AM UTC-7, Laurent Lc wrote: > > Hi > > Is it possible to convert a csv file to sqlite quiclly > thanks > Does Import_from_csv() help? http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=csv#Exporting-and-importing-data> /

[web2py] Re: does every controller function require a view?

if you plan to use functions in controllers that MAY NOT be seen by users, just define them with a parameter (a dummy one works fine) def this_function_is_accessible(): pass def this_is_not_accessible(dummy=None): pass On Tuesday, June 23, 2015 at 7:27:42 PM UTC+2, Alex Glaros wrote: >

Re: [web2py] Upgrading to the latest version

too many scaring advices here... first and foremost, if you have two web2py "roots" in any given (and separate) folders, they'll work without hiccup. second: if you copy your entire application (the folder applications/appname) from "old web2py" to "new web2py" you can test the functionality o

[web2py] Re: Expressions error in DAL query

although not in the book, epoch() is a method of a datetime field. http://pydal.readthedocs.org/en/latest/_modules/pydal/objects.html#Expression.epoch That being said, if I got the requirements properly, which is to craft a select on a datetime field for anything comprised from 5 minutes ago and

[web2py] Re: how to use onupdate with grid

No, it's not a redirect, even if it could be crafted as one. and yep, you are using it wrong. everything "on*" is a callback, not a string... so it needs to be a function. It takes "form" as the input. Strictly speaking, onupdate translates to the same thing of the "onsuccess" callback passed to

[web2py] Re: Expressions error in DAL query

On Tuesday, June 23, 2015 at 11:52:17 AM UTC-7, Niphlod wrote: > > although not in the book, epoch() is a method of a datetime field. > > http://pydal.readthedocs.org/en/latest/_modules/pydal/objects.html#Expression.epoch > Thanks for the pointer. There is interesting stuff to explore there.

[web2py] Re: how to use onupdate with grid

is this right? grid = SQLFORM.grid(db.AuthorizedInstance.id==request.get_vars. specificAuthorizationID, editable=True, deletable=False, create=False, searchable=False, details=False, csv=False, maxtextlength=5000, onupdate= lambda form:updateAuthorizationStatus(form)) -- Resources: - http://

Re: [web2py] Re: sending email

assuming you use web2py latest version (there is appconfig.ini on folder private), please try models/db.py mail = auth.settings.mailer mail.settings.server = 'logging' if request.is_local else myconf.take('smtp.sender') mail.settings.sender = myconf.take('smtp.sender') mail.settings.login = mycon

[web2py] Convert picture to pdf

Hi! It's possible convert one or many pictures in unique pdf file in web2py? USer select one or more pictures stored in app and download a pdf file with selected images. Thanks, Fabiano. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2p

[web2py] Re: reference will not set value in table

I changed the code to the following: *was:* *db3.define_table('station_analysis_parameters',* * ...* *Field('station_preset_file', 'reference analysis_presets', requires=IS_IN_DB(db3, 'analysis_presets.filename')),* *...* *now:* *db3.define_table('station_analysis_parameters',* * ...* *F

[web2py] Re: Autocomplete widgets and digital signatures

Sorry I misunderstood about passing other vars. When I talked about changed state I meant the ajax callback for autocomplete does not change state. Of course the form changes state but that has nothing to do with the autocomplete signature. Anyway, now looking at your code I understand better w

[web2py] Re: Unable to join more than one table in SQLForm.grid

Interesting indeed, this solves my similar problem as well, but how can I force 'distinct=True' in this context? 'distinct' would be specified in a select() statement, but that cannot be done here? Context: I have a complex query combining 3 tables with joins, but I only want to show the fields

[web2py] Re: Convert picture to pdf

pyfpdf which is included in web2py supports images so yes. I never tried it but supposedly you can just use an image html tag and the pdf converter will take care of it for you. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: reference will not set value in table

On Tuesday, June 23, 2015 at 5:15:28 PM UTC-4, jackson.r...@quantachrome.com wrote: > > I changed the code to the following: > > *was:* > *db3.define_table('station_analysis_parameters',* > * ...* > *Field('station_preset_file', 'reference analysis_presets', > requires=IS_IN_DB(db3, 'analysis

[web2py] Re: Paginate

See http://web2py.com/books/default/chapter/29/14/other-recipes#Pagination. On Monday, June 22, 2015 at 7:07:30 PM UTC-4, D. Kev wrote: > > Hi community. > > I am trying paginate a query well is a sub query, I have differents field > from differents tables and I inserted these in a form, I make a

[web2py] Re: does every controller function require a view?

Many times I wrote function for modular approach which return the value for me. Its up to you if the return value you want to display user than view is needed otherwise no. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Writing module for Google apps integration

Hi , I am thinking to expand web2py for more flexible to Google apps integration with the help of Google api like calander , drive, contact etc. Will have to configure in Google api explorer. Can any one suggest me or ready to contribute with me to writing module which generate the template for

[web2py] Re: does every controller function require a view?

Also, note that you can start the function name with a double underscore to keep it private (in that case, it does not have to take any arguments to remain private). Anthony On Tuesday, June 23, 2015 at 2:30:27 PM UTC-4, Niphlod wrote: > > if you plan to use functions in controllers that MAY NO

[web2py] Re: does every controller function require a view?

On Tuesday, June 23, 2015 at 1:27:42 PM UTC-4, Alex Glaros wrote: > > some functions are not viewed by user; they just return data to another > function. Do those need a view? > > I ask because if it crashes, then user may see the raw view > Not sure what you mean by "raw view" and how crashing

[web2py] views: {{include var}}

{{if 'page' in globals():}} {{include page}} {{else:}} {{=list}} {{pass}} erro - File "C:\web2py-m\gluon\template.py", line 684, in parse self.include(top, value) File "C:\web2py-m\gluon\template.py", line 462, in include text = self._get_file_text(filename) File "C:\web2py-m\gluon\

[web2py] How do I check of the version of pysimplesoap in web2py.

I am trying to use soap and I am comming across errors from 2012 is the version included in web2py always the latest with each new version of web2py? I do I check what version is included? I am getting a Tag not found: service (No elements found) error when trying to get the wsdl file. (The file s