Answers.Body: <p>There is a very useful extension called "<a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer"><strong>Extended Reports</strong></a>" that has an Activities report that allows you to pull information about the Source, Target and Assigned contacts, but if you are looking for information about an organization that is related to one of those contacts but is not directly linked to the activity (and you don't have access to a developer), then you'd probably be better off searching twice:</p>
  
  <ol>
  <li>Search > Advanced Search</li>
  <li><strong>Search 1:</strong>
  
  <blockquote>
    <ol>
    <li>Select "Display Results as" = Activities</li>
    <li>Enter desired search criteria for Activities</li>
    <li>Search and Export search results</li>
    </ol>
  </blockquote></li>
  <li><strong>Search 2:</strong>
  
  <blockquote>
    <ol>
    <li>Without changing the criteria you used to search for the activities, click to expand the Edit Search Criteria bar</li>
    <li>Select "Display Results as" = Related Contacts </li>
    <li>Select the relevant relationship</li>
    <li>Export results</li>
    </ol>
  </blockquote></li>
  <li>Use a <a href="https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1" rel="nofollow noreferrer"><strong>vlookup</strong></a> function to match data accordingly (facilitated if you export contact IDs)</li>
  </ol>
  
  <p>Hope this helps!
  Tamar</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-14T14:23:05.467Z
Answers.Text: Thanks Tamar.   I was trying to avoid 2 searches, but it looks like I may not be able to.   I appreciate your answer.
Answers.UserDisplayName: Christine
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-11-14T01:23:44.683Z
Answers.LastActivityDate: 2018-11-14T01:23:44.683Z
Answers.UserDisplayName: Tamar Meir - Cividesk
Body: <p>I am trying to set up a custom field mapping to export after I search for Activities.  I would like to export data associated with the Activity, but also include data from the Individual Contact and related Organization.  All the fields are available when I export my activity, but the data does not export for the Organization. </p>
  
  <p>Thanks  </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-14T03:30:10.307Z
Comments.Text: Hi Christine - do you mean there is a 'related org' field that is available when setting up the export mapping but which doesn't actually export the data?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-14T14:00:57.157Z
Comments.Text: Yes.   I can add them to the export data mapping, but no data exports.  I have relationships with employees of an organization and wanted to export custom data fields associated with the Org along with data from a completed activity and the Individual.   Thanks
Comments.UserDisplayName: Christine
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-14T17:34:51.183Z
Comments.Text: If you have access to your db and have some mysql skills then you can possibly do the required in one view. Similarly if your CMS is Drupal then you can probably build (or have built for you) a View display with an export that contains all the required info in one query
Comments.UserDisplayName: petednz - fuzion
Tags: <export><activity><field-mapping>
Title: Can I export custom data from a Contact, an Organization and an Activity in one export?
ThreadText: # Can I export custom data from a Contact, an Organization and an Activity in one export?
  
  (Asked by: username_0 on 2018-11-13)
  
  I am trying to set up a custom field mapping to export after I search for Activities. I would like to export data associated with the Activity, but also include data from the Individual Contact and related Organization. All the fields are available when I export my activity, but the data does not export for the Organization.
  
  Thanks
  
  **Tags:** export, activity, field-mapping
  
  > **Comments:**
  > **username_1**: Hi username_0 - do you mean there is a 'related org' field that is available when setting up the export mapping but which doesn't actually export the data?  
  > **username_0**: Yes.   I can add them to the export data mapping, but no data exports.  I have relationships with employees of an organization and wanted to export custom data fields associated with the Org along with data from a completed activity and the Individual.   Thanks  
  > **username_1**: If you have access to your db and have some mysql skills then you can possibly do the required in one view. Similarly if your CMS is Drupal then you can probably build (or have built for you) a View display with an export that contains all the required info in one query  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-11-14. Score: 1
  
  There is a very useful extension called "[**Extended Reports**](https://civicrm.org/extensions/extended-reports)" that has an Activities report that allows you to pull information about the Source, Target and Assigned contacts, but if you are looking for information about an organization that is related to one of those contacts but is not directly linked to the activity (and you don't have access to a developer), then you'd probably be better off searching twice:
  
  1. Search > Advanced Search
  2. **Search 1:**
     > 1. Select "Display Results as" = Activities
     > 2. Enter desired search criteria for Activities
     > 3. Search and Export search results
  3. **Search 2:**
     > 1. Without changing the criteria you used to search for the activities, click to expand the Edit Search Criteria bar
     > 2. Select "Display Results as" = Related Contacts
     > 3. Select the relevant relationship
     > 4. Export results
  4. Use a [**vlookup**](https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1) function to match data accordingly (facilitated if you export contact IDs)
  
  Hope this helps!
  username_2
  
  > **Comments:**
  > **username_0**: Thanks username_2.   I was trying to avoid 2 searches, but it looks like I may not be able to.   I appreciate your answer.  
  
  ---
  
  