Thank you for your help Dave. I try explain myself better: i have a form where the user upload an excel file. I need to process that file, but only some rows of them. And i need to let the user select which rows. Thanks a lot
Il giorno venerdì 8 maggio 2015 01:06:11 UTC+2, Dave S ha scritto: > > > > On Thursday, May 7, 2015 at 12:12:20 PM UTC-7, goome wrote: >> >> Thank you for your help Stifan. >> The problem here is that i need to let the user choose among some >> value gotted from the excel file he gave as input. > > > > Do you need to do this before adding anything from the file to the > database? > For instance, only a subset of the data in the file is to be committed? > > This could probably be done on the client side with javascript. There are > some javascript tools > that some of the other posters use for data management. > Joe Barnhart has this recommendation: > >> The jQuery Datatables library is very impressive. It handles sorting, >> filtering, displaying of data in all forms. Its really worth a look at >> http://datatables.net My application is very data-centric and I use a >> LOT of tables, so I built some datatable factory methods to help me. >> > <URL:https://groups.google.com/d/msg/web2py/fj_UhjPmhK0/arM06tukVOgJ> > I don't know what you need to do to feed it client data instead of server > data. > > If you want to do this on the server side instead, my first thought is to > [upload the file], import it via CSV import into a *temporary table*, and > then use the data in the temporary table to create the form (SQLFORM, or > its grid offspring), and when you process the form update the permanent > table. > > > > And i should do >> this meanwhile writing other files. > > > I'm not sure what this means. Do you need to have multiple outputs based > on the data, or do you need to multiple threads to speed up the processing? > > >> How can i do this? >> Make all this stuff as an ajax function called after the user select >> the file input? >> > > You could use AJAX/components to provide the view into the temporary > table, if you wanted it to appear on the same page as the input form for > the filename. If you preferred to redirect, then anything you weren't > ready to forget from the filename form could be stored in the session, I > think. > > >> Any easiest way? >> Thanks a lot >> >> > I say this with having done just the littlest bit with forms, and just a > teeny bit more with AJAX, and not much with the new-fangled tools that > javascript gurus are throwing at ^W^W offering us. > > Good luck! > > /dps > (to read the weak joke above, recall what CTRL-W does on the BASH command > line) > > >> >> 2015-05-07 20:56 GMT+02:00, 黄祥 <[email protected]>: >> > if you use sqlform.factory, i think you should do the insert data from >> > sqlform.factory to the table manually. >> > e.g. taken from >> > >> http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-factory >> >> > >> > & modified it >> > def form_from_factory(): >> > form = SQLFORM.factory( >> > Field('your_name', requires=IS_NOT_EMPTY()), >> > Field('your_image', 'upload')) >> > if form.process().accepted: >> > response.flash = 'form accepted' >> > db.customer.insert(**db.customer._filter_fields(form.vars) ) >> > elif form.errors: >> > response.flash = 'form has errors' >> > return dict(form=form) >> > >> > another thing, i think you can use another like sqlform, or >> sqlform.grid >> > >> > best regards, >> > stifan >> > >> > -- >> > 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 a topic in the >> > Google Groups "web2py-users" group. >> > To unsubscribe from this topic, visit >> > https://groups.google.com/d/topic/web2py/c247sPk5ALU/unsubscribe. >> > To unsubscribe from this group and all its topics, send an email to >> > [email protected]. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
