Associates do not import Associates

  • Hi! So I used the excel document to import in all of my guests.
    I had my main guest and his associates.
    What is not working is that if an associate wants to rsvp it doesn’t serve them the rest of the ‘family’, only the head of the family.
    So if the wife is rsvping for the family, she can only see her husband’s name, not her kids.
    She would need to rsvp under her husband’s name to see the kids’ names.

    Is that a glitch in the way I’ve formatted my excel document?
    I felt like before this update the import function worked correctly.

    https://www.ads-software.com/extend/plugins/rsvp/

Viewing 4 replies - 1 through 4 (of 4 total)

  • Gayatriom,

    I also have this issue, so I don’t think your formatting is an issue.

    I resolved the issue by making the following changes to rsvp_frontend.inc.php:

    Replace lines 197-201 with:

    $sql = "SELECT id, firstName, lastName FROM ".ATTENDEES_TABLE."
 	WHERE (
 			id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
		)
		 AND id <> %d
		 AND rsvpStatus <> 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));

    and replace lines 212-217 with: 

    $sql = "SELECT id, firstName, lastName personalGreeting FROM ".ATTENDEES_TABLE."
 	WHERE (
 			id IN (SELECT attendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE associatedAttendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d)
		 OR id IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID IN (SELECT associatedAttendeeID FROM ".ASSOCIATED_ATTENDEES_TABLE." WHERE attendeeID = %d))
		)
		 AND id <> %d
		 AND rsvpStatus = 'NoResponse'";
$associations = $wpdb->get_results($wpdb->prepare($sql, $attendeeID, $attendeeID,$attendeeID, $attendeeID ));
    Thread Starter Gayatriom

    (@gayatriom)

    oh man we did this manually since the wedding is SO close! thanks though! will use this for another client.

    I have a mirror of the project on GitHub that I keep my changes in: https://github.com/fergbrain/mirror-rsvp

    @fergbrain,

    Thanks for these code snippets!

    When I use them, though, it’s doing something funny with the Last name of the Associated Attendees. It’s inserting it below the “Will you be attending?” question, instead of next to their first name.

    Take a look, if you wouldn’t mind.

    Visit https://www.carrieandkristaps.com/rsvp and enter Suzanne DiFurio as the guest

    Any thoughts?

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Associates do not import Associates’ is closed to new replies.