We help IT Professionals succeed at work.

SUBDIVISION YARD LIGHT IS OUT, YOU NEED TO FIX IT

316 Views
Last Modified: 2014-11-24
Yard lights in our subdivision are the only means of illumination and residents are required by the covenants to keep working.    As chairman of the architectural committee, one of my volunteer efforts includes driving around twice a year and record any address with a non-working light.   Next step is to associate those addresses with a name on our membership list.  Once that is completed, the list (excel spreadsheet) is uploaded to a service who mails a postcard to each address.   With 435 potential addresses, this is a semi-annual burden.

With all the modern technology and Experts available, I am confident there must be a way to help automate this project.
Comment
Watch Question

Chief Operations Manager
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
EirmanChief Operations Manager
CERTIFIED EXPERT

Commented:
A further thought .... It would be even easier to design your Access database to just print Mailing labels.
Lance McGrewIT Director

Author

Commented:
All the yard lights require a working photo electric switch to provide dusk to dawn operation.   We typically drive around the neighborhood well after dusk which makes it obvious when a light is non-functional.

We have found leaving a notice at the door has its problems.   Notices need to be addressed to the dwelling owner.  People to rent simply ignore the notices.   Owners are subject to fines.

Eirman, I like your idea about using the database.   Provided we can create a method of quickly locating the approperate database record as we drive along, seems like using an Access database to print mail labels might just be the solution.   Last inspection yielded 85 outages.
Lance McGrewIT Director

Author

Commented:
Using a database to track outages and print mailing labels for postcard notifications or provide data to an outsource mailing service seems like a viable solution.
EirmanChief Operations Manager
CERTIFIED EXPERT

Commented:
All the yard lights require a working photo electric switch to provide dusk to dawn operation.
I should thought of that possibility.

I would use a rough map of each street and put an X against each offending property during the drive around.
Then back at the office. it should be easy enough to mark the appropriate properties in the database.

Thanks for the points.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.