Cornwell wrote:I'm wondering if having all the family-related information in a separate database would work, and linking to this via the foreign key field?
Shoe123 wrote:I could treat each family as a single phpList subscriber, but then I'd only have one email associated with the family, and I want each family member to be able to receive campaign emails. Is there a proper or at least effective way to design a phpList installation to do this?
Dragonrider wrote:So long as each individual has a unique email address, phplist will send the message to each person on a list. If a family have a single shared email address, only one message will be sent to that family group. Does that help?
vultan wrote:We have subscriber attributes that are common for an entire family, such as home address, number of kids, etc., but each adult member of the family also has their own email addresses.... I could treat each member of a family as a phpList subscriber, but then I'm duplicating for each member all of the shared attribute data. I could treat each family as a single phpList subscriber, but then I'd only have one email associated with the family, and I want each family member to be able to receive campaign emails.
Did you investigate this approach any further?Cornwell wrote:I'm wondering if having all the family-related information in a separate database would work, and linking to this via the foreign key field? But I have not used foreign key myself and I don't know if it has to be unique.
Cornwell wrote:Did you investigate this approach any further?Cornwell wrote:I'm wondering if having all the family-related information in a separate database would work, and linking to this via the foreign key field? But I have not used foreign key myself and I don't know if it has to be unique.
Roger
bizshop wrote:Other than the redundancy, unless you have a huge number of subscribers the load of having the duplicate fields will likely not be large.
That being said, I'd make a single attribute for each email address called 'family' where you would put their family name uniquely (maybe need smith1 and smith2 for example)
Then a separate Mysql table with one of the fields being that unique family identifier for the family particulars (address,kids,etc) since these are not used by the phpmail program. This may be what the foreign key does, but I've not explored that.
Return to Does phpList do this?
Users browsing this forum: No registered users and 0 guests