CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Custom data in event confirmation emails
Pages: [1] 2

Author Topic: Custom data in event confirmation emails  (Read 2705 times)

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Custom data in event confirmation emails
July 30, 2010, 06:47:21 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom data in event confirmation emails
July 30, 2010, 07:41:59 pm

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
July 30, 2010, 08:04:59 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom data in event confirmation emails
July 31, 2010, 10:10:34 pm

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

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 01, 2010, 09:20:58 am
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom data in event confirmation emails
August 01, 2010, 11:10:13 am

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
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 01, 2010, 01:22:15 pm
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

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom data in event confirmation emails
August 01, 2010, 05:28:53 pm

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

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Custom data in event confirmation emails
August 02, 2010, 06:56:30 am
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
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 02, 2010, 07:58:35 am
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

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Custom data in event confirmation emails
August 02, 2010, 09:10:10 am
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
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 03, 2010, 07:53:46 am
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

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: Custom data in event confirmation emails
August 03, 2010, 08:11:17 am
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.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 03, 2010, 09:06:26 am
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 post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Custom data in event confirmation emails
August 04, 2010, 09:15:40 am
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.
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Custom data in event confirmation emails

This forum was archived on 2017-11-26.