Hi David,
works great, thanks!
I'm now manually uploading with these few lines:
field = Field('invoice_logo', 'upload',
uploadfolder=os.path.join(request.folder,'uploads/'))
field._tablename = 'admin_setting'
uploaded_invoice_logo_filename =
field.store(request.vars.invoice_logo.file,
request.vars.invoice_logo.filename)
@Massimo: now that I know, it's quite easy so I don't know much to
make it better. It would be good if this would be mentioned in the
documentation (there is already a short 'Manual Uploads' section),
although this is probably not a common use case. And maybe it would be
a good idea to have default values for uploadfolder and tablename?
On 6 Okt., 03:46, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> 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
