开云体育

?Altering a Yahoo Group member list Export for the “Direct Add” function at groups.io

These are the steps I used to prepare a text file suitable for upload into the “Direct Add” member subscription function.? ("Direct Add" function is available only in paid groups)?

1.????? Export the Y! member list to csv format. (I’ve read that Yahoo will only export the first 1000 members – my group was smaller, so I don’t know that for sure.)
2.????? Open in Excel
3.????? Insert a new “Column A” to contain the text string “Direct Add” expects.?
4.????? Insert a new “Column D” to contain a translation of the “Delivery” field to the keyword expected by “Direct Add”
5.????? In my case, this resulted in a spreadsheet format as follows:
Column A: container for “Direct Add” lines
Column B: The Display Name from Yahoo
Column C: The email address from Yahoo
Column D: container for the “Delivery” option converted from Column G to the keyword “Direct Add” expects
Column E: Joined date from Yahoo – not used
Column F:? Member Status from Yahoo – not used
Column G: Email Delivery option from Yahoo, converted in Column D to the keyword “Direct Add” expects.
Column H: Posting status – not used.
6.????? For later convenience, I then sorted on Column F (descending) (to place non-member roles at the top), then on Column G (to group like delivery options together), then on Column C (to alphabetize member email addresses).
7.????? Paste the following formula into cell D1 and then copy it down through Column D for each entry.? I know that ‘special’ is not a currently supported keyword, but in my single-email test it was just ignored, and I could manually update from “Individual Emails” to “Special”.? However, when the “Direct Add” file I created here was processed after I uploaded it, the “Special” members were already set to “Special” in the group member list.?

=IF(G1="Individual Emails","",(IF(G1="Daily Digest","digest",(IF(G1="No Email","nomail",(IF(G1="Special Notices","special","SomethingElse")))))))

8.????? Paste the following formula into cell A1 and then copy it down throughout Column A for each entry:

=CONCATENATE(B1," <",C1,">","? ",D1)

9.??? Check the contents of Column A closely, to confirm each line is the format expected by "Direct Add".
10.??? Highlight all the contents of Column A.? Copy and paste it into a text file (I use Windows Notepad to be sure no non-text characters are carried forward.)?
11.?? I saved and uploaded this file to the “Direct Add” page.

?

There is also another Chrome-browser specific procedure to download group membership data that includes additional data fields, available here below.?

?