开云体育

Hello

While copying membership lists from Yahoogroups manually, it occurred to me that the main list of members INCLUDES members who are bouncing.

There is no option to display only members who are not bouncing.

So I wrote a quick little AutoIt script that compares the main list of members to the list of bouncing members, so that I can sort the main list of members by whether they are bouncing.



What's your strategy/method for getting this information?

Samuel

Samuel,

So I wrote a quick little AutoIt script that compares the main list of
members to the list of bouncing members, ...

What's your strategy/method for getting this information?

I've done much the same thing, pulling both lists into separate sheets in an Excel file, then appending a column to the members sheet that uses the =MATCH() function to find out if this row's address appears in the bouncing sheet. Sorting by that column separates the bouncers from the non-bouncers in the members list.

On the other hand, the .csv file exported by Sam Hobbs' chrome add-in includes a multitude of metadata columns, including a memberStatus column that indicates BOUNCED or CONFIRMED for each member.


Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

On 11 Nov 2019 00:05, Shal Farley wrote:

On the other hand, the .csv file exported by Sam Hobbs' chrome add-in includes a multitude of metadata columns, including a memberStatus column that indicates BOUNCED or CONFIRMED for each member.

The "members" information from IgnoredAmbience's scripts also include all this information, although at present in JSON format, not CSV. And converting it to CSV using e.g. AutoIt is slightly beyond my abilities since not every entry has the same fields, and I don't know how many possible different fields there are.

For example:

{
"yid": "myname",
"bounceStatus": "HARDBOUNCING",
"date": 988559966,
"postingStatus": "DEFAULT",
"yalias": "myname",
"emailPreference": "NONE",
"userId": 52339488,
"fileAccess": true,
"subscriptionStatus": "NORMAL",
"deliveryType": "NONE",
"bounceDate": 1094362187,
"isEmailHidden": false,
"index": 0,
"memberStatus": "BOUNCED",
"email": "121324.5476@..."
},

Samuel