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 »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Limiting default data when exporting to CSV list?
Pages: [1]

Author Topic: Limiting default data when exporting to CSV list?  (Read 1525 times)

gtothab

  • Guest
Limiting default data when exporting to CSV list?
July 13, 2009, 10:46:43 am
Is there a way to limit the data thats exported into a csv file BY DEFUALT from the event participants listing? I know you can restrict the participant fields that you want but I need to have only certain ones appear by default (under the Export PRIMARY fields option)

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: Limiting default data when exporting to CSV list?
July 13, 2009, 03:18:52 pm

no. you'll need to make some code changes to change the default export listing

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

gtothab

  • Guest
Re: Limiting default data when exporting to CSV list?
July 13, 2009, 06:27:40 pm
Thx,

I also saw the option for creating import/export mappings under "configure".

Looking into that. . .


Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Limiting default data when exporting to CSV list?
July 14, 2009, 08:05:15 am
Using the "Select fields to export" option, choosing the fields you want, and then saving those as an export mapping for your "users" is the intended approach for this. Then your users can simply select their mapping whenever they do an export.
Protect your investment in CiviCRM by  becoming a Member!

swimman13

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
Re: Limiting default data when exporting to CSV list?
March 09, 2010, 06:28:33 am
My issue is that the select fields for export list does not include many of the fields in the 'export primary' such as event start date.  Therefore, I would like to edit the primary filed export list query  Could you please point me to the code that creates the select / export list for the 'export primary fields' list.  CiviCRM 3.0.2

And while I'm asking...Is there an easy way to strip out the number of tickets purchased?  I'm using price sets with adult and student rates.  When I export the data, it shows as a text filed: Adult Admission - 2,Student Admission - 3, making it really hard to drop into a spreadsheet and do any analysis on.

 Thanks.

« Last Edit: March 09, 2010, 06:41:18 am by swimman13 »

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: Limiting default data when exporting to CSV list?
March 09, 2010, 07:45:25 am

CRM/Event/BAO/Query.php, function defaultReturnProperties

check the priceset custom search. gives you data in a nice manner (i think)

http://drupal.demo.civicrm.org/civicrm/contact/search/custom?csid=9&reset=1

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Limiting default data when exporting to CSV list?

This forum was archived on 2017-11-26.