Changes between Version 13 and Version 14 of DailyReminderScriptForTracScript


Ignore:
Timestamp:
Mar 1, 2022, 7:28:36 AM (7 months ago)
Author:
figaro
Comment:

Move example to functional description, add standard installation instructions

Legend:

Unmodified
Added
Removed
Modified
  • DailyReminderScriptForTracScript

    v13 v14  
    99The script searches the ticket status, and if one's status is not closed, it collects by owner and sends each of them a html mail.
    1010
    11 This is a Python script. The underlying database connection relies on Python's db capabilities, so probably you will have to install the appropriate db connector module(s) for your database:
     11This is a Python script. The underlying database connection relies on Python's database capabilities, so probably you will have to install the appropriate database connector module(s) for your database:
    1212 * MySQL: mysql-python
    1313 * PostgreSQL: psycopg2
     
    1919Feel free to adopt it to your needs, please test it, use it!
    2020
    21 '''Note:''' Change line 103 when upgrading from Trac 11.x to Trac 12.x due to database changes:
     21'''Note:''' Change line 103 when upgrading from Trac 0.11.x to Trac 0.12.x due to database changes:
    2222{{{#!python
    23 detail = detail + "  created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S',time.gmtime(int(tkt[0]/1000000))))
     23detail = detail + "  created at " + str(time.strftime('%Y. %B %d. (%A) %H:%M:%S', time.gmtime(int(tkt[0]/1000000))))
    2424}}}
    2525
    26 Please note the indentation! The Trac 12.x database converts every timestamp to a more accurate timestamp format, so a timestamp field must be divided by a million to work properly.
     26Please note the indentation! The Trac 0.12.x database converts every timestamp to a more accurate timestamp format, so a timestamp field must be divided by a million to work properly.
     27
     28=== Example
     29
     30One should put in a cronjob '''/etc/cron.d/trac_remind.cron''':
     31{{{#!sh
     320 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
     33}}}
     34
     35Don't forget to put a `MAILTO=your.address@your.domain.tld` into the cron file, the script prints out the recipient names where the mails had been sent to.
    2736
    2837== Bugs/Feature Requests
     
    4453You can check out DailyReminderScriptForTracScript from [/svn/dailyreminderscriptfortracscript here] using Subversion, or [source:dailyreminderscriptfortracscript browse the source] with Trac.
    4554
    46 == Example
     55== Installation
    4756
    48 One should put in a cronjob '''/etc/cron.d/trac_remind.cron''':
    49 {{{#!sh
    50 0 0 * * mon-fri root /path/to/this/script/trac_reminder_report.py
    51 }}}
    52 
    53 Don't forget to put a `MAILTO=your.address@your.domain.tld` into the cron file, the script prints out the recipient names where the mails had been sent to.
     57General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin TracPlugins] page.
    5458
    5559== Recent Changes