Asylum-loot

Asylum is the membership management solution for Helsinki Hacklab. This tool extracts member data from Asylum to SQLite to ease cross-tabulation and other housekeeping tasks.

TODO: There is proper API for Django. Use that instead.

Requirements

Way to steal cookies from a browser. For Firefox, install cookies.txt Firefox add-on.

Fedora

sudo dnf install php-cli php-pdo php-xml

Debian

sudo apt install php-cli php-sqlite3 php-xml

Usage

Asylum data:

1. Steal cookies from your browser and place them to cookies.txt in this directory. Use a browser add-on instructed above.
2. Run ./asylum-to-sqlite
3. Run sqlite3 members.sqlite3 and enjoy!

Slack users:

1. Download user CSV from Slack admin panel
2. Run: ./slack-to-sqlite <slack-helsinkihacklab-members.csv

Useful queries

Get user name, email and nicks on both Asylum and Slack:

SELECT m.name, m.email, m.nick, s.username FROM member m LEFT JOIN slack s ON s.email_norm=m.email_norm WHERE status !='Deactivated';

Get list of Slack usernames which don't match membership registry:

SELECT username FROM slack s LEFT JOIN member m ON m.email_norm=s.email_norm WHERE status NOT IN('Deactivated','Bot') AND m.email IS NOT NULL;