Well, first let me run my "vision" by all of you for what I plan to do with Views Mail. Currently I have a site setup http://www.mycru.org , its not meant to be a community site, meaning, I don't plan to have a lot of users accounts on there with their contact information. I got a page setup with a bunch of names and addresses created with content and view. This will be used as like a church directory.

The way I accomplished this is I created a content type, with all the required fields (name, phone, email, address...) and staff members can just create that particular type of content, and there it is in the database. Then I used view to show only that particular content type (i called it "contacts") and the desired fields to display in a table view format. I can sort my first and last name, and other fields. I also created some exposed filters in order to make the list shorter, and narrow down who I need on that page.

So that is what I have, I want to be able to use those exposed filters, and narrow down a group of people from their fields, after that group is narrowed down, I would like to be able to just send out a mass mailing with their given email (with is in one of the field). Like a newsletter.

The only problem I found is that most of the modules I found on drupal's site for mass mailing is using the the "community" aspect of drupal, using user registration, and all that stuff. So their mass mailing comes from the drupal user accounts(nodeprofles). Which is not what I have setup, I plan to have only a hand full of durpal accounts, mainly for staff members, and then a "global" account for the "community" where they can access the directory (this is for privacy reason, outside visitors will not be able to look up email address, phone numbers, street addersses... things like that, also eliminate spam bots).

So in a nut shell, I need a mass mailing solution where it takes the email address from a text field, and be able to use expose filters to narrow down the directory.

I tried installing Views Mail and it brought the site to a crawl and gave me some errors.
one of them indicate conflict with fieldgroup (which is setup for with the content type)
Invalid argument supplied for foreach() in /var/www/virtual/koish/cru.koish.com/modules/cck/fieldgroup.module on line 395.
I tried turning off fieldgroup module, and that error message went away, but then when I tried sending a mass newsletter, i got this message
Division by zero in /var/www/virtual/koish/cru.koish.com/includes/pager.inc on line 73.
And I checked the log messages, there is one more error
Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE sessions SET uid = 1, cache = 0, hostname = '24.223.193.218', session = 'form|a:10:{s:32:\"80f28fc8b560f846f9477505bd30a767\";a:2:{s:9:\"timestamp\";i:1188527090;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"a04b28665be1bf6b16dbb24a525cd115\";a:2:{s:9:\"timestamp\";i:1188527147;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"6d8905f2619bf2b8eafb53f921b90134\";a:2:{s:9:\"timestamp\";i:1188527150;s:4:\"args\";a:1:{i:0;s:24:\"system_modules_uninstall\";}}s:32:\"3df2758f1b50520121a03713e7a63993\";a:2:{s:9:\"timestamp\";i:1188527425;s:4:\"args\";a:3:{i:0;s:20:\"views_mail_mail_form\";i:1;O:8:\"stdClass\":58:{s:3:\"vid\";s:1:\"5\";s:4:\"name\";s:4:\"test\";s:11:\"description\";s:4:\"test\ in /var/www/virtual/koish/cru.koish.com/includes/database.mysql.inc on line 172.

I currently have Drupal 5.2 installed. I don't mean to rush, but I need a solution fast. The site is made for a campus ministry, and new freshman are starting school on 9/4/07, and I need to send out emails to all the new contacts we got, and getting connected with them asap.

CommentFileSizeAuthor
#1 README_20.txt6.24 KBsomebodysysop

Comments

somebodysysop’s picture

somebodysysop commented
StatusFileSize
new README_20.txt6.24 KB

So in a nut shell, I need a mass mailing solution where it takes the email address from a text field, and be able to use expose filters to narrow down the directory.

This is what views_mail does. It does not require nodeprofile or that email recipients be registered users. However, the node (content type) you use for the view must have the information (cck fields) for searching (exposed filters) and sending (name and email) the emails.

The content type for the node for which you are creating the view should have defined a "name" and "email" field. These can be text, but they should contain the name and email address of your intended recipients.

1. You need to create a view. It should have exposed filters.
2. It should be a page view with "Views Mail" views type.
3. Nodes per page should be 0.
4. You MUST select the "name" and "email" fields of your content type in the "Fields" section of the view. If you don't, they won't appear in the "Recipient name" and "Recipient email" pulldowns.
5. In the "Send mail" section, please select your node "name" field as "Recipient name" and your node's "email" field as "Recipient email".

If you are performing these steps, and still continue to get errors, please doublecheck the README.txt (attached).

If you still find you are receiving errors, then please try and give us as much about the particulars of your View as you can so that it can be recreated.

ChineseGuy’s picture

ChineseGuy commented

Ok, the Division by zero error is caused my the pager, I forgot to turn that off.
And I was able to successfully send out an email in test mode. But the error about fieldgroup still remains.

After I enable view type as views_mail, at the top of the page for view, I got these two error messages in a red box. 


    * warning: Invalid argument supplied for foreach() in /var/www/virtual/koish/cru.koish.com/modules/cck/fieldgroup.module on line 395.
    * warning: Invalid argument supplied for foreach() in /var/www/virtual/koish/cru.koish.com/modules/cck/fieldgroup.module on line 395.

I am wondering where that could come from. So I am going to try and give you guys as much info as possible.

My content type is call contact. We basically gave out surveys to people, and they answered them. I created the different fields corresponding to the surveys. We had 2 differnent type of survey, so I decided to put all the questions on there, and then use field group, and group the questions together in order to separate the two different surveys. So then I created a view with a filter that only shows the content type of "contacts" and added the fields for name, address, email, and the various survey questions.

The survey questions are on expose filters, so I can filter out the people I want to send out emails to by their answer. That's my setup for view.

I have no problem getting it to send email i guess, but the error message comes up in my view page right after i set it to views_mail, and the message seems to indicate it has something to do with my fieldgroup on my content type. If I turn off the fieldgroup module, the message will go away (kinda obvious), but then its harder to enter data in since both surveys are in "expanded" mode, instead of collapsed.

Any other info you guys want?

somebodysysop’s picture

somebodysysop commented

* warning: Invalid argument supplied for foreach() in /var/www/virtual/koish/cru.koish.com/modules/cck/fieldgroup.module on line 395.
* warning: Invalid argument supplied for foreach() in /var/www/virtual/koish/cru.koish.com/modules/cck/fieldgroup.module on line 395.

I don't have the fieldgroup.module installed, nor do I know what it does. So, the next logical step is for you to report this error with fieldgroup issues. If we know what is supposed to be happening in that line, we might be able to generate a fix.

ChineseGuy’s picture

ChineseGuy commented

The fieldgroup people pointed me to the right direction.
For more information, read this thread. http://drupal.org/node/174612

Thanks for your help!

somebodysysop’s picture

somebodysysop commented
Status: Active » Fixed
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)