Google Docs RSVP Guestlist Plugin for Wordpress

Current version: 1.2 Please use carefully, make sure you have backups of all your guest information. We cannot guarantee a perfect RSVP system.

If you downloaded 1.2 before 11/20/2008 you might want  to download it again. It was missing Zend files. - Thanks for noting this Jack.

Versions 1.1 and older do not work w/ Google Spreadsheets anymore.

Also, you need to hand-test each code you send out: right now, we are tracking a bug where certain codes (e.g. TT3020) aren’t working, but others do (e.g. xy123).

Download:google-docs-rsvp-guestlist.1.2.zip

Spanish version! (Thanks to Gorka Rodrigo gorka [at] irontec.com – Irontec: Internet y Sistemas sobre GNU / Linux http://www.irontec.com) Download: wp-guestlist-plugin_es.php (Rename this wp-guestlist-plugin.php and replace the english version with it.)

Requirements: Wordpress 2.5+ (untested on older versions), PHP 5+ (This is essential, you will get an unexpected ‘;’ error on line 276 if you are using an older version. Sometimes, PHP 5 is installed, but your web server, Apache, has been configured to use php4. Use phpinfo() to find this out and contact your admin to fix it.)


This plugin allows you to add RSVP and guestlist functionality to your Wordpress site. It tracks RSVPs for ceremony and banquet. Additionally, guests can leave custom messages for the planners. The guestlist is maintained with a Google Docs spreadsheet which is very easy to use.

It was originally designed to be a wedding guestlist that I made for a friend (congratulations to Mike & Di!).

Features Bulletlist:

  • Customizable RSVP page
  • Connects to Google Docs Spreadsheet for guestlist
  • Planners can write custom messages to guests
  • Guests can send custom message to planners
  • Email updates are sent to the planner
  • Wedding features: Records responses for Ceremony, Banquet, or Hotel Reservations

Instructions

  1. Using a Google account, create a new Spreadsheet at docs.google.com
  2. The spreadsheet must have the following 7 headers: Guest Name, Code, Custom Message for Guest, Ceremony, Banquet, Message from Guest, Hotel
  3. Fill in the guestlist with names, codes, and an optional custom message. Make sure the code is not guessable, for example: short numeric codes are probably a bad idea. A nosy guest might punch in random numbers and see guest information.
  4. Download, unzip, upload, and activate your plugin. (For details on how to do this with any Wordpress plugin click here.)
  5. In your Wordpress site, go to “Settings->Google Docs Guestlist” and fill in the account information and Google Docs title and sheet information.
  6. Create a new wordpress Page and put the text: wpgc-googledocsguestlist in the content box. The plugin will replace it with the RSVP code.
  7. Now, guests can type in a code and fill out the reservation form, which will send an email to you and update the spreadsheet. Note: Once guests have filled out the form, their RSVP code is no longer usable.  

Thank you! Good luck with your planning efforts. Remember to allow guests to contact you in other ways in case of digital emergencies.

We look forward to any comments. If there is a good response, we may incorporate your suggestions into the next version.

This code is released under GPLv3. If you create a new version of this plugin, let us know and we may link to it.

If this was helpful for your wedding (or any other event), please consider donating.


Thanks!

—————————-

Tips:

+ One cool thing you can do with the spreadsheet is to run typical spreadsheet operations. Mike added a “Running tally” to his spreadsheet so that he could keep track of attendance. Pretty cool! So long as it doesn’t interfere with the code section, you’re good to go.

—————————-

Updates

v.1.2.

- Updated to work with Google Spreadsheets after they changed how GData works. (Thanks to Brice D. for the bug fix)

v.1.1.

- Cleaned up the code when you turn off the hotels options

- Fixed some typos when it sends out the emails

152 Responses to “Google Docs RSVP Guestlist Plugin for Wordpress”

  1. [...] Google Docs RSVP Guestlist Plugin for Wordpress [...]

  2. [...] Google Docs RSVP Guestlist Plugin for Wordpress – Este plugin lhe permite adicionar a funcinalidade de RSVP e Guestlist em seu Wordpress website. [...]

  3. [...] Google Docs RSVP Guestlist Plugin for Wordpress [...]

  4. [...] Google Docs RSVP Guestlist Plugin for Wordpress [...]

  5. Leonaut.com says:

    Google Docs RSVP Guestlist…

    This plugin allows you to add RSVP and guestlist functionality to your Wordpress site. It tracks RSVPs for ceremony and banquet. Additionally, guests can leave custom messages for the planners. The guestlist is maintained with a Google Docs spreadsheet…

  6. Dan says:

    This is a very nice idea – I have an idea for a similar pluggin to this but have no skills to do it.

    Lets say we have a few jobs available and want to let them be taken on a first come first serve basis, where they could sign up for a job and then no one else could after that. Is there someway you can see to do that?

  7. Gifford says:

    Dan – that’s an interesting idea. I probably don’t have time to build it myself, I imagine you could fudge around w/ this plugin to make it do the same work… although it would be a bit of a stretch

  8. David says:

    Hi Gifford,

    I’ve installed the plugin and running WP 2.6.1 and PHP5+. When I activate the plugin, I receive the following error message.

    Parse error: syntax error, unexpected ‘;’, expecting ‘(‘ in /mnt/local/home/mysite/mysite/wp-content/plugins/wp-guestlist-plugin/wp-guestlist-plugin.php on line 276

    I started playing around and adding “( )” to line 276, but it just started a domino effect on other code changes. Is there something I’m missing that’s causing this error message?

    Thanks!

  9. admin says:

    Hi David,

    When you installed the plugin did you copy all of the plugin files over?

    Line 276 is this: $authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME;

    this pluginuses the Zend Gdata service, which is supposed to include a bunch of files in a subdirectory for the plugin named Zend. If that directory is missing, then I assume that you would have an error.

    Giff

  10. Kent says:

    Hi. I’m putting together a wordpress wedding page and I’d LOVE to use the guestbook plugin but when I try to activate the plugin I get the following error.

    Warning: main() [function.main]: open_basedir restriction in effect. File(/Zend/Loader.php) is not within the allowed path(s): (/var/www/vhosts/ect.net/httpdocs:/tmp) in /var/www/vhosts/ect.net/httpdocs/wp-content/plugins/google-docs-rsvp-guestlist/wp-guestlist-plugin.php on line 34

    What can I do to get this working?

  11. bravedave says:

    hi. I installed the plugin successfully but it does not seem to work when i try to rsvp. it only says no match.

  12. [...] I searched and searched for WordPress RSVP widget to no avail. There is an excellent one for weddings, but I didn’t feel like going under the hood and tweaking it for my very simple soccer poll. [...]

  13. Gabriel says:

    Hi, I’ve installed the plugin and set up my google spreadsheet. I am runnuing WP 2.6.1 and PHP 5.

    When I browse to my RSVP page and enter the code I get the following error:

    Fatal error: Class ‘ArrayObject’ not found in /home/u4/uglymunky/wptest/html/wp-content/plugins/google-docs-rsvp-guestlist/Zend/Registry.php on line 30

    I’ve double checked the plugin directory and it would seem that there aren’t any missing files.

    Any ideas?

    Thanks!

  14. admin says:

    Gab, i looked this up a bit and it sounds like the PHP 5 on your server doesn’t have the SPL extension enabled. Forward your error message to your system admin and maybe they can help. Or, you might have to use a different server…

  15. Gabriel says:

    Thanks! My admin went ahead and enabled SPL which cleared that problem, only now I enter the secret code and the resulting page only loads up to the following:

    RSVP Page

    The rest of the page is cut off

    Thank you again, any help would be much appreciated :)

  16. Gabriel says:

    …sorry just noticed the html code on my post was filtered…what i was trying to get at is that the resulting page only loads up to the opening div tag for the “entry” class. Everything after, never loads.

  17. John says:

    No matter what I do, I keep getting this…

    Oops. You found an error. Please try again or contact US at XXX@someemailaddress.com to confirm your response.

    Any ideas or logs I can look at to figure out the problem. I’ve double checked my username /password for google docs, double checked I have the required headers / info on the spreadsheet.

    Thanks

  18. Gabriel says:

    …anyone else running into the issue I posted on September 2, or have any ideas on how to fix it?

  19. [...] Google Docs RSVP Guestlist Plugin for Wordpress [...]

  20. Chris says:

    i have the same problem with activating the plugin like david (http://www.weedeedee.com/wordpress/google-docs-rsvp-guestlist-plugin-for-wordpress/#comment-123):

    Parse error: syntax error, unexpected ‘;’, expecting ‘(‘ in /home/soh/www.mypeacemusic.net/wp-content/plugins/google-docs-rsvp-guestlist/wp-guestlist-plugin.php on line 276

    i checked the directory, the Zend folder and all its content is there.

    any ideas?

    ====================
    Gifford: Hi Chris… hrm… what version of php are you using?

  21. Chris says:

    my version is: 4.4.8
    that should be the reason for the error, or?

    =============
    This is a problem. You need PHP 5 to run this plugin. My suggestion is to see if the admin actually has php 5 installed or to find a new server. Tell me if this fixes the problem.

  22. JohnnyG says:

    trying to get this plugin working with WordPress Version 2.6.2. I got it installed/configured, however whenever I input a CODE (for ex TT3020) is just spits out the “No match. Please try again.” error message. I’ve double checked my google spreadsheet and it matches what you have in your screenshots. Any ideas? Does this plugin check to see that your google account info is correct? I’m guessing mine is OK, however I can’t be %100 sure. thanks


    ===============
    Haven’t had time to work on this – but…
    I suggest trying another code?
    I tested out TT3020 and others and they seemed to not work. but “xy123″ worked as well as a number of others… older versions didn’t support codes that started with a number… I’ll get on this when i can.

    Giff

  23. Bruno Avila says:

    Hi Giff,

    I’m having the same problem that Johnny, but it did not work any code, nor the “xy123.” Does the new version of google docs, the plugin stops working?

    Thanks,

    Bruno

  24. Tiago Chiavegatti says:

    Gifford,

    I am having the same problem that Bruno is experiencing. I’ve been testing the plugin and customizing it during the last few weeks, but suddenly it stopped working. When I enter the code, I get the “Ops” error message.

    I don’t know if Google Docs version launched a new version during the last days, but I did saw that Zend Gdata has newer versions. Do you think that if I include Zend Gdata 1.6.2 package in the plugin it would solve this problem?

    Thanks,

    Tiago

    —-

    Hmmm that’s sucky. I’m looking into it.
    - Giff

  25. Brice D. says:

    In the last few days the rsvp plugin stopped working for me with the following error: “Expected response code 200, got 404…”

    First I upgraded Zend to 1.6.2 but it didn’t help (you don’t need to upgrade Zend for the following fix).

    The fix is to change the line:
    $feed = $gdClient->getSpreadsheetFeed();
    to:
    $feed = $gdClient->getSpreadsheetFeed( ‘http://spreadsheets.google.com/feeds/spreadsheets/private/full’ );

    and a few lines below change the line:
    $spreadsheet_key = $id[5];
    to:
    $spreadsheet_key = $id[7];

    There seems to have been a change somewhere in Google’s API, or Zend not using the right default URL.

    Here is the discussion that helped me find the fix: http://groups.google.com/group/Google-Docs-Data-APIs/browse_thread/thread/0639bcf78a961b1c?pli=1

    Hope that helps,

    Brice



    BRICE – you are awesome; I’ll get and new version up shortly – Giff

  26. Brice D. says:

    Giff: thank You for talking the time to release your work to the community!

  27. [...] Google Docs RSVP Guestlist Plugin for Wordpress [...]

  28. baron says:

    hi. Thanks for plugin

    perfect.

    Regards

  29. Cal says:

    I’m using a local install of wordpress (for testing) and receive the following error when I try to activate the plugin:

    Plugin could not be activated because it triggered a fatal error.

    Warning: require_once(Zend/Mime/Message.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampplite\htdocs\wordpress\wp-content\plugins\google-docs-rsvp-guestlist\Zend\Gdata\App\MediaEntry.php on line 40

    Fatal error: require_once() [function.require]: Failed opening required ‘Zend/Mime/Message.php’ (include_path=’.;C:\xampplite\php\pear\;C:\xampplite\htdocs\wordpress\wp-content\plugins\google-docs-rsvp-guestlist’) in C:\xampplite\htdocs\wordpress\wp-content\plugins\google-docs-rsvp-guestlist\Zend\Gdata\App\MediaEntry.php on line 40

  30. Cal says:

    Ok, I grabbed the latest Zend package from framework.zend.com and installed it. That seems to have rectified the “No such file or directory errors”. But now I’m getting the following error after submitting an xy123 code:

    “Oops. You found an error. Please try again or contact — at — to confirm your response.”

    Try uncommenting the debug messages (e.g. : //$outputtext .= $e->getMessage() . ” ” . $e->getTraceAsString(); ) and seeing what the error is…

    Hopefully that will give a better clue about what is going on…

  31. Ivan says:

    I love the idea of this plugin, but when I try to active it I get the following error:

    Warning: require_once(Zend/Mime/Message.php) [function.require-once]: failed to open stream: No such file or directory in /home/content/k/e/l/kelivawedd/html/wp/wp-content/plugins/google-docs-rsvp-guestlist/Zend/Gdata/App/MediaEntry.php on line 40

    Fatal error: require_once() [function.require]: Failed opening required ‘Zend/Mime/Message.php’ (include_path=’.:/usr/local/php5/lib/php:/home/content/k/e/l/kelivawedd/html/wp/wp-content/plugins/google-docs-rsvp-guestlist’) in /home/content/k/e/l/kelivawedd/html/wp/wp-content/plugins/google-docs-rsvp-guestlist/Zend/Gdata/App/MediaEntry.php on line 40

    I am not good at code. Can you please help? I am sure its something basic.

    Thanks,
    Ivan

  32. Ammon says:

    Thank you so much for developing this plugin! Its just what I need.

    Here’s my problem:

    When I try to activate the plugin from the admin interface I get the following error:

    Plugin could not be activated because it triggered a fatal error.

    Warning: require_once(Zend/Mime/Message.php) [function.require-once]: failed to open stream: No such file or directory in /Applications/MAMP/htdocs/Wordpress/wp-content/plugins/google-docs-rsvp-guestlist/Zend/Gdata/App/MediaEntry.php on line 40

    Fatal error: require_once() [function.require]: Failed opening required ‘Zend/Mime/Message.php’ (include_path=’.:/Applications/MAMP/bin/php5/lib/php:/Applications/MAMP/htdocs/Wordpress/wp-content/plugins/google-docs-rsvp-guestlist’) in /Applications/MAMP/htdocs/Wordpress/wp-content/plugins/google-docs-rsvp-guestlist/Zend/Gdata/App/MediaEntry.php on line 40

    The folder ‘Zend/Mime’ does not exist in my download, nor does the file ‘Message.php’. When I comment out line 40 ( require_once ‘Zend/Mime/Message.php’; ) in the file ‘Zend/Gdata/App/MediaEntry.php’, the plugin will activate without an error. However, when I submit a code on the RSVP page it appears to reload the RSVP page as far as the opening #entry div tag, much like Gabriel’s earlier issue.

    I am running wordpress 2.6.3 and php5.

    Thanks for the help!

  33. Alex says:

    I get similar to the last two comments when activating.

    Plugin could not be activated because it triggered a fatal error.

    Warning: require_once(Zend/Mime/Message.php) [function.require-once]: failed to open stream: No such file or directory in /home/alexyoc9/public_html/alexandannwedding/wp-content/plugins/google-docs-rsvp-guestlist 2/Zend/Gdata/App/MediaEntry.php on line 40

    Fatal error: require_once() [function.require]: Failed opening required ‘Zend/Mime/Message.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php:/home/alexyoc9/public_html/alexandannwedding/wp-content/plugins/google-docs-rsvp-guestlist 2′) in /home/alexyoc9/public_html/alexandannwedding/wp-content/plugins/google-docs-rsvp-guestlist 2/Zend/Gdata/App/MediaEntry.php on line 40

  34. Jack says:

    For those of you getting the line 40 error with Message.php, I was getting the same error. It seems that 1.2 is missing files. I had install 1.1 first and then 1.2. Best of luck and thanks for the tool. I am going to try to configure it soon.

    http://www.weedeedee.com/wordpress/wp-content/uploads/2008/08/google-docs-rsvp-guestlist11.zip

    Best of luck all with your weddings!
    Thanks Jack; Good luck with everything -Giff

  35. jack says:

    Thanks, Giff. I am still persisting along. I keep getting the ops error and my limited php knowledge doesn’t help either. I am pretty sure it is my install. I put up a sniffer and no packets go out to spreadsheet.google.com. I get no errors with I uncomment for debugging. Will see…

  36. Ryan says:

    Getting the same problem with the Oops message. I installed 1.1 then upgraded to 1.2. I also unzipped 1.2 into the folder for 1.1 and selected to update any duplicate files, then re-uploaded to my website to see if that would get the needed old files mixed with the new files.

    Still getting the oops message- and I was so excited about the plugin.

    Let me know if it gets fixed!

  37. Chris says:

    “No matter what I do, I keep getting this…

    Oops. You found an error. Please try again or contact US at XXX@someemailaddress.com to confirm your response.

    Any ideas or logs I can look at to figure out the problem. I’ve double checked my username /password for google docs, double checked I have the required headers / info on the spreadsheet.

    Thanks”

    hey John-
    I got this figured out. The default “oops” code isn’t very useful. If you go into the wp-guestlist-plugin.php file and find that error, you can comment it out, and a line or two down is a more useful error line you can uncomment. For me, I didn’t have PHPs ssl extension loaded. Then later I found I also needed to setup my smtp extension.

    You’ll want to change it back, though. The default error message is obviously much better for you guests to see

  38. jack says:

    Giff,

    Any suggestions with troubleshooting the php script or the Zend piece?

  39. Ryan says:

    Giff sent me an email on how to see uncomment the error. I just had my worksheet id wrong- sheet1 instead of Sheet1 (worksheet id is case sensitive)

    Just a tip for anyone else who is getting an error!

    (how embarrassing)

    Now to customize for my events!

  40. [...] WeeDeeDee Blog » Google Docs RSVP Guestlist Plugin for Wordpress [...]

  41. Hayley says:

    This looks like what I need for my wedding in August so thank you! I take it it’ll work with 2.7?

    Just wondering if it’s possible to add additional sections? I imagine I can copy/paste and modify the existing code and add the extra column to the google spreadsheet, is that right? Basically I need an option about dietary requirements.

    Also, is there anyway to deal with couples (possibly with children) which might only have one of them coming (or the couple are coming but not the kids)? On a basic level, a ‘number of guests attending’ would do it I think.

    Thanks again for creating this.

    ==========
    I haven’t tested on 2.7, but I don’t know why it wouldn’t work. If you know php, then feel free to play with the code. Without much coding, the simplest way to deal with dietary requirements is to ask them to indicate it on the comment-section. Good luck!
    -giff

  42. Brian says:

    I have got this to work as is, but I’m not sure how it was intended to work for couples and such. Is it set so that each entry would count as 2 for couples? What if Nathan Fong (from the screen-cap) didn’t bring a girl? What if any of these people decided to bring their 12 kids? How can I use this to get guests to put an accurate count of just who is coming? Like an evite +3 feature.

  43. Brian says:

    Duh, I got it. It failed every time I tested more than 1 guest name with the same number. I had forgotten to delete the hotel info for the main guest name. Great Plugin!

  44. Dan Trimble says:

    Thank you greatly for building this plugin; it looks to be exactly what I need.

    Unfortunately, I can’t get the plugin to activate. I download it, unzip, and FTP all the files to the plugin directory. Then, when I try to activate, it gives the error:

    Fatal error: Cannot redeclare class Zend_Loader in /usr/www/users/dant/wedding/wp-content/plugins/umapper/Zend/Loader.php on line 31

    It looks like all of the Zend folder/files were uploaded successfully from the download. My system (hosted at pair networks, http://www.pair.com) is running PHP 5.

    Your guidance here would be greatly, greatly appreciated.

    Happy New Year,
    Dan

  45. Dan Trimble says:

    Sorry, I totally missed the problem earlier. Been looking at code for too long; time for a break :)

    I just noticed the fatal error reference was actually pointing to UMapper’s Zend_Loader, not to your plugin.

    I deactivated UMapper (unfortunately — but the wedding RSVP plugin is a higher priority), tried to activate your plugin, and it worked fine.

    Now to replace or fix UMapper…

    dt


    Giff Hmmm… so this had nothing to do with the rsvp plugin? Ok

  46. Dan Trimble says:

    Except I do have one last problem it seems…

    Is there a trick to which codes will work and which one’s won’t? I noticed the red text at the top of this page indicating there’s known issues there, but I’m curious if I should format the codes in a certain way.

    Right now, each guest has one of two code formats: TF###, for sequentially-numbered guests of my family, and AF###, for sequentially-numbered guests of my fiancee’s family. So for example, right now, I have my mother and father as TF001 and TF002. Neither of those codes are working. They generate the “No match.” error. AF001 and so forth aren’t working either.

    I know there’s a known issue you’re working on, but so far, no codes have worked. Is there a standard format I should use to at least get some of them working?

    Dan

    ===
    If nothing is matching I would start double-checking other stuff: e.g. did I get the Headers for the spreadsheet correct, etc…

    Good luck, Giff

  47. Dan Trimble says:

    Yeah, it had nothing to do with the rsvp plugin. Weird, huh? Stranger too since UMapper was working fine and had no activation or other errors before I installed the RSVP plugin. Once it was installed though, trying to activate RSVP would cause that error from UMapper. Makes no sense to me, unless Wordpress 2.7 cyclically reactivates or reloads all the active plugins whenever you try to activate another one, and perhaps there was a problem with the presence of Zend Loader in two plugins?

    No idea, but at least it’s activated now. I can live without UMapper, but I can’t get by without an RSVP system.

    Regrettably though, I’ve double-checked everything and even considered everything case-sensitive, and I’m still not seeing what might be causing NONE of the codes to match. The following are my fields in my Google Docs spreadsheet:

    File Name: Wedding RSVPs
    Sheet Name: Guest List
    Columns, Left-to-Right:
    Guest Name
    Code
    Custom Message for Guest
    Ceremony
    Banquet
    Message from Guest
    Hotel

    Within Google Docs Guestlist settings, I have the following:

    Username/Password: both are valid
    Google Spreadsheet Name: Wedding RSVPs
    Google Worksheet Name: Guest List
    And I have hotels turned off as we have discounted rates, but want our guests to do their own booking.

    Anything look awry from the above?

    Dan

Leave a Reply

If this was helpful for your wedding (or any other event), please consider donating.
Thanks!