[web2py] import from csv

2013-07-22 Thread K. Antonis Tzorvas
with this db setup: db.define_table('station', Field('name'), Field('location'), Field('file', 'upload') db.define_table('records', ('station_id', db.station), Field('col1'), Field('col2')) col1-col2 are from file uploaded i want to have a controller that takes this csv file and imports the dat

Re: [web2py] cannot redefine field

2013-07-21 Thread K. Antonis Tzorvas
you are right, forgotten about the .requires part :/ thanks! On Sunday, July 21, 2013 9:32:15 PM UTC+3, Jonathan Lundell wrote: > > On 21 Jul 2013, at 11:28 AM, "K. Antonis Tzorvas" > > > wrote: > > db.define_table('station', > Fie

[web2py] cannot redefine field

2013-07-21 Thread K. Antonis Tzorvas
db.define_table('station', Field('name'), Field('country', 'string'), Field('city', 'string'), Field('records_file', 'upload'), format='%(name)s', migrate=False) db.station.name.requires = IS_NOT_IN_DB(

[web2py] define model, required only one from two fields

2013-07-21 Thread K. Antonis Tzorvas
i have a table: db.define_table('records', Field('file', 'upload'), Field('url', 'string')) and i want either "file" or "url" to be filled, cases that both are empty or filled should not pass. any idea on how to implement this one? -- --- You received this message because you are subscribed

[web2py] Re: Web2Py cannot import module matplotlib

2013-07-20 Thread K. Antonis Tzorvas
all operations are noticeably very slow, I haven't changed anything from the setup, any idea on what to look for? with the same app on pythonanywhere, everything runs faster On Saturday, July 20, 2013 11:53:36 AM UTC+3, K. Antonis Tzorvas wrote: > > I solved this problem by adding

[web2py] Re: Web2Py cannot import module matplotlib

2013-07-20 Thread K. Antonis Tzorvas
UTC+3, Massimo Di Pierro wrote: > > Look into this. When you import matplotlib it attempts to read(write?) > into the MPLCONFIGDIR. If it does not exist for the user or the user > (www-data) does not have read/write permission it fails. > > On Friday, 19 July 2013 20:45:28 UT

[web2py] Web2Py cannot import module matplotlib

2013-07-20 Thread K. Antonis Tzorvas
I've used this script https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh and the problem is that i cannot import matplotlib in web2py (although it did import numpy) if i try to run /home/www-data/web2py/web2py.py on another port then there is no problem with