My Database Table (sqlite) not readable in Web2Py if I CSV import a
bad date!
Field format in CSV should be: 2009-03-31 10:46:51
Excel converts this silently to: 31/03/2009 10:46
The record gets imported into DB but then a query on this table gives:
Traceback (most recent call last):
File
My Database Table (sqlite) not readable in Web2Py if I CSV import a
bad date!
Field format in CSV should be: 2009-03-31 10:46:51
Excel converts this silently to: 31/03/2009 10:46
The record gets imported into DB but then a query on this table gives:
Traceback (most recent call last):
File
...if the servername contains an underscore (_).
I think it is a bug in internet explorer, so no need to change web2py
for that.
A workaround is to use the ip address instead of the servername.
Hopefully this post can prevent other people from spending half a day
on this ;)
Best regards,
Hi Stefan,
the problem is not in IE but in your hostname. Hostname simply must NOT
contain anything but letters, nubers and '-' character. Anything else is
corretly assumed as malformed url and should not work.
So don't blame IE (even i don't like it neither), but this is not error,
that's
Massimo, could you please detail why Epydoc is limited. I personaly
use it with ReST formatting and find it OK, but am interested to see
the lacks.
I see an 'autodoc' extension for Sphinx. Is it the kind of thing you
want to do?
On Mar 31, 6:29 am, Yarko Tymciurak yark...@gmail.com wrote:
I've
In sphinx you could:
- get data from docstrings (like epydoc)
- write your own instructions/tips using reST
and all on one site with (imo) great design.
On Mar 31, 2:48 pm, Grahack christophegrag...@yahoo.fr wrote:
Massimo, could you please detail why Epydoc is limited. I personaly
use it
download this file:
http://tomqyp.javaeye.com/upload/picture/pic/34353/2878e3c1-6215-316d-aac8-f69a4a08e0cc.jpg
and upload the file on web2py app, web2py will say :timeout:timed
out.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to
I do not understarstand
On Mar 30, 11:45 pm, Yarko Tymciurak yark...@gmail.com wrote:
I looked at your post into trunk, Massimo - expedient... but can we have
this be something more... functional before next release?
I am thinking like this:
istead of:
ignore_rw=True
appadmin would
The problem is that web2py has not way of knowning is excel is set to
US or EU date format.
On Mar 31, 4:26 am, Fran francisb...@googlemail.com wrote:
My Database Table (sqlite) not readable in Web2Py if I CSV import a
bad date!
Field format in CSV should be: 2009-03-31 10:46:51
Excel
It was clear from me at pycon that Sphinx is considered the present
and future of python documentation.
On Mar 31, 7:48 am, Grahack christophegrag...@yahoo.fr wrote:
Massimo, could you please detail why Epydoc is limited. I personaly
use it with ReST formatting and find it OK, but am
still struggling to get a solution with this GAE issue.
anyone with experience of similar?
any help appreciated
Chrism
On Mar 29, 11:59 pm, murray3 ch...@murraypost.net wrote:
Here it is I have commented much whilst testing for mistake
thanks for any help
chrism
--
model:
Hello mate
I'm trying to parse the JSON object inside the callback method from my
client side, I got a message saying No JSON object could be
decoded... Do you please have any idea about what I'm doing wrong in
my callback method...Below you can see the sample of the callback
method, and format
So don't blame IE (even i don't like it neither), but this is not error,
that's correct.
Thanks a lot for telling me! I didn't know this.
Best regards,
Stefaan.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
On Tue, Mar 31, 2009 at 8:03 AM, mdipierro mdipie...@cs.depaul.edu wrote:
I do not understarstand
What I am saying is that you solved the problem of write permissions on a
column in appadmin by ignoring the permissions. If I now want to be able
to see the various permissions in appadmin,
Beyond that, epydoc is virtually unsupported now (having no activity for
more than a year now). I've used it for quite a while, but it chokes on
some perfectly valid Python. To accommodate it, you sometimes have to
jump backwards through fiery hoops. =(
I don't know Sphinx, but it is THE
Before you export from excel, you should be able to set your date field
format to something that will work, for example, in format cells - number
- Custom
set the field to -mm-dd hh:mm:ss
That matches what you are saying the field should be, and excel should
then export in this format to
On Tue, Mar 31, 2009 at 10:12 AM, Timothy Farrell tfarr...@swgen.comwrote:
Beyond that, epydoc is virtually unsupported now (having no activity for
more than a year now). I've used it for quite a while, but it chokes on
some perfectly valid Python. To accommodate it, you sometimes have to
hello everybody, I've created a little web2py application to manage
customers and contacts in my company. I've put the application on a
server and I've discovered some problems with rispect to i18n: for
some PC over the network some dates and strings appear with *** in
front of them but not if I
Hi Marco,
you got mdifferent preffered language set in your browsers.
*** indicates application is using some language file and *** marks
variables which were not translated yet.
So check language prefferences in your browsers and make translation in
tour application administration. :)
Michal
On Mar 31, 5:13 pm, Yarko Tymciurak yark...@gmail.com wrote:
Before you export from excel, you should be able to set your date field
format to something that will work, for example, in format cells - number
- Custom
set the field to -mm-dd hh:mm:ss
That matches what you are saying the
Can you summerize what the problem is?. I thought this:
# SQLField('timestamp','double',default=now),
was the bug and you fixed it.
On Mar 31, 8:14 am, murray3 ch...@murraypost.net wrote:
still struggling to get a solution with this GAE issue.
anyone with experience of similar?
any help
You have a logical problem. the sj.loads must be in the action that
receives the ajax call action in your case. It cannot be embedded in
the JS code that makes the call.
On Mar 31, 9:24 am, Yannick ytchatch...@gmail.com wrote:
Hello mate
I'm trying to parse the JSON object inside the callback
On Mar 31, 10:48 am, Fran francisb...@googlemail.com wrote:
On Mar 31, 5:13 pm, Yarko Tymciurak yark...@gmail.com wrote:
Before you export from excel, you should be able to set your date field
format to something that will work, for example, in format cells - number
- Custom
set the
Thanks Massimo But inside my callback method i do receive another JSON
message as response and I want to parse it for display... Do you know
How i can do it then ?
Thanks,
Yannick P.
On Mar 31, 12:22 pm, mdipierro mdipie...@cs.depaul.edu wrote:
You have a logical problem. the sj.loads must be
On 31 mar, 02:30, DenesL denes1...@yahoo.ca wrote:
Jose, do your test tables have integer indexes?.
Yes. The field primary key is integer auto-increment.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
web2py
Massimo,
I am not sure if I understand you correctly.
the routes_in looks something like:
('.*:/create','/init/default/create'),
('.*:/mycases','/init/default/mycases'),
create mycases are functions in default.py. After this routes
rewrite, I am able to type server/create and it redirects to
Talking about future needs... What would you do/how would you display
in the admin if the columns are to be read-only only for certain
groups ? For example editors can modify most parameters of an article,
but only a publisher should be able to change it's status.
On Mar 31, 5:06 pm, Yarko
Massimo,
I tried the Dojo everything worked out fine. I didn't take screen
shots, but if no one else is up for it I'll do it :P Only one question
aboutit though. Why do you use db.Field() for declaring SQL Fields
rather than SQLField() within the documentation? This may cause
confusion for
On Tue, Mar 31, 2009 at 12:35 PM, AchipA attila.cs...@gmail.com wrote:
Talking about future needs... What would you do/how would you display
in the admin if the columns are to be read-only only for certain
groups ? For example editors can modify most parameters of an article,
but only a
On Tue, Mar 31, 2009 at 12:45 PM, Yarko Tymciurak yark...@gmail.com wrote:
*snip*
What is not
(sorry - didn't see that remnant text - it should not be there...)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
You response is received by the JS so no coversion is necessary My
guess is
function Save() {
var data = $.toJSON( # I convert JSON object to simple text
here));
$.ajax({
type: 'POST',
url:
We could have a field.csv_in (similar to field.requires) that runs
when table.import_from_csv_file is called and passes it the current
value (this could go inside the current 'fix' function).
So you can do, e.g.
table.field.csv_in=IS_DATETIME('%d/%m/%Y %H:%M',error_message='must be
D/MM/
Hi to all.
I've finally buy the manual... wow 260 page... I don't sleep tonight.
^___^
I must use some strange browser.
For me I use Opera that's the best browser (for me, no browser war
please ^___^ )
but I want create usb key with all the usefull thing to work so I must
put web2py and a
Let me go over this quickly:
var data = $.toJSON( # I convert JSON object to simple text
here you create a JSON encoded 'data' object, which is in line with
the following jQuery (Javascript) code:
$.ajax({
type: 'POST',
On Tue, Mar 31, 2009 at 8:53 PM, LordMax lord...@gmail.com wrote:
Problem.
In Admin when I must edit something in the editor I've some trouble.
No syntax highlighting and no resize.
The editor used explicitely checks for the browser name. I use
Minefield (the development-version of Firefox)
gosh... I wonder how this would work... right now, the csv library is called
in more places than you'd imagine... and needs some cleanup / encapsulation
as it is...
On Tue, Mar 31, 2009 at 1:31 PM, DenesL denes1...@yahoo.ca wrote:
We could have a field.csv_in (similar to field.requires) that
I do not think the CSV formatting belongs in the model. There may be
difference places in an app where importing is done suing different
conventions. And why for csv and not xml? etc.
I will just post an example of how to create your own importer. It is
very short and easy.
Massimo
On Mar 31,
Here's what I want to do - be able to show/update selected values in a
multiple checkbox form.
checkbox values come from a predefined table: ['A', 'B', 'C', 'D]
user settings (separate field) that have been saved are: ['A', 'C']
So when user wants to update his settings, I want to show A, C as
Yes - I can provide CSS and graphic design if needed for any of the
community projects! Just let me know.
On Mar 30, 7:08 pm, mdipierro mdipie...@cs.depaul.edu wrote:
Fantastic Yarko,
@Mike. When talking about design, do you refer to CSS? We could very
much use that.
On Mar 30, 5:49 pm,
http://twitter.com/jtauber/status/1420954914
James. Are you here?
Massimo
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
web2py Web Framework group.
To post to this group, send email to web2py@googlegroups.com
To
On Tue, Mar 31, 2009 at 2:40 PM, mdipierro mdipie...@cs.depaul.edu wrote:
I do not think the CSV formatting belongs in the model. There may be
difference places in an app where importing is done suing different
conventions. And why for csv and not xml? etc.
I agree w/ Massimo...
Also, you
Guys - this is a Joke (see also the fued between pinax and
django)
see: http://www.ponyransom.com/
and: http://www.pinaxenvy.com/
On Tue, Mar 31, 2009 at 6:28 PM, mdipierro mdipie...@cs.depaul.edu wrote:
http://twitter.com/jtauber/status/1420954914
James. Are you here?
Massimo
Thanks Denes! Your code suggestion worked for me. All I needed to do
was the 'x in r' and it worked like a charm! :-)
On Mar 30, 10:25 pm, DenesL denes1...@yahoo.ca wrote:
On Mar 30, 7:00 pm, DJ sebastianjaya...@gmail.com wrote:
I would like someone to help me with the syntax. I want to show
Hi DenesL, Massimo, thanks for your help on this, it works... Coming
from JAVA/J2EE world few months ago I didn't know I'll enjoy Python
and Web2py that much... I hope and wish this interesting experience
will benefit to someone else very soon...
Just for the info in case someone else follow
Hi DenesL, Massimo, thanks for your help on this, it works... Coming
from JAVA/J2EE world few months ago I didn't know I'll enjoy Python
and Web2py that much... I hope and wish this interesting experience
will benefit to someone else very soon...
Just for the info in case someone else follow
On Mar 31, 6:58 pm, Yarko Tymciurak yark...@gmail.com wrote:
On Tue, Mar 31, 2009 at 2:40 PM, mdipierro mdipie...@cs.depaul.edu wrote:
I do not think the CSV formatting belongs in the model. There may be
it was only a suggestion, it has to be tied to the field somehow
difference places in
On Tue, Mar 31, 2009 at 8:52 PM, DenesL denes1...@yahoo.ca wrote:
On Mar 31, 6:58 pm, Yarko Tymciurak yark...@gmail.com wrote:
On Tue, Mar 31, 2009 at 2:40 PM, mdipierro mdipie...@cs.depaul.edu
wrote:
I do not think the CSV formatting belongs in the model. There may be
it was only a
Perhaps we should do it ourself for real.
On Mar 31, 7:11 pm, Yarko Tymciurak yark...@gmail.com wrote:
Guys - this is a Joke (see also the fued between pinax and
django)
see: http://www.ponyransom.com/
and: http://www.pinaxenvy.com/
On Tue, Mar 31, 2009 at 6:28 PM, mdipierro
Sorry for chiming in, but I do not see it is necessary to block the
default urls. As long as they can do proper jobs and do no harms, why
do we need to block it? Just let it be.
And in case you did not know yet, you might found the option 2 in this
post helps.
Not sure what you would want to port here; If I take this at face value,
here's what is currently documented (I've highlited what I thought might be
interesting from a web2py perspective).
In general, I think idea of having a package of light weight applications /
utilities is something both
Hello,
I was at the PyCon dojo and got to meet several of you afterward. The
dojo project is a very good example for showing the breadth of web2py.
I heard a couple of people say How come nobody knows about web2py
yet? afterward. You may want to consider putting the dojo example on
the web2py
Hello,
I was at the PyCon dojo and got to meet several of you afterward. The
dojo project is a very good example for showing the breadth of web2py.
I heard a couple of people say How come nobody knows about web2py
yet? afterward. You may want to consider putting the dojo example on
the web2py
As of right now, we're trying to get some screen shots for the Dojo as
of right now and then Massimo will put them up on the website. I plan
on doing the screen shots fairly soon, may be even tonight. :)
On Mar 31, 11:30 pm, David Niergarth jdn...@gmail.com wrote:
Hello,
I was at the PyCon
For our application we are not using the ORM features of the DAL (see
P.S. explanation). All of our non-auth queries use db.executesql(sql).
It seems like executesql() should support the optional mapping-or-
tuple argument that the underlying DB API 2.0 cursor supports. For
example,
Pagination would be excellent and is a must, I may write a small
function that does this exact thing. :)
One thing I would like to see, is a nice tutorial on how to provide a
search function within your website. Bonus points for using sphinx as
the backend :)
On Mar 31, 11:29 pm, Yarko
IMHO such lightweight applications/utilities would make WEB2PY the
only so capable MVC player.
In addition I'd like to request comments on, let's call it feature -
now that Auth is in not an add-on, is there are a place for (optional)
UNIX-like users/resources management?
In short: each resource
I agree. Anyway you can alway block them by adding a line like
routes_in=[
(...),
(...),
('.*','/yourapp/default/error_action'), # catch all not mapped before
]
On Mar 31, 9:52 pm, Iceberg iceb...@21cn.com wrote:
Sorry for chiming in, but I do not see it is necessary to block the
default
The problem is that not all adaptors support the same API and some are
undocumented. You can use
db._cursor.execute(select first, last from names where id=%(id)s;,
{'id': id})
db._cursor.fetchall()
On Mar 31, 10:54 pm, David Niergarth jdn...@gmail.com wrote:
For our application we are not
This is already in Auth. Auth actually does more than unix-like group
based access control. It does Role based access control (group based
is a particular case).
gid=auth.add_group(role='Manager')
auth.add_membership(gid, auth.user.id)
auth.add_permission(gid,'call function f')
I wondered if that might be the case. db._cursor will do just what we
need. Thanks.
--David
On Mar 31, 11:12 pm, mdipierro mdipie...@cs.depaul.edu wrote:
The problem is that not all adaptors support the same API and some are
undocumented. You can use
db._cursor.execute(select first, last
Just to fill in on the good-natured comaraderie here...
Once I saw the porting note here, I posted a twitter note that
we looked, and wanted to port... but web2py already has all this
(friendly jab ;-)...
It only took about 5 minutes after posting for the Pinax team to find it and
wail out
One postgres-specific change we made to our copy of gluon.sql to make
things a bit easier was to add the import
import psycopg2.extras
and change the line
self._pool_connection(lambda : psycopg2.connect(msg))
to
self._pool_connection(lambda :
Thank you, Massimo.
One more question - a role can have many groups and vice versa, an
user can belong to many groups and vice versa?
On Apr 1, 7:16 am, mdipierro mdipie...@cs.depaul.edu wrote:
This is already in Auth. Auth actually does more than unix-like group
based access control. It
Yarko,
Does that injection still exist? And, we need a web2py 1.6 soon :P
On Apr 1, 1:00 am, Vidul Petrov vidul.r...@gmail.com wrote:
Thank you, Massimo.
One more question - a role can have many groups and vice versa, an
user can belong to many groups and vice versa?
On Apr 1, 7:16 am,
This was posted as a comment to
http://mdp.cti.depaul.edu/AlterEgo/default/show/55:
Which reads:
web2py can import tables saved in csv format therefore it can access legacy
data.
web2py can also access existing databases directly (MySQL, PostgreSQL, SQLite
and Oracle) if
each table has
yes
On Apr 1, 12:00 am, Vidul Petrov vidul.r...@gmail.com wrote:
Thank you, Massimo.
One more question - a role can have many groups and vice versa, an
user can belong to many groups and vice versa?
On Apr 1, 7:16 am, mdipierro mdipie...@cs.depaul.edu wrote:
This is already in Auth.
Yes but it is not really a bug. appadmin select box is designed to be
used by the administrator, not to be exposed to untrusted users. Admin
must login from localhost or via https using secure session cookies.
This is as secure as SSH. After all the administrator is the
administrator, he already
Is it really backward compatible? Have you tried?
On Apr 1, 12:00 am, David Niergarth jdn...@gmail.com wrote:
One postgres-specific change we made to our copy of gluon.sql to make
things a bit easier was to add the import
import psycopg2.extras
and change the line
Can you create a custom database view and map the field?
On Apr 1, 12:06 am, Kevin Butler kevinjbut...@gmail.com wrote:
This was posted as a comment
tohttp://mdp.cti.depaul.edu/AlterEgo/default/show/55:
Which reads:
web2py can import tables saved in csv format therefore it can access
Sorry for bothering but I can not find clue myself:
this code works in Oracle:
db.define_table('headers', SQLField('ADDRESS', 'string', length=255))
and this - does not:
db.define_table('headers', SQLField('ADDRESS', 'string', length=512))
gives ORA-00911 error (bad symbol!)
sql log shows
70 matches
Mail list logo