Custom data in event confirmation emails

[kmarkley]

We're using a custom data group attached to participant records to collect data about our marketing efforts (i.e. how did you hear?).  A profile is used to expose the form for online registrations as well.  The group has one field with multi-selct checkboxes (i.e email, postcard, facebook, etc.)

The problem is with the even confirmation emails, which fail to display the data correctly.  Confirmations for online registrations show the value as "0th, 0 12:00 AM" and those for offline registrations just say "Array".  I am especially perplexed that these aren't wrong the same way.

Obviously we could (and did) edit the email templates to simply not display any of this data at all, but I would prefer to get it to work properly for those cases when the field is more important (e.g. menu choice, etc.)

Any suggestions?

[Donald Lobo]

can u upgrade to 3.1.6 and see if the problem still persists. better yet, if u can upgrade to 3.2.0 and check that would be great. if it is still an issue, would be great if you can email us your 3.2 civicrm DB so we can check and figure out whats happening

lobo

[kmarkley]

Well, the problem persists on my 3.2 development server.  I did revert the email templates back to default in case I had overridden a fix to the template itself.

You really want/need the WHOLE db?  Or could I just dump the relevant tables?  There is a lot of personally-identifiable info in there...

[Donald Lobo]

if you can reproduce on a smaller database or on drupal.demo.civicrm.org that should be fine also

lobo

[kmarkley]

It can't be reproduced on the demo server because the demo server doesn't send out emails.

However, I made a little demo site of my own with only drupal, civicrm, and the sample data.  I was able to reproduce half of the problem.  Offline registrations with custom participant data still have just the word "Array" in the confirmation email.  Online registrations, however, seem to be working on this install.

I'd be happy to send you the demo db.  I can't attach files to a PM so pls send instructions.

If the offline confirmation emails get fixed and I still have a problem with the online versions, I guess I'll try to strip all the email addresses etc out of a copy of my db and send that if you are still willing to have a look.

Thanks so much for your help.

[Donald Lobo]

i assume its a 3.2 demo db. if so please send it to deepak at webaccess.co.in

we'll check and fix the offline registration stuff. u'll need to reproduce the online registraton stuff in the demo db for us to take a look

lobo

[kmarkley]

yes, 3.2.

I went ahead and sanitized my real db (also 3.2) that has both problems.  Sent both to deepak.

Thanks again.

[Donald Lobo]

can u also send deepak step by step instructions on how to reproduce the issue

thanx

lobo

[Deepak Srivastava]

Kirk Markley,

I was able to reproduce the problem using your db. Problem happens when any of the fields of the profile associated /w event doesn't have a field label set.

Could you set the field label and see if that fixes the problem at your end. Also file an issue mentioning this behaviour.

thanks,
Deepak

[kmarkley]

Thank you Deepak.

For ONLINE registration, setting the profile field label fixes the problem.  Issue filed:
http://issues.civicrm.org/jira/browse/CRM-6572

However, for OFFLINE registration, in which the custom data is entered directly into the custom data group and not via a profile, the confirmation emails still just say "Array".

[Deepak Srivastava]

kirk,

yes mention offline problem as well. I was able to reproduce the problem but couldn't trace down why thats happening. Guess 'll need to spend more time with it.

Deepak

[kmarkley]

Thanks for updating the issue description.  Sorry I wasn't able to get to it yesterday.

FWIW, if anyone else is following this:  If you don't want to show a label for the field in your profile, you can assign a label of " " and the ONLINE confirmation emails will work.

[Deepak Srivastava]

I think i have tracked down offline problem which seems to be related to optionsPerLine setting. Try unsetting options-per-line for that particular custom field and check if that fixes the problem at your end.

[kmarkley]

I can confirm that the OFFLINE problem goes away when I clear the options-per-line setting. 

That said, it looks to me like two different issues.  Specifically:

ONLINE reg emails break (display "0th, 0 12:00 AM") when profile field name not set, regardless of options-per-line.

OFFLINE reg emails break (display "Array") when options-per-line is set, regardless of field name.

[kmarkley]

I saw that the issue was marked as fixed/completed this morning.  Thanks for the quick work.  Online registrations emails seem to be fine, even if the field label is not set in the profile.

Unfortunately, on my install, offline registration emails are still failing when 'options per line' is set.

Is there something I'm not doing?  I did clear my templates_c directory, but it made no difference.