gosh... I wonder how this would work... right now, the csv library is called in more places than you'd imagine... and needs some cleanup / encapsulation as it is...
On Tue, Mar 31, 2009 at 1:31 PM, DenesL <[email protected]> wrote: > > We could have a field.csv_in (similar to field.requires) that runs > when table.import_from_csv_file is called and passes it the current > value (this could go inside the current 'fix' function). > > So you can do, e.g. > > table.field.csv_in=IS_DATETIME('%d/%m/%Y %H:%M',error_message='must be > D/MM/YYYY HH:MM')) > > before the import. > The errors could be written out to a csvfilename+'_error' file. > > Obviously field.csv_in would not be limited to validators and could do > other things, it just has to behave like them returning a > value,message pair and if message!=None (as with validators) it would > mean that the current value is in error. > > > On Mar 31, 11:31 am, mdipierro <[email protected]> wrote: > > On Mar 31, 10:48 am, Fran <[email protected]> wrote: > > > > > > > > > On Mar 31, 5:13 pm, Yarko Tymciurak <[email protected]> wrote: > > > > > > Before you export from excel, you should be able to set your date > field > > > > format to something that will work, for example, in format cells -> > number > > > > -> Custom > > > > set the field to yyyy-mm-dd hh:mm:ss > > > > > > That matches what you are saying the field "should be", and excel > should > > > > then export in this format to csv. > > > > > Thanks a lot, that works. > > > I'd previously tried setting to 'generasl' hoping it would lave well- > > > alone. > > > Perhaps 'text' was what I meant. > > > > > Anyway, no way we can get Web2Py to allow either format for entry? > > > > The point is: > > > > 1) should web2py enforce a csv convention > > 2) should web2py be customizable to read any CSV > > > > So far we followed the approach 1) since it is easier to convert a CSV > > using excel that write the code for your own customization. > > Moreover 2) is never going to satisfy everybody and the csv module is > > very flexible anyway. You can use IS_DATE(format)(value)[0] to convert > > to ISO yourself from any format. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
