Invitation Sending: I want to send more than 5000 invitation

More
2 years 10 months ago #145754 by mrli999
Dear Friends,

I want to send more than 5000 inviation email. I set the email batch size to 60. Then I need to click the "send invitations" button for more than 80 times. Besides that the email administrtor help me to send the email batch every 15 minutes, that is: I send the fire email batch on 12:00, the second email bath on 12:15 or later, and so on.

Is there any way to do it automatically? thanks.
The following user(s) said Thank You: Lachelle14

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
2 years 10 months ago #145757 by Deusdeorum
There is a few options here:
  • You can use a cron plugin to automatically send out invitations, I think a solution already exist for purchase somewhere.
  • You can use the API to invite_participants(), api.limesurvey.org/classes/remotecontrol..._invite_participants , simply loop the survey until all the invitations has been sent, make sure to add some delay otherwise you will most likely get listed as a spammer
  • A more ugly way would be to have a click function on a server somewhere, click "invite participants" every 15 min, could be coded as a bash script and identify the button for invitations, same as above, use some kind of delay
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145760 by DenisChenu

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145766 by mrli999

Deusdeorum wrote: There is a few options here:

  • You can use a cron plugin to automatically send out invitations, I think a solution already exist for purchase somewhere.
  • You can use the API to invite_participants(), api.limesurvey.org/classes/remotecontrol..._invite_participants , simply loop the survey until all the invitations has been sent, make sure to add some delay otherwise you will most likely get listed as a spammer
  • A more ugly way would be to have a click function on a server somewhere, click "invite participants" every 15 min, could be coded as a bash script and identify the button for invitations, same as above, use some kind of delay



I would like to use the third method. Would you please let me know where can I find such script? Thanks

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145767 by mrli999
I set the email batch size to 60, and used the following scipte in VBA

Set aaa = ie.Document.getElementsByName("yt0")
For ii = 0 To aaa.Length - 1
If aaa(ii).Value = "Send invitations" Then aaa(ii).Click
Next

It does work and can click the "Send invitations" button automatically. However, it seems send all email in one time, not 60 emails in one time. If I hope only send one batch email (that is 60 emails), what should I do? Thanks.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145771 by DenisChenu

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago - 2 years 10 months ago #145772 by mrli999

DenisChenu wrote: Did you look at :
- www.limesurvey.org/index.php?option=com_...dMailAjax&Itemid=729
=> extensions.sondages.pro/mailing-manageme...k/documentation.html
?


Thank you very much. I read those materials, they are not what I need.

I need to send more than 5000 email invitations. I set the email batch size to 60, that is it will send 60 email every time. And I hope can send one batch every 15 mintues. So I have to wait for 15 minutes to click the "send invitations" button. I want to know is there any method can be used to click the button automatically every 15 minutes for me.

I can't send all 5000 email in one during to the limitation of the ISP.
Last edit: 2 years 10 months ago by mrli999.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145787 by mrli999
Using VBA in Excel, now I can automatically click the "send invitations" buttons and send email every 10 minutes (or other interval specified).

I set the email batch size to 60. But every time emails sent were not 60, it seemed to be 41. I don't know why.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145794 by holch
Not sure why only 41 are sent. Does your email provider have some limits there, maybe?

So it seems to work for you. Just for making this complete in case others are looking for a solution, the guys at the Limesurvey Template Shop have a cron job script that does what you are looking for on the server in the background. However, I have never tested it, so I don't know how well this works.

www.limesurvey-templates.com/limesurvey-...aa5asumka7spv58379n2

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago - 2 years 10 months ago #145833 by mrli999
I used the following vba script in Excel. But today only 40 emails were sent even the email batch size is still 60. I don't know why. Any one can help? thanks.

Sub send_Click()
Dim ie As Object
Dim iabcd As Integer

iabcd = 1

For iabcd = 1 To 10
Set ie = CreateObject("InternetExplorer.Application")

ie.Navigate " www.sample.com/survey/index.php?r=admin/...mail/surveyid/533664 "
ie.Visible = True
While ie.ReadyState <> 4
DoEvents
Wend

If ie.locationurl <> " www.sample.com/survey/index.php?r=admin/...mail/surveyid/533664 " Then
ie.Document.getElementById("user").Value = "username"
ie.Document.getElementById("password").Value = "password"
ie.Document.all("login_submit").Click
While ie.ReadyState <> 4
DoEvents
Wend
End If

ptb = 3
stb = Timer
Do While Timer < stb + ptb
DoEvents
Loop


ie.Document.all("yt0").Click

ptc = 3
stc = Timer
Do While Timer < stc+ ptc
DoEvents
Loop


If iabcd <> 10 Then
ie.Quit
pt = 60 * 10
st = Timer
Do While Timer < st + pt
DoEvents
Loop
End If

Next
ie.Quit
End Sub
Last edit: 2 years 10 months ago by mrli999.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145836 by Deusdeorum
What happens if you click the button manually? Is it still sending only 40 emails?
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145840 by mrli999

Deusdeorum wrote: What happens if you click the button manually? Is it still sending only 40 emails?


No, if i click the button manually, it will send 60 emails.

Now it only send 39 email when I use the VBA script. It seems from 43 to 42, 42 to 41, 41 to 40, and now 39. I don't know why.

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145853 by Mazi
If you are able to run cronjobs I recommend using this script which is used by several dozens of users:
www.limesurvey-templates.com/automatical...nvitations-p-49.html

From my experience sending such a huge amount of emails should definitely by done in batches to prevent being treated as spam or being put on blacklists.
Check www.limesurvey-consulting.com/how-to-pre...ing-treated-as-spam/ for more information.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145854 by DenisChenu

Mazi wrote: .....e sending such a huge amount of emails should definitely by done in batches to prevent being treated as spam or being put on blacklists.
.....

:blink: sending it in batch dpon't change the spam issue, really no reason.

And if the server have some condiguration issue (for example on ISP limit email 1 by second, if you send 2 in one second : all next message is refused) then : batch can broke more sneding email.

mrli999 already said he can not use batch like that because his hoster/ISP limit sending email.

@mrli999 : have the project to limit batch size globally and by survey in sendMailCron plugin. DOn't know when, but if you'r interested : follow the project.

Denis

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #145860 by Mazi

DenisChenu wrote: sending it in batch dpon't change the spam issue, really no reason.

Yes, it does. Especially for learning spam filters analysing ongoing mailserver traffic. These systems tend to lower the spam threshold if lots of emails are send within short time from a certain IP. Thus, using smaller batches and sending emails every 30 minutes instead of every 2 minutes may help.

DenisChenu wrote: And if the server have some condiguration issue (for example on ISP limit email 1 by second, if you send 2 in one second : all next message is refused) then : batch can broke more sneding email.
mrli999 already said he can not use batch like that because his hoster/ISP limit sending email.

Of course it depends on the configuration details. But if there are such limits, a cronjob is a good choice because you can easily configure it to stay within the required limits e.g. by increasing the delay between the different script calls.

Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com
The following user(s) said Thank You: mrli999

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!