CiviCRM Community Forums (archive)

The custom types created for custom contact types are not visible in drupal views. I copied the information from http://euyo.triquanta.nl/civicrm/admin/setting/uf&reset=1 in settings.php but it is not working.

Ok. I am willing to look into it and see if I can make the necessary adjustments. Could you give me a pointer were to start? Because I am fairly new to Civi it will be a lot faster if you can give me some pointers. Thanks.

After looking at the code I discovered that custom groups for subtypes were already implemented.
With some debugging I found that the value in
civicrm_custom_group.extends_entity_column_value was not clean text. You can see this in the attached file. This seems to obstruct somehow the integration. If I change by hand a value to plain text (as you can see in the screenshot, I did) all the groups and fields are shown in the views EXCEPT for the changed group.
Waht should the value be in extends_entity_column_value? Where could it go wrong? Maybe CRM_Core_BAO_CustomGroup::getTree is not working as expected?

Hmm, it seems that it had something to do with the cache. I deleted the template_c folder and now all the groups show up. Thanks for the help.

Ok, some more information. I used the dd function of the drupal devel module to see whats in the return value of getTree, and as you can see, only one group is returned. That is the one for Individuals. All the outher groups result in empty arrays.
civicrm_debug: Array
(
    [3] => Array
        (
            [id] => 3
            [name] => Status
            [table_name] => civicrm_value_status_3
            [title] => Status
            [help_pre] =>
            [help_post] =>
            [collapse_display] => 0
            [is_multiple] => 0
            [extends] => Contact
            [fields] => Array
                (
                    [3] => Array
                        (
                            [id] => 3
                            [label] => Email invalid
                            [column_name] => email_invalid_3
                            [data_type] => Boolean
                            [html_type] => Radio
                            [default_value] => 0
                            [is_required] => 0
                            [is_view] => 0
                            [date_format] => M
d
Y
                        )

                    [4] => Array
                        (
                            [id] => 4
                            [label] => Address invalid
                            [column_name] => address_invalid_4
                            [data_type] => Boolean
                            [html_type] => Radio
                            [default_value] => 0
                            [is_required] => 0
                            [is_view] => 0
                            [date_format] => M
d
Y
                        )

                    [5] => Array
                        (
                            [id] => 5
                            [label] => Last edited before import
                            [column_name] => last_edited_before_import_5
                            [data_type] => Date
                            [html_type] => Select Date
                            [is_required] => 0
                            [is_view] => 1
                            [date_format] => mm/dd/yy
                        )

                )

        )

    [info] => Array
        (
            [tables] => Array
                (
                    [civicrm_value_status_3] => Array
                        (
                            [email_invalid_3] => 1
                            [address_invalid_4] => 1
                            [last_edited_before_import_5] => 1
                        )

                )

            [select] => Array
                (
                    [0] => civicrm_value_status_3.id as civicrm_value_status_3_id
                    [1] => civicrm_value_status_3.entity_id as civicrm_value_status_3_entity_id
                    [2] => civicrm_value_status_3.email_invalid_3 as civicrm_value_status_3_email_invalid_3
                    [3] => civicrm_value_status_3.address_invalid_4 as civicrm_value_status_3_address_invalid_4
                    [4] => civicrm_value_status_3.last_edited_before_import_5 as civicrm_value_status_3_last_edited_before_import_5
                )

            [from] => Array
                (
                    [0] => civicrm_value_status_3
                )

            [where] =>
        )

)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)

civicrm_debug: Array
(
)


yes

since there could be multiple subtypes which are delimited by the SEPARATOR

can you get on IRC, so we can get more details, investigate and potentially fix

thanx

lobo

with developers in poland/india/US we are pretty much around 24 hours

just pop on irc and ask someone for help and point to the forum topic to give folks a context.

i will not be around a lot this week since i'm travelling and doing a few traininings

lobo

I'm having problems with some of the core fields in a contact subtype record not being returned in Views either - Organsization name is exposed but returns no data when previewed!! Possibly related?