Author Topic: Other strategies for exporting contacts? (Read 752 times)

jase700 · August 26, 2010, 04:32:35 am

I have a reasonably sized contact list ~175,000. I cannot get even a modest ~40k subset to export. I really only care about the e-mail addresses, not all of the address fields, etc. If I simply wanted to export e-mails, is there a way to do it using mysql? For example, just dumping the contact table (or other necessary tables) and importing them using a tool like phpmyadmin?

emilyf · August 26, 2010, 05:09:58 am

if you are using phpmyadmin you could do the following:

go to civicrm_email table and run:
SELECT `email` FROM `civicrm_email`;

then scroll down to hte bottom of the results page and under 'Query results operations' choose 'export'. and on the next page you can choose how many results you want to export.

Donald Lobo · August 26, 2010, 07:17:42 am

Note that we've fixed the export "scalability" issue in 3.2

u should be able to export the 175K / 40K list (will take a fair amount of time)

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Other strategies for exporting contacts? (Read 752 times)

jase700

Other strategies for exporting contacts?

emilyf

Re: Other strategies for exporting contacts?

Donald Lobo

Re: Other strategies for exporting contacts?