profile no longer displaying

[boulderfuzz]

I have a profile set up on my system with the following characteristics:

• type = Membership
• used for = Profile, CiviContribute
• enabled = yes

This profile collects data on a business membership form.

This profile has been active on our system for some time, and until recently the profile's data could be viewed through the membership for the organization which filled out the online membership form.  I recently discovered that I can no longer view the profile's contents in any of the contact record's contents.  Any idea how I can fix this? I am happy to make changes at the SQL level if someone can just direct me to the proper table and field.  Thanks!

[petednz]

it might help if you can fire through some screenshots - i ask because some of what you say makes sense but some of it makes me think you are talking about is the 'custom fields' themselves (which you can see on a contacts record eg on the membership record) versus the profile, which you would see on the membership forms.

[boulderfuzz]

sorry for the delay in getting back to you, and thank you for the offer to help. As requested, a (hopefully better) explanation with screenshots as panels in the attached PNG, for one of the businesses which recently filled out this profile. I can see the data in the SQL tables, but would like to also view the data in the Civi interface.

top panel: the profile under discussion is Additional Business Info

this profile is active and collecting data on my org's business membership form:  https://bouldermountainbike.org/civicrm/contribute/transact?reset=1&id=3

My expectation is that the data would be visible somewhere in the contact record, but that is not the case:

• middle panel: viewing the contact summary - I can see other profiles, but not the business profile
• bottom panel: my memory was that this particular profile could be viewed at the membership level, but no sign of the profile there either

[petednz]

as i read it, to the right of Additional Business Info it says 'used for Civi Contribute'

so have you looked on the Contribution record rather than their Membership record.

[boulderfuzz]

I looked at the contribution record too, no dice - here's a screenshot of the associated contribution record (with stuff erased for security, obviously).

[petednz]

The Fields (not the profile) are set up for Memberships?

Those custom Membership fields are in a Profile that shows on CiviContribute?

When submitted those fields are not adding data anywhere that you can see?

Have you looked in the 'values' tables in the db to confirm the data is being captured?

Have you done a really simple equivalent on demo to compare outcomes?

If you want you can PM me and then skype me as it may only take 5 mins to unravel.

[boulderfuzz]

ooh, smart, you found it!

The issue: the Custom Data fieldset was set to the incorrect Type.  At one time we had "business" as the only membership type sold through the 'business membership' page; now we have "business gold", "business supporter", "business corporate" types being sold through the page collecting data for the profile https://bouldermountainbike.org/civicrm/contribute/transact?reset=1&id=3.  The fieldset was still using only Type=business and had not incorporated the new membership types.

I updated the fieldset Type, and now all flavors of "business" memberships are enabled as acceptable types. I have verified that new memberships now display the profile when viewing the respective membership.  However, old memberships are not retroactively displaying the profile. The data are present in the respective 'values' table, I checked. Is there a flag I can set in the db to enable profile display for the older memberships?

[petednz]

Well to be honest, you found it. I just pointed in lots of directions ;-)

The data are present in the respective 'values' table, I checked. Is there a flag I can set in the db to enable profile display for the older memberships?

Are you saying - the data for the memberships which are not displaying in the fields, is in the db? That sounds unlikely but then you use the term 'profile display' which could be confusing.

Profiles are collections of fields that can be used in a number of ways, eg on Contribution pages, User registration pages, and also for search results etc.

Fields are what show eg if you click in to a Contact's Membership records.

Still happy to skype so I feel less like one of those posts at geographic tourist places that points in every possible direction with distances shown (Wellington 12121 km or 7531 mi) - well except no one thinks to point to Wellington