Previous Thread
Next Thread
Print Thread
Hop To
#261296 04/10/2018 1:58 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Hello guys,

Question, I send out emails to our member list of about 49K and 13K are coming back as deliverable. How do I export the 13k list and remove these emails from the UBB 7.6 ??

Thanks Mike

sundance #261297 04/10/2018 2:27 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Quote
13K are coming back as deliverable

If 13K came back to you, then you already know their addresses are "UNdeliverable."

Write a SQL query and execute it within the CONTROL PANEL > DATABASE TOOLS > SQL COMMAND page.

Similar to the following:

update ubbt_USER_PROFILE
set USER_ACCEPT_ADMIN_EMAILS = 'off'
where USER_REAL_EMAIL = 'mail@example.com'

mail@example.com would be where you insert the address you wanted to disable admin emails for. Do this for each address.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
sundance #261298 04/10/2018 2:38 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Know Your Bounces
Not all bounces are the same.
A soft bounce occurs when a temporary issue exists with the recipient’s email address. This delays the delivery of the message but does not necessarily stop it altogether. In many cases, the email server will reattempt delivery several times over a period of hours or even days. The message is only considered undeliverable if the retry period expires without a successful delivery.

A hard bounce occurs when the email message is deemed permanently undeliverable. An email address that generates a hard bounce should be immediately removed from your database so that you will not send any further messages to that recipient.


A number of different factors can generate bounces and cause issues for email marketers. Here are some of the most common:

1. The email entered during the opt-in process is invalid. People sometimes make mistakes when subscribing to mailing lists. Other times they deliberately enter an old email address out of concerns for spam or an increase in email volume. No matter what the reason, invalid email addresses are a common source of bounces. You can largely avoid this problem by using a double opt-in procedure before adding people to your list.

2. The sending IP address you are using has been blocked. Even if everything is fine with the message itself, the IP address you are using to send it could be blocked. This block can occur if you are suspected of spamming or email fraud or if your company has developed a bad reputation. You can avoid this problem by using quality email marketing techniques and never renting or buying prepackaged lists.

3. The email was blocked by the server (unable to relay). Emails can be blocked by the receiving server for a number of reasons. Many servers will block messages over a certain size, mails that use the wrong format and messages that appear to be spam. Mail servers can block your email also if the “From” address might not match an account on the email server. Reviewing your messages carefully, making your images as small as possible and following best practices can help you avoid this problem. Please note that mail server may block your email also for “technical” problems that you can’t have any control over, eg. “Out of memory”, “Connection timed out” and “Resources temporarily unavalaible”:

4. The receiving server is overloaded or temporarily unavailable. Even the most robust server can only handle so much traffic. Sometimes an email will bounce due to an overloaded or unavailable server. This type of situation generates a soft bounce.

5. The receiving mailbox is full (Quota exceeded). Few email providers allow unlimited storage. When a user reaches their predetermined limit, all future emails will bounce. Many email systems will hold those bounced emails and attempt redelivery for a period ranging from hours to days. If and when the recipient clears old messages and creates space, any cached emails will be delivered.

6. The email has been blocked by the recipient. Individuals can block emails from senders they no longer want to hear from. If that has happened to you, a bounce will be generated.

7. The recipient has activated an auto-responder or vacation reply. When employees go on vacation or will be unavailable, they can set up an autoresponder to tell contacts about it. If the email address you are trying to reach has an autoresponder, you will see a bounce, but the message may still be delivered after the autoresponder is turned off.

Nothing can reduce your bounce rate to zero


SOURCE:
http://blog.sendblaster.com/2015/01/22/7-reasons-why-your-emails-get-bounced/


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
sundance #261299 04/10/2018 2:51 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Yes Isaac,

We have been blocked, a few months ago some fool got access to our email data base on the server and sent out a bogus email. All of what you mentioned I am aware of and is true.

We use to only have about 4k in returns and we do send the emails with a message on how to remove yourself from the email notifications.

But it is not possible to re move 13k in emails one at a time. So the big question is how to capture all of the returns and then do an export of that data / emails only and then remove it from the UBB database email?

Thanks Mike

sundance #261300 04/10/2018 3:07 PM
Joined: Dec 2003
Posts: 6,568
Likes: 78
Joined: Dec 2003
Posts: 6,568
Likes: 78
Well there also is one more reason.
The email is just not valid anymore.
Meaning that if they have not visited in an extremely long time it probably is a bad email address.
Speaking on that , There is no way to remove the bounced emails from the database. in mass based on bounced emails that I know of.
They are unrelated programs, mail box and ubb.

But possibly you could run the query that does look for last login older than x number of days and set them to off.
But that would need to be a call on your side as to how often a member visits.

Last edited by Ruben; 04/10/2018 3:10 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
isaac #261301 04/10/2018 3:08 PM
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
Originally Posted by sundance
We use to only have about 4k in returns and we do send the emails with a message on how to remove yourself from the email notifications.

But it is not possible to re move 13k in emails one at a time. So the big question is how to capture all of the returns and then do an export of that data / emails only and then remove it from the UBB database email?

Originally Posted by isaac
If 13K came back to you, then you already know their addresses are "UNdeliverable."

Write a SQL query and execute it within the CONTROL PANEL > DATABASE TOOLS > SQL COMMAND page.

Similar to the following:

update ubbt_USER_PROFILE
set USER_ACCEPT_ADMIN_EMAILS = 'off'
where USER_REAL_EMAIL = 'mail@example.com'

mail@example.com would be where you insert the address you wanted to disable admin emails for. Do this for each address.

Write a batch to update your forum.
update ubbt_USER_PROFILE set USER_ACCEPT_ADMIN_EMAILS = 'off' where USER_REAL_EMAIL = 'mail@example.com'


Originally Posted by sundance
how to capture all of the returns

Originally Posted by sundance
13K are coming back

That set of data that comes back to you seems like a good place to begin generating a list with.


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
sundance #261302 04/10/2018 3:09 PM
Joined: Jun 2006
Posts: 16,304
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,304
Likes: 116
UBB.threads does not have the functionality to mass unsubscribe, or remove users, from a list; you would have to have a tool developed for the functionality that you're seeking.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #261303 04/10/2018 5:38 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
Originally Posted by Gizmo
UBB.threads does not have the functionality to mass unsubscribe, or remove users, from a list; you would have to have a tool developed for the functionality that you're seeking.
WOW, that kinda sucks. Is there a tool out there?

sundance #261304 04/10/2018 5:49 PM
Joined: Jun 2006
Posts: 16,304
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,304
Likes: 116
You'd likely have to hire someone to develop a script for you; no tool, that I'm aware of, exists to prune or change permissions on user accounts based on a list of addresses.

A tool would have to be created which would take a list of addresses (likely from a textarea field) and process each entry against your database for the action you'd want (which would likely be either to purge the user, add the user to a specific group so you can process manually, or simply disable their preference to receive admin emails).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
sundance #261333 04/12/2018 1:59 PM
Joined: Aug 2012
Posts: 113
S
member
member
S Offline
Joined: Aug 2012
Posts: 113
OK, thank you guys for the input!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Weird characters showing up
by Baldeagle - 06/17/2024 12:36 AM
Upgrading supporting apps (mysql, php)
by Baldeagle - 06/09/2024 8:39 AM
Questions re: forum layout and site issues
by domspeak - 06/03/2024 1:49 AM
Test
by Phun - 05/28/2024 7:31 PM
Who's Online Now
2 members (Gizmo, Baldeagle), 442 guests, and 169 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)