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
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 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
The topic has been locked.
More
7 years 3 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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
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.
The following user(s) said Thank You: mrli999
The topic has been locked.
  • mrli999
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 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
The topic has been locked.
  • mrli999
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
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.
The following user(s) said Thank You: mrli999
The topic has been locked.
  • mrli999
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 months ago - 7 years 3 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: 7 years 3 months ago by mrli999.
The topic has been locked.
  • mrli999
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 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.
The topic has been locked.
  • holch
  • holch's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 3 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 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
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 months ago - 7 years 3 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: 7 years 3 months ago by mrli999.
The topic has been locked.
More
7 years 3 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
The topic has been locked.
  • mrli999
  • mrli999's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 3 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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose