Re: [web2py] wiki 1st question: problem with an anchor

Thanks Jonathan, it works! If I want to have a link inside file abc to anchor [[a]] I have to use [[mylink #a]] - that's ok! But how link from file def to abc#a? I have tried [[mylink file:abc#a]] - this links to file://abc%23a What is the correct syntax? Regards, Martrin 2011/7/24 Jonathan Lun

[web2py] Tr.lời: Re: JSON & 1.97.1

Error when call the databales function directly and/or call call/json/datatables (I try again universal_caller function from old version (1.96.4), it works fine.) Traceback (most recent call last): File "D:\web2py197\gluon\restricted.py", line 192, in restricted exec ccode in environme

[web2py] Re: Tr.lời: Re: JSON & 1.97.1

This was fixed in trunk some time ago On Jul 25, 2:24 am, toan75 wrote: > Error when call the databales function directly and/or call > call/json/datatables > (I try again universal_caller function from old version (1.96.4), it works > fine.) > > Traceback (most recent call last): >   File "D:\we

[web2py] Re: export data to OOO and Excel

Have a look at http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xls http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xlsx they use tablib (which includes xlwt, ...) http://docs.tablib.org/en/latest/index.html

[web2py] About the About page

Hello, just a suggestion I need more pages like the about page. Pages that are static and not related to views or controllers or models. The about page functionality shoud be more generic and allow for other pages to be available in the app Maybe a WYSIWYG for creating this pages(welcome page, a

Re: [web2py] Re: export data to OOO and Excel

How about a video tutorial exporting to excel? 2011/7/25 selecta > Have a look at > > http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xls > > http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xlsx > > they use tablib (which includes x

[web2py] MongoDB supported by DAL

When will MongoDBAdapter finalize so we can use it with DAL?

[web2py] Re: The web2py grid/crud plugin you've always dreamed about!

does it or how does it support record representation for linked tables ? The record has a 'product' field linked to a 'db.product' with an id. and name field, and the name appeared in PowerTable with the following code in db.py . The representation that worked fine in PowerTables is only displayin

[web2py] Re: About the About page

On Jul 25, 10:50 am, António Ramos wrote: > Maybe a WYSIWYG for creating this pages(welcome page, app manual page,etc). plugin_wiki?

Re: [web2py] Re: Tr.lời: Re: JSON & 1.97.1

may be is time for a new official version ?

Re: [web2py] Re: About the About page

Oops, you are right! 2011/7/25 cjrh > On Jul 25, 10:50 am, António Ramos wrote: > > Maybe a WYSIWYG for creating this pages(welcome page, app manual > page,etc). > > plugin_wiki? >

[web2py] Re: Tr.lời: Re: JSON & 1.97.1

yes. will post soon. On Jul 25, 5:13 am, Vasile Ermicioi wrote: > may be is time for a new official version ?

[web2py] cron problem

dear all, I have a strange problem with cron it seams it does not respect what I have eritten in crontab... this is my crontab: 30 6 * * * root *cron/fetch_m_data 0 7 * * * root *default/send_mail_msg 30 14 * * * root *cron/fetch_x_data 0 21 * * * root *cron/fetch_m_data 0 23 * * * root *c

[web2py] Ticket issued: unrecoverable

Hello, when i try to acces my server admin remotely with FQDN and not by ip i get this error *Ticket issued: unrecoverable* Why? thank you

[web2py] upload - S3 storage

Hi all, Before I go off and make an attempt at creating a S3 upload function, I was just wondering if anyone has a working version ? I read the discussion on this and for me I need a way of storing uploaded images on S3 to share between a few VPS on Amazon's EC2. The only other way to accompl

[web2py] Strange form behaviour.

To get rid of the colon in the forms I do the following: form=SQLFORM(...) for label in form.elements('label'): label.components = label.components[-2] This works for: form=auth() form.SQLFORM(...) form=SQLFORM.factory(...) However, in case of form=crud.update(...) I get the following erro

[web2py] Re: Strange form behaviour.

The error is in your code for label in form.elements('label'): label.components = label.components[-2] because the delete row an a empty label. for label in form.elements('label'): if len(label.components)>=2: label.components = label.components[-2] anyway, what is that line for

[web2py] Re: Ticket issued: unrecoverable

never seen this before. can you try trunk? On Jul 25, 6:44 am, António Ramos wrote: > Hello, when i try to acces my server admin remotely with FQDN and not by ip > i get this error > > *Ticket issued: unrecoverable* > > Why? > > thank you

[web2py] Re: cron problem

Please open a ticket. Does it behave better is 30 6 * and 30 14* are replaced by 0 6 * and 0 14 *? On Jul 25, 6:22 am, Manuele Pesenti wrote: > dear all, > I have a strange problem with cron it seams it does not respect what I > have eritten in crontab... this is my crontab: > > 30 6 * * *  root

Re: [web2py] Re: Ticket issued: unrecoverable

Sorry, i´m no expert. What do you mean? try trunk? Sorry António 2011/7/25 Massimo Di Pierro > never seen this before. can you try trunk? > > On Jul 25, 6:44 am, António Ramos wrote: > > Hello, when i try to acces my server admin remotely with FQDN and not by > ip > > i get this error > > > >

Re: [web2py] Re: Ticket issued: unrecoverable

this is the link http://apps.cires.pt:10800/Lims/Default/index if you try http://194.65.91.152:10800/Lims/Default/index it works ok António Em 25 de julho de 2011 13:37, António Ramos escreveu: > Sorry, i´m no expert. > > What do you mean? > try trunk? > > Sorry > António > > 2011/7/25 Massimo

[web2py] Extend default user/group model

Hi to all, when I create a new application, the user/group db model is created automatically. How can I extend it? Should I redefine it? I would like to add some fields and some foreign keys to users or group. Thanks to all! (... and sorry for my english)

Re: [web2py] Re: cron problem

On 25/07/2011 14:33, Massimo Di Pierro wrote: Please open a ticket. Does it behave better is 30 6 * and 30 14* are replaced by 0 6 * and 0 14 *? can you tell me how to open a ticket? the fact is that the same application runs correctly in my local laptop (Debian testing) and not on the produc

Re: [web2py] upload - S3 storage

HI, Just looking at dal.py and there is a SQLCustomType, I was wondering if the functionality i would require could be added via this class?, Would this be the way to go ? Nils On Mon, Jul 25, 2011 at 1:04 PM, Nils Olofsson wrote: > Hi all, > >  Before I go off and make an  attempt at creatin

Re: [web2py] Re: Ticket issued: unrecoverable

Its working. Was a DNS problem. Sorry Em 25 de julho de 2011 13:51, António Ramos escreveu: > this is the link > http://apps.cires.pt:10800/Lims/Default/index > if you try > http://194.65.91.152:10800/Lims/Default/index > it works ok > > António > > Em 25 de julho de 2011 13:37, António Ramos e

[web2py] Re: Extend default user/group model

See http://web2py.com/book/default/chapter/08#Customizing-Auth. Make sure you define your custom tables after you instantiate Auth, but before you call auth.define_tables(). Anthony On Monday, July 25, 2011 7:23:05 AM UTC-4, Simone Fiorenzoni wrote: > Hi to all, > > when I create a new appli

[web2py] Re: Can't get linkto working in SQLFORM

I updated the book -- added args='db' to the URL() call. Does that make it work? Anthony On Monday, July 25, 2011 2:28:26 AM UTC-4, jc wrote: > Maybe the fix is just remove it from the manual, since the > instructions in the manual don't work. > > On Jul 24, 9:40 am, Massimo Di Pierro > wr

Re: [web2py] Re: Ticket issued: unrecoverable

What kind of a problem was it? Kenneth Its working. Was a DNS problem. Sorry Em 25 de julho de 2011 13:51, António Ramos > escreveu: this is the link http://apps.cires.pt:10800/Lims/Default/index if you try http://194.65.91.152:10800/Lims/Default

[web2py] How to debug HTTP 500 error on GAE?

I'm using the latest GAE 1.5.2 and web2py 1.96.4. When I run the application with: python2.5 /opt/gae-python-sdk/dev_appserver.py --port 8001 ./web2py and open http://localhost:8001 in a browser I get the HTTP 500 internal server error. There is no message in the appserver console output, there

Re: [web2py] Re: blob attach field issue with 1.97.1

Hello Massimo, Still can't figure out where the problem comes from... Your help would be appreciate. Richard On Fri, Jul 22, 2011 at 9:43 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Can you please try: > > Field('field1','upload',uploadfield='field1_blob'), > > Field('field1_b

Re: [web2py] Re: Ticket issued: unrecoverable

Our domain is CIRES.pt we have an internal dns for cires where we did not create the app.cires.ptrecord. i created the app.cires.pt only in my external dns. When i tested for app.cires.pt the web2py "server" pc tried to resolve internaly and gave that error. I saw in the log of web2py this error

[web2py] JQuery Mobile plugin . No date picker ?

no datepicker in jquery mobile plugin? thank you António

[web2py] REPRODUCED : blob attach field issue with 1.97.1

Hello, I report a problem last week... I finally be able to reproduce... It needs form.accept() to reproduce the problem... I attach a app that reproduce the problem. Thanks Richard PS.: I will attach the app when the mail get on the list.

[web2py] DAL left join problems

This query works as expected in the sqlite command line client: SELECT first_name, course_id FROM auth_user LEFT JOIN training_requirements ON auth_user.id = training_requirements.user_id WHERE course_id=8 OR course_id IS NULL; It returns one and only one row for each record in auth_user and the

[web2py] web2py for freelance work

I'm picking out a framework to use for freelance web development. Does anyone use web2py in that sort of situation? How does it fare? Do you find anything particularly limiting or particularly easy? How do clients respond when you tell them you're building the site in Python (not PHP), and that you

[web2py] Re: upload - S3 storage

Hi, This is what I have done so far, really rough. I have extended the Field class and added some extra functions. I called the class s3upload and I created function within the class called s3_store and s3_retrieve. I was just wondering if upon creating these classes. I.E creating the same funct

[web2py] Re: DAL left join problems

Found it, but don't know what to do about it. Here is what the DAL is spitting out: SELECT auth_user.first_name, training_requirements.course_id FROM auth_user LEFT JOIN training_requirements ON (training_requirements.user_id = auth_user.id) WHERE (((training_requirements.course_id = 8) OR (trai

Re: [web2py] Re: DAL left join problems

Could you post your models... You can make view at DB level and define a web2py model of your view... It help to get things done sometime and you can come back later and build web2py query correctly. Richard On Mon, Jul 25, 2011 at 1:45 PM, Cliff wrote: > Found it, but don't know what to do ab

[web2py] Re: Can't get linkto working in SQLFORM

Nope. >>> link = URL('list_records', args='db') >>> link '/test/default/list_records/db' The link for id = 1 will be e.g.: http://127.0.0.1:8000/test/test/list_records/db/dog?query=db.dog.owner%3D%3D1 where the query part looks better but it still fails: Traceback (most recent call last): Fil

Re: [web2py] web2py for freelance work

Hi spiffytech in my experience: 1.- Yes I use it, mostly for intranet apps. 2.- Well... difficult question... 3.- It's really easy (if the customer has its own server), if not, you have to look for a good one. 4.- If the customer knows something about programming he says 'wow', if the customer kno

[web2py] Re: Can't get linkto working in SQLFORM

The original book had: When editing an existing person, the appadmin UPDATE form shows a link to a page that lists the dogs that belong to the person. This behavior can be replicated using the linkto argument of the SQLFORM. linkto has to point to the URL of a new action that receives a query st

[web2py] Re: web2py for freelance work

See http://www.experts4solutions.com/. On Monday, July 25, 2011 1:26:16 PM UTC-4, spiffytech wrote: > I'm picking out a framework to use for freelance web development. Does > anyone use web2py in that sort of situation? How does it fare? Do you > find anything particularly limiting or particula

Re: [web2py] web2py for freelance work

> I'm picking out a framework to use for freelance web development. Does anyone use web2py in that sort of situation? How does it fare? Do you find anything particularly limiting or particularly easy? How do clients respond when you tell them you're building the site in Python (not PHP), and th

[web2py] References and markmin

Hi, the markmin manual says about references Citations and References Citations are treated as internal links in html and proper citations in latex if there is a final section called "References". But I want to use the German word "Literaturverzeichnis" instead of "References".- what shall I do?

[web2py] Re: DAL left join problems

I think the answer may be to manually insert the request_tenant field where I want it. I really only want it in the tables that represent objects, not in the many-to-many linking tables. Thanks, Richard. I got it working. The table structure is really pretty simple. It's lifted from a working P

[web2py] web2py GAE and memory usage

Hi all, i'm wondering if anyone has thoughts on how memory management works with regards to the the DAL and GAE. i have some "taskqueue" tasks on GAE that are invoked via GAE cron to aggregate data for me on a daily basis. these operations can work on 500 or more records per invocation. some

[web2py] Re: Database auditing - comments please

Newer version attached, has been tested in one specific app which brought up some issues with tables that have references to them (these have been fixed). Now patches instance instead of class (so web2py's normal reloading works equally well) Massimo / Jonathan - could you comment on the proba

[web2py] Re: upload - S3 storage

Creating a custom filed type seems unnecessary. "upload" fields end up just being filenames. Perhaps you could have a compute field that uploads the image to S3. Retrieving should just be a simple URL reference.

[web2py] Re: upload - S3 storage

And you might want to have a look at "boto" for a Python interface to Amazon.

[web2py] Re: Extend default user/group model

Also, "extra_fields" was recently added: - auth.settings.extra_fields['auth_user'].append(Field('country')) allows to extend auth_* tables without need of definiting a custom auth_* table. Must be placed before auth.define_tables()

[web2py] Re: About the About page

I'm not totally sure what you are looking for but adding static pages is pretty easy. I usually put them in default.py so they are at the top level but you could put them anywhere. A one liner in a controller file: def about(): return dict() And whatever you want in a view file.

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

Really awsome Bruno, I´m trying to implement it on our companys intranet and got one question and one suggestion. Is it possible to use T() on headers? Something like: headers=[['f_name',T('Name')]] Highlightning rows, sometimes it would be good to highlight some specific rows? Kenneth

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

2011/7/25 Kenneth Lundström > headers=[['f_name',T('Name')] I think you can use headers=[['f_name',str(T('Name'))] The highlight can be easuly implemented with JavaScript and CSS.

[web2py] Re: Can't get linkto working in SQLFORM

> - Why was this changed?. this was changed 2 years ago because the syntax of appadmin changed from raw SQL to DAL. > - Does anybody use it this way?. nobody. That is why we changed it. The documentation is incorrect. Strangely this was changed BEFORE the documentation was published. On Jul 25,

[web2py] Re: References and markmin

This is poorly documented. Look at the bottom of the markmin2latex. You can pass your own latex header and footer. They can redefine the title of References. I do not remember how to do it in latex On Jul 25, 2:14 pm, Martin Weissenboeck wrote: > Hi, > > the markmin manual says about references >

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

I published my first new version of our intranet on our production server and now I´m getting: Traceback(most recent call last): File"/data/domains/web2py/gluon/restricted.py",line181,inrestricted execccodeinenvironment File"/data/domains/web2py/applications/economy/models/plugin_PowerGr

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

Sorry, I found the error already. A stupid error. Our production server was laging behind on updates, was using 1.95.1, but not anymore. And now Powergrid is working. Kenneth I published my first new version of our intranet on our production server and now I´m getting: Traceback(most rece

[web2py] Re: cron problem

Manuele Pesenti wrote: dear all, I have a strange problem with cron it seams it does not respect what I have eritten in crontab... this is my crontab: 30 6 * * * root *cron/fetch_m_data 0 7 * * * root *default/send_mail_msg 30 14 * * * root *cron/fetch_x_data 0 21 * * * root *cron/fetch_m_

[web2py] A model of local and remote files

Anyone can help me. I want to create a model in web2py to save local files and remote files. How can I create a model to support both uploads or types of records? Anyone can help me.

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

BTW: You can remove or comment these two lines: from gluon.custom_import import track_changes track_changes() This is usefull only on my development environment. PowerGrid works only in web2py 1.97+, because it uses 'current' to deal with session, request, response and T I made some im

[web2py] please check out the nightly built

I am planning to release a 1.98.1 on Sunday. Many tickets have been closed. Please check out the nightly built on http://web2py.com/examples/default/download and report any issue. Massimo

[web2py] Re: Can't get linkto working in SQLFORM

On Monday, July 25, 2011 5:19:45 PM UTC-4, Massimo Di Pierro wrote: > > > - Why was this changed?. > > this was changed 2 years ago because the syntax of appadmin changed > from raw SQL to DAL. > > > - Does anybody use it this way?. > > nobody. That is why we changed it. The documentation is i

[web2py] Re: Running web2py on Jython

On Jul 23, 2:08 pm, Richard wrote: > Hi Chris, > > I for one am glad that you reanimated this thread :-) > > Your findings probably led to hg commit #2119 which has the commit > comment "possible __builtin__ fix for jython, thanks Chris Clark". > This raised some hopes, but the current hg tip stil

[web2py] Is the classic green and black layout still available?

Hi, I think the former green and black default layout looks very nice, so I'd like to use it, but it doesn't seem to be available in the recent versions, nor on the page to download new layouts. Is this layout still available somewhere? Here is an image showing what I mean http://web2py.com/book/s

Re: [web2py] Is the classic green and black layout still available?

http://www.web2py.com/examples/static/1.82.1/web2py_src.zip On Mon, Jul 25, 2011 at 10:08 PM, G wrote: > Hi, > I think the former green and black default layout looks very nice, so > I'd like to use it, but it doesn't seem to be available in the recent > versions, nor on the page to download new

[web2py] web2py DAL

DAL connect mssql use Pyodbc ，but this module can't call procedure with out parameter 。

[web2py] Re: upload - S3 storage

pbreit might be right - you would still end up uploading the file to your server, and then saving to s3. (though if your server was ec2 there might be a way to mount an s3 bucket, not sure though). i also agree on looking at the boto interface: http://code.google.com/p/boto/ i'm using an olde

[web2py] Re: web2py for freelance work

i do all my work as freelance work, and have done 98% of it in web2py in the last 2-3 years. it works like a champ, and is really easy to quickly build well-written code that i can easily support 2 years later. i can't say that for other frameworks i have worked on. also because web2py is ope

[web2py] Re: How to debug HTTP 500 error on GAE?

yikes!! i can't say that i ever had an error without log messages. somethings to look for: - do you have a logging configuration file that is hiding log messages? - is your web2py routes (routes.py or the other routing mechanism) causing a problem? - is your app.yaml not mapping the URLs to

[web2py] Re: Can't get linkto working in SQLFORM

I am not sure this is something we want to encourage outside appadmin. It should be corrected but it should say this is for appadmin. On Jul 25, 5:57 pm, Anthony wrote: > On Monday, July 25, 2011 5:19:45 PM UTC-4, Massimo Di Pierro wrote: > > > > - Why was this changed?. > > > this was changed 2

[web2py] Re: export data to OOO and Excel

@selecta, thanks for directing to 'tablib'. It is also a good choice. I am assessing whether to use 'excel-python' or 'tablib'. :-| On Jul 25, 1:52 pm, António Ramos wrote: > How about a video tutorial exporting to excel? > > 2011/7/25 selecta > > > > > Have a look at > > >http://tlc2.hg.sourcef