Let me understand this better f_invoice_file_path is the location where the
file is supposed to be stored or is it the full path including the desired
filename? Do you handle the file writing or should web2py do it
automatically?
On Tuesday, 29 July 2014 05:59:10 UTC-5, Kuba Kozłowicz wrote:
>
> I have three tables:
>
> - invoices
> - invoice summaries
> - invoice bundles
>
> The website I am working on provides such a functionality, that user
> uploads a file, from which invoices and invoice summaries are generated and
> after being generated they are zipped and put into a bundle.
>
> For each upload I create following structure for storing these files:
>
> invoices/
> /<bundle_id>/<list of invoices of bundle <bundle_id>>/
> summaries/
> /<bundle_id>/<list of invoices of bundle <bundle_id>>/
> bundles/
> /<bundle_id>/<list of invoices of bundle <bundle_id>>/
>
>
>
> So I end up having something that looks like this
>
> invoices/
> /1/<list of invoices of bundle_1>/
> /invoice1.pdf
> /invoice2.pdf
> /2/<list of invoices of bundle_2>/
> /invoice1.pdf
> /invoice2.pdf
> /3/<list of invoices of bundle_3>/
> /invoice1.pdf
> /invoice2.pdf
> summaries/
> /1/<list of summaries of bundle_1>/
> /summary1.pdf
> /2/<list of summaries of bundle_2>/
> /summary1.pdf
> /3/<list of summaries of bundle_3>/
> /summary1.pdf
> bundles/
> /1/<bundle_1>/
> /bundle.zip
> /2/<bundle_2>/
> /bundle.zip
> /3/<bundle_3>/
> /bundle.zip
>
>
>
>
> where inner folder name is ID of recently created bundle.
>
> Now to provide CRUD functionality I am using SMART GRID and I want to be
> able to display the file of invoice, summary, bundle entries ( by
> displaying I mean I want to display file's name and allow downloading it ),
> when a user either chooses VIEW in the SMART GRID or when he looks at the
> list of entries. Since I've chosen my own folder structure for storing
> these invoices, summaries and bundles I can't do it in a simple way,
> because Web2py uses its own mechanism to store and retrieve files and
> changse file's name. So in each of these tables I store the following
> fields:
> Field('f_invoice_file_path', type='string')
> Field('f_invoice_file', 'upload')
>
>
>
> what I wanted to do is something like this:
>
> def on_before_insert_invoice(fields, id):
> db(db.t_invoice.id == id).update(
> f_invoice_file=fields['f_invoice_file_path']
> )
> db.t_invoice._before_insert.append(
> on_before_insert_invoice
> )
>
> , here actually *fields* contains a list of tuples in following format
> (field, value) so I had to iterate over it to find fields[
> 'f_invoice_file_path'], I just omitted this part for brevity.
>
> , but I get following error and most likely it is not the proper way to do
> that:
>
> *** RuntimeError: Unable to handle upload
>
> Note that the field:
>
> Field('f_invoice_file_path', type='string')
>
> is saved correctly, I just need somehow to make upload field point to that
> location. The next weird thing is that variable *fields* doesn't contain
> field Field('f_invoice_file', 'upload')
> , even though I added it to the model, settings.migrate is set to True,
> and server has been restarted.
>
> How can I do it?
>
>
>
>
>
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
