Executive Summary
For the last two semesters, I have been in charge of the ward directory for my BYU ward. My responsibilities include taking everyone’s picture and then creating a picture directory with names and phone numbers. The names are in ABC order by first name. It may take three to four weeks to obtain all the photos, but the Bishop prefers to have an up-to-date copy to help in making church assignments. Since I do not have a program that will auto generate anything for me, I have used PowerPoint to recreate the directory each week by rearranging the pictures as new ones come in. This process can take a few hours each time, especially as the number of photos increases to 200 or more.
I have created a program that will automatically login to the LDS.org website and scrape the site for ward member data. It will fill in an Excel spreadsheet with each ward member’s first name, last name, phone number, and address. Additionally, the program will search the “Photos” folder for ward member pictures based on the filename. If pictures are found, they will be inserted in the appropriate spreadsheet rows. Note: the program has been designed to search for .jpg picture files.
No comments:
Post a Comment