Report content

[caver456]

• [x] report generation date
• [ ] new cards in the last n days
• [x] card movements (from one list to another) in the last n days
• [ ] up-for-grabs list - based on existence of a certain 'Label' or custom field value
• [x] cards without any assigned members
• [x] items grouped by list then by priority
  • [x] card name
  • [x] count of items with that priority in that list
  • [x] date created
  • [x] contact / 'responsible' member
• [x] card count per list
• [ ] tumbleweeds - no recent activity
• [x] report for each member - this might be only for internal use, e.g. each member's list automatically emailed to that member every two weeks
  • [x] list of cards for that member, grouped by list then by priority
• [ ] 'minutes' extractor - based on comments with certain keyword/s like 'MN decided' or 'MN agreed'

[jephro]

I do have an account :-)

My idea is to generate a simple list of possible issue / tasks and then ideally have that link to something like the thread of conversation about that issue / task.

I'll try and motivate to look and think more seriously about this over the next week when I'm off work.

[caver456]

Progress:

NCCoHo Maintenance Report - generated Thursday December 22 2022, 7:51 PM

Inbox : 0 cards

In-house labor - in progress : 12 cards
  High priority: 2 cards
    steps on walkway by end of 500 N
    north pool gate not auto closing well
  Medium priority: 5 cards
    501 water dripping from upstairs bathroom vent fan
    gutter overflows
    seal the exit pipe gaps after sprinkler PRV work
    Metal Closet door end 300 block
    paint / maintain metal utility closet doors
  Other: 5 cards
    Rat traps and sticky paper
    solar pool filter cleaning
    Paint the trash palace doors and wood beams and trim
    CH terrace door slams shut
    408 inverter

Contracted labor - in progress : 9 cards
  High priority: 2 cards
    dry rot on 606 siding
    600S leaks in water closet
  Medium priority: 2 cards
    low water pressure in multiple units
    Pathway lighting
  Low priority: 1 cards
    garage door replacement
  Other: 4 cards
    500S hot water performance issues
    pool deck structural issues
    Uneven concrete on sidewalk in front of pool
    402/403 garage leak

Monitor : 16 cards
  High priority: 2 cards
    400N boiler loose wire
    400N boiler leak
  Medium priority: 5 cards
    water in basements
    Pool fence has some rotting posts. not an easy fix
    Pool Shower Handle
    Alexa's solar panels (506)
    CH sprinkler stand pipe longer-term solutions
  Low priority: 1 cards
    CH fireplace not lighting
  Other: 8 cards
    roof flashing - watch for rust
    Stains on utility sheds around the steam vents from the heaters
    balcony inspections
    beeping behind boiler in 300N hot water utility closet
    paint peeling on 502
    CH washing machine - leftmost washer hot water faucet leak
    parking lot patch and seal
    C.H. Guest Bathroom Exhaust Fan

Complete : 72 cards
  High priority: 14 cards
    booster pump Dec 2022
    Water heater in pool bathroom not working.
    leak in 501 basement
    failed sprinkler inspection April 2022
    306 hydronic adjustment panel link
    CH crash bar lock keyhole stripped out
    No heat in 606
    505 PEX leak
    CH keypad lock - replace battery
    leak in 500S hydro closet
    failed sprinkler inspection - four fouled sprinkler heads
    503 basement leak
    PEX inspection / replacement
    500N boiler performance and leaks
  Medium priority: 25 cards
    clean out gutters and roofs
    CH kitchen ceiling light nearest to oven won't stay on
    CH guest bathroom lock
    Paint the Plywood structures
    spa decking loose
    Utility closet doors don't stay closed in the wind. East end 600s
    CH smoke detector replacement
    long-term hydronic system overhaul / rethinking
    CH small guest room door hinge
    303 rotting porch post
    common house kitchen light switch busted
    CH kitchen double sink faucet not working
    repair stairs at E end of 500N
    leak in 302 front yard
    booster pump
    discolored water
    rats
    no heat in 609 (Miller)
    no heat in 309 (Zisch)
    Solar PV inverter offline for CH/pool
    paint porch railings
    north pool gate not working
    walkway lighting embedded in wall outside sandbox is not working
    cap float valve discharge ports if any are leaking
    pool and spa resurfacing
  Low priority: 7 cards
    sliding doors on upper sheds
    photocell on east garage building
    path light timer 600N (next to Tom and Geolynn's house)
    slow drain in laundry room wash basin
    pool gate latch is broken
    pool gate spring is broken
    large cut hole in 500S hydro closet
  Other: 26 cards
    sprinkler retrofit in CH and all residential buildings
    electric radiator in poolhouse bathroom
    No heat in 502
    CH upstairs sink - large leak underneath
    GFCI by sandbox is frozen.
    common house refrigerator light not working
    Wood Repairs PR812-21SP
    light above dishwasher in common house
    common house front porch light
    Common house air conditioning
    Leak near sunrise garden
    termites around Alexa's (506) house kitchen window exterior
    pool shed door doesn't latch
    CH kitchen garbage disposal replacement
    pool furniture refurbish
    CH water filter install
    307 balcony post rot
    hose reel at W end of 600N
    chlorine palace door repair
    hydronics - float valve replacement, multiple buildings
    400N boiler repair
    mold in 403 attic
    common house bathroom light not working
    roof jacks
    common house stove light not working (very dim)
    Hydronic heating stopped working bld  300 south

Robert Mc's Projects : 7 cards
  Other: 7 cards
    Concrete Walk Trip Hazards
    Exterior Lighting at Parking lot/Garages
    Parking lot slurry seal/crack repair
    Structural Components at individual decks, balconies, railings
    Cleaning of debris from roofs
    Caulking at siding, trim and windows
    Painting after caulking is complete

MN Meta : 2 cards
  Other: 2 cards
    Investigate integrating email into trello / MN workflow
    Figure out how to export tasks for community perusal and taking of tasks

[caver456]

Did a bit of futzing to see if we can track card movements, i.e. 'cards moved to Complete in the last month'. Looks like Yes.

The 'actions' key of the board dict holds actions of type='updateCard' with relevant data 'fromList' and 'toList' (those names might not be accurate but I did confirm they are in the response). Each action also has a timestamp.

There's a limit on how many actions are returned with each API request (1000 or something by default), so hopefully they are in chronological order.