Hi sipiatti,
you can change the translation of '%Y-%m-%d' in your language file.
On Feb 16, 5:58 am, sipiatti <sipia...@gmail.com> wrote:
> Hi,
>
> I am very new in web2py (but I love it from the first met:) ), and
> faced a problem
> what I could solve with a workaround but I think it is not the right
> way.
>
> I have a custom form what I created with SQLFORM:
> form=SQLFORM(db.assets,
>
> fields=["assetno","subassetno","qty","costuser","name","serialno","activationdate","type_id"],
> col3={'qty':'No. of records will be
> created!','serialno':'E.g. S/N of a product'})
>
> I am using this in the table definiton for field activationdate:
> Field("activationdate","date",label="Date of
> activation",widget=SQLFORM.widgets.date.widget)
>
> If the quantity is greater then 1, I must insert additional entries to
> the db.
>
> I made this in the controller in order to achieve this:
> if len(request.vars)>0:
> qty=int(request.vars.qty)
> if qty>1:
> request.vars.qty='1'
> if form.accepts(request.vars, session):
> response.flash = '%s records inserted' % qty
> if qty>1:
> for i in range(1,qty):
>
> db.assets.insert(assetno=request.vars.assetno,subassetno=request.vars.subassetno,qty=1,costuser=request.vars.costuser,name=request.vars.name,serialno=request.vars.serialno,activationdate=request.vars.activationdate,type_id=int(request.vars.type_id))
> db.commit()
> elif form.errors:
> response.flash = 'Bad data!'
>
> it fails at db.insert, because I have hungarian locale and the date
> from the date widget comes in this format:
> YYYY.mm.dd.
> and not in this format:
> YYY-mm-dd
>
> I used this solution (converting the datestring :/ ):
> db.assets.insert(assetno=request.vars.assetno,subassetno=request.vars.subassetno,qty=1,costuser=request.vars.costuser,name=request.vars.name,serialno=request.vars.serialno,activationdate=datetime.datetime.strptime(request.vars.activationdate,"%Y.
> %m.%d.").date().isoformat(),type_id=int(request.vars.type_id))
>
> My question is:
> Is there any other more simple way to handle such problems?
>
> PS: I've translated the variable names in the code to english to be
> more understandable (most of them were hungarian), could be I've some
> typo :)
