Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-30 Thread Thadeus Burgess
Any status on xls2web2py? -Thadeus On Wed, Mar 17, 2010 at 9:38 AM, mdipierro wrote: > The problem with appadmin is that it is designed for the administrator > and has security issues. A user can execute any python code he/she > wants in the query string. This is a feature because its use is

[web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-17 Thread mdipierro
The problem with appadmin is that it is designed for the administrator and has security issues. A user can execute any python code he/she wants in the query string. This is a feature because its use is supposed to be restricted to the administrator. Users have to be trusted to expose appadmin to th

Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-17 Thread Thadeus Burgess
I had actually used appadmin in production for a particular database for several months. The users were the same as you are describing (end-user, used to excel). Now that it is time to give them the real app (as appadmin was just a quick get us up and running)... they are actually sad to see us st

Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread Vincent Borghi
On Tue, Mar 16, 2010 at 4:11 PM, mdipierro wrote: > I think what Vincent is asking is not so much importing capability but > an interface that can read an excel file (or a csv file) asks you the > names (guessing from the header) and types (guessing from data) of > columns and then writes the mode

[web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread Brian M
I've used this wrapper (http://code.activestate.com/recipes/483742- easy-cross-platform-excel-parsing-with-xlrd/) for xlrd (http:// www.lexicon.net/sjmachin/xlrd.htm) with good results. As long as the worksheet has column headers as the first row you're good to go - it will read in the data and pu

[web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread mdipierro
I think what Vincent is asking is not so much importing capability but an interface that can read an excel file (or a csv file) asks you the names (guessing from the header) and types (guessing from data) of columns and then writes the model for you. Perhaps something that can deal with the case wh

[web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread Dragonfyre13
Well, my suggestion would be forget the XLS format for the first iteration. Use CSV. If you're not concerned with formulas, that's the cleanest route, and included in the default python install. (csv module). I use it all the time for my load test frameworks I build. It's not only very easy to use

[web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread mdipierro
This can be done. I need to check the licence of the xls readers. On Mar 16, 3:45 am, Vincent Borghi wrote: > Hello > > I have used web2py to (quickly) implement a simple phone directory of > customer contacts, > for a small phone call center. > Before that, people tried to maintain their contact