I have built an email list for the last ~20 years, well maintained, blacklist after 5 bounces etc. to which I send a product update email twice per year.
That is to say, I have not been using phplist for 20 years, so at some point in a distant past I imported from various sources, exports from my eCommerce provider(s), from older emails etc.
It was a messy process and I wasn’t as concerned about certain things as I am now. For instance I would simply send an email starting with ‘Hi’ and not with ‘Hi [FIRSTNAME%%[NAME%%there]]’, as I do today.
Anyways, now I care and I know I still have a small number of nameless records in there. Not too many, but still. I would like to do an effort to fix that.
However phplist’s Subscribers / Search subscribers doesn’t allow me to search for empty records (that I can see) ?
So I tried exporting the entire list (thinking I can sort things out with Excel after) but this process always hangs at the same stage: 128250 / 145838
It’s been ‘hanging’ here for quite some time, so I doubt it will continue.
How do you suggest I build a list of users with an empty [FIRSTNAME] and / or [NAME] field ?
I already considered (and may go this path too) of sending an email to everybody but use Duncan’s SegmentPlugin (which I assume can filter on empty fields (I did not check yet)) and ask them to edit their record. But as is so often the case many will not bother.