- Posts: 155
- Thank you received: 2
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Invitation Sending: I want to send more than 5000 invitation
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
7 years 3 months ago #145754
by mrli999
Invitation Sending: I want to send more than 5000 invitation was created 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.
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
The topic has been locked.
- Deusdeorum
- Offline
- Senior Member
Less
More
- Posts: 72
- Thank you received: 17
7 years 3 months ago #145757
by Deusdeorum
Replied by Deusdeorum on topic Invitation Sending: I want to send more than 5000 invitation
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
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
7 years 3 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 .
I don't answer to private message.
Replied by DenisChenu on topic Invitation Sending: I want to send more than 5000 invitation
Hi,
Send token email one by one with ajax : allow to send all email in one click.
sendMailCron : Allow to send token email (invite or reminder) via PHP cli
Send token email one by one with ajax : allow to send all email in one click.
sendMailCron : Allow to send token email (invite or reminder) via PHP cli
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 .
I don't answer to private message.
The following user(s) said Thank You: mrli999
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago #145766
by mrli999
I would like to use the third method. Would you please let me know where can I find such script? Thanks
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago #145767
by mrli999
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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.
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.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
7 years 3 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 .
I don't answer to private message.
Replied by DenisChenu on topic Invitation Sending: I want to send more than 5000 invitation
Did you look at :
- www.limesurvey.org/index.php?option=com_...dMailAjax&Itemid=729
=> extensions.sondages.pro/mailing-manageme...k/documentation.html
?
- www.limesurvey.org/index.php?option=com_...dMailAjax&Itemid=729
=> extensions.sondages.pro/mailing-manageme...k/documentation.html
?
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 .
I don't answer to private message.
The following user(s) said Thank You: mrli999
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago - 7 years 3 months ago #145772
by mrli999
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.
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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: 7 years 3 months ago by mrli999.
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago #145787
by mrli999
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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.
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.
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11757
- Thank you received: 2753
7 years 3 months ago #145794
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Invitation Sending: I want to send more than 5000 invitation
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
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 answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago - 7 years 3 months ago #145833
by mrli999
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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
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: 7 years 3 months ago by mrli999.
The topic has been locked.
- Deusdeorum
- Offline
- Senior Member
Less
More
- Posts: 72
- Thank you received: 17
7 years 3 months ago #145836
by Deusdeorum
Replied by Deusdeorum on topic Invitation Sending: I want to send more than 5000 invitation
What happens if you click the button manually? Is it still sending only 40 emails?
The following user(s) said Thank You: mrli999
The topic has been locked.
- mrli999
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 155
- Thank you received: 2
7 years 3 months ago #145840
by mrli999
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.
Replied by mrli999 on topic Invitation Sending: I want to send more than 5000 invitation
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.
The topic has been locked.