Import OA.org emails into CiviCRM

openaustralia / oaf

OpenAustralia Foundation

https://github.com/openaustralia/oaf#readme

4 stars 3 forks source link

Import OA.org emails into CiviCRM #172

Closed henare closed 9 years ago

henare commented 9 years ago

I just used MySQL Workbench to get the data out of OpenAustralia.org, it was pretty easy.

Some OA stats:

Total OA.org alerts: 10,293
Total OA.org email addresses: 5,104
1,561 alerts go to 'gov.au' addresses

And import stats:

Was 5,646 addresses in CiviCRM already tagged with 'OpenAustralia.org'
About 550 new ones tagged during the import
Now 6,195 addresses tagged in CiviCRM

This time I split the import in half and so was importing 2,500 people and it was really slow. I think 2000 is the current sweet spot.

henare commented 8 years ago

To extract email addresses from OpenAustralia.org you can run the following command on kedumba:

$ mysql --user oa_prod --password --execute="SELECT DISTINCT(email) FROM alerts WHERE deleted=0 AND confirmed=1" oa_prod >> oa_emails.csv

It will then ask you for the oa_prod password (that you can get from the OA.org config /srv/www/www.openaustralia.org/current/twfy/conf/general) and it will save the list of email addresses as oa_emails.csv in the current directory.