Managing subscribers who are families

Questions about Version 3 phpList features (the answer is probably 'Yes!')
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Managing subscribers who are families

Postby vultan » 12:48pm, Wed 28 May, 2014

Hi there -

I'm looking to use phpList to manage members and mailing campaigns for a community group. People register for our group as families. 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'm not sure how to set this up. 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. Is there a proper or at least effective way to design a phpList installation to do this?

Thanks!
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby Cornwell » 6:28pm, Tue 03 Jun, 2014

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
PL Geek
 
Posts: 55
Joined: 12:03pm, Thu 24 Mar, 2005
Location: Durham, England

Re: Managing subscribers who are families

Postby vultan » 4:01pm, Wed 04 Jun, 2014

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?

Thanks, Cornwell -- that may be the way to go. Any recommendations for separate online databases with easy-to-use interfaces that work cleanly with phpList?
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby Cornwell » 5:59pm, Thu 05 Jun, 2014

phpList uses a database, probably mySQL. Does your hosting service provide phpMyAdmin as a database tool? If so one way would be to put your family information into a spreadsheet, save it as csv and then import that into the phpList database as an extra table called something like families.

If your membership list does not have too many comings and goings then you could also use phpMyAdmin to add and delete records - there's no need to upload a fresh version of the table each time. If there's a higher turnover then you'd probably have to look to having an online membership form.

Regards, Roger
Cornwell
PL Geek
 
Posts: 55
Joined: 12:03pm, Thu 24 Mar, 2005
Location: Durham, England

Re: Managing subscribers who are families

Postby vultan » 8:13pm, Fri 06 Jun, 2014

Thanks, Roger -- that's helpful.
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby Shoe123 » 11:13am, Tue 18 Nov, 2014

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?




Get
Shoe123
phpList newbie
 
Posts: 1
Joined: 10:58am, Tue 18 Nov, 2014

Re: Managing subscribers who are families

Postby Dragonrider » 12:40pm, Tue 18 Nov, 2014

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?


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?
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: Managing subscribers who are families

Postby vultan » 9:51pm, Wed 19 Nov, 2014

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?


That would help with the email addresses, but it wouldn't help with the redundant family information. See my initial posting:

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.


If a family has a shared email address, then yes, it would do the trick; but not all families do.
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby Cornwell » 9:56pm, Wed 19 Nov, 2014

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.
Did you investigate this approach any further?
Roger
Cornwell
PL Geek
 
Posts: 55
Joined: 12:03pm, Thu 24 Mar, 2005
Location: Durham, England

Re: Managing subscribers who are families

Postby vultan » 10:03pm, Wed 19 Nov, 2014

Cornwell wrote:
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.
Did you investigate this approach any further?
Roger


Hi Roger: I didn't. It was above the threshold of "a bunch of work to set up as a prototype, and we're also exploring other options." I might get back to it at some point.
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby Cornwell » 11:43am, Thu 20 Nov, 2014

Fair enough: I too have a pile of ideas that are bubbling under but not of sufficient urgency to lead me to find the time to implement them.
Cornwell
PL Geek
 
Posts: 55
Joined: 12:03pm, Thu 24 Mar, 2005
Location: Durham, England

Re: Managing subscribers who are families

Postby bizshop » 8:23pm, Sat 22 Nov, 2014

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.
bizshop
phpLister
 
Posts: 6
Joined: 6:09pm, Sun 21 Jan, 2007

Re: Managing subscribers who are families

Postby vultan » 10:47pm, Sun 23 Nov, 2014

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.


Thanks, Bizshop. Yeah, I'm not worried about the space or time issues in the redundancy, but rather the fact that they'll grow inconsistent over time. A separate database would likely work. Though, of course, I was looking for an easy solution. :) I can handle it, but the non-profit I'm helping to support consists of folks who aren't very technically literate. Of course, I could build something to hide the separate database, etc, but I was hoping to spend less time than that...
vultan
phpLister
 
Posts: 6
Joined: 12:40pm, Wed 28 May, 2014

Re: Managing subscribers who are families

Postby jsrds » 7:39am, Tue 13 Jan, 2015

Did you try to find this idea any further?
jsrds
phpList newbie
 
Posts: 1
Joined: 7:22am, Mon 29 Dec, 2014
Location: Sri Lanka


Return to Does phpList do this?

Who is online

Users browsing this forum: No registered users and 1 guest