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 CiviMember (Moderator: Deepak Srivastava) »
  • Exporting membership data
Pages: [1]

Author Topic: Exporting membership data  (Read 1616 times)

Laryn

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 4
    • CEDC
  • CiviCRM version: 4.6.x
  • CMS version: Drupal 7
Exporting membership data
February 27, 2008, 02:12:39 pm
We'd like to be able to export to CSV not only contact info for members, but also the membership info (type of membership, join date, start date, end date)... and potentially even the status (new, current, expired, etc.).

Is there any way to do this?

I found this page which suggests that membership info should be exported as well, but it doesn't appear in my CSV file.

This page describes what I've attempted, but there is no membership information in the dropdowns to select for export.
CEDC...social justice by design

*Get support on the new CiviCRM help site. /laryn

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: Exporting membership data
February 27, 2008, 04:31:37 pm

If you choose the "Export" action from this page:

http://drupal.demo.civicrm.org/civicrm/member/search?reset=1&force=1

you get an export file with the following header

Code: [Select]
"Contact ID","Membership ID","Contact Type","Display Name","Membership Type","Start Date","End Date","Source","Status","Test","Member Since","Street Address","Supplemental Address 1","Supplemental Address 2","City","Postal Code","Postal Code Suffix","State","Country","Geo Code 1","Geo Code 2","Email","Phone","IM Screen Name"

The user does not have control over what fields are exported. We are planning to make export for the various components more configurable in v2.1. But the above export fives you all the information you've asked for :)

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

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Exporting membership data
February 27, 2008, 06:54:27 pm
But note the problem I am reporting on elsewhere  :-\  about the system mis-exporting IMHO additional records - http://forum.civicrm.org/index.php/topic,2542.msg10832.html#msg10832
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Laryn

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 4
    • CEDC
  • CiviCRM version: 4.6.x
  • CMS version: Drupal 7
Re: Exporting membership data
February 27, 2008, 08:28:16 pm
Thanks Lobo! It looks like exactly what I need. Rather have too much info than too little at this point. ;)

I'll have to see if the issue you raise effects me, Peter.

L.
CEDC...social justice by design

*Get support on the new CiviCRM help site. /laryn
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Exporting membership data

This forum was archived on 2017-11-26.