Suggestions to make the behaviour better?
On Oct 5, 5:55 pm, TheSweetlink <yanosh...@gmail.com> wrote: > Hello Alex, > > Two things I've found when manually uploading via SQLFORM.factory: > > 1) You need to specify a table_name='...' to avoid the > no_table_newfilename.extension issue like this: > > form = SQLFORM.factory(...Field definitions..., > table_name='some_table_name') > > 2) Additionally you must specify an uploadfolder in your upload Field > definition similar to this: > > form = SQLFORM.factory(..., > Field('invoice_logo', type='upload', > uploadfolder=os.path.join(request.folder,'static/uploads/')), > ..., table_name='whatever_you_like') > > **NOTE** 'static/uploads' is just an example, you can upload to > wherever it will be appropriate. > > In this case the newly uploaded and renamed file to > your_application's_dir/static/uploads/your_new_filename_here > > One gotcha to look out for following your field name as an example > without the quotation marks: > > In your form.accepts(...): > > "request.vars.invoice_logo" will contain the original filename of your > upload whereas > > "form.vars.invoice_logo_newfilename" will contain the newly renamed > file like yourtablename.9203842903.thaoeu09gu023hgda3p.ext > > No need to call store() directly as SQLFORM.factory will take care of > that for you. > > I hope that this helps you. > > -David Bloom > > On Oct 4, 7:53 pm, Alex <mrauc...@gmail.com> wrote: > > > > > > > > > Hi, > > > I've already spent quite some time with the following problem which I > > think should be fairly easy. I hope someone can help me. > > > # model > > db.define_table('admin_setting', > > Field('name', 'string', notnull=True), > > Field('value', 'string', notnull=True)) > > > in the controller I'm creating a form for various admin settings. > > form = SQLFORM.factory( > > Field('invoice_logo', 'upload'), ...) > > > the view works well and displays all fields. > > > When uploading a file for the logo the file should be handled like > > always (file uploaded to uploads folder, renamed to uuid filename). in > > the table admin_setting I want to store the filename of the uploaded > > file in a row where name='invoice_logo' (the filename should be stored > > in the value field). > > > How can I achieve this? currently I have this code (the update is > > performed later and not shown here): > > if form.accepts(request.vars, formname='admin_setting_form', > > dbio=False): > > if request.vars.invoice_logo != None: > > if type(request.vars.invoice_logo) != str: > > request.vars.invoice_logo_filename = > > request.vars.invoice_logo.filename > > field = Field('invoice_logo', 'upload') > > # field.store fails because field does not have a _tablename > > uploaded_file = field.store(request.vars.invoice_logo.file, > > request.vars.invoice_logo.filename) > > else: > > del request.vars.invoice_logo # do not delete existing logo