avrex is a Python library and command-line tool for downloading reports off websites hosted by AssociationVoice. AssociationVoice provides websites for property management, and may be used by groups like strata corporations, condo boards, and homeowner associations (HOAs).
avrex makes it easy for data stored on AssociationVoice websites to be exported for backup, automation, analysis, and transformation.
pip install avrex
Supports Python 3.7+. Tested on Python 3.9.
For all operations, avrex needs the URL for the AssociationVoice site's login page,
and a corresponding username and password.
These arguments are automatically picked up from the environment variables
AV_URL, AV_USERNAME, and AV_PASSWORD.
They are also automatically loaded from an Envfile if present,
and accepted as options in the CLI, and as arguments in the API.
Installation adds the avrex script. The commands are avrex reports and avrex download-report:
> avrex reports --help
Usage: avrex reports [OPTIONS]
List available reports.
Options:
--username TEXT
--password TEXT
--url TEXT URL to login page
--help Show this message and exit.
> avrex download-report --help
Usage: avrex download-report [OPTIONS] REPORT DESTINATION
Download a report.
REPORT is a report ID or exact name of a report. DESTINATION is a path to
a file. Existing files are overwritten. The file must have an extension
matching a valid export format for the report.
Options:
--date-range TEXT Format: YYYY-MM-DD,YYYY-MM-DD
--username TEXT
--password TEXT
--url TEXT URL to login page
--help Show this message and exit.
Reports listing and downloading is available in avrex.AssociationVoiceApi:
>>> from avrex import AssociationVoiceApi
>>> api = AssociationVoiceApi(username="foo", password="bar", url="https://secure.associationvoice.com/Account/Login/100")
>>> api.list_reports()
OrderedDict([('16', 'Advanced Map Usage'), ('6', 'Directory - Communication Methods Updates'), ('15', ...
>>> with open("comm-updates.csv", "wb") as outf:
... api.download_report("Directory - Communication Methods Updates", "2021-01-01", "2021-01-31", "CSV", outf)