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 »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Activity Export with Relationships Error
Pages: [1]

Author Topic: Activity Export with Relationships Error  (Read 274 times)

ankles

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • MySQL version: ?
  • PHP version: ?
Activity Export with Relationships Error
July 17, 2014, 06:53:58 am
I raised this as a bug about a month ago on Jira, which is affecting a client that wants to export data into Excel. Unfortunately when it said Donald said it would be fixed in 4.6, I thought he meant 4.4.6!

https://issues.civicrm.org/jira/browse/CRM-14834

I wonder if anyone has any suggestions of a workaround for this issue, since it will be a while before this is fixed in core?

Thanks
Alex

Maggih

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 7.12
  • CMS version: Drupal
  • MySQL version: don't know
  • PHP version: don't know
Re: Activity Export with Relationships Error
July 18, 2014, 07:49:23 am
Not a fix I'm afraid but I'm currently struggling with the same issue.  One thing I did find by chance was that if you pull a Find Participant report (from Events / Find Participants menu) relationships are maintained.

For example, using Find Participants report I was able to pull out data about the Individual (ethnicity, age etc), Participant (event attended, date of event, evaluation data etc)  and Organisation (income, number of paid employees, number of volunteers, address etc) as the Employee Of relationship had been maintained.

I simply can't get the same information for Activity.  If I repeat the custom Fields as per the Find Participants custom field set I get a DB Syntax error message.

I'm not a developer (end user) but wonder how it is that reports for Events maintain the Employee Of relationship yet Activity doesn't.  I'm sure we can't be the only people suffering this issue.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Activity Export with Relationships Error

This forum was archived on 2017-11-26.