Hi all,
I am looking for help/advice.
on my site i have two types of users buyers and sellers. Sellers add their items to the database table, the buyers add a 'saved search' to the site and then the buyers can see any items that match their search parameters. the list of results will change as new items are added to the site by sellers..
This is all working on the front end of the site and buyers can get a list of items that match their parameters
As the results list will always be changing, i am now looking to get a daily email sent to the user showing the first five results.
i have downloaded a Cron emulator (my server wont allow me to run Cron from cPanel) to run a scheduled task at the time of my choosing.
How would i go about setting up a form that gets the results for each user and then mails those specific results to the specific user.
I want to be able to use a mailer (AcyMailing? i have installed this already as its going to send my newsletter out, once i have set it up) to send emails as i think (hope) that i will exceed mailing limits in the future and don't want to write one method and then have to change it at a later date.
If you need any more information please ask, but any help would be appreciated.
I can write the form that will get the list of results myself, just not sure how to get those results into a mailer to be sent out to the users.
Kind Regards
Allan
I am looking for help/advice.
on my site i have two types of users buyers and sellers. Sellers add their items to the database table, the buyers add a 'saved search' to the site and then the buyers can see any items that match their search parameters. the list of results will change as new items are added to the site by sellers..
This is all working on the front end of the site and buyers can get a list of items that match their parameters
As the results list will always be changing, i am now looking to get a daily email sent to the user showing the first five results.
i have downloaded a Cron emulator (my server wont allow me to run Cron from cPanel) to run a scheduled task at the time of my choosing.
How would i go about setting up a form that gets the results for each user and then mails those specific results to the specific user.
I want to be able to use a mailer (AcyMailing? i have installed this already as its going to send my newsletter out, once i have set it up) to send emails as i think (hope) that i will exceed mailing limits in the future and don't want to write one method and then have to change it at a later date.
If you need any more information please ask, but any help would be appreciated.
I can write the form that will get the list of results myself, just not sure how to get those results into a mailer to be sent out to the users.
Kind Regards
Allan
Hi Allan,
If you are looking to mail big lists then you really do need to set up a linkage with a 'professional' mailing service. You could build a form and use a Custom Code action with a PHP loop to get the addresses and send emails. This would be good for tens of emails, maybe a few hundred but not thousands.
AcyMailing is much better set up to handle large mailings. I didn't know they had a limit but f they do then you might need to link to an external service like MailChimp, AWeber, etc. (the big advantage of these is that they are set up to handle 'spam complaints' without getting your site URL blacklisted).
For AcyMailing I think that you can send an article so you could use the Cron job to update an article content with the latest listings and then trigger the mailing.
Bob
If you are looking to mail big lists then you really do need to set up a linkage with a 'professional' mailing service. You could build a form and use a Custom Code action with a PHP loop to get the addresses and send emails. This would be good for tens of emails, maybe a few hundred but not thousands.
AcyMailing is much better set up to handle large mailings. I didn't know they had a limit but f they do then you might need to link to an external service like MailChimp, AWeber, etc. (the big advantage of these is that they are set up to handle 'spam complaints' without getting your site URL blacklisted).
For AcyMailing I think that you can send an article so you could use the Cron job to update an article content with the latest listings and then trigger the mailing.
Bob
Hi bob,
Thanks for your reply,
I have got a script written that pulls the correct data from the database, with the relevant user details in it (Username and email address).
Can you point me in the right direction to get this data from my Chronoform into an article so acymailing can use it to generate the unique email content. I'm stumped!
I am going to get Acymailing to use Mailchimp to do the actual sending.
If this is outside your scope, let me know.
Thanks for your reply,
I have got a script written that pulls the correct data from the database, with the relevant user details in it (Username and email address).
Can you point me in the right direction to get this data from my Chronoform into an article so acymailing can use it to generate the unique email content. I'm stumped!
I am going to get Acymailing to use Mailchimp to do the actual sending.
If this is outside your scope, let me know.
Hi Allan,
There are two ways to add content to an article. The simplest (but possibly more limited) is to use a custom code action to build the article content then use the ChronoForms Submit Article action to create the article.
The more flexible option - particularly if you want to edit the article content would be to build the content in the same way then use a MySQL query in the same Custom Code action to add a new article or update an existing one.
Bob
There are two ways to add content to an article. The simplest (but possibly more limited) is to use a custom code action to build the article content then use the ChronoForms Submit Article action to create the article.
The more flexible option - particularly if you want to edit the article content would be to build the content in the same way then use a MySQL query in the same Custom Code action to add a new article or update an existing one.
Bob
This topic is locked and no more replies can be posted.
