CiviCRM Community Forums (archive)

Eileen McNaughton developed a module hosted on GitHub at https://github.com/eileenmcnaughton/civicrm_views_token

This allows users to create a view in Drupal and have it available as a token in CiviMail to embed the view in mailings

We installed that module and built a view of current content posted on our website and successfully embedded it into a mailing template, so that every time that template is used, the token area is automatically populated with latest content from the website.

So far so good.

What we need is the module to be adapted so that more than one drupal view and one token is supported. Any pointers to how to go about doing this would be great, there is also cash available to pay someone to develop this functionality if necessary.

Cheers

Sean

This is yet another fantastic piece of code from Eileen!
Since Drupal is a content management system, a lot of time is spent getting drupal content into civicrm.  I know there was discussion about using drupal tokens and nodes as civicrm tokens (which would be fantastic.)  Perhaps the great work Eileen is doing on drupal entities could be used here instead.  That would allow a single drupal module to address all these needs.

NB - sonicthoughts - this isn't really an extension of the entity concept as the civicrm token is a very civi concept.

We have had some conversations lately about automatically mailing out drupal content items as CiviMail (think press releases) & I'm hoping to see a blog posted fleshing that out a bit

Sean,

Check this line  - the variable is converted into an array - I don't know what setting the variable to an array using drush would look like but it is presumable not too hard to figure out

https://github.com/eileenmcnaughton/civicrm_views_token/blob/master/civicrm_views_token.module#L72



Have a look at this too

http://fuzion.co.nz/blogs/styling-mails-civimails-civicrm

Your take-away from that should be that your view needs a table layout not a div layout for outlook

Hi Eileen, Sorry for the delay in replying!!  Was talking to a company about this but that seems to have petered out.  I assumed the Array was to hold the different elements of the view, not multiple views. I'm not a PHP expert (or even a novice), but I thought I could just clone the module and rename all the variables to get a second view into an embeddable token, then a third, then a fourth etc. but have been warned off this by my MYSQL/PHP acquaintances as it would mess up the database? How then to get multiple views into multiple tokens with one module.? We are willing to pay to get this work done!

Cheers

Sean

Thanks Eileen,

That worked quite well and we have multiple views available to include in bulk emails now.

However we have an "issue" with the URLS generated through the module, which may not be down to the module but to our own configuration, but I don't know why it's happening.

When we test a bulk email the links work perfectly as in (1) below

(1)http://www.voscur.org/new-job-entry-page/1-oct-2014-1016/bristol-drugs-project-shared-care-worker

But when the mail is actually scheduled and sent any links generated from the view look like this and don't then work

(2)http://www.voscur.org/sites/all/modules/civicrm/bin/sites/all/modules/civicrm/bin/sites/all/modules/civicrm/bin/new-job-entry-page/1-oct-2014-1016/bristol-drugs-project-shared-care-worker

If anyone has any insight that might be helpful it would be appreciated

Sean