@auth.requires_login()
def list_of_files():
import os
files = os.listdir('/upload/Documents')
db.document.scandoc.uploadfolder='/upload/Documents'
for filename in files:
stream=open(filename,'rb')
db.document.insert(scandoc=db.document.scandoc.store(stream,filename=filename))
storedfiles=db(db.document.id>0).select(orderby=db.document.scandoc)
return dict(storedfiles=storedfiles,form=form)
On Apr 25, 5:56 pm, greenpoise <[email protected]> wrote:
> Ok. I have tried all the above but keeps breaking for me. This is what
> I am trying:
>
> 1. Upload files that are already in a folder into the database
> (without selecting them one by one)
> 2. Display those files and be able to download them.
>
> This is my code:
>
> @auth.requires_login()
> def list_of_files():
> import os
> files = os.listdir('/upload/Documents')
>
> storedfiles=db(db.document.id>0).select(orderby=db.document.scandoc)
> db.document.scandoc.uploadfolder='/upload/Documents'
>
> for files in files:
> db.document.insert(scandoc =
> db.document.scandoc.store(stream,filename=files))
> return dict(storedfiles=storedfiles,form=form)
>
> and I get this error message:
>
> File "/home/danel/Applications/web2py/applications/madra_v2/
> controllers/default.py", line 200, in list_of_files
> db.document.insert(scandoc =
> db.document.scandoc.store(stream,filename=files))
> NameError: global name 'stream' is not defined
>
> Thanks in advance
>
> On Apr 23, 5:34 pm, mdipierro <[email protected]> wrote:
>
> > yes, you have to set
>
> > db.workspace.filefield.uploadefolder='/somewhere/'
>
> > On Apr 23, 2:40 pm, greenpoise <[email protected]> wrote:
>
> > > Is this possible? to put on db the files of a folder?
>
> > > def list_of_files():
> > > import os
>
> > > storedfiles=db(db.workspace.id>0).select(orderby=db.workspace.droppedfile)
> > > files = os.listdir('/home/dan/Docs')
> > > for files in files:
> > > db.workspace.insert(filefield =
> > > db.workspace.droppedfile.store(files,filename='test.pdf'))
> > > return dict(storedfiles=storedfiles,form=form)
>
> > > On Apr 22, 8:48 pm, greenpoise <[email protected]> wrote:
>
> > > > Perfect. Will try. Thanks again!
>
> > > > Dan
>
> > > > On Apr 22, 4:51 pm, mdipierro <[email protected]> wrote:
>
> > > > > Most of it is done in the Field.store() method in sql.py. In fact you
> > > > > can do
>
> > > > > db.mytable.insert(filefield=db.mytable.filefield.store(stream,filename='original_filename.txt'))
>
> > > > > On Apr 22, 3:27 pm, greenpoise <[email protected]> wrote:
>
> > > > > > wow thats rough!! over 3,000 lines of coding. thanks!! :-)
>
> > > > > > On Apr 22, 4:07 pm, Thadeus Burgess <[email protected]> wrote:
>
> > > > > > > Take a look at welcome/controllers/default.py->def download
>
> > > > > > > Andhttp://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#291
>
> > > > > > > Andhttp://code.google.com/p/web2py/source/browse/gluon/sql.py#2667
>
> > > > > > > Andhttp://code.google.com/p/web2py/source/browse/gluon/sql.py#2694
>
> > > > > > > Andhttp://code.google.com/p/web2py/source/browse/gluon/sql.py#3292
>
> > > > > > > I think there are a couple more locations too... specifically
> > > > > > > web2py
> > > > > > > will rename the file to something safe....
>
> > > > > > > --
> > > > > > > Thadeus
>
> > > > > > > On Thu, Apr 22, 2010 at 2:54 PM, greenpoise
> > > > > > > <[email protected]> wrote:
> > > > > > > > My question is, which controller takes careof the upload field
> > > > > > > > in
> > > > > > > > web2py??? Web2py makes it easy to upload a file but I want to
> > > > > > > > know
> > > > > > > > how it does it so I can write a function based on it.
>
> > > > > > > > Thanks
>
> > > > > > > > dan
>
> > > > > > > > --
> > > > > > > > Subscription
> > > > > > > > settings:http://groups.google.com/group/web2py/subscribe?hl=en
