开云体育

  1. GroupManagersForum
  2. Topics

Direct Add commas appearing in Display Name.

Bill Perry
 

开云体育

Hi I’m a newby with this system, having used Yahoo Groups for many years and due to delays in Gmail transmission of YahooGroups email, have been investigating other systems. This looks good but I have run into a very small problem.

?

I have paid for a month subs to do a Direct Add of the 70 odd members of our small group.

?

In testing with just 3 addresses in the following format:

?

Bill Perry <billperry@...>

Ali Perry-Sky <alisonperry@...>

Ali -Plusnet <ali@...>


and adding these either via an uploaded file or directly placed into the emails field below the form example, when the emails are sent, an additional comma appears after the Display Name in the “You have been added” email e.g. Hello Ali Perry-Sky,, . This is not a major problem but when on the “Admin/Members” screen, this extra comma is also shown after the Display Name.

?

This only happens when using the “Direct Add” process and not when using the “Invite” process.

?

It can be edited and deleted using the members profile screen by the Owner but I don’t fancy going in 70 times just to do that. See attached picture.

?

Is this a bug or am I doing something wrong?

?

Kind regards

?

Bill Perry

?

?

Groupsio comma.jpg

 

On Sun, Oct 14, 2018 at 12:11 PM, Bill Perry wrote:
Is this a bug or am I doing something wrong?
Sure sounds like a bug that should be reported to [email protected].? Mark has done some work on the Direct Add recently, so this may be something that sneaked in.

As an afterthought, have you tried it using only a first name, or at least something without spaces?? That might give Mark more information to dig with.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions
 

Bill,

but when on the “Admin/Members” screen, this extra comma is also shown
after the Display Name.
If those commas were truly not in the addresses as you entered them then this looks like a bug to me, and a recent one. I Direct Add'd several dozen members a few weeks ago without this happening - using exactly the format you show as example (copy/pasted from Excel).

I'd report that to [email protected] as a bug. Leave an example intact if you can and cited it by group name and member address.

Shal


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

开云体育

Thanks for your quick responses.

?

An interesting twist in this is if I directly type in an address or two into the Addresses pane, as I did after I sent my previous email, then the extra comma does not appear. They only appear if copied from the Excel generated csv file, or if then that has been opened in notepad, to ensure that the file is as clean as it can be, from extraneous commas.

?

I’ll try something else and get back to you once done.

?

Bill

?

?

From: [email protected] [mailto:[email protected]] On Behalf Of Duane
Sent: 14 October 2018 18:29
To: [email protected]
Subject: Re: [GMF] Direct Add commas appearing in Display Name.

?

On Sun, Oct 14, 2018 at 12:11 PM, Bill Perry wrote:

Is this a bug or am I doing something wrong?

Sure sounds like a bug that should be reported to [email protected].? Mark has done some work on the Direct Add recently, so this may be something that sneaked in.

As an afterthought, have you tried it using only a first name, or at least something without spaces?? That might give Mark more information to dig with.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions

 

Bill,

the extra comma does not appear. They only appear if copied from the
Excel generated csv file,
In Excel you have to make sure the Display Name and the address are in the same column, otherwise an intervening comma in the CSV is inevitable.

I recommend against writing to a CSV. Instead select the (desired rows of) the column in Excel and copy / paste directly into the Direct Add address box.

I use the CONCATENATE() function to build the desired string in an auxiliary column. For example, if Column A has the email addresses, and Column B has the Display Names, I create another column containing the formula:

=CONCATENATE("""",$B3,""" <",$A3,">")

Note that I put " marks around the Display Name - I did that because some of my members have commas in their Display name. Without that complication it would be simply:

=CONCATENATE($B3," <",$A3,">")

Copy that formula into all the rows of the auxiliary column and now you have a copy/paste -able column for Direct Add (or Invite).

Shal


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

Shal,

Your instruction " I recommend against writing to a CSV. Instead select the (desired rows
of) the column in Excel and copy / paste directly into the Direct Add address box."

This worked fine. Thanks for the suggestion.

