CiviCRM Community Forums (archive)

It would appear that Views2 cannot access custom data at the moment.

setup:
Drupal 6.16
Civi 3.1.1
Views 6.x-2.8

Having followed the instructions here:http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module, here: http://redspire.net/content/civicrm-views-2-integration-remote-civicrm-database, and here: http://redspire.net/content/problems-and-solutions-problems-views-2-civicrm-and-drupal-6 I still couldn't get any custom data to appear when setting up a view - note I do not mean "it didn't appear after adding it to the view", I mean "there's no way to add it to the view - it doesn't appear in the edit view interface".

Note that I was using custom activity data.

Since then, I've done some searching and it seems to be a common theme across data types:

For Events, and a response suggesting that this is a known issue: http://forum.civicrm.org/index.php/topic,12132.0.html
For Events and Participants http://forum.civicrm.org/index.php/topic,11873.0.html

I have also tried the patch listed here http://forum.civicrm.org/index.php/topic,12000.0.html without success.

Yep.

Ok, I'll try upgrading to civicrm 3.1.3 (something I didn't want to do unless I really really had to due to potential to break things).

It was because of the number of similar problems I'd seen that I presumed it was a problem. Also because I've done *everything* as per instructions, and yet am still getting no joy.

ok, I'm about to check up after the upgrade - if it doesn't work, I guess I'll lodge a ticket?

cheers

cheers - I notice there has been a couple of Views2 upgrades over the last week as well - hopefully it will all be ok by this afternoon

More tests complete!

I added some custom data fields for "contacts", added the new table to settings.php, cleared views cache, started a new view, and lo, the custom fields were available in views. (Therefore: I am doing it right)

I then added a new custom data set for activities, made it available for phone call types, and followed through. Nothing.

I changed the above to be available for the value "any" and suddenly it was there (Therefore: it's not broadly a CiviCRM-Activities problem)

I went to my original custom data - because this is set to be an activity subbtype that we had created. Can't change it to Any type without getting and error.

Instead, I selected (ctrl-select) all types (basically the basics + my new subtype) and saved etc etc - still no joy.

It would seem that when creating a new Custom Data Group, if you select Activity as it's type in the Used For* field, and choose anything except --Any--, it wont appear in Views2.

I think that's as good a bug report as I can do - hopefully we can work something out from here given this knowledge?

cheers

tx Eileen - I took a quick look around, but there doesn't seem to be a pair of files to compare - contacts for instance only have one base file civicrm_handler_field_contact_link.inc to activity's 4, none of which are a _link.inc (but there are two type.incs)

And then in the civicrm_handler_field_link*.inc nameset there are one of each, but they don't seem to be where the prolem lies. I will have to come back to this at a time when I'm not limited to putty/cygwin and their vagaries...and I've done some more php readin'

ok, this file: civicrm_handler_filter_activityType.inc references State/Province:

39     function title( ) {
40         return t('State/Province');
41     }

which seems weird to me? I don't even know if this is where the problem is - I was just reading the source.