Validate bulk invite CSV file and show error on invalid file format

I have about 500 users and I like to add some of them to another group. When i resend the bulk invite with the updated group in the CSV, I get an invalid email error. Can someone help?

Since the 2.3 update this bug should be fixed

  • Bulk invite should skip invite and add existing users to groups.

My guess is that you have an invalid email address in the file. It would be better if it ignored the invalid address and worked with the rest, but that seems not to be the case (if no users were added to the group).

I tried with two active users who are already in another group, so their email address are actually valid.

Maybe @techapj could have a look at your list to determine why some of the emails are invalid, can you share it with him?

3 Likes

I had a look at the file. The bulk invite process was failing because the data was not comma (,) separated, it was using semi-colon (;) instead. Please make sure to use the format described in first post.

6 Likes

Hmm. Shouldn’t the import complain about invalid file format if it does not see any commas in the input @techAPJ?

I feel like we messed up here by not providing a proper error message.

Never underestimate what your users will try to do…

3 Likes

When I first used it (more than 3 years ago) I was surprised that it just worked. When a spreadsheet imports a file it gives you a preview of what will happen before it actually does it.

1 Like

That is not a bad idea @techAPJ you could count the lines and validate the file and pop a dialog like

This will send invitations to 200 email addresses, do you want to proceed?

4 Likes