Import a Ward Birthday Calendar with this spreadsheet

Do you have a useful link that involves the Church and the technology discussed on this site? Post your links and resources here.
johncpratt1
New Member
Posts: 24
Joined: Tue Jan 04, 2011 6:02 am

Import a Ward Birthday Calendar with this spreadsheet

Postby johncpratt1 » Sun Jan 30, 2011 8:45 pm

I made an Excel spreadsheet to convert a ward birthday list from a clerk office computer into a Ward Birthday calendar for the new lds.org calendar:

http://buildzion.com/index.php/LDS-Items/Executive-Secretary-Items.html

johncpratt1
New Member
Posts: 24
Joined: Tue Jan 04, 2011 6:02 am

Postby johncpratt1 » Wed Nov 09, 2011 6:28 am

There is a new version for Calendar Version 2.0:
http://buildzion.com/downloads/WardBirthdayCalendar2.xls
Note, there is bug currently with 2.0: importing all-day events (google calendar format) results in an event scheduled at 12 AM (which I have reported)

User avatar
aebrown
Community Administrator
Posts: 14689
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Wed Nov 09, 2011 7:08 am

johncpratt1 wrote:There is a new version for Calendar Version 2.0:
http://buildzion.com/downloads/WardBirthdayCalendar2.xls
Note, there is bug currently with 2.0: importing all-day events (google calendar format) results in an event scheduled at 12 AM (which I have reported)


Please reconsider before using this. View this post (from a member of the Calendar development team), which says in part:

jdcr256 wrote: No holidays or birthdays were included from the v1 data. Our system simply wouldn't be able to handle every ward creating their own holiday calendar and birthday calendar.


I personally don't think that a stake Holiday calendar is a significant resource drain -- a dozen or so events for an entire stake is not a big deal. But if every ward adds hundreds of events for a birthday calendar, that could easily double the number of events on the calendar, which could have a significant impact on system resources.

To be good citizens of the Calendar system, we should be wary of adding so many events, especially when the Calendar development team made a specific effort to remove birthday calendars just recently.
Questions that can benefit the larger community should be asked in a public forum, not a private message.

johncpratt1
New Member
Posts: 24
Joined: Tue Jan 04, 2011 6:02 am

Postby johncpratt1 » Thu Nov 10, 2011 5:42 am

AEbrown:
I had no idea a birthday calendar posed such a hardship, but I wonder: that post also says that a holiday calendar imposed a hardship --could it be that the real issue is actually that the events repeat forever (rather than the number of events per year)?

This newer version of the ward birthday calendar also imports birthdays on a "per year" basis --nothing repeats.

I wonder, did the calendar development team remove all birthday calendars, even for ones that didn't repeat? I hope it is the "ad-infinitum" repeating of events rather than doubling the number of events...

User avatar
aebrown
Community Administrator
Posts: 14689
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Thu Nov 10, 2011 6:01 am

johncpratt1 wrote:could it be that the real issue is actually that the events repeat forever (rather than the number of events per year)?


That can't be the issue, since no events repeat forever under Calendar V2 -- they repeat no more than 2 years in the future, and always have an end date (or max number of occurrences).

But in any case, I'll try to get an answer as to whether the problem is with a large number of events (single or repeating), or only with a large number of repeating events.
Questions that can benefit the larger community should be asked in a public forum, not a private message.

jdcr256
Church Employee
Church Employee
Posts: 557
Joined: Wed Feb 17, 2010 1:53 pm
Location: Riverton, Utah

Postby jdcr256 » Thu Nov 10, 2011 8:32 am

Sharing birthdays on the ward calendar has two problems:

a) greatly increases the number in events in the database.
b) shares private information about individuals without their consent or control

It's really better to leave birthdays off of ward calendars.

johncpratt1
New Member
Posts: 24
Joined: Tue Jan 04, 2011 6:02 am

Postby johncpratt1 » Fri Nov 11, 2011 5:29 am

Thanks. Can I offer a suggestion? Import the birthday list and sync the ward calendar in a 3rd party calendar program, for example:

1) make a private google calendar (not public)
2) Sync the ward calender into it
3) Import the ics file made by the birthday spreadsheet in a 2nd private google calendar
4) Print the combination for the ward newsletter.

I think all bases can be covered in this manner. We hand-edit our birthday list to remove individuals who don't want their birthdays listed (and have been doing this for a long time--I felt sorry for our editor, actually).

Thanks again for the clarification.


Return to “Links & Resources”

Who is online

Users browsing this forum: No registered users and 1 guest