Re: [web2py] License expiry date management

[Prabhakar Shanmugam]

Dear Richard and Anthony,

Thank you for both of your responses. I got an idea, am glad to try it out.

Thank you once again, let me try out in this direction.

Regards,
Prabhakar

On Wed, Apr 11, 2018 at 8:57 PM, Anthony  wrote:

> And if you need that to happen automatically on a regular schedule, you
> can use the web2py scheduler: http://web2py.com/
> books/default/chapter/29/04/the-core#web2py-Scheduler.
>
> Anthony
>
>
> On Wednesday, April 11, 2018 at 10:52:03 AM UTC-4, Richard wrote:
>>
>> Something like that :
>>
>> next_week_sunday_date = \
>> (request.now.date() + datetime.timedelta(days=7)) +
>> datetime.timedelta(days=6 - request.now.weekday())
>>
>> rows_with_records_of_software_license_that_will_end_the_next_sunday =
>> db(db.table_name.field_date_name == next_week_sunday_date).select(
>> db.table_name.ALL)
>>
>> Then :
>>
>> for r in rows_with_records_of_software_license_that_will_end_the_
>> next_sunday:
>> # get data you require from you table row and send you email
>>
>> Richard
>>
>> On Wed, Apr 11, 2018 at 4:01 AM, Prabhakar Shanmugam 
>> wrote:
>>
>>> Dear All,
>>>
>>> I have just started learning web2py and I have hands on in python.
>>>
>>> Please just give some pointers. Iam sure this might be a trivial
>>> question, but I thought during the learning process I will ask this trivial
>>> question.
>>>
>>> I was seeing if i can write a license expiry daet management app, so
>>> that, we get a notification well before the license expires.
>>>
>>> I was going through the documentation, and I got some examples for
>>> sending emails, however, am not finding a way to identify a field value say
>>> a expiry date field and then calculating it and seeing if it is 40 or less
>>> days from today and notify.
>>>
>>> What are the options available to me to achieve this.
>>>
>>> Regards,
>>> Prabhakar
>>>
>>>
>>> --
>>> 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.
>>>
>>
>> --
> 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.
>

-- 
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.

Re: [web2py] License expiry date management

[Anthony]

And if you need that to happen automatically on a regular schedule, you can 
use the web2py 
scheduler: 
http://web2py.com/books/default/chapter/29/04/the-core#web2py-Scheduler.

Anthony

On Wednesday, April 11, 2018 at 10:52:03 AM UTC-4, Richard wrote:
>
> Something like that :
>
> next_week_sunday_date = \
> (request.now.date() + datetime.timedelta(days=7)) + 
> datetime.timedelta(days=6 - request.now.weekday())
>
> rows_with_records_of_software_license_that_will_end_the_next_sunday = 
> db(db.table_name.field_date_name == next_week_sunday_date
> ).select(db.table_name.ALL)
>
> Then :
>
> for r in 
> rows_with_records_of_software_license_that_will_end_the_next_sunday:
> # get data you require from you table row and send you email
>
> Richard
>
> On Wed, Apr 11, 2018 at 4:01 AM, Prabhakar Shanmugam  
> wrote:
>
>> Dear All,
>>
>> I have just started learning web2py and I have hands on in python. 
>>
>> Please just give some pointers. Iam sure this might be a trivial 
>> question, but I thought during the learning process I will ask this trivial 
>> question.
>>
>> I was seeing if i can write a license expiry daet management app, so 
>> that, we get a notification well before the license expires.
>>
>> I was going through the documentation, and I got some examples for 
>> sending emails, however, am not finding a way to identify a field value say 
>> a expiry date field and then calculating it and seeing if it is 40 or less 
>> days from today and notify. 
>>
>> What are the options available to me to achieve this.
>>
>> Regards,
>> Prabhakar
>>
>>
>> -- 
>> 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.
>>
>
>

-- 
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.

Re: [web2py] License expiry date management

[Richard Vézina]

Something like that :

next_week_sunday_date = \
(request.now.date() + datetime.timedelta(days=7)) +
datetime.timedelta(days=6 - request.now.weekday())

rows_with_records_of_software_license_that_will_end_the_next_sunday =
db(db.table_name.field_date_name == next_week_sunday_date
).select(db.table_name.ALL)

Then :

for r in
rows_with_records_of_software_license_that_will_end_the_next_sunday:
# get data you require from you table row and send you email

Richard

On Wed, Apr 11, 2018 at 4:01 AM, Prabhakar Shanmugam 
wrote:

> Dear All,
>
> I have just started learning web2py and I have hands on in python.
>
> Please just give some pointers. Iam sure this might be a trivial question,
> but I thought during the learning process I will ask this trivial question.
>
> I was seeing if i can write a license expiry daet management app, so that,
> we get a notification well before the license expires.
>
> I was going through the documentation, and I got some examples for sending
> emails, however, am not finding a way to identify a field value say a
> expiry date field and then calculating it and seeing if it is 40 or less
> days from today and notify.
>
> What are the options available to me to achieve this.
>
> Regards,
> Prabhakar
>
>
> --
> 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.
>

-- 
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.

[web2py] License expiry date management

[Prabhakar Shanmugam]

Dear All,

I have just started learning web2py and I have hands on in python. 

Please just give some pointers. Iam sure this might be a trivial question, 
but I thought during the learning process I will ask this trivial question.

I was seeing if i can write a license expiry daet management app, so that, 
we get a notification well before the license expires.

I was going through the documentation, and I got some examples for sending 
emails, however, am not finding a way to identify a field value say a 
expiry date field and then calculating it and seeing if it is 40 or less 
days from today and notify. 

What are the options available to me to achieve this.

Regards,
Prabhakar


-- 
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.