Thanks! you make it look so easy!
>From the error message below, it goes through the files but it stops.
File "/home/danel/Applications/web2py/applications/madra_v2/
controllers/default.py", line 198, in list_of_files
stream=open(filename,'rb')
IOError: [Errno 2] No such file or directory: 'E37048.pdf'
On Apr 25, 7:38 pm, mdipierro <[email protected]> wrote:
> @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
