Skip to content

Tools for reading Liquid Feedback data into a local database to detect changes and send a mail ofr changes.

Notifications You must be signed in to change notification settings

haibaer76/lftools

Repository files navigation

This project is the begin of a collection of utilities which make use
of the Liquid Feedback API to obtain information about changed and new
issues or initiatives.

All changes can be mailed to a single address at the moment.

System Requirements
===================

To use these tools, you need the following software installed:
1. Perl
2. MySQL (if you want to store the stuff in a database)
3. the CPAN Modules LWP::Simple, XML::DOM, XML::EasyOBJ and Crypt::SSLeay

Installation
============
* WARNING *
The installation script will drop any existing database with the name given in
the file config.pm!
1. Unpack the archive into a directory (or clone the source with git,
which is the recommended way).
2. copy the file config.pm.sample to config.pm
3. edit the file config.pm and adapt the variables to your system environment
4. run the script install.sh (only required if database access is needed)

Usage
=====
The main work is currently done with the script sync_from_server.pl

Call this script with no arguments will fetch all new initiatives and issues
from the LQFB-Server and synchronize the data with the local database

You can add the argument "mail" to the script, e.g.
./sync_from_server.pl mail
which writes an email for each new or changed initiative/issue to the
receiver, which is given in the variable $MAIL_RECEIVER in the file config.pm.
It is intended that you put this call in the crontab of a unix machine and
call this script every 15 minutes. The given email address can then be a
mailing list or something similiar, so everybody who joins the mailing list
will be informed about new issues or initiatives.

Another script, simple_check_script.pl , is provided which does not need
database access.

How to deal with updates
========================
The tools will be updated in an irregular way. 

1. To install an updated version
of these tools you have the following options:
a) If you got the source with git just move to the source directory and enter
git pull
into you command line.
b) Download a new archive and unpack it to the same directory. Replace all chaned files
2. After installing the updated version there have to be changes made in the
database. This is done by a migration script. So open a command prompt, move to
the source directory and enter
./migrate.sh into the command line.

About

Tools for reading Liquid Feedback data into a local database to detect changes and send a mail ofr changes.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published