I've now run into another problem or undocumented feature. I had about 70 members in total to add. As a trial using the above method I added 2 batches of 10, and then as it was working I added the last 50 as one batch. The system came back and said that I'd reached the maximum number of direct add and this need approval, but I have not found anywhere any indication there is a maximum that I can load and in what period. Or who has to give the approval or how long that might take.

Very surprised at such a low number.

Bill

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Shal Farley
Sent: 14 October 2018 19:18
To: [email protected]
Subject: Re: [GMF] Direct Add commas appearing in Display Name.

Bill,

> the extra comma does not appear. They only appear if copied from the > Excel generated csv file,

In Excel you have to make sure the Display Name and the address are in the same column, otherwise an intervening comma in the CSV is inevitable.

I recommend against writing to a CSV. Instead select the (desired rows
of) the column in Excel and copy / paste directly into the Direct Add address box.

I use the CONCATENATE() function to build the desired string in an auxiliary column. For example, if Column A has the email addresses, and Column B has the Display Names, I create another column containing the
formula:

=CONCATENATE("""",$B3,""" <",$A3,">")

Note that I put " marks around the Display Name - I did that because some of my members have commas in their Display name. Without that complication it would be simply:

=CONCATENATE($B3," <",$A3,">")

Copy that formula into all the rows of the auxiliary column and now you have a copy/paste -able column for Direct Add (or Invite).

Shal


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

On Sun, Oct 14, 2018 at 03:16 PM, Bill Perry wrote:
I've now run into another problem or undocumented feature.
Yes, there's a limit of 20 per 24 hours for Invites or Direct Adds.? It was implemented as a result of a spammer attack a couple of years ago, .? There was some question about why it applies to Direct Add since those groups are paid for, but I don't think Mark ever supplied an answer.? He usually approves these quickly and there have been reports that it isn't always required on future 'batches'.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions
Bill Perry
 

开云体育

I can understand the reasoning for this limit, it’s just a shame it’s not clearly and simply documented for new users, especially as I paid for the “direct add” feature today to get the process completed more quickly and with the least amount of hassle for my members. Now a group of 50 of them, who I told in a separate email would be receiving the “Welcome” and “You’ve now been added emails” this evening will get them, ?I don’t know when.

?

Oh hum!

?

Bill ?

?

From: [email protected] [mailto:[email protected]] On Behalf Of Duane
Sent: 14 October 2018 21:40
To: [email protected]
Subject: Re: [GMF] Direct Add commas appearing in Display Name.

?

On Sun, Oct 14, 2018 at 03:16 PM, Bill Perry wrote:

I've now run into another problem or undocumented feature.

Yes, there's a limit of 20 per 24 hours for Invites or Direct Adds.? It was implemented as a result of a spammer attack a couple of years ago, .? There was some question about why it applies to Direct Add since those groups are paid for, but I don't think Mark ever supplied an answer.? He usually approves these quickly and there have been reports that it isn't always required on future 'batches'.

Duane
--
Help: /static/help
GMF's Wiki: /g/GroupManagersForum/wiki
Search button at the top of Messages list
A few site FAQs: /static/pricing#frequently-asked-questions

Bill Perry
 

Just a quick apology for the negative comment below, it had been a long day! The 50 accounts were released at about 1.30GMT and I have had lots of positive comments about Groups.io from the subscribers. I also much appreciate this group and the quick responses and help I received from those on here.

?

Many thanks

?

Bill

?

From: [email protected] [mailto:[email protected]] On Behalf Of Bill Perry
Sent: 14 October 2018 23:38
To: [email protected]
Subject: Re: [GMF] Direct Add commas appearing in Display Name.

?

I can understand the reasoning for this limit, it’s just a shame it’s not clearly and simply documented for new users, especially as I paid for the “direct add” feature today to get the process completed more quickly and with the least amount of hassle for my members. Now a group of 50 of them, who I told in a separate email would be receiving the “Welcome” and “You’ve now been added emails” this evening will get them, ?I don’t know when.

?

Oh hum!

?

Bill ?



[excess quote trimmed by moderator]

1 - 9 of 9