Electricity · Direct-SQL source
BMS database
A second way to bring in a month's consumption — read straight from the building's BMS
pms database instead of the Excel export. Each meter is matched by its stable
power_meter_id (not row position). Pull live (on the building network) or
upload the CSV the pull script writes; you'll preview every row before anything is
billed.
▸
Pull from BMS now
The BMS database isn't configured here (BMS_DB_* in .env).
The live pull only works when the app runs on the building network. Use the
CSV upload, or run the standalone tools/bms_pull.py on a LAN machine.
▸
Upload BMS CSV
Sign in to upload a BMS CSV.
▸
Identity mapping
All 166 registry meters are linked to a BMS
power_meter_id. Inspect the map →
▸
BMS periods
No BMS periods yet — pull or upload a month above.