41 lines
1.2 KiB
Markdown
41 lines
1.2 KiB
Markdown
# 2026-02-15 - Daily Memory Log
|
|
|
|
## Home Assistant Entity Cleanup Workflow
|
|
|
|
**Goal:** Create a spreadsheet-based workflow for renaming HA entities
|
|
|
|
### What We Built
|
|
|
|
**Script 1: `temp/get_ha_entities.py`**
|
|
- Pulls all entities from HA REST API
|
|
- Creates CSV: `entity_id`, `domain`, `current_name`, `new_name`, `area`, `current_state`
|
|
- Sorted by domain, then entity_id
|
|
|
|
**Script 2: `temp/write_ha_names.py`** (pending testing)
|
|
- Reads edited CSV
|
|
- Pushes `new_name` values back to HA via entity registry API
|
|
|
|
### Results
|
|
- **Total entities:** 1,420
|
|
- **CSV file:** `ha_entities.csv` in workspace
|
|
- **Workflow:** Edit CSV → run write script → names updated in HA
|
|
|
|
### Token Refresh Required
|
|
- Previous HA token expired (likely from OpenClaw reset yesterday)
|
|
- Generated new long-lived access token
|
|
- Updated in script, needs TOOLS.md update
|
|
|
|
### Next Steps
|
|
- Test the write-back script
|
|
- Maybe add bulk operations (delete, disable, change area)
|
|
|
|
---
|
|
|
|
## Files Created
|
|
- `temp/get_ha_entities.py` - Entity exporter
|
|
- `temp/write_ha_names.py` - Entity renamer (write-back)
|
|
- `ha_entities.csv` - Generated spreadsheet (1,420 rows)
|
|
|
|
## Tools Updated
|
|
- None yet (token still needs TOOLS.md update)
|