CiviCRM Community Forums (archive)

I need to create a drupal view, i.e. a listing of CiviEvents that includes an image for each event (see the attached design requirement). I can deal with all of the default event data, but not clear on how to get a image into the view that can also utilize drupals image styles.

 (btw: the forum topic 34532 (http://forum.civicrm.org/index.php/topic,34532.0.html) comes close, but no cigar.)

Suggestions??

Carl

Hi, Pete! And thanks ...

First, I don't need to add multiple images, so that does simplify things.   Maybe I just misinterpreted your your instructions

ASIDE: [and I *did* get an error along the way, but I think that's another story: "Notice: Array to string conversion in HTML_QuickForm_Rule_Required->validate() (line 63 of /var/www/mysite.com/sites/all/modules/civicrm/packages/HTML/QuickForm/Rule/Required.php)" } - seems this is a known problem when creating a custom field, e.g. events and using "Any" as the event type. and has something to do with having using multiple, "any" for the events and/or a PHP version problem.

Onward.  This is what I did:
* went to admin to create a set of custom fields called ~Test~ and 'used for' Events of "any" kind, i.e. workshop, exhibition, etc.
* created a custom field called "Picture" with a type of 'file'
* and a second field called "Path", type alphanumeric.  (this is where it got confusing).

* after having some event data I went to create a drupal view using 'civicrm_entity' to create view fields for the picture and the path.
* this is where I had trouble.  ... "path", i.e. [path] is usually associated with "file", but in this case it would require an explicit entry of a path on the admin interface, which may not work well. So I just never could figure out what to do from that point.  And I couldn't find a token replacement for [path] on the file.

So was it necessary at all to create the path field in the custom field set, and create only the Picture file type? If so, how can I get the path for the picture and/or just get it to display??

Sorry, but I really missed the mark on this one. 

Carl

Pete,

Yes, that's right! I want to use CiviEvent's default fields, and one custom field (image) for the view.

If you refer back to the screenshot of the client's design, you'll see that CiviEvent has all the data I need, except for the image.  And that's what I'm having trouble with.

Carl

Sorry, Pete! 

I'm using CiviEvents for the view.

The custom field for the image was, of 'file' type, and when I got to views, I could find all of the CiviEvent fields available, including the file, but was having trouble getting the path from the file, i.e. there was not a drupal token for path, i.e. [path]  to do a rewrite of the field.  Hence I could not display the image.

Carl

I think I'm getting closer ... but views is delivering a broken image link.

Q: When I define the image path field in the custom CiviEvent field, should it be of Type alphanumeric, file, or link??

FYI:
When the Image file uploaded from CiviEvent arrives in the Drupal View as the original file field (not the path field) the link exists and is found at http://mysite.com/sites/default/files/civicrm/custom/ThePicture.jpg and is represented by the token [event_image_one] , However it displays as broken. 

If I look at the file with a different image tool, it appears okay. 

If I replace the token path in the Rewrite output area to a different image with a literal address like MyThemeName/images/picture.jpg, its okay.

Carl

Pete,

Hopefully this helps someone, but I just learned something that might be worth sharing.

When an image is uploaded to the website via an Event Custom Field type of 'file', the image lands in 'sites/default/files/civicrm/custom' . Any image that is placed in that directory can not be displayed.  I tested this my using rewrite in a drupal view and entered the location explicitly via an <img src="the location"/>.  And the image is not shown ... none of the images will appear.  However, if I put one of those images into the theme/images directory, they work perfectly.  All of these experiments were conducted from Drupal views.

FYI: I did not need to create a path field and exclude display of the 'file' field to do this. In fact I never could get it to work that way ... it definitely had something to do with the location.

The kicker: So how dangerous is it, to remove .htaccess from that civicrm custom folder?  Scary, huh?  Well, as it turns out, removing the .htaccess from the civicrm/custom folder allows the images to be displayed!

I know, its a Cardinal Sin to do that, but the only way to workaround it is to manually place the images desired into a different folder, e.g. the theme/images folder, and rewrite the custom 'file'field with the literal location of the new directory, i.e. don't use a token.

OR

Find out some other way to get Event Management to upload a file to some other area.  Is there way to do this?

I don't mind manually moving the uploaded images as long as I don't have too many (and that could happen), but I don't like fooling with mother nature either, i.e. deleting the htaccess.

Got any suggestions???  Like is there someway to exercise the Resource Directory Extension for the images and and redirect files to that location via the civicrm.settings.php file??

Carl

Actually, I *was* logged-in as admin while doing this, but could well be that wouldn't work if not logged in.

You know, I do like your suggestion of getting rid of the custom 'file' type field and just use an alphanumeric, or at least for the time being.

It *would* be nice if there were an image type field to chose from in the Custom event fields, huh?  I'll submit a request for a enhancement. 

Thanks, Pete ... here come the Kudos!

Carl