Exporting Salsa for CiviCRM » History » Version 3
Jon Goldberg, 09/17/2014 04:26 PM
| 1 | 1 | Jon Goldberg | h1. Exporting Salsa for CiviCRM |
|---|---|---|---|
| 2 | |||
| 3 | 2 | Jon Goldberg | When logged in as a Manager, "Query/Export" will give you a full export of contact data. There's a "Select My Entire List" button. There's also an "include my deleted supporters" checkbox, which you may want to check (but probably not). This will NOT get you groups/tags. |
| 4 | 1 | Jon Goldberg | |
| 5 | 3 | Jon Goldberg | h3. To get groups/tags/chapters |
| 6 | 2 | Jon Goldberg | |
| 7 | 3 | Jon Goldberg | You need to get to custom reports. The only way I've found so far is to click "Built-in Reports", then "Clone and Edit" a report, then select "List Custom Groups". Or go straight here: https://hq-org.salsalabs.com/dia/hq/reports/list.jsp?table=report |
| 8 | 1 | Jon Goldberg | |
| 9 | 3 | Jon Goldberg | _groups_ |
| 10 | * Create a new report. |
||
| 11 | * Select the type of report you would like to create: Standard report |
||
| 12 | * Use "Advanced Object Chooser". |
||
| 13 | * Report on "Contacts", then "Supporter Groups", then "Groups". |
||
| 14 | 1 | Jon Goldberg | |
| 15 | |||
| 16 | |||
| 17 | |||
| 18 | Here's a TSV of how to interpret the "Receive_Email" field. |
||
| 19 | code # of records meaning |
||
| 20 | -24 11066 INACTIVE: (5.1.1 User Unknown) |
||
| 21 | -26 1265 INACTIVE: Address contains RFC spec. invalid characters / is improperly formatted |
||
| 22 | -3 10596 INACTIVE: UNSUBSCRIBED (actively unsubscribed by user) |
||
| 23 | -30 8 INACTIVE (Reported as Spam): Other Blacklist (BLACKLIST) |
||
| 24 | -32 11 (Unknown Status) |
||
| 25 | -35 1 INACTIVE (Reported as Spam): Outblaze |
||
| 26 | -4 1 (Unknown Status) |
||
| 27 | -42 349 INACTIVE (Recipient Initiated Spam Report): MSN/Hotmail/WebTV |
||
| 28 | -44 10 INACTIVE (Recipient Initiated Spam Report): UNTI (Juno/NetZero/FreeServers) |
||
| 29 | -45 818 INACTIVE (Recipient Initiated Spam Report): Yahoo |
||
| 30 | -46 69 INACTIVE (Recipient Initiated Spam Report): Comcast.net |
||
| 31 | -47 545 INACTIVE (Recipient Initiated Spam Report): AOL |
||
| 32 | -48 1 INACTIVE (Recipient Initiated Spam Report): RoadRunner |
||
| 33 | -50 10 ISP Specific Bounces: AIM.com Unactivated account |
||
| 34 | -51 3 INACTIVE (Recipient Initiated Spam Report): Excite |
||
| 35 | -52 18 INACTIVE (Reported as Spam): Earthlink |
||
| 36 | -53 15 (Unknown Status) |
||
| 37 | -54 1 (Unknown Status) |
||
| 38 | -60 4 Bad Address/Expired address, etc (n.b.: These addresses are all @democracyinaction.org) |
||
| 39 | -9 5 INACTIVE: DEATH (supporter has died) |
||
| 40 | 0 1101 0 - Inactive or Unknown(not subscribed) |
||
| 41 | 1 64352 1 - Imported or unknown (subscribed) |
||
| 42 | 10 3 ACTIVE: CONFIRMED (Double opt-in) |
||
| 43 | 3 8924 ACTIVE: CLIENT (Client has directly signed up) |